public int IsUserExist(MemberUserObject user) { bool flag = false; con.Open(); SqlCommand command = new SqlCommand("Select u_id From Users Where u_name='" + user.u_name + "' And u_password='******'", con); return(Convert.ToInt32(command.ExecuteScalar())); }
public void AddEmpDetails(MemberUserObject EmpDetails) { try { con.Open(); SqlCommand command = new SqlCommand("INSERT INTO ShoppingCart.Users (u_name,u_adress,u_id,u_password,u_email) VALUES (" + EmpDetails.u_name + "," + EmpDetails.u_adress + ", " + EmpDetails.u_id + "," + EmpDetails.u_password + "," + EmpDetails.u_email + "); ", con); flag = Convert.ToBoolean(command.ExecuteScalar()); if (flag) { Console.WriteLine("welcome"); } } catch { throw; } finally { con.Dispose(); con.Close(); } }