Guest User

Untitled

a guest
Sep 8th, 2018
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.01 KB | None | 0 0
  1. Return a value in c# function
  2. using System;
  3. using System.Configuration;
  4. using System.Data;
  5. using System.Linq;
  6. using System.Web;
  7. using System.Web.Security;
  8. using System.Web.UI;
  9. using System.Web.UI.HtmlControls;
  10. using System.Web.UI.WebControls;
  11. using System.Web.UI.WebControls.WebParts;
  12. using System.Xml.Linq;
  13. using System.Data.Odbc;
  14. using System.Data.SqlClient;
  15. using System.Collections;
  16. using System.IO;
  17.  
  18.  
  19. using iTextSharp.text.html.simpleparser;
  20. using iTextSharp.text;
  21. using iTextSharp.text.pdf;
  22. using iTextSharp.text.html;
  23.  
  24. /// <summary>
  25. /// Summary description for Data
  26. /// </summary>
  27. public class Data
  28. {
  29. public Data()
  30. {
  31. //
  32. // TODO: Add constructor logic here
  33. //
  34.  
  35.  
  36.  
  37. }
  38. public void dat(AjaxControlToolkit.HTMLEditor.Editor Editor1,TextBox TextBox3, TextBox TextBox4, TextBox TextBox2, TextBox TextBox1, DropDownList DropDownList1, DropDownList DropDownList3, HiddenField HiddenField1, HiddenField HiddenField4)
  39. {
  40. String dbDate = DateTime.ParseExact(TextBox3.Text, "dd/mm/yyyy", null).ToString("yyyy-mm-dd");
  41.  
  42. String respo1 = "";
  43. String respo2 = "";
  44. String editorcont1 = "";
  45. int res = 0;
  46. String sb = "";
  47.  
  48. String petitioner = "";
  49. String petitioner1 = "";
  50. String resp = "";
  51. String resp1 = "";
  52.  
  53. String respondants = "";
  54. String addr1 = "";
  55. String addr2 = "";
  56.  
  57.  
  58. var order = "";
  59.  
  60. String nextdate = "";
  61. String nextdate1 = "**/**/****";
  62. String judge1 = "";
  63. String judge2 = "";
  64. String judge3 = "";
  65. String advocates = "";
  66.  
  67.  
  68. String a = DropDownList1.SelectedItem.Value;
  69. String b = DropDownList3.SelectedItem.Value.PadLeft(3, '0');
  70. String c = TextBox1.Text.PadLeft(5, '0').ToString();
  71. String d = TextBox2.Text.ToString();
  72. String digit = a + b + c + d;
  73. String jjj = "";
  74.  
  75.  
  76. try
  77. {
  78. OdbcConnection casetype = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=10.155.160.130;Database=testcase;User=root;Password=;Option=3;");
  79. casetype.Open();
  80.  
  81. String petresquery1 = "select fil_no from testcase.main where reg_no =? OR fil_no=?";
  82. OdbcCommand petrescmd1 = new OdbcCommand(petresquery1, casetype);
  83. petrescmd1.Parameters.AddWithValue("?", digit);
  84. petrescmd1.Parameters.AddWithValue("?", digit);
  85. OdbcDataReader respetMyReader1 = petrescmd1.ExecuteReader();
  86.  
  87. while (respetMyReader1.Read())
  88. {
  89. String fil_no = respetMyReader1["fil_no"].ToString();
  90. HiddenField4.Value = fil_no;
  91. //Response.Write(HiddenField4.Value);
  92. }
  93.  
  94.  
  95. string showmodifquery = "select notice from notice_aspx where fil_no=?";
  96.  
  97. OdbcCommand showmodifcmd = new OdbcCommand(showmodifquery, casetype);
  98.  
  99. showmodifcmd.Parameters.AddWithValue("?", HiddenField4.Value);
  100. OdbcDataReader showmodifMyReader = showmodifcmd.ExecuteReader();
  101.  
  102. if (showmodifMyReader.Read())
  103. {
  104. String showmodif1 = showmodifMyReader["notice"].ToString();
  105.  
  106. Editor1.Content = showmodif1;
  107. }
  108. else
  109. {
  110. //************to get case type
  111. string casetypequery = "select casename from casetype where skey=?";
  112. //************to get pet res
  113. string petresquery = "select pet_name,res_name from testcase.main where reg_no =? OR fil_no=?";
  114. //*******to get respondants
  115. string respoquery = "SELECT sr_no,partyname,addr1,addr2 FROM testcase.party where fil_no=? and pet_res='R'order by sr_no,party_lh,party_lh2,party_lh3,party_lh4,party_lh5";
  116. //*******to get order
  117. string ordequery = "select orde from testcase.orddetpabak where fil_no=? and orderdate=?";
  118. //*********to get next date
  119. string nextdatequery = "SELECT next_dt FROM testcase.heardt where fil_no=? and next_dt>?;";
  120. //*********to get jud1
  121. string jud1query = "select jname from testcase.orddetpabak,testcase.judge where orddetpabak.jud1 = judge.jcode and fil_no=? and orderdate=?;";
  122. //*********to get jud2
  123. string jud2query = "select jname from testcase.orddetpabak,testcase.judge where orddetpabak.jud2 = judge.jcode and fil_no=? and orderdate=?;";
  124. //*********to get jud3
  125. string jud3query = "select jname from testcase.orddetpabak,testcase.judge where orddetpabak.jud3 = judge.jcode and fil_no=? and orderdate=?;";
  126. //*********to get advocates
  127. string advquery = "SELECT adv FROM testcase.orddetpabak where fil_no=? and orderdate=?";
  128.  
  129.  
  130.  
  131. //************to get case type
  132. OdbcCommand casetypecmd = new OdbcCommand(casetypequery, casetype);
  133. String casetypefromdropdown = DropDownList3.SelectedItem.ToString();
  134. casetypecmd.Parameters.AddWithValue("?", casetypefromdropdown);
  135. using (OdbcDataReader casetypeMyReader = casetypecmd.ExecuteReader())
  136. {
  137. while (casetypeMyReader.Read())
  138. {
  139. String casename = casetypeMyReader["casename"].ToString();
  140. HiddenField1.Value = casename;
  141. }
  142. }
  143.  
  144. //************to get pet res
  145. OdbcCommand petrescmd = new OdbcCommand(petresquery, casetype);
  146. petrescmd.Parameters.AddWithValue("?", digit);
  147. petrescmd.Parameters.AddWithValue("?", digit);
  148. using (OdbcDataReader respetMyReader = petrescmd.ExecuteReader())
  149. {
  150. while (respetMyReader.Read())
  151. {
  152. petitioner1 = respetMyReader["pet_name"].ToString();
  153.  
  154. //petitioner1 = petitioner.Substring(0, 1) + petitioner.Substring(1).ToLower();
  155. resp1 = respetMyReader["res_name"].ToString();
  156. //resp1 = resp.Substring(0, 1) + resp.Substring(1).ToLower();
  157.  
  158. //String fil_no = respetMyReader["fil_no"].ToString();
  159. //HiddenField4.Value = fil_no;
  160. ////Response.Write(HiddenField4.Value);
  161. // return petitioner1;
  162. }
  163. if (petitioner1 == "")
  164. {
  165. HttpContext.Current.Response.Write("<b><font color='red'>Wrong Entry!!!");
  166. }
  167. }
  168.  
  169.  
  170. //*******to get respondants
  171.  
  172. String respo = HiddenField4.Value;
  173. OdbcCommand respocmd = new OdbcCommand(respoquery, casetype);
  174. respocmd.Parameters.AddWithValue("?", respo);
  175. using (OdbcDataReader respoMyReader = respocmd.ExecuteReader())
  176. {
  177. while (respoMyReader.Read())
  178. {
  179. respo1 = respoMyReader["sr_no"].ToString();
  180. respo2 = respoMyReader["partyname"].ToString();
  181. addr1 = respoMyReader["addr1"].ToString();
  182. addr2 = respoMyReader["addr2"].ToString();
  183. res = Convert.ToInt32(respo1);
  184. //Response.Write(res);
  185. //Response.Write(respo2);
  186.  
  187. //editorcont1 = "<table><tr><td width='10'>" + res + "</td><td>"+"<P align= 'left'>"+ respo2 +"</P></td>"+"</br>";
  188.  
  189. ////HiddenField7.Value = editorcont1;
  190. //asd(editorcont1);
  191.  
  192. //respondants = respo2.Substring(0, 1) + respo2.Substring(1).ToLower();
  193. //addr1 = addr1.Substring(0, 1) + addr1.Substring(1).ToLower();
  194. //addr2 = addr2.Substring(0, 1) + addr2.Substring(1).ToLower();
  195. editorcont1 = res + ")&nbsp;&nbsp;" + respo2 + "<br/>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" + addr1 + "&nbsp;&nbsp;" + addr2 + "<br/>";
  196. sb = sb + editorcont1;
  197. }
  198. }
  199.  
  200. //*******to get order
  201. OdbcCommand ordecmd = new OdbcCommand(ordequery, casetype);
  202. ordecmd.Parameters.AddWithValue("?", HiddenField4.Value);
  203. ordecmd.Parameters.AddWithValue("?", dbDate);
  204. using (OdbcDataReader ordeMyReader = ordecmd.ExecuteReader())
  205. {
  206. while (ordeMyReader.Read())
  207. {
  208. order = ordeMyReader["orde"].ToString();
  209. }
  210.  
  211. }
  212. //*******to get nextdate
  213. OdbcCommand nextdatecmd = new OdbcCommand(nextdatequery, casetype);
  214. nextdatecmd.Parameters.AddWithValue("?", HiddenField4.Value);
  215. nextdatecmd.Parameters.AddWithValue("?", dbDate);
  216. using (OdbcDataReader nextdateMyReader = nextdatecmd.ExecuteReader())
  217. {
  218. while (nextdateMyReader.Read())
  219. {
  220. nextdate = nextdateMyReader["next_dt"].ToString();
  221.  
  222. }
  223. nextdate1 = Convert.ToDateTime(nextdate).ToString("dd/MM/yyyy");
  224.  
  225.  
  226. }
  227.  
  228. //*********to get jud1
  229. OdbcCommand jud1cmd = new OdbcCommand(jud1query, casetype);
  230. jud1cmd.Parameters.AddWithValue("?", HiddenField4.Value);
  231. jud1cmd.Parameters.AddWithValue("?", dbDate);
  232. using (OdbcDataReader jud1MyReader = jud1cmd.ExecuteReader())
  233. {
  234. while (jud1MyReader.Read())
  235. {
  236. judge1 = jud1MyReader["jname"].ToString();
  237. jjj = "J";
  238. }
  239. }
  240.  
  241.  
  242. //*********to get jud2
  243. OdbcCommand jud2cmd = new OdbcCommand(jud2query, casetype);
  244. jud2cmd.Parameters.AddWithValue("?", HiddenField4.Value);
  245. jud2cmd.Parameters.AddWithValue("?", dbDate);
  246. using (OdbcDataReader jud2MyReader = jud2cmd.ExecuteReader())
  247. {
  248. while (jud2MyReader.Read())
  249. {
  250. judge2 = jud2MyReader["jname"].ToString();
  251. jjj = "JJ";
  252. }
  253. }
  254.  
  255.  
  256. //*********to get jud3
  257. OdbcCommand jud3cmd = new OdbcCommand(jud3query, casetype);
  258. jud3cmd.Parameters.AddWithValue("?", HiddenField4.Value);
  259. jud3cmd.Parameters.AddWithValue("?", dbDate);
  260. using (OdbcDataReader jud3MyReader = jud3cmd.ExecuteReader())
  261. {
  262. while (jud3MyReader.Read())
  263. {
  264. judge3 = jud3MyReader["jname"].ToString();
  265. jjj = "JJJ";
  266. }
  267. }
  268. //*******to get advocates
  269. OdbcCommand advcmd = new OdbcCommand(advquery, casetype);
  270. advcmd.Parameters.AddWithValue("?", HiddenField4.Value);
  271. advcmd.Parameters.AddWithValue("?", dbDate);
  272. using (OdbcDataReader advMyReader = advcmd.ExecuteReader())
  273. {
  274. while (advMyReader.Read())
  275. {
  276. advocates = advMyReader["adv"].ToString();
  277. }
  278.  
  279. }
  280. DateTime month = DateTime.Now;
  281. String tyear = TextBox2.Text;
  282. tyear = tyear.Remove(0, 2);
  283.  
  284. String year = DateTime.Now.Year.ToString();
  285. year = year.Remove(0, 2);
  286.  
  287. TextBox4.Text = order;
  288. }
  289. }
  290. catch (Exception er)
  291. { }
  292.  
  293. }
  294. }
  295.  
  296. public class Product
  297. {
  298. int Id { get; set;}
  299. string Name { get; set;}
  300. double Value { get; set;}
  301. }
  302.  
  303. public Product GetProduct(string Id)
  304. {
  305. Product product;
  306. // load product here
  307. return product;
  308. }
Add Comment
Please, Sign In to add comment