ASP.NET
converting javascript to c# RSS

0 replies

Last post Feb 16, 2012 11:45 AM by Honnappa
‹ Previous Thread|Next Thread ›
Honnappa

Participant
1112 Points
534 Posts
converting javascript to c#

Feb 16, 2012 11:45 AM|LINK
i have a project which is written in asp..but in every page they mentioning Language as Javascript.
How to convert this to asp.net
Here is the sample code
<%@ Language="JavaScript"%>
<!--#include file="../../ini/connector.asp"-->
<!--#include virtual="/library/JavaScript/dbmanagerv4.js"-->
<!--#include virtual="/library/JavaScript/date.js"-->
<!--#include virtual="/library/JavaScript/recordstd.js"-->
<!--#include virtual="/library/JavaScript/Money.js"-->
<%

  if (Request.Querystring("langue")>"")
   Langue=Request.Querystring("langue");
  else
   Langue="fr";
  
  if (Request.QueryString("start")>"")
   start=Request.QueryString("start");
  else
   start=0;

  var DataSrc=Readddf ("Smanager.ini");
  
  rs=Server.CreateObject("ADODB.Recordset");
  Data="";
  separator="";
  leftjoin="";
  parenthese="";
  recherche="";
  
  for (index in DataSrc.Fields) {
	if (DataSrc.Fields[index].Format!="G") {
		TheData = String(DataSrc.Fields[index].Name);
		var iPos = TheData.lastIndexOf("@@");
		if (iPos>0)
			TheData = TheData.slice(0,iPos)+""+Langue;
		else
			TheData = String(DataSrc.Fields[index].Name);
			
		if (DataSrc.Fields[index].Format!="S") {
		  Data+=separator+DataSrc.Table+"."+TheData;
		}else{
		  var DataSrcSelect = Readddf (DataSrc.Fields[index].Name+".ini");
		  leftjoin+="LEFT JOIN "+DataSrcSelect.Table+" ON "+DataSrc.Table+"."+DataSrc.Fields[index].Name+"="+DataSrcSelect.Table+"."+DataSrcSelect.Key+") ";
		  if(String(DataSrcSelect.Show).indexOf("+")!=-1){
		   var TABshow = String(DataSrcSelect.Show).split("+");
		   Data+=separator+DataSrcSelect.Table+"."+TABshow[0];
		   Data+=","+DataSrcSelect.Table+"."+TABshow[1];
		  }else{
		   Data+=separator+DataSrcSelect.Table+"."+DataSrcSelect.Show;
		  }
		  parenthese+="(";
		}
		separator=",";
	 }
  }
  
  if (Request.Querystring("sens")>"")
   sens="";
  else
   sens=" DESC ";
  
  sql="SELECT "+Data+" FROM "+parenthese+DataSrc.Table+" "+leftjoin+" ORDER BY "+(Request.QueryString("orderby")>""?DataSrc.Table+"."+Request.QueryString("orderby"):DataSrc.Table+"."+DataSrc.Order)+" "+sens+";";
  //Response.Write(sql);
  rs.Open(sql,connPage,3,3);
  
  if (Request.Form("recherche")>"" || Request.Querystring("recherche")>""){
   critere="";
   separator="";
   if(Request.Querystring("recherche")>"")
     recherche=Request.Querystring("recherche")
   else
     recherche=Request.Form("recherche")
   
  if(isNaN(recherche)){
   
   for (index in DataSrc.Fields) {
     TheData = String(DataSrc.Fields[index].Name);
	 var iPos = TheData.lastIndexOf("@@");
	 if (iPos>0)
	  TheData = TheData.slice(0,iPos)+""+Langue;
	 else
	  TheData = String(DataSrc.Fields[index].Name);
	 
	  switch (DataSrc.Fields[index].Format) {
		case "T" : critere+=separator+" "+TheData+" like '%"+recherche+"%'";
				   separator=" OR ";
				   break;
		case "S" : var DataSrcSelect = Readddf (DataSrc.Fields[index].Name+".ini");
				   if(String(DataSrcSelect.Show).indexOf("+")!=-1){
				    var TABshow = String(DataSrcSelect.Show).split("+");
					critere+=separator+" "+TABshow[0]+" like '%"+recherche+"%'";
					critere+=" OR "+TABshow[1]+" like '%"+recherche+"%'";
				   }else{
				    critere+=separator+" "+DataSrcSelect.Show+" like '%"+recherche+"%'";
				   }
				   separator=" OR ";
				   break;
	 }
   }
   
   }else{
   
   for (index in DataSrc.Fields) {
     TheData = String(DataSrc.Fields[index].Name);
	 var iPos = TheData.lastIndexOf("@@");
	 if (iPos>0)
	  TheData = TheData.slice(0,iPos)+""+Langue;
	 else
	  TheData = String(DataSrc.Fields[index].Name);
	 
	  switch (DataSrc.Fields[index].Format) {
		case "N" : critere+=separator+" "+TheData+"="+recherche+"";
		           separator=" OR ";
		           break;
		case "A" : critere+=separator+" "+TheData+"="+recherche+"";
		           separator=" OR ";
		           break;
	 }
   }
   }
   //Response.Write("critere : "+critere);
   rs.Filter=critere;
  }
  
  RecPLine=20;
  if(DataSrc.Rpp>"")
    RecPPage=parseInt(DataSrc.Rpp);
  else
    RecPPage=rs.recordCount;
	
  idx=0;
  
  if (!rs.EOF){
   rs.MoveFirst();
   for (idx=0;idx<start;idx++){
    rs.MoveNext();
   }
  }
  
  BackIdx=idx-RecPPage;
  
%>
<html>
<head>
<link rel="stylesheet" href="../Style.css" type="text/css">
</head>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
  <tr><form method="post" action="manager.asp?langue=<%=Langue%>" name="formrecherche">
    <td align="center"><input type="text" value="<%=(recherche>""?recherche:"")%>" name="recherche" size="25">&nbsp;<input type="submit" value="Recherche"></td>
  </tr>
</table>
<br>
<table width="100%" border="1" cellspacing="0" cellpadding="2" class="texte">
<th width="1%">&nbsp;</th>
<%
// CREATION OF HEAD OF TABLE
flagcb=0;
for (index in DataSrc.Fields) {
	Response.Write("<th>"+(DataSrc.Fields[index].Format=="I" || DataSrc.Fields[index].Format=="G"?DataSrc.Fields[index].Titre:"<a href=\"manager.asp?langue="+Langue+"&orderby="+DataSrc.Fields[index].Name+"&sens="+sens+"&recherche="+recherche+"\">"+DataSrc.Fields[index].Titre+"</a>")+"</th>");
}

// BROWSE RECORD

if (!rs.EOF) {
do
{
%>
<tr>
<td><a href="adddata.asp?langue=<%=Langue%>&update=ok&id=<%=rs.Fields(DataSrc.Key)%>" style="color:green"><img src="shared\boutons\modifierdonnees.gif" border=0></a></td>
<%

for (index in DataSrc.Fields) {
	switch (DataSrc.Fields[index].Format) {
		case "I" :
			Response.Write("<td><a href=\"uploadimage.asp?id="+rs.Fields(DataSrc.Key)+"&table="+DataSrc.Table+"&fields="+DataSrc.Fields[index].Name+"\"><img src=\"shared\\boutons\\envoyerimage.gif\" border=0>"+(rs.Fields(DataSrc.Fields[index].Name)>""?rs.Fields(DataSrc.Fields[index].Name):"")+"</a><br><a href=\"delimg.asp?id="+rs.Fields(DataSrc.Key)+"&table="+DataSrc.Table+"&fields="+DataSrc.Fields[index].Name+"&back=news\"><img src=\"shared\\boutons\\suppressionimage.gif\" border=0>"+(rs.Fields(DataSrc.Fields[index].Name)>""?rs.Fields(DataSrc.Fields[index].Name):"")+"</a></td>");
			break;
		case "S" :
			var DataSrcSelect = Readddf (String(DataSrc.Fields[index].Name)+".ini");
			if(String(DataSrcSelect.Show).indexOf("+")!=-1){
			 var TABshow = String(DataSrcSelect.Show).split("+");
			 Response.Write("<td>"+(rs.Fields(TABshow[0])>""?rs.Fields(TABshow[0]):"")+" - "+(rs.Fields(TABshow[1])>""?rs.Fields(TABshow[1]):"")+"</td>");
			}else{
			 Response.Write("<td>"+rs.Fields(DataSrcSelect.Show)+"</td>");
			}
			break;
		case "D" :
			Response.Write("<td>"+(rs.Fields(DataSrc.Fields[index].Name)>""?FormatDate(rs.Fields(DataSrc.Fields[index].Name)):"&nbsp;")+"</td>");
			break;
		case "O":
			Response.Write("<td><input type=\"checkbox\""+(rs.Fields(DataSrc.Fields[index].Name)>0?" checked":"")+"></td>");
			break;
		case "T":
			Response.Write("<td>"+(rs.Fields(DataSrc.Fields[index].Name)>""?rs.Fields(DataSrc.Fields[index].Name):"&nbsp;")+"</td>");
			break;
		case "N":
			Response.Write("<td>"+(rs.Fields(DataSrc.Fields[index].Name)>""?rs.Fields(DataSrc.Fields[index].Name):"&nbsp;")+"</td>");
			break;
		case "P":
			Response.Write("<td>"+(rs.Fields(DataSrc.Fields[index].Name)>""?FormatNumber(String(rs.Fields(DataSrc.Fields[index].Name)),2,0):"&nbsp;")+"</td>");
			break;
		case "A":
			Response.Write("<td>"+rs.Fields(DataSrc.Fields[index].Name)+"</td>");
			break;
		case "M":
			Response.Write("<td>"+(rs.Fields(DataSrc.Fields[index].Name)>""?rs.Fields(DataSrc.Fields[index].Name):"&nbsp;")+"</td>");
		case "G":
			// Add Manager
			Response.Write("<td><a href=\""+DataSrc.Fields[index].Name+"/default.asp?langue="+Langue+"&idproduit="+rs.Fields(DataSrc.Key)+"\">"+DataSrc.Fields[index].Titre+"</a></td>");
			break;

	}
}
Response.Write("</tr>");

rs.MoveNext();
idx++;
}
while (!rs.EOF&&(idx<RecPPage+parseInt(start)));
}
%>
</form>
</table>
<br><br>
<%

nbrpage=rs.recordCount/RecPPage;

if (nbrpage!=parseInt(nbrpage)){
 nbrpage=nbrpage+1;
}

if (nbrpage>1){

 Response.Write("<table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\"><tr><td width=\"75px\" align=\"right\">");
 
 if (start>0){
  Response.Write("<a HREF=\"manager.asp?start="+BackIdx+"&amp;langue="+Langue+"&orderby="+(Request.QueryString("orderby")>""?Request.QueryString("orderby"):DataSrc.Order)+"&sens="+(Request.Querystring("sens")>""?Request.Querystring("sens"):"")+"&recherche="+recherche+"\">["+FindTraduction("webofficepro","T_DBmanager","39",Langue)+"]</a>");
 }
 else
  Response.Write("&nbsp;");
  
 Response.Write("</td><td align=\"center\"><table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\"><tr>");
 
 // Cases  numerotees :
 
 for (cpt=1;cpt<=parseInt(nbrpage);cpt++){
  Response.Write("<td align=\"center\">&nbsp;");
  
  if (parseInt((cpt-1)*RecPPage)!=start){
   Response.Write("<a href=\"manager.asp?langue="+Langue+"&start="+parseInt((cpt-1)*RecPPage)+"&orderby="+(Request.QueryString("orderby")>""?Request.QueryString("orderby"):DataSrc.Order)+"&sens="+(Request.Querystring("sens")>""?Request.Querystring("sens"):"")+"&recherche="+recherche+"\">");
  }
  else{
   Response.Write("<b style=\"font-size:13px; color: red\">");
  }
  
  Response.Write("<span style=\"font-size:14px;\">"+cpt+"</span>");
  
  if (parseInt((cpt-1)*RecPPage)!=start)
   Response.Write("</a>");
  else Response.Write("</b>");
   Response.Write("</td>");
   
   if(cpt % RecPLine==0)
     Response.Write("</tr><tr>")
  }
  
  //Fin cases numerotees
  
  Response.Write("</tr></table></td><td width=\"75px\" align=\"left\">");
  
  if (!rs.EOF){
   Response.Write("&nbsp;<a HREF=\"manager.asp?start="+idx+"&amp;langue="+Langue+"&orderby="+(Request.QueryString("orderby")>""?Request.QueryString("orderby"):DataSrc.Order)+"&sens="+(Request.Querystring("sens")>""?Request.Querystring("sens"):"")+"&recherche="+recherche+"\">["+FindTraduction("webofficepro","T_DBmanager","40",Langue)+"]</a>");
  }
  else{
   Response.Write("&nbsp;");
  }
  
  Response.Write("</td>");
  Response.Write("</tr>");
  Response.Write("</table>");
  Response.Write("<BR>");
  Response.Write("<BR>");
}
%>
</body>
</html>
All is Well !! hm30shettikera@gmail.com

My Profile
‹ Previous Thread|Next Thread ›
converting javascript to c# RSS

0 replies

Honnappa

converting javascript to c#

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft
