public int IsLogInValid(string id, string password) { this.sql = "select * from Login where userid ='" + id + "'and password ='******';"; this.Ds = DBcon.GetDataSet(sql); if (this.Ds.Tables[0].Rows.Count == 1) { if (IsAdminValid(id, password) == true) { return(1); } else if (IsEmployeeValid(id, password) == true) { return(2); } else { return(0); } } else { return(0); } }
public bool IsEmployeeValid(string id, string password) { this.sql = "select * from Login where userid ='" + id + "'and password ='******'and usertype ='Employee';"; this.Ds = DBcon.GetDataSet(sql); if (this.Ds.Tables[0].Rows.Count == 1) { return(true); } else { return(false); } }