public JsonResult dropdownIndex(int FinancialYearId, int FinancialPeriodTypeId, int acid) { LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); ComCodeSL objComCodeModel = new ComCodeSL(); ComCodeDTO objComCodeDTO = new ComCodeDTO(); Common.Common objCommon = new Common.Common(); if (!objCommon.ValidateCSRFForAJAX()) { return(Json(new { status = false, Message = "" }, JsonRequestBehavior.AllowGet)); } ViewBag.FinancialYearId = FinancialYearId; if (FinancialYearId != 0) { objComCodeDTO = objComCodeModel.GetDetails(objLoginUserDetails.CompanyDBConnectionString, FinancialYearId); FinancialPeriodTypeId = (objComCodeDTO.ParentCodeId == null ? 0 : Convert.ToInt32(objComCodeDTO.ParentCodeId)); } return(Json(new { status = true, FinancialPeriodTypeId = FinancialPeriodTypeId, Message = "Contact Successfully Submitted" }, JsonRequestBehavior.AllowGet)); //return RedirectToAction("Index", "TradingWindowEvent", new { FinancialYearId = FinancialYearId, acid = acid }); }
//[Button(ButtonName = "dropdown")] //[ActionName("dropdownIndex")] public JsonResult fillTemplateDropdown(int CommunicationModeCodeId) { //LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); Common.Common objCommon = new Common.Common(); if (!objCommon.ValidateCSRFForAJAX()) { return(Json(new { status = false, Message = "" }, JsonRequestBehavior.AllowGet)); } List <PopulateComboDTO> lstList = new List <PopulateComboDTO>(); if (CommunicationModeCodeId != 0) { lstList = FillComboValues(ConstEnum.ComboType.TemplateList, Convert.ToString(CommunicationModeCodeId), null, null, null, null, true); ViewBag.TemplateList = lstList; } return(Json(new { status = true, FinancialPeriodTypeId = lstList, Message = "" }, JsonRequestBehavior.AllowGet)); //return RedirectToAction("Index", "TradingWindowEvent", new { FinancialYearId = FinancialYearId, acid = acid }); }
public Body(Database _db, UserModel _user) { this.db = _db; this.user = _user; this.cm = new Common.Common(db); this.bIsMale = this.user.Gender == "M"; }
public ModbusTCP(string sCompanyID, string sEquipmentIDs, int iDBCallTimes, int iEquipmentStateTime) { gsCompanyID = sCompanyID; gsEquipmentIDs = sEquipmentIDs; giDBCallTimes = iDBCallTimes; giEquipmentStateTime = iEquipmentStateTime; wsEEP_Client_WS = new EEP_Client_WS.EEP_Client_WS(); objMS_SQL = new AdapterLogs.AdapterLogs.MS_SQL(); objCommon = new Common.Common(); }
public ModbusTCP(string sCompanyID, string sEquipmentIDs, int iDBCallTimes, int iEquipmentStateTime) { gsCompanyID = sCompanyID; gsEquipmentIDs = sEquipmentIDs; giDBCallTimes = iDBCallTimes; giEquipmentStateTime = iEquipmentStateTime; wsEEP_Client_WS = new EEP_Client_WS.EEP_Client_WS(); objMS_SQL = new AdapterLogs.AdapterLogs.MS_SQL(); objCommon = new Common.Common(); }
public ActionResult PartialCreateView2(int CommunicationMode_id) { LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); Common.Common objCommon = new Common.Common(); if (!objCommon.ValidateCSRFForAJAX()) { return(RedirectToAction("Unauthorised", "Home")); } ViewBag.isAllEdit = isAllEdit; ViewBag.CommunicationMode_id = CommunicationMode_id; return(PartialView("PartialCreate2")); }
/// <summary> /// 美食展示分页 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult DishesShow(int?id = 1) { int totalCount = 0; int pageIndex = id ?? 1; int pageSize = 6; PagedList <Dishes> objlist = new DishManager().GetDishes("", pageSize, (pageIndex - 1) * 6, out totalCount).AsQueryable().ToPagedList(pageIndex, pageSize); objlist.TotalItemCount = totalCount; objlist.CurrentPageIndex = (int)(id ?? 1); Common.Common info = new Common.Common(); info.objDish = objlist; return(View("DishesShow", info)); }
public ActionResult NewsManager(int?id = 1) { int totalCount = 0; int pageIndex = id ?? 1; int pageSize = 6; PagedList <News> objlist = new NewsManager().GetNews("", pageSize, (pageIndex - 1) * 5, out totalCount).AsQueryable().ToPagedList(pageIndex, pageSize); objlist.TotalItemCount = totalCount; objlist.CurrentPageIndex = (int)(id ?? 1); Common.Common info = new Common.Common(); info.objNewsModel = objlist; return(View("NewsManager", info)); }
public ActionResult ParentPopulateCombo_OnChange(string CodeId, string CalledFrom, int ParentId, int acid) { Common.Common objCommon = new Common.Common(); if (!objCommon.ValidateCSRFForAJAX()) { return(RedirectToAction("Unauthorised", "Home")); } ViewBag.GridType = ConstEnum.GridType.ComCodeList; ViewBag.AddNew = ParentId; ViewBag.UserAction = acid; return(PartialView("PartialDataGrid")); }
public static Models.ApiResultModel<List<OrdersModel>> GetOrders() { Common.Common common = new Common.Common(); try { OrdersService ordersService = new OrdersService(); List<OrdersModel> orders = ordersService.GetOrders(); return common.ThrowResult<List<OrdersModel>>(Enum.ApiStatusEnum.OK, string.Empty, orders); } catch (Exception ex) { return common.ThrowResult<List<OrdersModel>>(Enum.ApiStatusEnum.InternalServerError, ex.Message, null); } }
public static Models.ApiResultModel <List <CustomersModel> > GetCustomers() { Common.Common common = new Common.Common(); try { CustomerDetailService customerDetailService = new CustomerDetailService(); List <CustomersModel> customers = customerDetailService.GetCustomers(); return(common.ThrowResult <List <CustomersModel> >(Enum.ApiStatusEnum.OK, string.Empty, customers)); } catch (Exception ex) { return(common.ThrowResult <List <CustomersModel> >(Enum.ApiStatusEnum.InternalServerError, ex.Message, null)); } }
public static Models.ApiResultModel <bool> EditAddress(int id, string address) { Common.Common common = new Common.Common(); try { CustomerDetailService customerDetailService = new CustomerDetailService(); bool r = customerDetailService.EditAddress(id, address); return(common.ThrowResult <bool>(Enum.ApiStatusEnum.OK, string.Empty, r)); } catch (Exception ex) { return(common.ThrowResult <bool>(Enum.ApiStatusEnum.InternalServerError, ex.Message, false)); } }
public async Task <IHttpActionResult> PostLogin([FromBody] Login data) { Login login = new Login(); try { Common.Common obj = new Common.Common(); List <Login> lst = new List <Login>(); login = await obj.Login(data.Code); } catch (Exception ex) { return(null); } return(Ok(login)); }
/// <summary> /// This method is used to fetch sub category drop down view (partial) /// </summary> /// <param name="category_id"></param> /// <returns></returns> public ActionResult PartialCreateView(int CommunicationMode_id) { Common.Common objCommon = new Common.Common(); if (!objCommon.ValidateCSRFForAJAX()) { return(RedirectToAction("Unauthorised", "Home")); } CommunicationRuleMasterModel objCommunicationRuleMasterModel = new CommunicationRuleMasterModel(); LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); List <PopulateComboDTO> lstList = new List <PopulateComboDTO>(); ViewBag.isAllEdit = isAllEdit; lstList = FillComboValues(ConstEnum.ComboType.ListOfCode, Convert.ToInt32(ConstEnum.CodeGroup.Events).ToString(), null, null, null, null, false); ViewBag.TriggerEventCodeList = lstList; lstList = FillComboValues(ConstEnum.ComboType.ListofEventsWithUserTypeForCommunicatioTriggerEvent, null, null, null, null, null, false); ViewBag.TriggerEventCodeWithUserTypeList = lstList; lstList = FillComboValues(ConstEnum.ComboType.ListOfCode, Convert.ToInt32(ConstEnum.CodeGroup.Events).ToString(), null, null, null, null, false); ViewBag.OffsetEventCodeList = lstList; objCommunicationRuleMasterModel.AssignedTriggerEventCodeId = new List <PopulateComboDTO>(); objCommunicationRuleMasterModel.AssignedOffsetEventCodeId = new List <PopulateComboDTO>(); ViewBag.CommunicationMode_id = CommunicationMode_id; return(PartialView("PartialCreate1", objCommunicationRuleMasterModel)); }
private void bt_print_Click(object sender, EventArgs e) { //RdlcPrintNew rdlcprint = new RdlcPrintNew(); //rdlcprint.Run(reportView.LocalReport, "单据打印", false, "A4"); //DataGridViewExport.DataGridviewShowToExcel(dgv_tjxm,false); string path = ""; bool overWrite = true; if (dgv_tjxm.Rows.Count == 0) { return; } Common.Common comn = new Common.Common(); saveFileDialog1.Filter = "Excel File|*.xls"; saveFileDialog1.Title = "数据导出"; if (saveFileDialog1.ShowDialog() != DialogResult.Cancel) { path = saveFileDialog1.FileName; DataGridViewExport.ExportToExcel(dgv_tjxm, path, "s", overWrite); } DialogResult result = MessageBox.Show("是否打开Excel文件?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.No) { return; } if (DataGridViewExport.IsExistsExcel()) { DataGridViewExport.OpenExcel(path); } }
protected void Page_Load(object sender, EventArgs e) { BLL.Administrator bllAdministrator = new BLL.Administrator(); Model.Administrator modelAdministrator = new Model.Administrator(); Common.Common common = new Common.Common(); string ManagerGUID = ""; switch (Request["ActionMethod"]) { case "OpenCreate": break; case "OpenEdit": ManagerGUID = common.SQLFilter(Request["ManagerGUID"]); modelAdministrator = bllAdministrator.ExGetModel(ManagerGUID); txtManagerUserName.Value = modelAdministrator.AdminUser; txtManagerName.Value = modelAdministrator.AdminAccount; break; default: common.MsgAndClose("服务器错误,请重试!7516", this); break; } }
public ActionResult ChangePassword(int formId, int acid, PasswordManagementModel objPwdMgmtModel) { bool bErrorOccurred = false; string i_ErrorMessage = ""; LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); PasswordManagementDTO objPwdMgmtDTO = new PasswordManagementDTO(); PasswordConfigModel objPassConfigModel = new PasswordConfigModel(); UserInfoSL objUserInfoSL = new UserInfoSL(); UserPolicyDocumentEventLogDTO objChangePasswordEventLogDTO = null; PasswordExpiryReminderDTO objPassExpiryReminderDTO = null; InsiderTradingEncryption.DataSecurity objPwdHash = new InsiderTradingEncryption.DataSecurity(); try { DataSecurity objDataSecurity = new DataSecurity(); string sOldPassword = string.Empty; string sNewPassword = string.Empty; string sConfirmNewPassword = string.Empty; string sPasswordHash = string.Empty; string sPasswordHashWithSalt = string.Empty; string sSaltValue = string.Empty; string javascriptEncryptionKey = Common.ConstEnum.Javascript_Encryption_Key; string userPasswordHashSalt = Common.ConstEnum.User_Password_Encryption_Key; if (objPwdMgmtModel.OldPassword == null || objPwdMgmtModel.OldPassword == "" || objPwdMgmtModel.NewPassword == null || objPwdMgmtModel.NewPassword == "" || objPwdMgmtModel.ConfirmNewPassword == null || objPwdMgmtModel.ConfirmNewPassword == "") { i_ErrorMessage = "All fields are required fields."; bErrorOccurred = true; } else if (objPwdMgmtModel.NewPassword == null || objPwdMgmtModel.NewPassword == "" || objPwdMgmtModel.ConfirmNewPassword == null || objPwdMgmtModel.ConfirmNewPassword == "") { i_ErrorMessage = "Please enter new password and confirm new password."; bErrorOccurred = true; } else if (objPwdMgmtModel.NewPassword != objPwdMgmtModel.ConfirmNewPassword) { i_ErrorMessage = "New password and Confirm password are not matching."; bErrorOccurred = true; } else if (objPwdMgmtModel.OldPassword == objPwdMgmtModel.NewPassword) { i_ErrorMessage = "New password should not be same as old password."; bErrorOccurred = true; } else if (!string.IsNullOrEmpty(objPwdMgmtModel.OldPassword) && !string.IsNullOrEmpty(objPwdMgmtModel.NewPassword) && !string.IsNullOrEmpty(objPwdMgmtModel.ConfirmNewPassword)) { sOldPassword = DecryptStringAES(objPwdMgmtModel.OldPassword, javascriptEncryptionKey, javascriptEncryptionKey); sNewPassword = DecryptStringAES(objPwdMgmtModel.NewPassword, javascriptEncryptionKey, javascriptEncryptionKey); sConfirmNewPassword = DecryptStringAES(objPwdMgmtModel.ConfirmNewPassword, javascriptEncryptionKey, javascriptEncryptionKey); sPasswordHashWithSalt = objPwdHash.CreateSaltandHash(sNewPassword); sPasswordHash = sPasswordHashWithSalt.Split('~')[0].ToString(); sSaltValue = sPasswordHashWithSalt.Split('~')[1].ToString(); } //Check if the new password follows Password policy if (!bErrorOccurred) { Common.Common objCommon = new Common.Common(); bool isPasswordValid = objCommon.ValidatePassword(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.UserName, sNewPassword, sPasswordHash, objLoginUserDetails.LoggedInUserID, out i_ErrorMessage); if (!isPasswordValid) { bErrorOccurred = true; } } if (bErrorOccurred) { ViewBag.LoginError = i_ErrorMessage; return(View("ChangePassword")); } objPwdMgmtModel.UserInfoID = objLoginUserDetails.LoggedInUserID; string saltValue = string.Empty; string calledFrom = "ChangPwd"; using (UserInfoSL ObjUserInfoSL = new UserInfoSL()) { List <AuthenticationDTO> lstUserDetails = ObjUserInfoSL.GetUserLoginDetails(objLoginUserDetails.CompanyDBConnectionString, Convert.ToString(objLoginUserDetails.LoggedInUserID), calledFrom); foreach (var UserDetails in lstUserDetails) { saltValue = UserDetails.SaltValue; } } string usrSaltValue = (saltValue == null || saltValue == string.Empty) ? userPasswordHashSalt : saltValue; if (saltValue != null && saltValue != "") { objPwdMgmtModel.OldPassword = objPwdHash.CreateHashToVerify(sOldPassword, usrSaltValue); } else { objPwdMgmtModel.OldPassword = objPwdHash.CreateHash(sOldPassword, usrSaltValue); } objPwdMgmtModel.NewPassword = sPasswordHash; objPwdMgmtModel.ConfirmNewPassword = sPasswordHash; objPwdMgmtModel.SaltValue = sSaltValue; InsiderTrading.Common.Common.CopyObjectPropertyByName(objPwdMgmtModel, objPwdMgmtDTO); objUserInfoSL.ChangePassword(objLoginUserDetails.CompanyDBConnectionString, ref objPwdMgmtDTO); objLoginUserDetails.PasswordChangeMessage = Common.Common.getResource("usr_msg_11271"); Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails); Common.Common.SetSessionValue("IsChangePassword", false); } catch (Exception exp) { string sErrMessage = Common.Common.getResource(exp.InnerException.Data[0].ToString()); ViewBag.LoginError = sErrMessage; objPassConfigModel = GetPasswordConfigDetails(); return(View("ChangePassword")); } finally { objLoginUserDetails = null; objPwdMgmtDTO = null; objUserInfoSL = null; objPwdHash = null; } return(RedirectToAction("Index", "Home", new { acid = Convert.ToString(Common.ConstEnum.UserActions.CRUSER_COUSERDASHBOARD_DASHBOARD) })); }
public ActionResult SetPassword(PasswordManagementModel objPwdMgmtModel) { bool bErrorOccurred = false; string i_ErrorMessage = ""; string NewPassword = null; InsiderTradingDAL.CompanyDTO objSelectedCompany = new CompanyDTO(); UserInfoDTO objUserInfoDTO = new UserInfoDTO(); LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); try { if (objLoginUserDetails == null) { objLoginUserDetails = new LoginUserDetails(); } if (objPwdMgmtModel.CompanyID == null || objPwdMgmtModel.CompanyID == "") { i_ErrorMessage = "Company is required field."; bErrorOccurred = true; } else if (objPwdMgmtModel.NewPassword == null || objPwdMgmtModel.NewPassword == "" || objPwdMgmtModel.ConfirmNewPassword == null || objPwdMgmtModel.ConfirmNewPassword == "") { i_ErrorMessage = "Please enter new password and confirm password."; bErrorOccurred = true; } else if (objPwdMgmtModel.NewPassword != objPwdMgmtModel.ConfirmNewPassword) { i_ErrorMessage = "New password and Confirm password are not matching."; bErrorOccurred = true; } if (System.Configuration.ConfigurationManager.AppSettings["CompanyType"] == "Textbox") { Dictionary <string, string> objCompaniesDictionary = null; objCompaniesDictionary = new Dictionary <string, string>(); using (CompaniesSL objCompanySL = new CompaniesSL()) { foreach (InsiderTradingDAL.CompanyDTO objCompanyDTO in objCompanySL.getAllCompanies(Common.Common.getSystemConnectionString())) { objCompaniesDictionary.Add(objCompanyDTO.sCompanyDatabaseName, objCompanyDTO.sCompanyName.ToLower()); } } if (objCompaniesDictionary.ContainsValue(objPwdMgmtModel.CompanyID.ToLower())) { objPwdMgmtModel.CompanyID = (from entry in objCompaniesDictionary where entry.Value.ToLower() == objPwdMgmtModel.CompanyID.ToLower() select entry.Key).FirstOrDefault(); } else { objLoginUserDetails.ErrorMessage = "Invalid Company Name"; Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails); return(RedirectToAction("SetPassword", "Account", new { code = objPwdMgmtModel.HashValue })); } } //hashed password to check password history InsiderTradingEncryption.DataSecurity objPwdHash = new InsiderTradingEncryption.DataSecurity(); string saltValue = string.Empty; if (objPwdMgmtModel.NewPassword != null) { //NewPassword = objPwdHash.CreateSaltandHash(objPwdMgmtModel.NewPassword); string sPasswordHashWithSalt = objPwdHash.CreateSaltandHash(objPwdMgmtModel.NewPassword); NewPassword = sPasswordHashWithSalt.Split('~')[0].ToString(); saltValue = sPasswordHashWithSalt.Split('~')[1].ToString(); } using (CompaniesSL objCompanySL = new CompaniesSL()) { objSelectedCompany = objCompanySL.getSingleCompanies(Common.Common.getSystemConnectionString(), objPwdMgmtModel.CompanyID); } //Check if the new password follows Password policy if (!bErrorOccurred) { Common.Common objCommon = new Common.Common(); PasswordManagementDTO objPasswordManagementUserFromHashCodeDTO = new PasswordManagementDTO(); using (UserInfoSL objUserInfoSL = new UserInfoSL()) { objPasswordManagementUserFromHashCodeDTO = objUserInfoSL.GetUserFromHashCode(objSelectedCompany.CompanyConnectionString, objPwdMgmtModel.HashValue); objUserInfoDTO = objUserInfoSL.GetUserDetails(objSelectedCompany.CompanyConnectionString, objPasswordManagementUserFromHashCodeDTO.UserInfoID); } bool isPasswordValid = objCommon.ValidatePassword(objSelectedCompany.CompanyConnectionString, objUserInfoDTO.LoginID, objPwdMgmtModel.NewPassword, NewPassword, objUserInfoDTO.UserInfoId, out i_ErrorMessage); if (!isPasswordValid) { bErrorOccurred = true; } } if (bErrorOccurred) { //ModelState.AddModelError("Error", i_ErrorMessage); if (objLoginUserDetails == null) { objLoginUserDetails = new LoginUserDetails(); } objLoginUserDetails.ErrorMessage = i_ErrorMessage; objLoginUserDetails.CompanyName = objPwdMgmtModel.CompanyID; Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails); PasswordConfigSL objPassConfigSL = new PasswordConfigSL(); PasswordConfigDTO objPassConfigDTO = new PasswordConfigDTO(); objPassConfigDTO = objPassConfigSL.GetPasswordConfigDetails(objSelectedCompany.CompanyConnectionString); PasswordConfigModel objPassConfigModel = new PasswordConfigModel(); InsiderTrading.Common.Common.CopyObjectPropertyByName(objPassConfigDTO, objPassConfigModel); TempData["PasswordConfigModel"] = objPassConfigModel; return(RedirectToAction("SetPassword", "Account", new { code = objPwdMgmtModel.HashValue })); //return View("SetPassword", objPwdMgmtModel); } PasswordManagementDTO objPwdMgmtDTO = new PasswordManagementDTO(); if (objLoginUserDetails == null) { objLoginUserDetails = new LoginUserDetails(); } if (objSelectedCompany == null) { objLoginUserDetails.ErrorMessage = "Entered company is incorrect, please enter correct company and try again."; } else { objPwdMgmtModel.NewPassword = NewPassword; objPwdMgmtModel.ConfirmNewPassword = NewPassword; objPwdMgmtModel.SaltValue = saltValue; InsiderTrading.Common.Common.CopyObjectPropertyByName(objPwdMgmtModel, objPwdMgmtDTO); using (UserInfoSL objUserInfoSL = new UserInfoSL()) { objPwdMgmtDTO.UserInfoID = objUserInfoDTO.UserInfoId; objUserInfoSL.ChangePassword(objSelectedCompany.CompanyConnectionString, ref objPwdMgmtDTO); } //InsiderTradingDAL.UserInfoDTO objUserInfo = objUserInfoSL.GetUserDetails(objSelectedCompany.CompanyConnectionString, objPwdMgmtDTO.UserInfoID); objLoginUserDetails.SuccessMessage = Common.Common.getResourceForGivenCompany("usr_msg_11271", objSelectedCompany.sCompanyDatabaseName); } Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails); return(RedirectToAction("Login", "Account")); //return RedirectToAction("Index", "Home", new { acid = Convert.ToString(Common.ConstEnum.UserActions.CRUSER_COUSERDASHBOARD_DASHBOARD) }); } catch (Exception exp) { string sErrMessage = Common.Common.getResourceForGivenCompany(exp.InnerException.Data[0].ToString(), objSelectedCompany.sCompanyDatabaseName); if (objLoginUserDetails == null) { objLoginUserDetails = new LoginUserDetails(); } objLoginUserDetails.ErrorMessage = sErrMessage; Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails); return(RedirectToAction("Login", "Account")); //ModelState.AddModelError("Error", sErrMessage); //return View("SetPassword", objPwdMgmtModel); } finally { objLoginUserDetails = null; } }
private void txt_bl_Leave(object sender, EventArgs e) { Common.Common comn = new Common.Common(); txt_bl.Text = comn.CharConverter(txt_bl.Text.Trim()); }
private void btnSf_Click(object sender, EventArgs e) { #region 输入检查 if (str_tjbh == "") { MessageBox.Show("请选择一条人员信息!", "提示"); return; } if (str_tjcs == "") { MessageBox.Show("请选择一条人员信息!", "提示"); return; } Common.Common comn = new Common.Common(); if (rbt_je.Checked == true) { if (comn.DoubleYz(txt_je.Text.Trim()) == -1 || comn.Szyz(txt_je.Text.Trim()) == -1) //既不是双精度又不是数字 { MessageBox.Show("请输入正确的金额格式,如:100.5或100", "提示"); txt_je.Focus(); return; } if (Convert.ToDecimal(txt_je.Text.Trim()) > ysje) { MessageBox.Show("最大金额优惠不能大于应收金额!", "提示"); txt_je.Focus(); return; } if (txt_yhbz.Text == "") { MessageBox.Show("请输入优惠备注信息!", "提示"); txt_yhbz.Focus(); return; } } if (rbt_bl.Checked == true) { if (comn.DoubleYz(txt_bl.Text.Trim()) == -1 || comn.Szyz(txt_bl.Text.Trim()) == -1) //既不是双精度又不是数字 { MessageBox.Show("请输入正确的比例格式,如:9或9.5", "提示"); txt_bl.Focus(); return; } if (Convert.ToDecimal(txt_bl.Text.Trim()) > 100) { MessageBox.Show("优惠比例不能大于或等于100!", "提示"); txt_je.Focus(); return; } if (txt_yhbz.Text == "") { MessageBox.Show("请输入优惠备注信息!", "提示"); txt_yhbz.Focus(); return; } } #endregion string sfh = xtbiz.GetHmz("tj_sjh", 1); str_sfhdy = sfh; #region 优惠处理 int yhlx = 0; decimal ssje = 0; decimal yhxx = 0; if (rbt_je.Checked == true || txt_je.Text.Trim() != "") { yhlx = 1; //金额优惠 yhxx = Convert.ToDecimal(txt_je.Text.Trim()); //优惠信息 ssje = ysje - yhxx; //应收-优惠金额 } if (rbt_bl.Checked == true || txt_bl.Text.Trim() != "") { yhlx = 2; //比例优惠 yhxx = Convert.ToDecimal(txt_bl.Text.Trim()); ssje = ysje - ysje * (yhxx / 100); //应收-应收*优惠比例 } if (rbt_bl.Checked == false && rbt_je.Checked == false) { ssje = ysje; } #endregion #region 收费保存,打印 try { int k = tjdjbiz.TjSf(sfh, str_tjbh, str_tjcs, Program.userid, ysje, ssje, yhlx, yhxx, sfh, txt_yhbz.Text.Trim()); if (k > 0) { MessageBox.Show("收费成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); #region 日志记录 loginbiz.WriteLog(this.Name.Trim(), "【" + Program.username + "】" + "在电脑【" + ma.HostName() + "】上收费成功,收费号是:" + sfh + ",IP:" + Program.hostip, Program.username); #endregion txt_bl.Text = ""; txt_je.Text = ""; btn_query_Click(null, null); dgvFyxx.DataSource = tjdjbiz.GetTjfyxx("", "");; btnSf.Enabled = false; string sfdyfp = xtbiz.GetXtCsz("sfdyfp"); //是否打印收费发票 if (sfdyfp == "1") //1打印,0不打印 { PrintRdlc(str_tjbh, str_tjcs, sfh); } } } catch (Exception ex) { #region 错误日志 loginbiz.WriteLogErr(this.Name.Trim(), "【" + Program.username + "】" + "在电脑【" + ma.HostName() + "】上收费是出现异常,错误原因:" + ex.ToString() + ",IP:" + Program.hostip, Program.username); #endregion MessageBox.Show(ex.ToString()); return; } #endregion }
private void btn_bzsf_Click(object sender, EventArgs e) { #region 输入检查 if (str_tjbh_bz == "") { MessageBox.Show("请选择一条人员信息!", "提示"); return; } if (str_tjcs_bz == "") { MessageBox.Show("请选择一条人员信息!", "提示"); return; } if (txt_sfbeizhu.Text == "") { MessageBox.Show("请输入收费备注!费办卡可以输入收费项目名称!", "提示"); this.ActiveControl = txt_sfbeizhu; return; } Common.Common comn = new Common.Common(); if (comn.DoubleYz(txt_bzsfje.Text.Trim()) == -1 || comn.Szyz(txt_bzsfje.Text.Trim()) == -1) //既不是双精度又不是数字 { MessageBox.Show("请输入正确的金额格式,如:100.5或100", "提示"); txt_je.Focus(); return; } #endregion string sfh = xtbiz.GetHmz("tj_sjh", 1); #region 办证收费保存,打印 try { int k = tjdjbiz.TjSf(sfh, str_tjbh_bz, str_tjcs_bz, Program.userid, Convert.ToDecimal(txt_bzsfje.Text.Trim()), Convert.ToDecimal(txt_bzsfje.Text.Trim()), 2, 0, sfh, txt_sfbeizhu.Text.Trim()); if (k > 0) { MessageBox.Show("收费成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); #region 日志记录 loginbiz.WriteLog(this.Name.Trim(), "【" + Program.username + "】" + "在电脑【" + ma.HostName() + "】上补证收费成功,收费号是:" + sfh + ",IP:" + Program.hostip, Program.username); #endregion button1_Click(null, null); btn_bzsf.Enabled = false; string sfdyfp = xtbiz.GetXtCsz("sfdybzfp"); //是否打印办证收费发票 if (sfdyfp == "1") //1打印,0不打印 { PrintRdlc(str_tjbh_bz, str_tjcs_bz, sfh); } } } catch (Exception ex) { #region 错误日志 loginbiz.WriteLogErr(this.Name.Trim(), "【" + Program.username + "】" + "在电脑【" + ma.HostName() + "】上收补证费出现异常,错误原因:" + ex.ToString() + ",IP:" + Program.hostip, Program.username); #endregion MessageBox.Show(ex.ToString()); btn_bzsf.Enabled = false; return; } #endregion }
public JsonResult Apply(string nAllEmployeeFlag, string nAllInsiderFlag, string nAllEmployeeInsiderFlag, string nAllCoFlag, string nAllCorporateInsiderFlag, string nAllNonEmployeeInsiderFlag, string sMapToId, string sMapToTypeCodeId, string arrIncluded, string arrExcluded, string arrFilter, string arrnonInsEmpFilter, int acid, string __RequestVerificationToken = "", int formId = 0) { bool statusFlag = false; var ErrorDictionary = new Dictionary <string, string>(); string[][] arrApplicabilityInclude = null; string[] arrApplicabilityExclude = null; List <ApplicabilityFilter> arrFilterList = null; List <NonInsEmpApplicabilityFilter> arrFilterNonInsEmpList = null; LoginUserDetails objLoginUserDetails = null; DataTable tblApplicabilityUserIncludeExclude = null; DataTable tblApplicabilityFilterType = null; DataTable tblNonInsEmpApplicabilityFilterType = null; Common.Common objCommon = new Common.Common(); try { if (!objCommon.ValidateCSRFForAJAX()) { return(Json(new { status = statusFlag, Message = ErrorDictionary }, JsonRequestBehavior.AllowGet)); } objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails); if (arrIncluded != "") { arrApplicabilityInclude = JsonConvert.DeserializeObject <string[][]>(arrIncluded); } if (arrExcluded != "") { arrApplicabilityExclude = JsonConvert.DeserializeObject <string[]>(arrExcluded); } if (arrFilter != "") { arrFilterList = JsonConvert.DeserializeObject <List <ApplicabilityFilter> >(arrFilter); } if (arrnonInsEmpFilter != "") { arrFilterNonInsEmpList = JsonConvert.DeserializeObject <List <NonInsEmpApplicabilityFilter> >(arrnonInsEmpFilter); } tblApplicabilityUserIncludeExclude = new DataTable("ApplicabilityUserIncludeExcludeType"); tblApplicabilityUserIncludeExclude.Columns.Add(new DataColumn("UserId", typeof(int))); tblApplicabilityUserIncludeExclude.Columns.Add(new DataColumn("InsiderTypeCodeId", typeof(int))); tblApplicabilityUserIncludeExclude.Columns.Add(new DataColumn("IncludeExcludeCodeId", typeof(int))); if (arrApplicabilityInclude != null) { for (int i = 0; i < arrApplicabilityInclude.Length; i++) { int UserTypeCodeId = i == 0 ? ConstEnum.Code.EmployeeType : i == 1 ? ConstEnum.Code.CorporateUserType : i == 2 ? ConstEnum.Code.NonEmployeeType : i == 3 ? ConstEnum.Code.COUserType : ConstEnum.Code.EmployeeType; DataRow row = null; for (int j = 0; j < arrApplicabilityInclude[i].Length; j++) { row = tblApplicabilityUserIncludeExclude.NewRow(); row["UserId"] = Convert.ToInt32(arrApplicabilityInclude[i][j]); row["InsiderTypeCodeId"] = UserTypeCodeId; row["IncludeExcludeCodeId"] = InsiderTrading.Common.ConstEnum.Code.IncludeTypeCode; tblApplicabilityUserIncludeExclude.Rows.Add(row); } row = null; } } if (arrApplicabilityExclude != null) { DataRow row = null; for (int i = 0; i < arrApplicabilityExclude.Length; i++) { row = tblApplicabilityUserIncludeExclude.NewRow(); row["UserId"] = Convert.ToInt32(arrApplicabilityExclude[i]); row["InsiderTypeCodeId"] = ConstEnum.Code.EmployeeType; row["IncludeExcludeCodeId"] = InsiderTrading.Common.ConstEnum.Code.ExcludeTypeCode; tblApplicabilityUserIncludeExclude.Rows.Add(row); } row = null; } tblApplicabilityFilterType = new DataTable("ApplicabilityFilterType"); tblApplicabilityFilterType.Columns.Add(new DataColumn("ApplicabilityDtlsId", typeof(int))); tblApplicabilityFilterType.Columns.Add(new DataColumn("DepartmentCodeId", typeof(int))); tblApplicabilityFilterType.Columns.Add(new DataColumn("GradeCodeId", typeof(int))); tblApplicabilityFilterType.Columns.Add(new DataColumn("DesignationCodeId", typeof(int))); tblApplicabilityFilterType.Columns.Add(new DataColumn("CategoryCodeId", typeof(int))); tblApplicabilityFilterType.Columns.Add(new DataColumn("SubCategoryCodeId", typeof(int))); tblApplicabilityFilterType.Columns.Add(new DataColumn("RoleId", typeof(int))); tblNonInsEmpApplicabilityFilterType = new DataTable("NonInsEmpApplicabilityFilterType"); tblNonInsEmpApplicabilityFilterType.Columns.Add(new DataColumn("ApplicabilityDtlsId", typeof(int))); tblNonInsEmpApplicabilityFilterType.Columns.Add(new DataColumn("DepartmentCodeId", typeof(int))); tblNonInsEmpApplicabilityFilterType.Columns.Add(new DataColumn("GradeCodeId", typeof(int))); tblNonInsEmpApplicabilityFilterType.Columns.Add(new DataColumn("DesignationCodeId", typeof(int))); tblNonInsEmpApplicabilityFilterType.Columns.Add(new DataColumn("CategoryCodeId", typeof(int))); tblNonInsEmpApplicabilityFilterType.Columns.Add(new DataColumn("SubCategoryCodeId", typeof(int))); tblNonInsEmpApplicabilityFilterType.Columns.Add(new DataColumn("RoleId", typeof(int))); if (arrFilterList != null) { DataRow row = null; foreach (var objFilter in arrFilterList) { row = tblApplicabilityFilterType.NewRow(); row["ApplicabilityDtlsId"] = 0; row["DepartmentCodeId"] = DBNull.Value; row["GradeCodeId"] = DBNull.Value; row["DesignationCodeId"] = DBNull.Value; row["CategoryCodeId"] = DBNull.Value; row["SubCategoryCodeId"] = DBNull.Value; row["RoleId"] = DBNull.Value; if (objFilter.ApplicabilityDtlsId != "" && objFilter.ApplicabilityDtlsId != "0") { row["ApplicabilityDtlsId"] = Convert.ToInt32(objFilter.ApplicabilityDtlsId); } if (objFilter.DepartmentId != "" && objFilter.DepartmentId != "0") { row["DepartmentCodeId"] = Convert.ToInt32(objFilter.DepartmentId); } if (objFilter.GradeId != "" && objFilter.GradeId != "0") { row["GradeCodeId"] = Convert.ToInt32(objFilter.GradeId); } if (objFilter.DesignationId != "" && objFilter.DesignationId != "0") { row["DesignationCodeId"] = Convert.ToInt32(objFilter.DesignationId); } if (objFilter.CategoryId != "" && objFilter.CategoryId != "0") { row["CategoryCodeId"] = Convert.ToInt32(objFilter.CategoryId); } if (objFilter.SubCategoryId != "" && objFilter.SubCategoryId != "0") { row["SubCategoryCodeId"] = Convert.ToInt32(objFilter.SubCategoryId); } if (objFilter.RoleId != "" && objFilter.RoleId != "0") { row["RoleId"] = Convert.ToInt32(objFilter.RoleId); } if (row["DesignationCodeId"] != DBNull.Value || row["GradeCodeId"] != DBNull.Value || row["DepartmentCodeId"] != DBNull.Value || row["CategoryCodeId"] != DBNull.Value || row["SubCategoryCodeId"] != DBNull.Value || row["RoleId"] != DBNull.Value) { tblApplicabilityFilterType.Rows.Add(row); } } row = null; } if (arrFilterNonInsEmpList != null) { DataRow row = null; foreach (var objFilter in arrFilterNonInsEmpList) { row = tblNonInsEmpApplicabilityFilterType.NewRow(); row["ApplicabilityDtlsId"] = 0; row["DepartmentCodeId"] = DBNull.Value; row["GradeCodeId"] = DBNull.Value; row["DesignationCodeId"] = DBNull.Value; row["CategoryCodeId"] = DBNull.Value; row["SubCategoryCodeId"] = DBNull.Value; row["RoleId"] = DBNull.Value; if (objFilter.ApplicabilityDtlsId != "" && objFilter.ApplicabilityDtlsId != "0") { row["ApplicabilityDtlsId"] = Convert.ToInt32(objFilter.ApplicabilityDtlsId); } if (objFilter.DepartmentId != "" && objFilter.DepartmentId != "0") { row["DepartmentCodeId"] = Convert.ToInt32(objFilter.DepartmentId); } if (objFilter.GradeId != "" && objFilter.GradeId != "0") { row["GradeCodeId"] = Convert.ToInt32(objFilter.GradeId); } if (objFilter.DesignationId != "" && objFilter.DesignationId != "0") { row["DesignationCodeId"] = Convert.ToInt32(objFilter.DesignationId); } if (objFilter.CategoryId != "" && objFilter.CategoryId != "0") { row["CategoryCodeId"] = Convert.ToInt32(objFilter.CategoryId); } if (objFilter.SubCategoryId != "" && objFilter.SubCategoryId != "0") { row["SubCategoryCodeId"] = Convert.ToInt32(objFilter.SubCategoryId); } if (objFilter.RoleId != "" && objFilter.RoleId != "0") { row["RoleId"] = Convert.ToInt32(objFilter.RoleId); } if (row["DesignationCodeId"] != DBNull.Value || row["GradeCodeId"] != DBNull.Value || row["DepartmentCodeId"] != DBNull.Value || row["CategoryCodeId"] != DBNull.Value || row["SubCategoryCodeId"] != DBNull.Value || row["RoleId"] != DBNull.Value) { tblNonInsEmpApplicabilityFilterType.Rows.Add(row); } } row = null; } using (ApplicabilitySL objApplicabilitySl = new ApplicabilitySL()) { int nCountOverlapPolicy = 0; objApplicabilitySl.InsertDeleteApplicability(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(sMapToTypeCodeId), Convert.ToInt32(sMapToId), Convert.ToInt32(nAllEmployeeFlag), Convert.ToInt32(nAllInsiderFlag), Convert.ToInt32(nAllEmployeeInsiderFlag), Convert.ToInt32(nAllCoFlag), Convert.ToInt32(nAllCorporateInsiderFlag), Convert.ToInt32(nAllNonEmployeeInsiderFlag), tblApplicabilityFilterType, tblNonInsEmpApplicabilityFilterType, tblApplicabilityUserIncludeExclude, objLoginUserDetails.LoggedInUserID, out nCountOverlapPolicy); statusFlag = true; ErrorDictionary.Add("success", "Applicability saved successfully."); ErrorDictionary.Add("CountOverlapPolicy", Convert.ToString(nCountOverlapPolicy)); } } catch (Exception exp) { ModelState.Remove("KEY"); ModelState.Add("KEY", new ModelState()); ModelState.Clear(); string sErrMessage = Common.Common.getResource(exp.InnerException.Data[0].ToString()); ModelState.AddModelError("error", sErrMessage); ErrorDictionary = GetModelStateErrorsAsString(); } finally { objLoginUserDetails = null; arrApplicabilityInclude = null; arrApplicabilityExclude = null; arrFilterList = null; tblApplicabilityUserIncludeExclude = null; tblApplicabilityFilterType = null; } return(Json(new { status = statusFlag, Message = ErrorDictionary }, JsonRequestBehavior.AllowGet)); }
public ActionResult PopulateCombo_OnChange(string CodeId, string CalledFrom, int ParentId, int acid) { LoginUserDetails objLoginUserDetails = null; ComCodeModel objComCodeModel = null; PopulateComboDTO objPopulateComboDTO = null; List <PopulateComboDTO> lstParentCodeGroup = null; List <PopulateComboDTO> lstLabelForParent = null; List <PopulateComboDTO> lstCodeGroup = null; string sView = string.Empty; Common.Common objCommon = new Common.Common(); try { if (!objCommon.ValidateCSRFForAJAX()) { return(RedirectToAction("Unauthorised", "Home")); } string ParentLabel = ""; string[] arr = new String[2]; objComCodeModel = new ComCodeModel(); objPopulateComboDTO = new PopulateComboDTO(); objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); arr = CodeId.Split(new string[] { "-" }, StringSplitOptions.None); if (Convert.ToInt32(arr[1]) != 0) { objPopulateComboDTO.Key = "0"; objPopulateComboDTO.Value = "Select"; lstParentCodeGroup = new List <PopulateComboDTO>(); lstParentCodeGroup.Add(objPopulateComboDTO); lstParentCodeGroup.AddRange(Common.Common.GetPopulateCombo(objLoginUserDetails.CompanyDBConnectionString, ConstEnum.ComboType.ListOfCode, arr[1], null, null, null, null, sLookUpPrefix)); lstLabelForParent = new List <PopulateComboDTO>(); lstLabelForParent.AddRange(Common.Common.GetPopulateCombo(objLoginUserDetails.CompanyDBConnectionString, ConstEnum.ComboType.CodeParentList, null, arr[1], null, null, null, sLookUpPrefix)); ParentLabel = lstLabelForParent.ElementAt <PopulateComboDTO>(0).Value; if (ParentLabel.Contains("Master")) { ParentLabel = ParentLabel.Substring(0, (ParentLabel.Length - 7)); } if (CalledFrom == "Details") { ViewBag.ParentCodeName = lstParentCodeGroup; ViewBag.SelectedValue = "0"; } else if (CalledFrom == "List") { ViewBag.ParentCodeName = lstParentCodeGroup; } } lstCodeGroup = new List <PopulateComboDTO>(); lstCodeGroup.Add(objPopulateComboDTO); lstCodeGroup.AddRange(Common.Common.GetPopulateCombo(objLoginUserDetails.CompanyDBConnectionString, ConstEnum.ComboType.CodeParentList, null, null, null, null, null, sLookUpPrefix)); objComCodeModel.CodeGroupId = CodeId; if (CalledFrom == "Details") { ViewBag.ParentLabel = ParentLabel; ViewBag.CodeGroupDropDown = lstCodeGroup; sView = "PartialCreate"; } else if (CalledFrom == "List") { ViewBag.GridType = ConstEnum.GridType.ComCodeList; if (arr[1] != "0") { ViewBag.ParentLabel = ParentLabel; ViewBag.ParentId = ParentId; objComCodeModel.ParentCodeId = ParentId; ViewBag.CodeGroupDropDown = new SelectList(lstCodeGroup, "Key", "Value"); sView = "PartialIndex"; } else if (ParentId == 0) { ViewBag.AddNew = 1; sView = "PartialDataGrid"; } } ViewBag.UserAction = acid; } finally { objLoginUserDetails = null; objPopulateComboDTO = null; lstParentCodeGroup = null; lstLabelForParent = null; lstCodeGroup = null; } return(PartialView(sView, objComCodeModel)); }
/// <summary> /// Process /// </summary> /// <returns>info</returns> protected override String DoIt() { log.Info("C_DunningRun_ID=" + _C_DunningRun_ID + ",R_MailText_ID=" + _R_MailText_ID + ", EmailPDF=" + _EMailPDF + ",IsOnlyIfBPBalance=" + _IsOnlyIfBPBalance); // Need to have Template if (_EMailPDF && _R_MailText_ID == 0) { throw new Exception("@NotFound@: @R_MailText_ID@"); } String subject = ""; MMailText mText = null; if (_EMailPDF) { mText = new MMailText(GetCtx(), _R_MailText_ID, Get_TrxName()); if (_EMailPDF && mText.Get_ID() == 0) { throw new Exception("@NotFound@: @R_MailText_ID@ - " + _R_MailText_ID); } subject = mText.GetMailHeader(); } // MDunningRun run = new MDunningRun(GetCtx(), _C_DunningRun_ID, Get_TrxName()); if (run.Get_ID() == 0) { throw new Exception("@NotFound@: @C_DunningRun_ID@ - " + _C_DunningRun_ID); } // Print Format on Dunning Level MDunningLevel level = new MDunningLevel(GetCtx(), run.GetC_DunningLevel_ID(), Get_TrxName()); MPrintFormat format = MPrintFormat.Get(GetCtx(), level.GetDunning_PrintFormat_ID(), false); MClient client = MClient.Get(GetCtx()); int count = 0; int errors = 0; MDunningRunEntry[] entries = run.GetEntries(false); for (int i = 0; i < entries.Length; i++) { MDunningRunEntry entry = entries[i]; if (_IsOnlyIfBPBalance && Env.Signum(entry.GetAmt()) <= 0) { continue; } // To BPartner MBPartner bp = new MBPartner(GetCtx(), entry.GetC_BPartner_ID(), Get_TrxName()); if (bp.Get_ID() == 0) { AddLog(entry.Get_ID(), null, null, "@NotFound@: @C_BPartner_ID@ " + entry.GetC_BPartner_ID()); errors++; continue; } // To User MUser to = new MUser(GetCtx(), entry.GetAD_User_ID(), Get_TrxName()); if (_EMailPDF) { if (to.Get_ID() == 0) { AddLog(entry.Get_ID(), null, null, "@NotFound@: @AD_User_ID@ - " + bp.GetName()); errors++; continue; } else if (to.GetEMail() == null || to.GetEMail().Length == 0) { AddLog(entry.Get_ID(), null, null, "@NotFound@: @EMail@ - " + to.GetName()); errors++; continue; } } // BP Language //Language language =Language.getLoginLanguage(); // Base Language Language language = Env.GetLoginLanguage(GetCtx()); String tableName = "C_Dunning_Header_v"; if (client.IsMultiLingualDocument()) { tableName += "t"; String AD_Language = bp.GetAD_Language(); if (AD_Language != null) { //language =language.getLanguage(AD_Language); } } // format.SetLanguage(language); // format.SetTranslationLanguage(language); // query Query query = new Query(tableName); query.AddRestriction("C_DunningRunEntry_ID", Query.EQUAL, entry.GetC_DunningRunEntry_ID()); // Engine //PrintInfo info = new PrintInfo( // bp.GetName(), // X_C_DunningRunEntry.Table_ID, // entry.GetC_DunningRunEntry_ID(), // entry.GetC_BPartner_ID()); //info.SetDescription(bp.GetName() + ", Amt=" + entry.GetAmt()); //ReportEngine re = new ReportEngine(GetCtx(), format, query, info); byte[] pdfReport; string reportPath = ""; bool printed = false; if (_EMailPDF) { EMail email = client.CreateEMail(to.GetEMail(), to.GetName(), null, null); if (email == null || !email.IsValid()) { AddLog(entry.Get_ID(), null, null, "@RequestActionEMailError@ Invalid EMail: " + to); errors++; continue; } mText.SetUser(to); // variable context mText.SetBPartner(bp); mText.SetPO(entry); String message = mText.GetMailText(true); if (mText.IsHtml()) { email.SetMessageHTML(mText.GetMailHeader(), message); } else { email.SetSubject(mText.GetMailHeader()); email.SetMessageText(message); } // //File attachment = re.GetPDF(File.createTempFile("Dunning", ".pdf")); //log.Fine(to + " - " + attachment); //email.AddAttachment(attachment); // // Get report that is bound on the dunning entry tab of dunning run window. int ReportProcess_ID = Util.GetValueOfInt(DB.ExecuteScalar("SELECT AD_Process_ID FROM ad_tab WHERE export_id='VIS_634'")); if (ReportProcess_ID > 0) { Common.Common Com = new Common.Common(); Dictionary <string, object> d = Com.GetReport(GetCtx(), ReportProcess_ID, "C_DunningRunEntry", X_C_DunningRunEntry.Table_ID, entry.GetC_DunningRunEntry_ID(), 0, "", FileType, out pdfReport, out reportPath); if (pdfReport != null) { email.AddAttachment(pdfReport, "Dunning" + entry.GetC_DunningRunEntry_ID() + ".pdf"); } } String msg = email.Send(); MUserMail um = new MUserMail(mText, entry.GetAD_User_ID(), email); um.Save(); if (msg.Equals(EMail.SENT_OK)) { AddLog(entry.Get_ID(), null, null, bp.GetName() + " @RequestActionEMailOK@"); count++; printed = true; } else { AddLog(entry.Get_ID(), null, null, bp.GetName() + " @RequestActionEMailError@ " + msg); errors++; } } else { //re.print(); count++; printed = true; } if (printed) { entry.SetProcessed(true); entry.Save(); DunningLevelConsequences(level, entry); } } // for all dunning letters if (errors == 0) { run.SetProcessed(true); run.Save(); } if (_EMailPDF) { return("@Sent@=" + count + " - @Errors@=" + errors); } return("@Printed@=" + count); }
public JsonResult Index(DelegateModel objDelegateModel, int acid) { bool bStatusFlag = false; int nPatrialSave = 0; var ErrorDictionary = new Dictionary <string, string>(); Common.Common objCommon = new Common.Common(); LoginUserDetails objLoginUserDetails = null; try { if (!objCommon.ValidateCSRFForAJAX()) { return(Json(new { status = false, msg = ErrorDictionary }, JsonRequestBehavior.AllowGet)); } objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); if (ModelState.IsValid) { ViewBag.UserInfoIdFrom = objDelegateModel.UserInfoIdFrom; ViewBag.UserInfoIdTo = objDelegateModel.UserInfoIdTo; ViewBag.DelegationFrom = objDelegateModel.DelegationFrom; ViewBag.DelegationTo = objDelegateModel.DelegationTo; objDelegateModel.DelegationId = 0; DelegationMasterDTO objDelegationMasterDTO = new DelegationMasterDTO(); Common.Common.CopyObjectPropertyByName(objDelegateModel, objDelegationMasterDTO); using (DelegationMasterSL objDelegationMasterSL = new DelegationMasterSL()) { objDelegationMasterDTO = objDelegationMasterSL.SaveDetails(objDelegationMasterDTO, nPatrialSave, objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID); bStatusFlag = true; ErrorDictionary.Add("id", Convert.ToString(objDelegationMasterDTO.DelegationId)); } } else { ErrorDictionary = GetModelStateErrorsAsString(); } }catch (Exception e) { ModelState.Remove("KEY"); ModelState.Add("KEY", new ModelState()); ModelState.Clear(); string sErrMessage = Common.Common.getResource(e.InnerException.Data[0].ToString()); ModelState.AddModelError("error", sErrMessage); ErrorDictionary = GetModelStateErrorsAsString(); } finally { objLoginUserDetails = null; } return(Json(new { status = bStatusFlag, msg = ErrorDictionary, user_action = acid })); }
public JsonResult Create(List <TradingWindowEventModel> tradingWindowEventModel, int nFinancialYearCodeId, int nFinancialPeriodTypeCodeId, int acid, string __RequestVerificationToken, int formId) //public JsonResult Create(List<TradingWindowEventModel> tradingWindowEventModel, int nFinancialYearCodeId, int nFinancialPeriodTypeCodeId, int acid) { bool bReturn = true; LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); TradingWindowEventSL objTradingWindowEventSL = new TradingWindowEventSL(); Common.Common objCommon = new Common.Common(); try { if (!objCommon.ValidateCSRFForAJAX()) { return(Json(new { status = false, error = "" }, JsonRequestBehavior.AllowGet)); } #region Create Data Table tblTradingWindowEventType DataTable tblTradingWindowEventType = new DataTable("TradingWindowEventType"); tblTradingWindowEventType.Columns.Add(new DataColumn("TradingWindowEventId", typeof(int))); tblTradingWindowEventType.Columns.Add(new DataColumn("FinancialYearCodeId", typeof(int))); tblTradingWindowEventType.Columns.Add(new DataColumn("FinancialPeriodCodeId", typeof(int))); tblTradingWindowEventType.Columns.Add(new DataColumn("TradingWindowId", typeof(string))); tblTradingWindowEventType.Columns.Add(new DataColumn("EventTypeCodeId", typeof(int))); tblTradingWindowEventType.Columns.Add(new DataColumn("TradingWindowEventCodeId", typeof(int))); tblTradingWindowEventType.Columns.Add(new DataColumn("ResultDeclarationDate", typeof(DateTime))); tblTradingWindowEventType.Columns.Add(new DataColumn("WindowCloseDate", typeof(DateTime))); tblTradingWindowEventType.Columns.Add(new DataColumn("WindowOpenDate", typeof(DateTime))); tblTradingWindowEventType.Columns.Add(new DataColumn("DaysPriorToResultDeclaration", typeof(int))); tblTradingWindowEventType.Columns.Add(new DataColumn("DaysPostResultDeclaration", typeof(int))); tblTradingWindowEventType.Columns.Add(new DataColumn("WindowClosesBeforeHours", typeof(int))); tblTradingWindowEventType.Columns.Add(new DataColumn("WindowClosesBeforeMinutes", typeof(int))); tblTradingWindowEventType.Columns.Add(new DataColumn("WindowOpensAfterHours", typeof(int))); tblTradingWindowEventType.Columns.Add(new DataColumn("WindowOpensAfterMinutes", typeof(int))); #endregion Create Data Table tblTradingWindowEventType ModelState.Clear(); foreach (var index in tradingWindowEventModel) { DataRow row = tblTradingWindowEventType.NewRow(); DateTime now = Common.Common.GetCurrentDate(objLoginUserDetails.CompanyDBConnectionString); if (index.TradingWindowEventId != null) { row["TradingWindowEventId"] = index.TradingWindowEventId; } row["FinancialYearCodeId"] = nFinancialYearCodeId; if (index.FinancialPeriodCodeId != null) { row["FinancialPeriodCodeId"] = index.FinancialPeriodCodeId; } if (index.TradingWindowId != null) { row["TradingWindowId"] = index.TradingWindowId; } if (index.ResultDeclarationDate != null) { row["ResultDeclarationDate"] = index.ResultDeclarationDate; } else { ModelState.AddModelError("ResultDeclarationDate", "Enter Result Declaration Date");//InsiderTrading.Common.Common.getResource("rul_msg_15083")); bReturn = false; } if (index.WindowOpenDate != null) { row["WindowOpenDate"] = index.WindowOpenDate; } if (index.WindowCloseDate != null) { row["WindowCloseDate"] = index.WindowCloseDate; } if (index.DaysPriorToResultDeclaration != null) { row["DaysPriorToResultDeclaration"] = index.DaysPriorToResultDeclaration; } else { ModelState.AddModelError("DaysPriorToResultDeclaration", "Enter Days Prior To Result Declaration");//InsiderTrading.Common.Common.getResource("rul_msg_15083")); bReturn = false; } if (index.DaysPostResultDeclaration != null) { row["DaysPostResultDeclaration"] = index.DaysPostResultDeclaration; } else { ModelState.AddModelError("DaysPriorToResultDeclaration", "Enter DaysPostResultDeclaration");//InsiderTrading.Common.Common.getResource("rul_msg_15083")); bReturn = false; } if (!bReturn) { break; } tblTradingWindowEventType.Rows.Add(row); } if (!bReturn && !ModelState.IsValid) { return(Json(new { status = false, error = ModelState.ToSerializedDictionary() })); } bReturn = objTradingWindowEventSL.SaveDetails(objLoginUserDetails.CompanyDBConnectionString, tblTradingWindowEventType, nFinancialPeriodTypeCodeId, objLoginUserDetails.LoggedInUserID); // TODO: Add insert logic here return(Json(new { status = true, Message = Common.Common.getResource("rul_msg_15380")//"Data saved successfully." }, JsonRequestBehavior.AllowGet)); } catch (Exception exp) { string sErrMessage = Common.Common.getResource(exp.InnerException.Data[0].ToString()); ModelState.AddModelError("Error", Common.Common.GetErrorMessage(exp)); return(Json(new { status = false, error = ModelState.ToSerializedDictionary() })); } finally { objLoginUserDetails = null; objTradingWindowEventSL = null; } }
/// <summary> /// Gets the modules. /// </summary> /// <param name="poeid">The poeid.</param> /// <returns></returns> public void SignUp(SignupRequest sr) { //New user int userid = 0; var user = sr.User; string salt = CreateSalt(); string encPassword = CreatePasswordHash(user.Password + salt); using (var context = DataContextFactory.GetIntelliSetDataContext()) { if (sr.Mode == 0) { var resultuser = context.RegisterUser(user.FirstName + " " + user.LastName, user.Password, encPassword, salt, user.FirstName, user.LastName, user.EmailAddress, user.CompanyName, Convert.ToInt32(user.Country.Id), user.Photo, user.YammerToken).FirstOrDefault(); if (resultuser != null) { userid = resultuser.UserId.GetValueOrDefault(); } sr.User.UserId = userid; SendWelcomeEmail(user.FirstName + " " + user.LastName, user.EmailAddress); } int subscriptionId = 0; var resultsub = context.CreateSubscription(user.EmailAddress, sr.Netwrok.NetworkName, 1, 1, sr.Netwrok.Plan).ToList(); if (resultsub.Count > 0) { subscriptionId = resultsub[0].SubscriptionID.GetValueOrDefault(0); } if (userid != 0) { //subscriptionId = (from c in resultsub let subscriptionID = c.SubscriptionID where subscriptionID != null select subscriptionID.Value).FirstOrDefault(); context.UserSubscribtions(subscriptionId, userid, DateTime.Now, 1, 10, 120); } sr.Netwrok.Subscriptionid = subscriptionId; int salesOrderId = 0; if (sr.Payment != null) { var resultPayment = context.InsertPayment(subscriptionId, sr.Payment.Amount, sr.Payment.Response, sr.Payment.ResponseId); if (resultPayment != null) { salesOrderId = resultPayment.FirstOrDefault().SalesOrderId.GetValueOrDefault(); } } //Insert SubscribedPoes var common = new Common.Common(); var subscriptedPoes = common.GetSubscribedPoes(subscriptionId); List <Util.Domain.POE> newlyAddedPoes = sr.Poes; if (sr.Poes != null) { foreach (var poe in subscriptedPoes) { newlyAddedPoes.RemoveAll(a => a.POEId == poe.POEId); } foreach (Util.Domain.POE poe in sr.Poes) { if (sr.Payment != null) { context.InsertSalesOrderItem(salesOrderId, 1, poe.POEId, poe.Name, 20.00m); } float poecost = 0; if (sr.Members != null) { poecost = sr.Members[0].PoeAmount; } context.InsertSubscribedPoes(poe.POEId, subscriptionId, poecost); } } if (newlyAddedPoes != null) { foreach (var poe in newlyAddedPoes) { SendAddPoeNotificationEmail(user.FirstName + " " + user.LastName, user.EmailAddress, poe.Name); } } if (sr.Members != null) { foreach (UserPOEMapping member in sr.Members) { int parentMappingid = 0; int childMappingId = 0; int peerParentMappingid = 0; int peerchildMappingId = 0; int memberid = 0; string salttemp = CreateSalt(); string encPasswordtemp = CreatePasswordHash("Pass@123" + salttemp); var resultmembers = context.RegisterUser(member.User.FirstName + " " + member.User.LastName, "Pass@123", encPasswordtemp, salttemp, member.User.FirstName, member.User.LastName, member.User.EmailAddress, user.CompanyName, Convert.ToInt32(user.Country.Id), null, member.User.YammerToken).FirstOrDefault(); if (member.Designation.Level != (int)NetworkUserFilterType.Customer) { SendInviteEmail( sr.User.FirstName + " " + sr.User.LastName, member.User.FirstName + " " + member.User.LastName, sr.User.EmailAddress, member.User.EmailAddress, subscriptionId); } if (resultmembers != null) { memberid = resultmembers.UserId.GetValueOrDefault(); context.UserSubscribtions(subscriptionId, memberid, DateTime.Now, 1, member.Designation.Level, member.UserAmount); } member.User.UserId = memberid; if (member.POE.POEId != 0) { switch (member.Designation.Level) { case (int)NetworkUserFilterType.TeamMember: parentMappingid = InsertPoeMapping(user.UserId, member.POE.POEId, 2, "Manager", sr.Netwrok.Subscriptionid); childMappingId = InsertPoeMapping(member.User.UserId, member.POE.POEId, member.Designation.Level, member.Designation.Name, sr.Netwrok.Subscriptionid); break; case (int)NetworkUserFilterType.Manager: parentMappingid = InsertPoeMapping(member.User.UserId, member.POE.POEId, member.Designation.Level, member.Designation.Name, sr.Netwrok.Subscriptionid); childMappingId = InsertPoeMapping(user.UserId, member.POE.POEId, 1, "Team Member", sr.Netwrok.Subscriptionid); break; case (int)NetworkUserFilterType.SkipLevelManager: parentMappingid = InsertPoeMapping(member.User.UserId, member.POE.POEId, member.Designation.Level, member.Designation.Name, sr.Netwrok.Subscriptionid); childMappingId = InsertPoeMapping(user.UserId, member.POE.POEId, 1, "Team Member", sr.Netwrok.Subscriptionid); break; case (int)NetworkUserFilterType.Customer: parentMappingid = InsertPoeMapping(member.User.UserId, member.POE.POEId, member.Designation.Level, member.Designation.Name, sr.Netwrok.Subscriptionid); childMappingId = InsertPoeMapping(user.UserId, member.POE.POEId, 1, "Team Member", sr.Netwrok.Subscriptionid); break; case (int)NetworkUserFilterType.PeerManager: parentMappingid = InsertPoeMapping(member.User.UserId, member.POE.POEId, (int)NetworkUserFilterType.PeerManager, member.Designation.Name, sr.Netwrok.Subscriptionid); childMappingId = InsertPoeMapping(user.UserId, member.POE.POEId, (int)NetworkUserFilterType.PeerTeam, "Peer Team Member", sr.Netwrok.Subscriptionid); peerParentMappingid = InsertPoeMapping(user.UserId, member.POE.POEId, (int)NetworkUserFilterType.PeerManager, "Peer Manager", sr.Netwrok.Subscriptionid); peerchildMappingId = InsertPoeMapping(member.User.UserId, member.POE.POEId, (int)NetworkUserFilterType.PeerTeam, member.Designation.Name, sr.Netwrok.Subscriptionid); break; } } if (parentMappingid != 0 && childMappingId != 0) { InsertNetworkUsers(parentMappingid, childMappingId, sr.Netwrok.NetworkName, sr.Netwrok.Subscriptionid); } if (peerParentMappingid != 0 && peerchildMappingId != 0) { InsertNetworkUsers(peerParentMappingid, peerchildMappingId, sr.Netwrok.NetworkName, sr.Netwrok.Subscriptionid); } member.ParentMappingId = parentMappingid; member.ChildMappingId = childMappingId; member.PeerParentMappingId = peerParentMappingid; member.PeerChildMappingId = peerchildMappingId; //insert sales order if (sr.Payment != null) { context.InsertSalesOrderItem(salesOrderId, 2, memberid, member.User.EmailAddress, 5.00m); } } } } }
public JsonResult Delete(int acid, int TemplateMasterId) { bool statusFlag = false; var ErrorDictionary = new Dictionary <string, string>(); LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails); Common.Common objCommon = new Common.Common(); try { // TemplateMasterSL objTemplateMasterSL = new TemplateMasterSL(); //TemplateMasterModel objTemplateMasterModel = new TemplateMasterModel(); if (!objCommon.ValidateCSRFForAJAX()) { return(Json(new { status = statusFlag, Message = ErrorDictionary }, JsonRequestBehavior.AllowGet)); } using (var objTemplateMasterSL = new TemplateMasterSL()) { bool result = objTemplateMasterSL.Delete(objLoginUserDetails.CompanyDBConnectionString, TemplateMasterId, objLoginUserDetails.LoggedInUserID); } // return RedirectToAction("Index", "TemplateMaster",new {acid = ConstEnum.UserActions.TEMPLATE_LIST_RIGHT }); statusFlag = true; ErrorDictionary.Add("success", Common.Common.getResource("tra_msg_16175")); } catch (Exception exp) { //string sErrMessage = Common.Common.getResource(exp.InnerException.Data[0].ToString()); //ModelState.AddModelError("Error", sErrMessage); TemplateMasterModel objTemplateMasterModel = new TemplateMasterModel(); List <PopulateComboDTO> lstList = new List <PopulateComboDTO>(); lstList = FillComboValues(ConstEnum.ComboType.ListOfCode, ConstEnum.CodeGroup.RoleStatus, null, null, null, null, true); ViewBag.TemplateStatus = lstList; //get list of communication mode lstList = FillComboValues(ConstEnum.ComboType.ListOfCode, ConstEnum.CodeGroup.CommunicationModes, null, null, null, null, true); ViewBag.CommunicationMode = lstList; //get list of disclousre type lstList = FillComboValues(ConstEnum.ComboType.ListOfCode, ConstEnum.CodeGroup.DisclosureType, null, null, null, null, true); ViewBag.DisclosureType = lstList; lstList = null; FillGrid(ConstEnum.GridType.TemplateMasteList, null, null, null); // return View("View", objTemplateMasterModel); ModelState.Remove("KEY"); ModelState.Add("KEY", new ModelState()); ModelState.Clear(); string sErrMessage = Common.Common.getResource(exp.InnerException.Data[0].ToString()); ModelState.AddModelError("error", sErrMessage); ErrorDictionary = GetModelStateErrorsAsString(); } finally { objLoginUserDetails = null; } return(Json(new { status = statusFlag, Message = ErrorDictionary }, JsonRequestBehavior.AllowGet)); }
public ActionResult AjaxHandler(String gridtype, String inp_sParam = "", String isInsider = "", int acid = 0, String ClearSearchFilter = "") { if (ClearSearchFilter == "True") { TempData.Remove("SearchArray"); JsonResult returnJson = Json(new { status = false }, JsonRequestBehavior.AllowGet); return(returnJson); } int out_iTotalRecords = 0; String sLookUpPrefix = ""; LoginUserDetails objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); IEnumerable <Object> lstCRUserList = new List <Object>(); // Change the received generic object to <key, value> pair as per required for datatable. List <Dictionary <string, Object> > lstUserList = new List <Dictionary <string, Object> >(); Common.Common objCommon = new Common.Common(); try { if (!objCommon.ValidateCSRFForAJAX()) { return(RedirectToAction("Unauthorised", "Home")); } //Fetch Search parameters String sSearch = Request.Form["Search"]; String[] arr = new string[51]; arr = sSearch.Split(new string[] { "|#|" }, StringSplitOptions.None); for (int i = 0; i <= arr.Length - 1; i++) { if (arr[i] == "" || arr[i] == "0") { arr[i] = null; } } if (!IsNullOrEmpty(arr) && (gridtype == InsiderTrading.Common.ConstEnum.GridType.ContinuousDisclosureListForCO.ToString() || gridtype == InsiderTrading.Common.ConstEnum.GridType.ContinousDisclosureStatusList.ToString() || gridtype == InsiderTrading.Common.ConstEnum.GridType.Report_ContinuousReportEmployeeWise.ToString() || gridtype == InsiderTrading.Common.ConstEnum.GridType.Report_InitialDisclosureEmployeeWise.ToString() || gridtype == InsiderTrading.Common.ConstEnum.GridType.InitialDisclosureListForCO.ToString() || gridtype == InsiderTrading.Common.ConstEnum.GridType.COUserList.ToString() || gridtype == InsiderTrading.Common.ConstEnum.GridType.EmployeeUserList.ToString() || (gridtype == InsiderTrading.Common.ConstEnum.GridType.RestrictedList.ToString() && arr[8] != "History"))) { TempData["SearchArray"] = arr; TempData.Keep("SearchArray"); } if (!IsNullOrEmpty(arr) && (gridtype == InsiderTrading.Common.ConstEnum.GridType.Report_ContinuousReportEmployeeIndividual.ToString() || gridtype == InsiderTrading.Common.ConstEnum.GridType.Report_InitialDisclosureEmployeeIndividual.ToString())) { TempData["ReportSearchArray"] = arr; TempData.Keep("ReportSearchArray"); } //Get sort column, direction, display length and page number String sSortCol = Request.Form["mDataProp_" + Request.Form["iSortCol_0"]]; String sSortDir = Request.Form["sSortDir_0"]; int nDisplayLength = Convert.ToInt32(Request.Form["iDisplayLength"]); int nPage = 0; if (nDisplayLength != 0) { nPage = Convert.ToInt32(Request.Form["iDisplayStart"]) / nDisplayLength + 1; } using (GenericSLImpl <Object> objGenericSLImpl = new GenericSLImpl <Object>()) { //PENDING TRANSACTIONS DASHBOARD : Initial Disclosures-Insider if (isInsider == "InitialDisInsider" && inp_sParam == "154002") { //nDisplayLength = 10; lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5], inp_sParam, arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19], arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } //PENDING TRANSACTIONS DASHBOARD : Initial Disclosures-Insider Relative else if (isInsider == "InitialDisInsider-Relative" && inp_sParam == "154002") { //nDisplayLength = 10; lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5], inp_sParam, arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19], "1", arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } //PENDING TRANSACTIONS DASHBOARD : Initial Disclosures-CO else if (isInsider == "ContiDisCO" && inp_sParam == "154006") { //nDisplayLength = 10; lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5], inp_sParam, arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19], arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } //PENDING TRANSACTIONS DASHBOARD : Continuous Disclosures-CO else if (isInsider == "ContinouseDisCO" && inp_sParam == "114049") { lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5], arr[6], "153019", arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19], arr[20], arr[21], arr[22], arr[23], "2", arr[25], arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } //PENDING TRANSACTIONS DASHBOARD : Continuous Disclosures-Insider else if (isInsider == "ContiDisInsider" && inp_sParam == "144001") { lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5], arr[6], "153019", arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19], arr[20], arr[21], arr[22], arr[23], "3", arr[25], arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } //PENDING TRANSACTIONS DASHBOARD : Period End Disclosures-Insider else if (isInsider == "PeriodEndDisInsider" && inp_sParam == "154002") { lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5], arr[6], inp_sParam, arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19], arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } //PENDING TRANSACTIONS DASHBOARD : Period End Disclosures-Insider else if (isInsider == "PeriodEndDisCO") { lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5], arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], "1", arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } //PENDING TRANSACTIONS DASHBOARD : Trade details-Insider else if (isInsider == "TradeDetailsInsider" && inp_sParam == "154002") { lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5], inp_sParam, arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19], arr[20], arr[21], arr[22], arr[23], "1", arr[25], arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } //PENDING TRANSACTIONS DASHBOARD : Trade details-CO else if (isInsider == "TradeDetailsCO" && inp_sParam == "154006") { lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5], inp_sParam, arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19], arr[20], arr[21], arr[22], arr[23], "1", arr[25], arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } //PENDING TRANSACTIONS DASHBOARD : Submission to Stock Exchange-CO else if (isInsider == "SubToStckExCO" && inp_sParam == "154002") { lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5], arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], inp_sParam, arr[19], arr[20], arr[21], arr[22], arr[23], "1", arr[25], arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } //PENDING TRANSACTIONS DASHBOARD : Pre-clearances-CO else if (isInsider == "PreClearancesCO" && inp_sParam == "144001") { lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], inp_sParam, arr[3], arr[4], arr[5], arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19], arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } else if (isInsider == "PreClearancesCO_OS" && inp_sParam == "144001") { lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], inp_sParam, arr[5], arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19], arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } else if (isInsider == "PreClearancesCO_OS" && inp_sParam == "154002") { lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5], inp_sParam, arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19], arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } //Defaulter DASHBOARD : Initial, Continouse, Period End, Pre-Clearance else if (inp_sParam == "170001" || inp_sParam == "170002" || inp_sParam == "170003" || inp_sParam == "170004") { lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5], arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19], arr[20], arr[21], arr[22], arr[23], arr[24], inp_sParam, arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } //Defaulter DASHBOARD : Contra Trade else if (inp_sParam == "169007") { lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5], arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19], arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], inp_sParam, arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } else { lstCRUserList = objGenericSLImpl.ListAllDataTableGrid(objLoginUserDetails.CompanyDBConnectionString, Convert.ToInt32(gridtype), nDisplayLength, nPage, sSortCol, sSortDir, out out_iTotalRecords, sLookUpPrefix, arr[0], arr[1], arr[2], arr[3], arr[4], arr[5], arr[6], arr[7], arr[8], arr[9], arr[10], arr[11], arr[12], arr[13], arr[14], arr[15], arr[16], arr[17], arr[18], arr[19], arr[20], arr[21], arr[22], arr[23], arr[24], arr[25], arr[26], arr[27], arr[28], arr[29], arr[30], arr[31], arr[32], arr[33], arr[34], arr[35], arr[36], arr[37], arr[38], arr[39], arr[40], arr[41], arr[42], arr[43], arr[44], arr[45], arr[46], arr[47], arr[48], arr[49] ); } } foreach (dynamic objUserList in lstCRUserList) { var dictionary = new Dictionary <string, Object>(); foreach (KeyValuePair <string, Object> kvp in objUserList) // enumerating over it exposes the Properties and Values as a KeyValuePair { dictionary.Add(kvp.Key, kvp.Value); } lstUserList.Add(dictionary); dictionary = null; } JsonResult returnJson = Json(new { aaData = lstUserList, status = true, draw = Request.Form["draw"], iTotalRecords = out_iTotalRecords, iTotalDisplayRecords = out_iTotalRecords }, JsonRequestBehavior.AllowGet); return(returnJson); } catch (Exception exp) { lstUserList = new List <Dictionary <string, Object> >(); JsonResult returnJson = Json(new { aaData = lstUserList, status = false, draw = Request.Form["draw"], iTotalRecords = 0, iTotalDisplayRecords = 0 }, JsonRequestBehavior.AllowGet); return(returnJson); } finally { lstCRUserList = null; lstUserList = null; } }
public IList <UserPOEMapping> GetFeedbackGiven(int userId, int subscriptionid) { //Log("WCF-GetFeedbackGiven-IN"); var common = new Common.Common(); using (var context = DataContextFactory.GetIntelliSetDataContext()) { var results = context.GetFeedbackGiven(userId, subscriptionid); var outPut = new List <UserPOEMapping>(); //foreach (var b in results.GroupBy(item => item.GroupName).ToList()) //{ foreach (var a in results) { if (a.FeedbackType != null) { var userPoeMapping = new UserPOEMapping { UserPOEMappingId = a.RequestedFor.GetValueOrDefault(), AreaId = a.ZoneId.GetValueOrDefault(), User = new User { UserId = a.UserId.GetValueOrDefault(), FirstName = a.FirstName, LastName = a.LastName, EmailAddress = a.EmailID, // Photo = a.Photo, Country = new Country { Id = a.CountryId.GetValueOrDefault(), Name = Helper.GetCountryName(a.CountryId.GetValueOrDefault()) }, Area = new Zone { Id = a.ZoneId.GetValueOrDefault(), Name = Helper.GetAreaById(a.ZoneId.GetValueOrDefault()) } }, POE = new Util.Domain.POE() { POEId = a.POEId.GetValueOrDefault(), Name = a.POEName, }, Designation = new Designation { DesignationId = a.DesignationId.GetValueOrDefault(), Name = a.JobTitle, }, FeedbackDetails = new Feedback { FeedbackId = a.GroupName != null ? 0 : a.POEFeedbackId.GetValueOrDefault(), RequestedBy = common.GetUserDetailsByMappingId(a.RequestedBy.GetValueOrDefault()), RequestedFor = common.GetUserDetailsByMappingId(a.RequestedFor.GetValueOrDefault()), RequestedFrom = common.GetUserDetailsByMappingId(a.RequestedFrom.GetValueOrDefault()), RequestedById = a.RequestedBy.GetValueOrDefault(), RequestedForId = a.RequestedFor.GetValueOrDefault(), RequestedFromId = a.RequestedFrom.GetValueOrDefault(), CreatedOnDtm = a.CreatedOn.GetValueOrDefault(), UpdatedOnDtm = a.UpdatedOn.GetValueOrDefault(), CreatedOn = a.CreatedOn != null ? a.CreatedOn.GetValueOrDefault().ToString("MMMM dd, yyyy") : "", UpdatedOn = a.UpdatedOn != null ? a.UpdatedOn.GetValueOrDefault().ToString("MMMM dd, yyyy") : "", FeedbackStatus = (FeedbackStatus) Enum.Parse(typeof(FeedbackStatus), a.FeedbackStatus.GetValueOrDefault().ToString()), FeedbackType = (FeedbackType) Enum.Parse(typeof(FeedbackType), a.FeedbackType.Value.ToString(CultureInfo.InvariantCulture)), GroupName = a.GroupName }, JobTitle = a.JobTitle }; outPut.Add(userPoeMapping); //if (userPoeMapping.FeedbackDetails.GroupName != null) //{ // userPoeMapping.Nooffbs = 1; // break; //} } } //} // Log("WCF-GetFeedbackGiven-OUT"); return(outPut); } }
public JsonResult UpdateResourceValue(ResourceModel objResourceModel, int acid) { bool bReturn = false; LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails); ResourcesSL objResourcesSL = new ResourcesSL(); ResourcesDTO objResourcesDTO = new ResourcesDTO(); CompaniesSL objCompaniesSL = new CompaniesSL(); bool statusFlag = false; var ErrorDictionary = new Dictionary <string, string>(); Common.Common objCommon = new Common.Common(); string message = string.Empty; try { if (!objCommon.ValidateCSRFForAJAX()) { return(Json(new { status = statusFlag, Message = ErrorDictionary }, JsonRequestBehavior.AllowGet)); } Common.Common.CopyObjectPropertyByName(objResourceModel, objResourcesDTO); objResourcesDTO.LoggedInUserId = objLoginUserDetails.LoggedInUserID; bReturn = objResourcesSL.SaveDetails(objLoginUserDetails.CompanyDBConnectionString, objResourcesDTO); if (bReturn) { objCompaniesSL.UpdateMasterCompanyDetails(Common.Common.getSystemConnectionString(), objLoginUserDetails.CompanyName, 1); Common.Common.UpdateCompanyResources(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.CompanyName); //return Json(new //{ // status = true, // Message = InsiderTrading.Common.Common.getResource("mst_msg_10049") //"Resource Update Successfully." //}, JsonRequestBehavior.AllowGet); statusFlag = true; message = InsiderTrading.Common.Common.getResource("mst_msg_10049"); } else { statusFlag = false; message = "Resource not saved."; } //return Json(new //{ // status = false, // Message = "Resource not saved." //}, JsonRequestBehavior.AllowGet); } catch (Exception exp) { ModelState.Remove("KEY"); ModelState.Add("KEY", new ModelState()); ModelState.Clear(); string sErrMessage = Common.Common.getResource(exp.InnerException.Data[0].ToString()); ModelState.AddModelError("error", sErrMessage); ErrorDictionary = GetModelStateErrorsAsString(); } finally { objLoginUserDetails = null; objResourcesSL = null; objResourcesDTO = null; objCompaniesSL = null; } return(Json(new { status = statusFlag, Message = message }, JsonRequestBehavior.AllowGet)); }