public List <EntitlementDTO> GetUserRole()
{
using (IDbSvc dbSvc = new DbSvc(_configSvc))
{
try
{
dbSvc.OpenConnection();
MySqlCommand command = new MySqlCommand();
command.CommandText = "select UserRoleId,RoleName from dic_entitlement where RoleIsActive=1";
command.Connection = dbSvc.GetConnection() as MySqlConnection;
_dtData = new DataTable();
MySqlDataAdapter msDa = new MySqlDataAdapter(command);
msDa.Fill(_dtData);
List <EntitlementDTO> lstEntitlement = new List <EntitlementDTO>();
if (_dtData != null && _dtData.Rows.Count > 0)
{
EntitlementDTO entitlementDTO = null;
foreach (DataRow dr in _dtData.Rows)
{
entitlementDTO = new EntitlementDTO();
entitlementDTO.UserRoleId = (int)dr["UserRoleId"];
entitlementDTO.RoleName = dr["RoleName"].ToString();
lstEntitlement.Add(entitlementDTO);
}
}
return(lstEntitlement);
}
catch (Exception exp)
{
throw exp;
}
}
}
// return Entitlement List
public SelectList getEntitleMentDropDown()
{
List <EntitlementDTO> lstentitleDto = _ddlRepo.GetUserRole();
EntitlementDTO entitleDto = new EntitlementDTO();
entitleDto.UserRoleId = -1;
entitleDto.RoleName = string.Empty;
lstentitleDto.Insert(0, entitleDto);
return(new SelectList(lstentitleDto, "UserRoleId", "RoleName"));
}
public StatusDTO <UserMasterDTO> Login(UserMasterDTO data, out List <EntitlementDTO> roleList, out List <ActionDTO> actionList)
{
StatusDTO <UserMasterDTO> status = new StatusDTO <UserMasterDTO>();
roleList = null;
actionList = null;
using (IDbSvc dbSvc = new DbSvc(_configSvc))
{
try
{
dbSvc.OpenConnection();
MySqlCommand command = new MySqlCommand();
command.CommandText = "UserLogin";
command.CommandType = CommandType.StoredProcedure;
command.Connection = dbSvc.GetConnection() as MySqlConnection;
command.Parameters.Add("@UserName", MySqlDbType.String).Value = data.UserName;
command.Parameters.Add("@UserPassword", MySqlDbType.String).Value = data.Password;
MySqlParameter error = new MySqlParameter("@ErrorMsg", MySqlDbType.VarChar);
error.Direction = ParameterDirection.Output;
command.Parameters.Add(error);
MySqlDataAdapter rdr = new MySqlDataAdapter(command);
_dsData = new DataSet();
rdr.Fill(_dsData);
List <EntitlementDTO> entitlementList = new List <EntitlementDTO>();
List <ActionDTO> useractionList = new List <ActionDTO>();
UserMasterDTO userMaster = new UserMasterDTO();
if (_dsData != null && _dsData.Tables.Count == 3)
{
if (_dsData.Tables[0].Rows.Count > 0)
{
userMaster.UserMasterId = Convert.ToInt32(_dsData.Tables[0].Rows[0]["UserMasterId"]);
userMaster.UserName = _dsData.Tables[0].Rows[0]["UserName"].ToString();
userMaster.FName = _dsData.Tables[0].Rows[0]["FName"].ToString();
userMaster.MName = _dsData.Tables[0].Rows[0]["MName"].ToString();
userMaster.LName = _dsData.Tables[0].Rows[0]["LName"].ToString();
}
if (_dsData.Tables[1].Rows.Count > 0)
{
EntitlementDTO userEntitle = new EntitlementDTO();
for (int i = 0; i < _dsData.Tables[1].Rows.Count; i++)
{
userEntitle.UserRoleId = Convert.ToInt32(_dsData.Tables[1].Rows[i]["UserRoleId"]);
userEntitle.RoleName = _dsData.Tables[1].Rows[i]["RoleName"].ToString();
entitlementList.Add(userEntitle);
}
roleList = entitlementList;
}
if (_dsData.Tables[2].Rows.Count > 0)
{
ActionDTO useractionDTO = null;
for (int i = 0; i < _dsData.Tables[2].Rows.Count; i++)
{
useractionDTO = new ActionDTO();
useractionDTO.ActionName = _dsData.Tables[2].Rows[i]["ActionName"].ToString();
useractionDTO.ActionLink = _dsData.Tables[2].Rows[i]["ActionLink"].ToString();
useractionDTO.IsChildAction = Convert.ToBoolean(_dsData.Tables[2].Rows[i]["IsChildAction"]);
useractionDTO.MenuText = _dsData.Tables[2].Rows[i]["MenuText"].ToString();
useractionDTO.DisabledControlId = _dsData.Tables[2].Rows[i]["DisabledControlId"].ToString();
useractionDTO.HiddenControlId = _dsData.Tables[2].Rows[i]["HiddenControlId"].ToString();
useractionDTO.GroupName = _dsData.Tables[2].Rows[i]["GroupName"].ToString();
useractionDTO.MenuImage = _dsData.Tables[2].Rows[i]["MenuImage"].ToString();
if (useractionDTO.IsChildAction || !string.IsNullOrEmpty(_dsData.Tables[2].Rows[i]["ParentActionId"].ToString()))
{
useractionDTO.ParentAction = new ActionDTO();
useractionDTO.ParentAction.RowId = Convert.ToInt32(_dsData.Tables[2].Rows[i]["ParentActionId"]);
useractionDTO.ParentAction.ActionLink = _dsData.Tables[2].Select("ActionId=" + useractionDTO.ParentAction.RowId)[0]["ActionLink"].ToString();
}
useractionList.Add(useractionDTO);
}
actionList = useractionList;
}
status.IsException = false;
status.IsSuccess = true;
status.ReturnObj = userMaster;
}
else
{
status.IsSuccess = false;
status.FailureReason = error.Value.ToString();
}
return(status);
}
catch (Exception exp)
{
throw exp;
}
}
}
