public int ValidateLocalLogin(string strUserName, string strPassword) { //string str = "SELECT UserID FROM tblUserManagement WHERE UserName = '******' AND Password = '******' AND ActiveStatus=1"; string str = "SELECT UserID FROM tblUserManagement WHERE UserName = '******' AND Password = '******'"; List <UserManagement> lstUser = _database.Query <UserManagement>(str); if (lstUser.Count > 0) { Service.clsSmartTailoringService.UserID = lstUser[0].UserID; } return(lstUser.Count); }