Guest User

Untitled

a guest
Feb 15th, 2019
140
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.70 KB | None | 0 0
  1. public partial class Emp_Addemp
  2. {
  3. protected void Page_Load(object sender, EventArgs e)
  4. {
  5. }
  6.  
  7. protected void btnsub_Click(object sender, EventArgs e)
  8. {
  9. user u = new user();
  10. u.username = "chek";
  11. u.password = "testpass";
  12.  
  13. ServiceReference1.empdetails e1 = new ServiceReference1.empdetails();
  14. //userdetails u = new userdetails();
  15. ServiceReference1.userdetailsSoapClient client = new ServiceReference1.userdetailsSoapClient("userdetailsSoap");
  16. string gen ="";
  17. if (rdbmale.Checked)
  18. {
  19. gen = "Male";
  20. }
  21. else
  22. {
  23. gen = "Female";
  24. }
  25.  
  26. e1.eid = -1;
  27. e1.ename = txtname.Text;
  28. e1.eaddress = txtadd.Text;
  29. e1.emobileno = txtmobileno.Text;
  30. e1.gender = gen;
  31. e1.ejoiningdate = DateTime.Now;
  32. e1.eleavedate = DateTime.Now;
  33. e1.status = true;
  34.  
  35. int emid = client.insertemp(e1); //Error
  36. }
  37. }
  38.  
  39. [WebService(Namespace = "http://localhost:35046/")]
  40.  
  41. [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
  42. // To allow this Web Service to be called from script, using ASP.NET AJAX,
  43. uncomment the following line.
  44. // [System.Web.Script.Services.ScriptService]
  45. public class userdetails : System.Web.Services.WebService {
  46.  
  47. public userdetails () {
  48.  
  49. //Uncomment the following line if using designed components
  50. //InitializeComponent();
  51. }
  52. public user checkuser;
  53.  
  54. //[SoapHeader("checkuser", Required = true)]
  55. [WebMethod]
  56. public int insertemp(empdetails emp)
  57. {
  58. int eid = 0;
  59. eid = empDA.insertuserdetails(emp);
  60. return eid;
  61. }
  62.  
  63. }
  64.  
  65. public class empDA
  66. {
  67. public empDA()
  68. {
  69. }
  70.  
  71.  
  72. public static int insertuserdetails(empdetails emp)
  73. {
  74. int result = 0;
  75.  
  76. using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["testingConnectionString"].ConnectionString))
  77. {
  78. SqlCommand cmd = new SqlCommand("insertuserdetails", con);
  79. cmd.CommandType = CommandType.StoredProcedure;
  80. if (emp.eid == -1)
  81. {
  82. cmd.Parameters.AddWithValue("@eid", DBNull.Value);
  83. }
  84. else
  85. {
  86. cmd.Parameters.AddWithValue("@eid", emp.eid);
  87. }
  88. cmd.Parameters.Add("@ename", emp.ename);
  89. cmd.Parameters.Add("@gender", emp.gender);
  90. cmd.Parameters.Add("@eaddress", emp.eaddress);
  91. cmd.Parameters.Add("@eno", emp.emobileno);
  92. cmd.Parameters.Add("@status", emp.status);
  93. cmd.Parameters.Add("@joindate", emp.ejoiningdate);
  94. cmd.Parameters.Add("@leavedate", emp.eleavedate);
  95.  
  96. DbParameter returnValue;
  97. returnValue = cmd.CreateParameter();
  98. returnValue.Direction = ParameterDirection.ReturnValue;
  99. cmd.Parameters.Add(returnValue);
  100.  
  101. con.Open();
  102. try
  103. {
  104. cmd.ExecuteNonQuery();
  105. result = Convert.ToInt32(returnValue.Value);
  106. }
  107. catch
  108. {
  109. throw;
  110. }
  111. finally
  112. {
  113. con.Close();
  114. }
  115. }
  116.  
  117. return result;
  118. }
  119.  
  120.  
  121. private static empdetails FillDataRecord(IDataReader myDataRecord)
  122. {
  123. empdetails h2 = new empdetails();
  124.  
  125. h2.eid = (myDataRecord.GetInt32(myDataRecord.GetOrdinal("eid")));
  126. h2.ename = myDataRecord.GetString(myDataRecord.GetOrdinal("ename"));
  127. h2.eaddress = myDataRecord.GetString(myDataRecord.GetOrdinal("eaddress"));
  128. h2.ejoiningdate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("ejoiningdate"));
  129. h2.eleavedate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("eleavedate"));
  130. h2.gender = myDataRecord.GetString(myDataRecord.GetOrdinal("gender"));
  131. h2.emobileno = myDataRecord.GetString(myDataRecord.GetOrdinal("emobileno"));
  132. h2.status = myDataRecord.GetBoolean(myDataRecord.GetOrdinal("status"));
  133. // h2.ScheduleObject = ConvertInt32ToByteArray(myDataRecord.GetOrdinal("ScheduleObject"));
  134. return h2;
  135. }
  136. }
Add Comment
Please, Sign In to add comment