public ActionResult Summary(int acid, int period, int year, int pdtype, int uid = 0, int tmid = 0) { LoginUserDetails objLoginUserDetails = null; UserInfoDTO objUserInfoDTO = null; ViewBag.showAddTransactionBtn = false; DateTime dtEndDate = DateTime.Now; Dictionary <string, object> dicPeriodStartEnd = null; try { objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); //set activity id for summary page as this page is access from both menu - insider and CO ViewBag.activity_id = acid; using (PeriodEndDisclosureSL objPeriodEndDisclosure = new PeriodEndDisclosureSL()) { dicPeriodStartEnd = objPeriodEndDisclosure.GetPeriodStarEndDate(objLoginUserDetails.CompanyDBConnectionString, year, period, pdtype); DateTime dtStartDate = Convert.ToDateTime(dicPeriodStartEnd["start_date"]); dtEndDate = Convert.ToDateTime(dicPeriodStartEnd["end_date"]); String dtFormat = "dd MMM yyyy"; ViewBag.Period = dtStartDate.ToString(dtFormat) + " - " + dtEndDate.ToString(dtFormat); } //set input vaules for period end summary grid ViewBag.UserId = (uid == 0) ? objLoginUserDetails.LoggedInUserID : uid; ViewBag.YearCode = year; ViewBag.PeriodCode = period; ViewBag.PeriodType = pdtype; ViewBag.TransactionMasterId = (tmid == 0) ? "" : tmid.ToString(); ViewBag.GridType = ConstEnum.GridType.PeriodEndDisclosurePeriodSummary; //if activity id is for CO then fetch employee insider details if (acid == ConstEnum.UserActions.CO_DISCLOSURE_DETAILS_PERIOD_END_DISCLOSURE) { using (UserInfoSL objUserInfoSL = new UserInfoSL()) { objUserInfoDTO = objUserInfoSL.GetUserDetails(objLoginUserDetails.CompanyDBConnectionString, uid); ViewBag.EmployeeId = objUserInfoDTO.EmployeeId; ViewBag.InsiderName = (objUserInfoDTO.UserTypeCodeId == ConstEnum.Code.CorporateUserType) ? objUserInfoDTO.CompanyName : objUserInfoDTO.FirstName + " " + objUserInfoDTO.LastName; } } } catch (Exception ex) { } finally { dicPeriodStartEnd = null; //objLoginUserDetails = null; objUserInfoDTO = null; } int contDisStatusCount = 0; int PEDisStatusCount = 0; int IsIDPending = 0; using (TradingTransactionSL objTradingTransactionSL = new TradingTransactionSL()) { acid = ConstEnum.UserActions.INSIDER_DISCLOSURE_DETAILS_PERIOD_END_DISCLOSURE; year = 0; List <ContinuousDisclosureStatusDTO> lstConDisclosureStatus = objTradingTransactionSL.Get_ContinuousDisclosureStatus(objLoginUserDetails.CompanyDBConnectionString, uid, dtEndDate); foreach (var contDisStatus in lstConDisclosureStatus) { contDisStatusCount = contDisStatus.ContDisPendingStatus; } if (contDisStatusCount > 0) { int ContDisCheck = contDisStatusCount; return(RedirectToAction("PeriodStatus", "PeriodEndDisclosure", new { acid, year, uid, ContDisCheck })); } else { List <ContinuousDisclosureStatusDTO> lstPEDisclosureStatus = objTradingTransactionSL.Get_PEDisclosureStatus(objLoginUserDetails.CompanyDBConnectionString, uid, dtEndDate); foreach (var periodEndStatus in lstPEDisclosureStatus) { PEDisStatusCount = periodEndStatus.PEDisPendingStatus; IsIDPending = periodEndStatus.IsRelativeFound; } if (IsIDPending > 0) { return(RedirectToAction("PeriodStatus", "PeriodEndDisclosure", new { acid, year, uid, PEDisStatusCount, IsIDPending })); } else if (PEDisStatusCount > 0) { int PeriodEndDisCheck = PEDisStatusCount; return(RedirectToAction("PeriodStatus", "PeriodEndDisclosure", new { acid, year, uid, PeriodEndDisCheck })); } else { TradingTransactionMasterDTO objTradingTransactionMasterDTO = null; objTradingTransactionMasterDTO = new TradingTransactionMasterDTO(); objTradingTransactionMasterDTO = objTradingTransactionSL.GetTradingTransactionMasterDetails(objLoginUserDetails.CompanyDBConnectionString, tmid); if (objTradingTransactionMasterDTO.TransactionStatusCodeId == 148002) { ViewBag.showAddTransactionBtn = true; } return(View("Summary")); } } } }
public ActionResult Index(int acid) { TempData.Remove("SearchArray"); LoginUserDetails objLoginUserDetails = null; InsiderDashboardDTO objInsiderDashboardDTO = null; UserInfoDTO objUserInfoDTO = null; ApprovedPCLDTO objApprovedPCLDTO = null; PasswordExpiryReminderDTO objPassExpiryReminderDTO = null; DateTime CurrentDate; ArrayList lst = new ArrayList(); UserPolicyDocumentEventLogDTO objChangePasswordEventLogDTO = null; CompanyConfigurationDTO objCompanyConfigurationDTO = null; int RequiredModuleID = 0; int noOfDays = 0; object path; ViewBag.dupTransCnt = false; ViewBag.ApprovedPCLCnt = false; Common.Common.WriteLogToFile("Start Method", System.Reflection.MethodBase.GetCurrentMethod()); try { objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); // check IsUserLogin flag in session, and set flag true -- this will indicate user is login and redirect here for first time if (!objLoginUserDetails.IsUserLogin) { objLoginUserDetails.IsUserLogin = true; Common.Common.SetSessionValue(ConstEnum.SessionValue.UserDetails, objLoginUserDetails); } if (objLoginUserDetails.CompanyName == "DCBBank") { ViewBag.IsVisible = 0; } else { ViewBag.IsVisible = 1; } using (var objInsiderInitialDisclosureSL = new InsiderInitialDisclosureSL()) { InsiderInitialDisclosureDTO objInsiderInitialDisclosureDTO = null; objInsiderInitialDisclosureDTO = objInsiderInitialDisclosureSL.Get_mst_company_details(objLoginUserDetails.CompanyDBConnectionString); RequiredModuleID = objInsiderInitialDisclosureDTO.RequiredModule; } objInsiderDashboardModel = new InsiderDashboardModel(); objInsiderDashboardModel.objInsiderDashboardOtherModel = new InsiderDashboardOtherModel(); switch (RequiredModuleID) { case ConstEnum.Code.RequiredModuleOwnSecurity: ViewBag.RequiredModuleOwn = true; ViewBag.RequiredModuleBoth = false; ViewBag.RequiredModuleOther = false; break; case ConstEnum.Code.RequiredModuleOtherSecurity: ViewBag.RequiredModuleOwn = false; ViewBag.RequiredModuleBoth = false; ViewBag.RequiredModuleOther = true; objInsiderDashboardModel.objInsiderDashboardOtherModel = BindDashboardForOtherSecurities(); break; case ConstEnum.Code.RequiredModuleBoth: ViewBag.RequiredModuleOwn = true; int?TradingPolicyID_OS; //check other sericity model is applicable for user or not InsiderInitialDisclosureDTO objInsiderInitialDisclosureDTO = null; using (var objInsiderInitialDisclosureSL = new InsiderInitialDisclosureSL()) { objInsiderInitialDisclosureDTO = objInsiderInitialDisclosureSL.Get_TradingPolicyID_forOS(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID); TradingPolicyID_OS = objInsiderInitialDisclosureDTO.TradingPolicyID_OS; } if (TradingPolicyID_OS == null || TradingPolicyID_OS == 0) { ViewBag.RequiredModuleBoth = false; ViewBag.RequiredModuleOther = false; } else { ViewBag.RequiredModuleBoth = true; ViewBag.RequiredModuleOther = true; } objInsiderDashboardModel.objInsiderDashboardOtherModel = BindDashboardForOtherSecurities(); break; } if (objInsiderDashboardModel.objInsiderDashboardOtherModel.IsChangePassword) { Common.Common.SetSessionValue("IsChangePassword", true); return(RedirectToAction("ChangePassword", "UserDetails", new { acid = Convert.ToString(Common.ConstEnum.UserActions.CHANGE_PASSWORD) })); } using (InsiderDashboardSL objInsiderDashboardSL = new InsiderDashboardSL()) { objInsiderDashboardDTO = objInsiderDashboardSL.GetTradingCalenderDetails(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID); if (objInsiderDashboardDTO.IsActivated == 1) { ViewBag.hideTrading = 0; } else { ViewBag.hideTrading = 1; } objInsiderDashboardDTO = objInsiderDashboardSL.GetDashboardDetails(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID); Common.Common.CopyObjectPropertyByName(objInsiderDashboardDTO, objInsiderDashboardModel); CurrentDate = Convert.ToDateTime(DateTime.Now.Date.ToString("dd/MM/yyyy"), System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat); objPassExpiryReminderDTO = objInsiderDashboardSL.GetPasswordExpiryReminder(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID); if (objLoginUserDetails.LoggedInUserID == objPassExpiryReminderDTO.UserID && objPassExpiryReminderDTO.ValidityDate.Date >= CurrentDate && objPassExpiryReminderDTO.ExpiryReminderDate.Date <= CurrentDate) { if ((objPassExpiryReminderDTO.ValidityDate.Date - CurrentDate.Date).Days == 1) { noOfDays = (objPassExpiryReminderDTO.ValidityDate.Date - CurrentDate.Date).Days; } else { noOfDays = (objPassExpiryReminderDTO.ValidityDate.Date - CurrentDate.Date).Days + 1; } lst.Add(noOfDays); lst.Add(objPassExpiryReminderDTO.ValidityDate.Date.ToString("dd/MM/yyyy")); ViewBag.PasswordReminderMsg = Common.Common.getResource("pc_msg_50569", lst); } else if (objPassExpiryReminderDTO.ValidityDate.Date < CurrentDate) { Common.Common.SetSessionValue("IsChangePassword", true); return(RedirectToAction("ChangePassword", "UserDetails", new { acid = Convert.ToString(Common.ConstEnum.UserActions.CHANGE_PASSWORD) })); } } using (UserInfoSL objUserInfoSL = new UserInfoSL()) { objUserInfoDTO = objUserInfoSL.GetUserDetails(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID); if (objUserInfoDTO.DateOfBecomingInsider != null) { ViewBag.InsiderTypeUser = 1; } else { ViewBag.InsiderTypeUser = 0; } } int SecurityTypeCodeIdCnt = 0; int TransactionTypeCodeIdCnt = 0; int DateOfAcquisitionCnt = 0; using (InsiderDashboardSL objInsiderDashboardSL = new InsiderDashboardSL()) { List <DupTransCntDTO> lstDupTransCnt = objInsiderDashboardSL.Get_DupTransCnt(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID); foreach (var dupTransCnt in lstDupTransCnt) { SecurityTypeCodeIdCnt = dupTransCnt.SecurityTypeCodeIdCnt; TransactionTypeCodeIdCnt = dupTransCnt.TransactionTypeCodeIdCnt; DateOfAcquisitionCnt = dupTransCnt.DateOfAcquisitionCnt; } } if (SecurityTypeCodeIdCnt != 0 && TransactionTypeCodeIdCnt != 0 && DateOfAcquisitionCnt != 0) { ViewBag.dupTransCnt = true; TempData["TradingTransactionModel"] = null; TempData["DuplicateTransaction"] = null; } int localApprovedPCLCnt = 0; using (TradingTransactionSL objTradingTransactionSL = new TradingTransactionSL()) { List <ApprovedPCLDTO> lstApprovedPCLCnt = objTradingTransactionSL.GetApprovedPCLCntSL(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID); foreach (var ApprovedPCLCnt in lstApprovedPCLCnt) { localApprovedPCLCnt = ApprovedPCLCnt.ApprovedPCLCnt; } } if (localApprovedPCLCnt != 0) { ViewBag.ApprovedPCLCnt = true; } } catch (Exception exp) { Common.Common.WriteLogToFile("Exception occurred ", System.Reflection.MethodBase.GetCurrentMethod(), exp); } finally { objLoginUserDetails = null; objInsiderDashboardDTO = null; objUserInfoDTO = null; } Common.Common.WriteLogToFile("End Method", System.Reflection.MethodBase.GetCurrentMethod()); return(View(objInsiderDashboardModel)); }
public ActionResult Save(InsiderTrading.Models.NSEGroupDocumentMappingModel objNSEGroupDocumentModel, Dictionary <int, List <DocumentDetailsModel> > dicPolicyDocumentsUploadFileList, int GroupId) { ModelState.Remove("KEY"); ModelState.Add("KEY", new ModelState()); ModelState.Clear(); var StockExchangeDateSubmission = Request.Form["SubmissionFromDate"]; LoginUserDetails objLoginUserDetails = null; DocumentDetailsSL objDocumentDetailsSL = new DocumentDetailsSL(); List <DocumentDetailsModel> UploadFileDocumentDetailsModelList = null; NSEGroupDocumentMappingDTO objNSEGroupDocDTO = new NSEGroupDocumentMappingDTO(); NSEGroupDetailsDTO objNSEGroupDetailsDTO = new NSEGroupDetailsDTO(); NSEGroupDTO objNSEGroupDTO = new NSEGroupDTO(); objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails); DateTime?date = null; using (NSEGroupSL ObjNSEGroupSL = new NSEGroupSL()) { List <NSEGroupDTO> lstDate = ObjNSEGroupSL.Get_Group_Date(objLoginUserDetails.CompanyDBConnectionString, GroupId); foreach (var submitdate in lstDate) { date = submitdate.DownloadedDate; } } if (StockExchangeDateSubmission == "") { ModelState.AddModelError("DateOfSubmissionToNSE", Common.Common.getResource("nse_lbl_50535")); } else { objNSEGroupDTO.SubmissionDate = Convert.ToDateTime(StockExchangeDateSubmission); if (objNSEGroupDTO.SubmissionDate > Common.Common.GetCurrentDate(objLoginUserDetails.CompanyDBConnectionString)) { ModelState.AddModelError("DateOfSubmissionToNSE", Common.Common.getResource("nse_lbl_50534")); } if (Convert.ToDateTime(date).Date > objNSEGroupDTO.SubmissionDate) { ModelState.AddModelError("DateOfSubmissionToNSE", Common.Common.getResource("nse_lbl_50536")); } } if (ModelState.IsValid) { if (dicPolicyDocumentsUploadFileList.Count > 0) // file is uploaded and data found for file upload { UploadFileDocumentDetailsModelList = dicPolicyDocumentsUploadFileList[ConstEnum.Code.UploadNseDocument]; } List <DocumentDetailsModel> objSavedDocumentDetialsModelList = objDocumentDetailsSL.SaveDocumentDetails(objLoginUserDetails.CompanyDBConnectionString, UploadFileDocumentDetailsModelList, ConstEnum.Code.UploadNseDocument, GroupId, objLoginUserDetails.LoggedInUserID, objLoginUserDetails.CompanyName); DocumentDetailsDTO objDocumentDetailsDTO = null; objDocumentDetailsDTO = new DocumentDetailsDTO(); using (NSEGroupSL objNSEGroupSL = new NSEGroupSL()) { if (UploadFileDocumentDetailsModelList != null) { foreach (var fleGUID in UploadFileDocumentDetailsModelList) { objNSEGroupDetailsDTO.LoggedInUserId = objLoginUserDetails.LoggedInUserID; objNSEGroupDetailsDTO.GroupId = GroupId; List <NSEGroupDetailsDTO> GrouplistDetails = objNSEGroupSL.Save_NSEGroup_Details(objLoginUserDetails.CompanyDBConnectionString, objNSEGroupDetailsDTO); foreach (var nseuserId in GrouplistDetails) { objNSEGroupDocDTO.NSEGroupDetailsId = nseuserId.NSEGroupDetailsId; objNSEGroupDetailsDTO.GroupId = Convert.ToInt32(GroupId); bool bReturnDoc = objNSEGroupSL.Save_New_NSEDocument(objLoginUserDetails.CompanyDBConnectionString, objNSEGroupDocDTO, fleGUID.GUID); } } } objNSEGroupDTO.GroupId = GroupId; objNSEGroupDTO.LoggedInUserId = objLoginUserDetails.LoggedInUserID; objNSEGroupDTO.StatusCodeId = 508007; bool bReturn = objNSEGroupSL.Update_NSEGroup(objLoginUserDetails.CompanyDBConnectionString, objNSEGroupDTO); } TradingTransactionMasterDTO objTradingTransactionMasterDTO = null; using (TradingTransactionSL objTradingTransactionSL = new TradingTransactionSL()) { using (NSEGroupSL objNSEGroupSL = new NSEGroupSL()) { List <NSEGroupDetailsDTO> grpTransIdList = objNSEGroupSL.Get_Group_TransactionId(objLoginUserDetails.CompanyDBConnectionString, GroupId); foreach (var TransId in grpTransIdList) { objTradingTransactionMasterDTO = new TradingTransactionMasterDTO(); objTradingTransactionMasterDTO.TransactionMasterId = TransId.transId; objTradingTransactionMasterDTO.TransactionStatusCodeId = ConstEnum.Code.DisclosureStatusForHardCopySubmittedByCO; objTradingTransactionMasterDTO.HardCopyByCOSubmissionDate = Convert.ToDateTime(StockExchangeDateSubmission); objTradingTransactionMasterDTO = objTradingTransactionSL.GetTradingTransactionMasterCreate(objLoginUserDetails.CompanyDBConnectionString, objTradingTransactionMasterDTO, objLoginUserDetails.LoggedInUserID, out nDisclosureCompletedFlag); } } } return(RedirectToAction("Index", "NSEDownload", new { acid = ConstEnum.UserActions.NSEDownload })); } else { ViewBag.groupId = GroupId; ViewBag.DownloadDate = date; ViewBag.UserAction = Common.ConstEnum.UserActions.NSEDownload; objNSEGroupDocumentModel.NSEGroupDocumentFile = Common.Common.GenerateDocumentList(ConstEnum.Code.UploadNseDocument, 0, 0, null, 0, false, 0, ConstEnum.FileUploadControlCount.NSEUploadFile); return(View("NSEUploadDoc", objNSEGroupDocumentModel)); } }