public static AppUserDetails SetAppUserDetails(string username) { string sql = "SELECT U.UserID, U.UserName, U.DistrictID, U.PartnerID, D.DistrictName, UT.UserTypeCode, U.FullName, U.SaMIOrganizationID " + "FROM tbl_users AS U " + "JOIN tbl_districts AS D ON D.DistrictID = U.DistrictID " + "JOIN tbl_user_types UT ON UT.UserTypeID = U.UserTypeID " + "LEFT JOIN tbl_stakeholders SH ON SH.StakeHolderID = U.PartnerID " + "LEFT JOIN tbl_SaMI_organizations SO ON SO.SaMIOrganizationID = U.SaMIOrganizationID " + "WHERE UserName = '******'"; DataView dv = new UserDAO().ExecuteQuery(sql); AppUserDetails objAppUserDetails = null; if (dv.Table.Rows.Count > 0) { objAppUserDetails = new AppUserDetails(); objAppUserDetails.UserID = (int)dv.Table.Rows[0]["UserID"]; objAppUserDetails.DistrictID = (int)dv.Table.Rows[0]["DistrictID"]; objAppUserDetails.PartnerID = (int)dv.Table.Rows[0]["PartnerID"]; objAppUserDetails.UserType = dv.Table.Rows[0]["UserTypeCode"].ToString(); objAppUserDetails.FullName = dv.Table.Rows[0]["FullName"].ToString(); objAppUserDetails.DistrictName = dv.Table.Rows[0]["DistrictName"].ToString(); if (dv.Table.Rows[0]["SaMIOrganizationID"] != DBNull.Value) objAppUserDetails.SaMIOrganizationID = (int)dv.Table.Rows[0]["SaMIOrganizationID"]; else objAppUserDetails.SaMIOrganizationID = 0; } return objAppUserDetails; }
public static Boolean CheckLogin(string username, string password) { Boolean blnLogin = false; DataView dv = new UserDAO().CheckLogin(username, AppCommonBO.EncodeUserPassword(password)); if (dv.Table.Rows.Count > 0) blnLogin = true; return blnLogin; }
public static Boolean CheckUserAuthentication(string username, string password) { Boolean blnLogin = false; DataView dv = new UserDAO().CheckUserAuthentication(username, password); if (dv.Table.Rows.Count > 0) blnLogin = true; return blnLogin; }
public static Boolean IsUserExists(string UserName) { Boolean blnExists = false; DataView dv = new UserDAO().Select("UserName", "", "UserName = '******'"); if (dv.Count > 0) blnExists = true; return blnExists; }