public Userlogin Loginsecond_Update(login_Class obj) { Userlogin Userlogin1 = new Userlogin(); Userlogin1 = objModels.loginSecond_Update(obj); return(Userlogin1); }
public Userlogin loginSecond_Update(login_Class obj) { if (obj.wantnews == "True") { obj.wantnews = "1"; } else { obj.wantnews = "0"; }; SqlConnection con = new SqlConnection(objCon.ConnectionReturn()); SqlCommand cmd = new SqlCommand("Customer_Insert", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", obj.FirstName); cmd.Parameters.AddWithValue("@phone", obj.phone); cmd.Parameters.AddWithValue("@email", obj.email); cmd.Parameters.AddWithValue("@HouseNo", obj.House); cmd.Parameters.AddWithValue("@AddressLine2", obj.AddressLine2); cmd.Parameters.AddWithValue("@AddressLine3", obj.AddressLine3); cmd.Parameters.AddWithValue("@AddressLine4", obj.AddressLine4); cmd.Parameters.AddWithValue("@PostCode", obj.PostCode); cmd.Parameters.AddWithValue("@InvoicePostCode", obj.InvoicePostCode); cmd.Parameters.AddWithValue("@InvoiceCompany", obj.InvoiceCompany); cmd.Parameters.AddWithValue("@InvoiceHouse", obj.InvoiceHouse); cmd.Parameters.AddWithValue("@InvoiceAddressLine2", obj.InvoiceAddressLine2); cmd.Parameters.AddWithValue("@InvoiceAddressLine3", obj.InvoiceAddressLine3); cmd.Parameters.AddWithValue("@InvoiceAddressLine4", obj.InvoiceAddressLine4); cmd.Parameters.AddWithValue("@wantnews", obj.wantnews); cmd.Parameters.Add("@Return", SqlDbType.NVarChar, 50).Value = ""; cmd.Parameters.Add("@ReturnName", SqlDbType.NVarChar, 50).Value = ""; cmd.Parameters["@Return"].Direction = ParameterDirection.Output; cmd.Parameters["@ReturnName"].Direction = ParameterDirection.Output; con.Open(); cmd.ExecuteNonQuery(); con.Close(); Userlogin Userlogin = new Userlogin(); Userlogin.Id = Convert.ToString(cmd.Parameters["@Return"].Value); Userlogin.Name = Convert.ToString(cmd.Parameters["@Returnname"].Value); return(Userlogin); }
public string loginfirst_Insert(login_Class obj) { SqlConnection con = new SqlConnection(objCon.ConnectionReturn()); SqlCommand cmd = new SqlCommand("loginFirstDetial_Insert", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", obj.FirstName); cmd.Parameters.AddWithValue("@Phone", obj.PhoneNumber); cmd.Parameters.AddWithValue("@Email", obj.email); cmd.Parameters.AddWithValue("@Password", obj.Password); cmd.Parameters.Add("@Return", SqlDbType.NVarChar, 50).Value = ""; cmd.Parameters["@Return"].Direction = ParameterDirection.Output; con.Open(); cmd.ExecuteNonQuery(); con.Close(); string Return = Convert.ToString(cmd.Parameters["@Return"].Value); return(Return); }
public string Loginfirst_Insert(login_Class obj) { string Return = objModels.loginfirst_Insert(obj); return(Return); }