/// <summary> /// /// </summary> /// <param name="i_sConnectionString"></param> /// <param name="i_nUserInfoId"></param> /// <param name="o_nReturnValue"></param> /// <param name="o_nErroCode"></param> /// <param name="o_sErrorMessage"></param> /// <returns></returns> public InsiderTradingDAL.RoleMasterDTO GetRoleMasterDetails(string i_sConnectionString, int i_nRoleId) { InsiderTradingDAL.RoleMasterDTO res = null; try { //InsiderTradingDAL.RoleMasterDAL objRoleMaterDAL = new InsiderTradingDAL.RoleMasterDAL(); using (var objRoleMasterDAL = new InsiderTradingDAL.RoleMasterDAL()) { res = objRoleMasterDAL.GetDetails(i_sConnectionString, i_nRoleId); } } catch (Exception exp) { throw exp; } return(res); }
public ActionResult Create(int RoleId, int acid, string frm = "", int uid = 0) { LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); PopulateComboDTO objPopulateComboDTO = new PopulateComboDTO(); List <PopulateComboDTO> lstRoleStatusList = new List <PopulateComboDTO>(); List <PopulateComboDTO> lstUserTypeList = new List <PopulateComboDTO>(); try { objPopulateComboDTO.Key = "0"; objPopulateComboDTO.Value = "Select"; lstRoleStatusList.Add(objPopulateComboDTO); lstRoleStatusList.AddRange(Common.Common.GetPopulateCombo(objLoginUserDetails.CompanyDBConnectionString, ConstEnum.ComboType.ListOfCode, Convert.ToInt32(ConstEnum.CodeGroup.RoleStatus).ToString(), null, null, null, null, "usr_msg_").ToList <PopulateComboDTO>()); lstUserTypeList.Add(objPopulateComboDTO); lstUserTypeList.AddRange(Common.Common.GetPopulateCombo(objLoginUserDetails.CompanyDBConnectionString, ConstEnum.ComboType.ListOfCode, Convert.ToInt32(ConstEnum.CodeGroup.UserType).ToString(), null, null, null, null, "usr_msg_").ToList <PopulateComboDTO>()); ViewBag.RoleStatus = lstRoleStatusList; // new SelectList(lstRoleStatusList, "Key", "Value"); ViewBag.UserType = lstUserTypeList; //set varible to check if user come on role page from role menu option or from employee/insider create/edit page string link_from = ""; int user_id = 0; ViewBag.vwbUserTypeCodeId = 0; if (frm != "") { link_from = frm; user_id = uid; switch (frm) { case "emp": //link from employee page ViewBag.vwbUserTypeCodeId = ConstEnum.Code.EmployeeType; ViewBag.UserTypeCodeId = ConstEnum.Code.EmployeeType; break; case "nonemp": //link from non employee page ViewBag.vwbUserTypeCodeId = ConstEnum.Code.NonEmployeeType; ViewBag.UserTypeCodeId = ConstEnum.Code.NonEmployeeType; break; case "corp": //link from corporate employee page ViewBag.vwbUserTypeCodeId = ConstEnum.Code.CorporateUserType; ViewBag.UserTypeCodeId = ConstEnum.Code.CorporateUserType; break; case "cousr": //link from CO user page ViewBag.vwbUserTypeCodeId = ConstEnum.Code.COUserType; ViewBag.UserTypeCodeId = ConstEnum.Code.COUserType; break; default: //default return to role master list page break; } } ViewBag.link_from = link_from; ViewBag.user_id = user_id; ViewBag.user_action = acid; if (RoleId > 0) { RoleMasterSL objRoleMasterSL = new RoleMasterSL(); RoleMasterModel objRoleMasterModel = new RoleMasterModel(); InsiderTradingDAL.RoleMasterDTO objRoleMasterDTO = objRoleMasterSL.GetRoleMasterDetails(objLoginUserDetails.CompanyDBConnectionString, RoleId); InsiderTrading.Common.Common.CopyObjectPropertyByName(objRoleMasterDTO, objRoleMasterModel); ViewBag.IsDefault = objRoleMasterModel.IsDefault; ViewBag.IsActivityAssigned = objRoleMasterDTO.IsActivityAssigned; if (frm != "") { return(PartialView("Create", objRoleMasterModel)); } else { return(View("Create", objRoleMasterModel)); } } else { ViewBag.IsActivityAssigned = 0; ViewBag.IsDefault = false; if (frm != "") { return(PartialView("Create")); } else { return(View("Create")); } } } catch (Exception exp) { string sErrMessage = Common.Common.getResource(exp.InnerException.Data[0].ToString()); ModelState.AddModelError("Error", sErrMessage); return(View("View1")); } finally { objLoginUserDetails = null; objPopulateComboDTO = null; lstRoleStatusList = null; lstUserTypeList = null; } }
public ActionResult Create(RoleMasterModel objRoleMasterModel, int acid = 0, string frm = "", int uid = 0) { LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails); RoleMasterSL objRoleMasterSL = new RoleMasterSL(); InsiderTradingDAL.RoleMasterDTO objRoleMasterDTO = new InsiderTradingDAL.RoleMasterDTO(); PopulateComboDTO objPopulateComboDTO = new PopulateComboDTO(); List <PopulateComboDTO> lstRoleStatusList = new List <PopulateComboDTO>(); List <PopulateComboDTO> lstUserTypeList = new List <PopulateComboDTO>(); try { if (Request.Params["authorization"] != null && Request.Params["authorization"] != "") { acid = Convert.ToInt32(Request.Params["authorization"].Split(':')[1]); } InsiderTrading.Common.Common.CopyObjectPropertyByName(objRoleMasterModel, objRoleMasterDTO); objRoleMasterDTO = objRoleMasterSL.InsertUpdateRoleMasterDetails(objLoginUserDetails.CompanyDBConnectionString, objRoleMasterDTO, objLoginUserDetails.LoggedInUserID); //check from where create role page is called and redirect back to same page if (frm != "") { return(Json(new { status = true, url = Url.Action("Index", "RoleActivity", new { RoleId = objRoleMasterDTO.RoleId, CalledFrom = frm, acid = Common.ConstEnum.UserActions.CRUSER_ROLEMASTER_EDIT, uid = uid }), RoleId = objRoleMasterDTO.RoleId, CalledFrom = frm, RoleName = objRoleMasterDTO.RoleName, IsActive = (objRoleMasterDTO.StatusCodeId == ConstEnum.Code.RoleStatusActive ? true : false), uid = uid })); //return PartialView("RedirectToRoleActivity"); //return RedirectToAction("Index", "RoleActivity", new { RoleId = objRoleMasterDTO.RoleId, CalledFrom = frm, acid = ConstEnum.UserActions.CRUSER_ROLEMASTER_CREATE, uid = uid }).Success(Common.Common.getResource("usr_msg_12053")); } return(RedirectToAction("Index", "RoleMaster", new { acid = Common.ConstEnum.UserActions.CRUSER_ROLEMASTER_VIEW }).Success(Common.Common.getResource("usr_msg_12053"))); } catch (Exception exp) { string sErrMessage = Common.Common.getResource(exp.InnerException.Data[0].ToString()); ModelState.AddModelError("Error", sErrMessage); if (frm != "") { return(Json(new { status = false, error = ModelState.ToSerializedDictionary(), Message = sErrMessage })); } else { var RoleId = objRoleMasterModel.RoleId; ViewBag.IsActivityAssigned = 0; objPopulateComboDTO.Key = "0"; objPopulateComboDTO.Value = "Select"; lstRoleStatusList.Add(objPopulateComboDTO); lstRoleStatusList.AddRange(Common.Common.GetPopulateCombo(objLoginUserDetails.CompanyDBConnectionString, ConstEnum.ComboType.ListOfCode, Convert.ToInt32(ConstEnum.CodeGroup.RoleStatus).ToString(), null, null, null, null, "usr_msg_").ToList <PopulateComboDTO>()); lstUserTypeList.Add(objPopulateComboDTO); lstUserTypeList.AddRange(Common.Common.GetPopulateCombo(objLoginUserDetails.CompanyDBConnectionString, ConstEnum.ComboType.ListOfCode, Convert.ToInt32(ConstEnum.CodeGroup.UserType).ToString(), null, null, null, null, "usr_msg_").ToList <PopulateComboDTO>()); //ViewBag.RoleStatus = FillComboValues(ConstEnum.ComboType.ListOfCode, Convert.ToInt32(ConstEnum.CodeGroup.RoleStatus).ToString(), null, null, null, null, true); //ViewBag.UserType = FillComboValues(ConstEnum.ComboType.ListOfCode, Convert.ToInt32(ConstEnum.CodeGroup.UserType).ToString(), null, null, null, null, true); ViewBag.RoleStatus = lstRoleStatusList; // new SelectList(lstRoleStatusList, "Key", "Value"); ViewBag.UserType = lstUserTypeList; if (RoleId > 0) { objRoleMasterDTO = objRoleMasterSL.GetRoleMasterDetails(objLoginUserDetails.CompanyDBConnectionString, RoleId); ViewBag.IsActivityAssigned = objRoleMasterDTO.IsActivityAssigned; } ViewBag.IsDefault = objRoleMasterModel.IsDefault; //set varible to check if user come on role page from role menu option or from employee/insider create/edit page string link_from = ""; int user_id = 0; ViewBag.vwbUserTypeCodeId = 0; if (frm != "") { link_from = frm; user_id = uid; switch (frm) { case "emp": //link from employee page ViewBag.vwbUserTypeCodeId = ConstEnum.Code.EmployeeType; ViewBag.UserTypeCodeId = ConstEnum.Code.EmployeeType; break; case "nonemp": //link from non employee page ViewBag.vwbUserTypeCodeId = ConstEnum.Code.NonEmployeeType; ViewBag.UserTypeCodeId = ConstEnum.Code.NonEmployeeType; break; case "corp": //link from corporate employee page ViewBag.vwbUserTypeCodeId = ConstEnum.Code.CorporateUserType; ViewBag.UserTypeCodeId = ConstEnum.Code.CorporateUserType; break; case "cousr": //link from CO user page ViewBag.vwbUserTypeCodeId = ConstEnum.Code.COUserType; ViewBag.UserTypeCodeId = ConstEnum.Code.COUserType; break; default: //default return to role master list page break; } } ViewBag.link_from = link_from; ViewBag.user_id = user_id; ViewBag.user_action = acid; return(View("Create", objRoleMasterModel)); } } finally { objLoginUserDetails = null; objRoleMasterSL = null; objRoleMasterDTO = null; objPopulateComboDTO = null; lstRoleStatusList = null; lstUserTypeList = null; } }
public RoleMasterDTO InsertUpdateRoleMasterDetails(string sConnectionString, RoleMasterDTO m_objRoleMasterDTO, int nLoggedInUserId) { #region Paramters int out_nReturnValue; int out_nSQLErrCode; string out_sSQLErrMessage; #endregion Paramters try { #region Out Paramter var nout_nReturnValue = new SqlParameter("@out_nReturnValue", System.Data.SqlDbType.Int); nout_nReturnValue.Direction = System.Data.ParameterDirection.Output; nout_nReturnValue.Value = 0; var nout_nSQLErrCode = new SqlParameter("@out_nSQLErrCode", System.Data.SqlDbType.Int); nout_nSQLErrCode.Direction = System.Data.ParameterDirection.Output; nout_nSQLErrCode.Value = 0; var sout_sSQLErrMessage = new SqlParameter("@out_sSQLErrMessage", System.Data.SqlDbType.NVarChar); sout_sSQLErrMessage.Direction = System.Data.ParameterDirection.Output; sout_sSQLErrMessage.Value = string.Empty; #endregion Out Paramter using (var db = new PetaPoco.Database(sConnectionString, "System.Data.SqlClient") { EnableAutoSelect = false }) { using (var scope = db.GetTransaction()) { var res = db.Query <RoleMasterDTO>("exec st_usr_RoleMasterSave @inp_iRoleId,@inp_sRoleName,@inp_sDescription,@inp_iStatusCodeId,@inp_iUserTypeCodeId,@inp_iIsDefault,@inp_iLoggedInUserId,@out_nReturnValue OUTPUT,@out_nSQLErrCode OUTPUT,@out_sSQLErrMessage OUTPUT", new { @inp_iRoleId = m_objRoleMasterDTO.RoleId, @inp_sRoleName = m_objRoleMasterDTO.RoleName, @inp_sDescription = m_objRoleMasterDTO.Description, @inp_iStatusCodeId = m_objRoleMasterDTO.StatusCodeId, @inp_iUserTypeCodeId = m_objRoleMasterDTO.UserTypeCodeId, @inp_iIsDefault = (m_objRoleMasterDTO.IsDefault ? 1 : 0), @inp_iLoggedInUserId = nLoggedInUserId, @out_nReturnValue = nout_nReturnValue, @out_nSQLErrCode = nout_nSQLErrCode, @out_sSQLErrMessage = sout_sSQLErrMessage, }).SingleOrDefault <RoleMasterDTO>(); #region Error Values if (Convert.ToInt32(nout_nReturnValue.Value) != 0) { Exception e = new Exception(); out_nReturnValue = Convert.ToInt32(nout_nReturnValue.Value); string sReturnValue = sLookUpPrefix + out_nReturnValue; e.Data[0] = sReturnValue; if (nout_nSQLErrCode.Value != System.DBNull.Value) { out_nSQLErrCode = Convert.ToInt32(nout_nSQLErrCode.Value); e.Data[1] = out_nSQLErrCode; } if (sout_sSQLErrMessage.Value != System.DBNull.Value) { out_sSQLErrMessage = Convert.ToString(sout_sSQLErrMessage.Value); e.Data[2] = out_sSQLErrMessage; } Exception ex = new Exception(db.LastSQL.ToString(), e); throw ex; } else { scope.Complete(); return(res); } #endregion Error Values } } } catch (Exception exp) { throw exp; } finally { } }
public IEnumerable <RoleMasterDTO> GetList(RoleMasterDTO m_objRoleMasterDTO, string sConnectionString) { #region Paramters int out_nReturnValue; int out_nSQLErrCode; string out_sSQLErrMessage; #endregion Paramters try { #region Out Paramter var nout_nReturnValue = new SqlParameter("@out_nReturnValue", System.Data.SqlDbType.Int); nout_nReturnValue.Direction = System.Data.ParameterDirection.Output; nout_nReturnValue.Value = 0; var nout_nSQLErrCode = new SqlParameter("@out_nSQLErrCode", System.Data.SqlDbType.Int); nout_nSQLErrCode.Direction = System.Data.ParameterDirection.Output; nout_nSQLErrCode.Value = 0; var sout_sSQLErrMessage = new SqlParameter("@out_sSQLErrMessage", System.Data.SqlDbType.NVarChar); sout_sSQLErrMessage.Direction = System.Data.ParameterDirection.Output; sout_sSQLErrMessage.Value = string.Empty; #endregion Out Paramter using (var db = new PetaPoco.Database(sConnectionString, "System.Data.SqlClient") { EnableAutoSelect = false }) { var res = db.Query <RoleMasterDTO>("exec st_usr_RoleMasterList @inp_iRoleId,@inp_sRoleName,@inp_sDescription,@inp_iStatusCodeId,@inp_sLandingPageURL,@inp_iUserTypeCodeId,@out_nReturnValue OUTPUT,@out_nSQLErrCode OUTPUT,@out_sSQLErrMessage OUTPUT", new { @inp_iRoleId = m_objRoleMasterDTO.RoleId, @inp_sRoleName = m_objRoleMasterDTO.RoleName, @inp_sDescription = m_objRoleMasterDTO.Description, @inp_iStatusCodeId = m_objRoleMasterDTO.StatusCodeId, @inp_iUserTypeCodeId = m_objRoleMasterDTO.UserTypeCodeId, }).ToList <RoleMasterDTO>(); #region Error Values if (Convert.ToInt32(nout_nReturnValue.Value) != 0) { Exception e = new Exception(); out_nReturnValue = Convert.ToInt32(nout_nReturnValue.Value); e.Data[0] = out_nReturnValue; if (nout_nSQLErrCode.Value != System.DBNull.Value) { out_nSQLErrCode = Convert.ToInt32(nout_nSQLErrCode.Value); e.Data[1] = out_nSQLErrCode; } if (sout_sSQLErrMessage.Value != System.DBNull.Value) { out_sSQLErrMessage = Convert.ToString(sout_sSQLErrMessage.Value); e.Data[2] = out_sSQLErrMessage; } Exception ex = new Exception(db.LastCommand.ToString(), e); throw ex; } else { return(res); } #endregion Error Values } } catch (Exception exp) { throw exp; } finally { } }