public ResponseModel GetStoreRolesByUserID() { ResponseModel objResponseModel = new ResponseModel(); StoreCRMRoleModel objCRMRoleModel = new StoreCRMRoleModel(); int statusCode = 0; string statusMessage = ""; try { ////Get token (Double encrypted) and get the tenant id string token = Convert.ToString(Request.Headers["X-Authorized-Token"]); Authenticate authenticate = new Authenticate(); authenticate = SecurityService.GetAuthenticateDataFromToken(_radisCacheServerAddress, SecurityService.DecryptStringAES(token)); StoreCRMRoleCaller newCRM = new StoreCRMRoleCaller(); objCRMRoleModel = newCRM.GetCRMRoleByUserID(new StoreCRMRoleService(_connectioSting), authenticate.TenantId, authenticate.UserMasterID); statusCode = objCRMRoleModel == null ? (int)EnumMaster.StatusCode.RecordNotFound : (int)EnumMaster.StatusCode.Success; statusMessage = CommonFunction.GetEnumDescription((EnumMaster.StatusCode)statusCode); objResponseModel.Status = true; objResponseModel.StatusCode = statusCode; objResponseModel.Message = statusMessage; objResponseModel.ResponseData = objCRMRoleModel; } catch (Exception) { throw; } return(objResponseModel); }
/// <summary> /// Get CRM Role Dropdown /// </summary> /// <param name="tenantID"></param> public List <StoreCRMRoleModel> GetStoreCRMRoleDropdown(int tenantID) { List <StoreCRMRoleModel> objCRMLst = new List <StoreCRMRoleModel>(); DataSet ds = new DataSet(); MySqlCommand cmd = new MySqlCommand(); try { conn.Open(); cmd.Connection = conn; MySqlCommand cmd1 = new MySqlCommand("SP_GetStoreCRMDropdown", conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@Tenant_ID", tenantID); MySqlDataAdapter da = new MySqlDataAdapter(); da.SelectCommand = cmd1; da.Fill(ds); if (ds != null && ds.Tables[0] != null) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { StoreCRMRoleModel cRMRoleModel = new StoreCRMRoleModel(); cRMRoleModel.CRMRoleID = Convert.ToInt32(ds.Tables[0].Rows[i]["RoleID"]); cRMRoleModel.RoleName = Convert.ToString(ds.Tables[0].Rows[i]["RoleName"]); objCRMLst.Add(cRMRoleModel); } } } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } } return(objCRMLst); }
/// <summary> /// Get CRM Role By UserID /// </summary> /// <param name="tenantID"></param> /// <param name="UserID"></param> public StoreCRMRoleModel GetStoreCRMRoleByUserID(int tenantID, int UserID) { StoreCRMRoleModel cRMRoleModel = new StoreCRMRoleModel(); DataSet ds = new DataSet(); MySqlCommand cmd = new MySqlCommand(); try { conn.Open(); cmd.Connection = conn; MySqlCommand cmd1 = new MySqlCommand("SP_GetStoreCRMRoleDetailsByUserID", conn); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@_tenantID", tenantID); cmd1.Parameters.AddWithValue("@_userID", UserID); MySqlDataAdapter da = new MySqlDataAdapter(); da.SelectCommand = cmd1; da.Fill(ds); var test = ds.Tables.Count; if (ds != null && ds.Tables != null) { if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { cRMRoleModel = ds.Tables[0].AsEnumerable().Select(r => new StoreCRMRoleModel() { CRMRoleID = Convert.ToInt32(r.Field <object>("CRMRolesID")), RoleName = r.Field <object>("RoleName") == System.DBNull.Value ? string.Empty : Convert.ToString(r.Field <object>("RoleName")), isRoleActive = r.Field <object>("RoleStatus") == System.DBNull.Value ? string.Empty : Convert.ToString(r.Field <object>("RoleStatus")), CreatedBy = r.Field <object>("CreatedBy") == System.DBNull.Value ? string.Empty : Convert.ToString(r.Field <object>("CreatedBy")), CreatedDate = r.Field <object>("CreatedDate") == System.DBNull.Value ? string.Empty : Convert.ToString(r.Field <object>("CreatedDate")), ModifiedBy = r.Field <object>("UpdatedBy") == System.DBNull.Value ? string.Empty : Convert.ToString(r.Field <object>("UpdatedBy")), ModifiedDate = r.Field <object>("UpdatedDate") == System.DBNull.Value ? string.Empty : Convert.ToString(r.Field <object>("UpdatedDate")), }).FirstOrDefault(); } if (cRMRoleModel != null) { if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0) { cRMRoleModel.Modules = ds.Tables[1].AsEnumerable().Where(r => r.Field <object>("CRMRolesID") != System.DBNull.Value && cRMRoleModel.CRMRoleID.Equals(Convert.ToInt32(r.Field <object>("CRMRolesID")))).Select(r => new StoreModuleDetails() { CRMRoleID = Convert.ToInt32(r.Field <object>("CRMRolesID")), ModuleID = Convert.ToInt32(r.Field <object>("ModuleID")), ModuleName = r.Field <object>("ModuleName") == System.DBNull.Value ? string.Empty : Convert.ToString(r.Field <object>("ModuleName")), Modulestatus = r.Field <object>("ModuleStatus") == System.DBNull.Value ? false : Convert.ToBoolean(Convert.ToInt16(r.Field <object>("ModuleStatus"))), }).OrderBy(x => x.ModuleID).ToList(); } } } } catch (Exception) { throw; } finally { if (conn != null) { conn.Close(); } if (ds != null) { ds.Dispose(); } } return(cRMRoleModel); }