public void IsUserExist(MemberUserObject EmpDetails) { bool flag = false; con.Open(); SqlCommand command = new SqlCommand("Select u_name From ShoppingCart Where u_name='" + EmpDetails.u_name + "' And u_password='******'", con); flag = Convert.ToBoolean(command.ExecuteScalar()); con.Close(); }
public void InsertUserDetails(MemberUserObject EBO) { try { DAL.AddEmpDetails(EBO); } catch { throw; } }
public void AddEmpDetails(MemberUserObject EmpDetails) { try { bool flag = false; con.Open(); SqlCommand command = new SqlCommand("INSERT INTO ShoppingCart.Users (u_name,u_adress,u_id,u_password) VALUES ("+EmpDetails.u_name+","+ EmpDetails.u_adress+", " + EmpDetails.u_id + "," + EmpDetails.u_password +"); ", con); flag = Convert.ToBoolean(command.ExecuteScalar()); } catch { throw; } finally { con.Dispose(); con.Close(); } }
public void SelectUserDetails(MemberUserObject EBO) { DAL.IsUserExist(EBO); }