public SubuserBLL.SubuserEntity AuthenticateSubuser2(DBSite site, string email_id, string password) { SubuserBLL.SubuserEntity sub_user = null; string qry = "SELECT " + " SubuserID " + ", SubUserName " + ", EmailId " + ", Active " + ", UserId " + " FROM tblSubuser "; qry += " WHERE EmailId='" + email_id + "'" + " AND SubuserPassword='******'"; DataTable dt = site.ExecuteSelect(qry); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; sub_user = new SubuserBLL.SubuserEntity(); sub_user.SubuserId = util.CheckNullInt(row["SubuserID"]); sub_user.SubuserName = util.CheckNull(row["SubUserName"]); sub_user.EmailId = util.CheckNull(row["EmailID"]); sub_user.UserState = util.CheckNull(row["Active"]); sub_user.UserId = util.CheckNullInt(row["UserId"]); } return(sub_user); }
//---------- Get subusers of user ------------------- public List <SubuserBLL.SubuserEntity> GetSubusers(DBSite site, string user_id) { List <SubuserBLL.SubuserEntity> subuser_list = new List <SubuserBLL.SubuserEntity>(); SubuserBLL.SubuserEntity subuser = null; string qry = " SELECT " + "SubuserId" + ", SubuserName" + ", SubuserCreationDate" + ", SubuserPassword" + ", EmailId" + ", Active" + ", Designation" + ", Address" + ", City" + ", Mobile" + " FROM tblSubuser" + " WHERE UserId=" + user_id; DataTable subuser_table = site.ExecuteSelect(qry); foreach (DataRow row in subuser_table.Rows) { subuser = new SubuserBLL.SubuserEntity(); subuser.SubuserId = util.CheckNullInt(row["SubuserId"]); subuser.SubuserName = util.CheckNull(row["SubuserName"]); subuser.CreationDate = Convert.ToDateTime(row["SubuserCreationDate"]).ToShortDateString(); subuser.Password = util.CheckNull(row["SubuserPassword"]); subuser.EmailId = util.CheckNull(row["EmailId"]); subuser.UserState = util.CheckNull(row["Active"]); subuser.Designation = util.CheckNull(row["Designation"]); subuser.Address = util.CheckNull(row["Address"]); subuser.City = util.CheckNull(row["City"]); subuser.Mobile = util.CheckNull(row["Mobile"]); subuser_list.Add(subuser); } return(subuser_list); }