Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public partial class Emp_Addemp
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- }
- protected void btnsub_Click(object sender, EventArgs e)
- {
- user u = new user();
- u.username = "chek";
- u.password = "testpass";
- ServiceReference1.empdetails e1 = new ServiceReference1.empdetails();
- //userdetails u = new userdetails();
- ServiceReference1.userdetailsSoapClient client = new ServiceReference1.userdetailsSoapClient("userdetailsSoap");
- string gen ="";
- if (rdbmale.Checked)
- {
- gen = "Male";
- }
- else
- {
- gen = "Female";
- }
- e1.eid = -1;
- e1.ename = txtname.Text;
- e1.eaddress = txtadd.Text;
- e1.emobileno = txtmobileno.Text;
- e1.gender = gen;
- e1.ejoiningdate = DateTime.Now;
- e1.eleavedate = DateTime.Now;
- e1.status = true;
- int emid = client.insertemp(e1); //Error
- }
- }
- [WebService(Namespace = "http://localhost:35046/")]
- [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
- // To allow this Web Service to be called from script, using ASP.NET AJAX,
- uncomment the following line.
- // [System.Web.Script.Services.ScriptService]
- public class userdetails : System.Web.Services.WebService {
- public userdetails () {
- //Uncomment the following line if using designed components
- //InitializeComponent();
- }
- public user checkuser;
- //[SoapHeader("checkuser", Required = true)]
- [WebMethod]
- public int insertemp(empdetails emp)
- {
- int eid = 0;
- eid = empDA.insertuserdetails(emp);
- return eid;
- }
- }
- public class empDA
- {
- public empDA()
- {
- }
- public static int insertuserdetails(empdetails emp)
- {
- int result = 0;
- using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["testingConnectionString"].ConnectionString))
- {
- SqlCommand cmd = new SqlCommand("insertuserdetails", con);
- cmd.CommandType = CommandType.StoredProcedure;
- if (emp.eid == -1)
- {
- cmd.Parameters.AddWithValue("@eid", DBNull.Value);
- }
- else
- {
- cmd.Parameters.AddWithValue("@eid", emp.eid);
- }
- cmd.Parameters.Add("@ename", emp.ename);
- cmd.Parameters.Add("@gender", emp.gender);
- cmd.Parameters.Add("@eaddress", emp.eaddress);
- cmd.Parameters.Add("@eno", emp.emobileno);
- cmd.Parameters.Add("@status", emp.status);
- cmd.Parameters.Add("@joindate", emp.ejoiningdate);
- cmd.Parameters.Add("@leavedate", emp.eleavedate);
- DbParameter returnValue;
- returnValue = cmd.CreateParameter();
- returnValue.Direction = ParameterDirection.ReturnValue;
- cmd.Parameters.Add(returnValue);
- con.Open();
- try
- {
- cmd.ExecuteNonQuery();
- result = Convert.ToInt32(returnValue.Value);
- }
- catch
- {
- throw;
- }
- finally
- {
- con.Close();
- }
- }
- return result;
- }
- private static empdetails FillDataRecord(IDataReader myDataRecord)
- {
- empdetails h2 = new empdetails();
- h2.eid = (myDataRecord.GetInt32(myDataRecord.GetOrdinal("eid")));
- h2.ename = myDataRecord.GetString(myDataRecord.GetOrdinal("ename"));
- h2.eaddress = myDataRecord.GetString(myDataRecord.GetOrdinal("eaddress"));
- h2.ejoiningdate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("ejoiningdate"));
- h2.eleavedate = myDataRecord.GetDateTime(myDataRecord.GetOrdinal("eleavedate"));
- h2.gender = myDataRecord.GetString(myDataRecord.GetOrdinal("gender"));
- h2.emobileno = myDataRecord.GetString(myDataRecord.GetOrdinal("emobileno"));
- h2.status = myDataRecord.GetBoolean(myDataRecord.GetOrdinal("status"));
- // h2.ScheduleObject = ConvertInt32ToByteArray(myDataRecord.GetOrdinal("ScheduleObject"));
- return h2;
- }
- }
Add Comment
Please, Sign In to add comment