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);
}
