public SqlDataAdapter ReqCity()
{
AddCustomerDAL ud = new AddCustomerDAL();
SqlDataAdapter rd = ud.GetCity();
return(rd);
}
public void UserInsertBusiness(Users u)
{
SqlParameter[] sp = new SqlParameter[10];
sp[0] = new SqlParameter("@upassword", u.UserPassword);
sp[1] = new SqlParameter("@uname", u.UserName);
sp[2] = new SqlParameter("@emailid", u.UserEmailId);
sp[3] = new SqlParameter("@mobile", u.UserMobile);
sp[4] = new SqlParameter("@annual_income", u.UserIncome);
sp[5] = new SqlParameter("@pincode", u.UserPincode);
sp[6] = new SqlParameter("@address", u.UserAddress);
sp[7] = new SqlParameter("@dob", u.UserDob);
sp[8] = new SqlParameter("@created_at", u.CreatedAt);
sp[9] = new SqlParameter("@city_name", u.UserCity);
try
{
AddCustomerDAL ud = new AddCustomerDAL();
ud.insert_User(sp);
}
catch (Exception e)
{
Console.Write(e);
}
}
public SqlDataAdapter UserCredentials(Users u)
{
SqlParameter[] sp = new SqlParameter[1];
sp[0] = new SqlParameter("@email", u.UserEmailId);
AddCustomerDAL ud = new AddCustomerDAL();
SqlDataAdapter rd = ud.GetUserCredential(sp);
return(rd);
}
public int GetAddResult(Customers customers)
{
AddCustomerDAL AddCS = new AddCustomerDAL();
int r = AddCS.InsertCustomer(customers);
if (r > 0)
{
return(1);//表示成功
}
else
{
return(2);//表示失败
}
}