public void DownloadFls(int UserInfoIdCheck, int GroupId, DateTime?SubmissionDate) { #region DownloadZipFolder LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails); using (NSEGroupSL ObjNSEGroupSL = new NSEGroupSL()) { List <NSEGroupDocumentMappingDTO> list = ObjNSEGroupSL.Get_All_NSEGroupDocument(objLoginUserDetails.CompanyDBConnectionString, GroupId, UserInfoIdCheck); string downloadFle = string.Empty; string directory = ConfigurationManager.AppSettings["Document"]; using (var zipStream = new ZipOutputStream(Response.OutputStream)) { if (UserInfoIdCheck == 1) { foreach (var downloadDt in list) { downloadFle = "attachment; filename=" + Convert.ToString(downloadDt.DownloadedDate) + ".zip"; } } else { downloadFle = "attachment; filename=" + Convert.ToString(SubmissionDate) + ".zip"; } Response.AddHeader("Content-Disposition", downloadFle); Response.ContentType = "application/zip"; int recCount = 0; string docName = string.Empty; foreach (var docPath in list) { if (UserInfoIdCheck == 1) { recCount = recCount + 1; docName = docPath.DocumentName + " " + "(" + recCount + ")" + ".pdf"; } else { docName = docPath.DocumentName; } string documentPath = (Path.Combine(directory, Convert.ToString(objLoginUserDetails.CompanyName), docPath.MapToTypeCodeId.ToString(), GroupId.ToString(), docPath.GUID)); byte[] fileBytes = System.IO.File.ReadAllBytes(documentPath); var fileEntry = new ZipEntry(Path.GetFileName(documentPath).Replace(docPath.GUID, docName)) { Size = fileBytes.Length, }; zipStream.PutNextEntry(fileEntry); zipStream.Write(fileBytes, 0, fileBytes.Length); } zipStream.Flush(); zipStream.Close(); } } #endregion DownloadZipFolder }
public ActionResult DownloadDocument(int acid, int GroupId) { LoginUserDetails objLoginUserDetails = null; TemplateMasterDTO objTemplateMasterDTO = null; ViewBag.GroupID = GroupId; ViewBag.ShowNote = false; objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails); using (NSEGroupSL ObjNSEGroupSL = new NSEGroupSL()) { List <NSEGroupDTO> lstSubmitDate = ObjNSEGroupSL.Get_Group_Date(objLoginUserDetails.CompanyDBConnectionString, GroupId); foreach (var submitdate in lstSubmitDate) { DateTime?SubmissionDate = submitdate.SubmissionDate; if (SubmissionDate.HasValue) { //download uploaded documents int UserInfoIdCheck = 0; DownloadFls(UserInfoIdCheck, GroupId, SubmissionDate); } else { TransactionLetterModel objTransactionLetterModel = new TransactionLetterModel(); objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails); using (TemplateMasterSL ObjTemplateMasterSL = new TemplateMasterSL()) { int DisclosureTypeCodeId = ConstEnum.Code.DisclosureTypeContinuous; int LetterCode = ConstEnum.Code.DisclosureLetterUserCO; TempData["NseDownloadFlag"] = 1; TempData["NseDownloadFlag2"] = 1; objTemplateMasterDTO = ObjTemplateMasterSL.GetTransactionLetterDetailsForGroup(objLoginUserDetails.CompanyDBConnectionString, DisclosureTypeCodeId, LetterCode); Common.Common.CopyObjectPropertyByName(objTemplateMasterDTO, objTransactionLetterModel); objTransactionLetterModel.DisclosureTypeCodeId = ConstEnum.Code.DisclosureTypeContinuous; objTransactionLetterModel.LetterForCodeId = LetterCode; objTransactionLetterModel.CompanyLogo = objLoginUserDetails.CompanyLogoURL; ViewBag.Layout = "~/Views/shared/_Layout.cshtml"; ViewBag.acid = acid; ViewBag.EditLetter = false; objLoginUserDetails.UserTypeCodeId = ConstEnum.Code.COUserType; } return(View("~/Views/Pdf/Letter.cshtml", objTransactionLetterModel)); } } } return(null); }
public ActionResult UploadDocument(int acid, int GroupId) { NSEGroupSL ObjNSEGroupSL = new NSEGroupSL(); NSEGroupDocumentMappingModel objNSEDocumentModel = null; LoginUserDetails objLoginUserDetails = null; objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails); objNSEDocumentModel = new NSEGroupDocumentMappingModel(); ViewBag.UserAction = acid; DateTime? date = null; List <NSEGroupDTO> lstDate = ObjNSEGroupSL.Get_Group_Date(objLoginUserDetails.CompanyDBConnectionString, GroupId); foreach (var submitdate in lstDate) { date = submitdate.DownloadedDate; } ViewBag.groupId = GroupId; ViewBag.DownloadDate = date; objNSEDocumentModel.NSEGroupDocumentFile = Common.Common.GenerateDocumentList(ConstEnum.Code.UploadNseDocument, 0, 0, null, 0, false, 0, ConstEnum.FileUploadControlCount.NSEUploadFile); return(View("NSEUploadDoc", objNSEDocumentModel)); }
public ActionResult ViewGroupDetails(int acid, int GroupId) { ViewBag.GroupID = GroupId; LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails); using (NSEGroupSL ObjNSEGroupSL = new NSEGroupSL()) { List <NSEGroupDTO> lstDate = ObjNSEGroupSL.Get_Group_Date(objLoginUserDetails.CompanyDBConnectionString, GroupId); foreach (var submitdate in lstDate) { DateTime?SubmissionDate = submitdate.SubmissionDate; if (SubmissionDate.HasValue) { return(RedirectToAction("ListByCO", "PreclearanceRequest", new { acid = ConstEnum.UserActions.CO_DISCLOSURE_DETAILS_CONTINUOUS_DISCLOSURE, GroupId })); } else { FillGrid(Common.ConstEnum.GridType.NSEDownloadDeleteGroupDetails, "0", null, null); return(View("ViewGroupDetails")); } } } return(null); }
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)); } }
public JsonResult DeleteGroupDetails(string arrIncluded, int acid, int GroupId) { bool statusFlag = false; var ErrorDictionary = new Dictionary <string, string>(); try { string[][] arrGroupDetails = null; Common.Common objCommon = new Common.Common(); if (arrIncluded != "") { arrGroupDetails = JsonConvert.DeserializeObject <string[][]>(arrIncluded); } DataTable dtDeleteGroupDetails = new DataTable(); dtDeleteGroupDetails.Columns.Add(new DataColumn("TransactionMasterID", typeof(int))); if (arrGroupDetails != null) { for (int i = 0; i < arrGroupDetails.Length; i++) { DataRow row = null; for (int j = 0; j < arrGroupDetails[i].Length; j++) { row = dtDeleteGroupDetails.NewRow(); row["TransactionMasterID"] = Convert.ToInt32(arrGroupDetails[i][j]); dtDeleteGroupDetails.Rows.Add(row); } row = null; } } bool bReturn = false; if (dtDeleteGroupDetails.Rows.Count == 0 || dtDeleteGroupDetails.Rows.Count < 0) { ErrorDictionary.Add("error", "Record deletion failed"); } else if (dtDeleteGroupDetails.Rows.Count > 0) { for (int i = 0; i < dtDeleteGroupDetails.Rows.Count; i++) { int TransactionMasterId = Convert.ToInt32(dtDeleteGroupDetails.Rows[i]["TransactionMasterID"].ToString()); NSEGroupSL objNSEGroupSL = new NSEGroupSL(); LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails); List <InsiderTradingDAL.NSEGroupDocumentMappingDTO> list = objNSEGroupSL.Get_Singledocument_Details(objLoginUserDetails.CompanyDBConnectionString, TransactionMasterId); InsiderTradingDAL.NSEGroupDetailsDTO objNSEGroupDetailsDTO = new InsiderTradingDAL.NSEGroupDetailsDTO(); objNSEGroupDetailsDTO.TransactionMasterId = TransactionMasterId; objNSEGroupDetailsDTO.LoggedInUserId = objLoginUserDetails.LoggedInUserID; bReturn = objNSEGroupSL.Delete_User_From_NSEGroup(objLoginUserDetails.CompanyDBConnectionString, objNSEGroupDetailsDTO); string directory = ConfigurationManager.AppSettings["Document"]; string OutputPathWithFileName = Path.Combine(directory, objLoginUserDetails.CompanyName, ConstEnum.Code.NseDocumentFormC.ToString(), TransactionMasterId.ToString()); foreach (var path in list) { string sGUID = Convert.ToString(path.GUID); string sourceFileNameWithPath = Path.Combine(directory, objLoginUserDetails.CompanyName, ConstEnum.Code.NseDocumentFormC.ToString(), GroupId.ToString(), Convert.ToString(sGUID.ToString())); FileInfo file = new FileInfo(Path.Combine(directory, objLoginUserDetails.CompanyName, ConstEnum.Code.NseDocumentFormC.ToString(), GroupId.ToString(), Convert.ToString(sGUID.ToString()))); if (file.Exists) { System.IO.File.Move(sourceFileNameWithPath, OutputPathWithFileName + "//" + sGUID); } } statusFlag = true; } if (bReturn) { statusFlag = true; ErrorDictionary.Add("success", "Record deleted successfully"); } else { ErrorDictionary.Add("error", "Record deletion failed"); } } FillGrid(Common.ConstEnum.GridType.NSEDownloadDeleteGroupDetails, "0", null, null); } catch (Exception ex) { throw ex; } return(Json(new { status = statusFlag, Message = ErrorDictionary }, JsonRequestBehavior.AllowGet)); }
public void DownloadExcel(int acid, int GroupId) { int UserInfoIdCheck = 1; string exlFilename = string.Empty; LoginUserDetails objLoginUserDetails = (LoginUserDetails)InsiderTrading.Common.Common.GetSessionValue((string)ConstEnum.SessionValue.UserDetails); using (NSEGroupSL ObjNSEGroupSL = new NSEGroupSL()) { List <NSEGroupDocumentMappingDTO> listDownloadDate = ObjNSEGroupSL.Get_All_NSEGroupDocument(objLoginUserDetails.CompanyDBConnectionString, GroupId, UserInfoIdCheck); foreach (var downloadDt in listDownloadDate) { exlFilename = "attachment; filename=Stock Exchange Submission" + " " + Convert.ToString(downloadDt.DownloadedDate) + ".xlsx"; } } string sConnectionString = string.Empty; sConnectionString = objLoginUserDetails.CompanyDBConnectionString; SqlConnection con = new SqlConnection(sConnectionString); SqlCommand cmd = new SqlCommand(); con.Open(); DataTable dt = new DataTable(); cmd = new SqlCommand("st_tra_NSEDownloadGroupWiseExcel", con); cmd.Parameters.AddWithValue("@GroupId", GroupId); cmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter adp = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); adp.Fill(dt); ExcelPackage excel = new ExcelPackage(); var workSheet = excel.Workbook.Worksheets.Add("Stock Exchange Submission"); var totalCols = dt.Columns.Count; var totalRows = dt.Rows.Count; workSheet.Cells["V1:AA1"].Merge = true; workSheet.Cells["V1:AA1"].Value = "Trading in derivatives"; workSheet.Cells["V1:AA1"].Style.Border.Top.Style = workSheet.Cells["V1:AA1"].Style.Border.Bottom.Style = workSheet.Cells["V1:AA1"].Style.Border.Left.Style = workSheet.Cells["V1:AA1"].Style.Border.Right.Style = ExcelBorderStyle.Thin; workSheet.Cells["V1:AA1"].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center; workSheet.Cells["G2:I2"].Merge = true; workSheet.Cells["G2:I2"].Value = "Securities held prior*"; workSheet.Cells["J2:M2"].Merge = true; workSheet.Cells["J2:M2"].Value = "Securities Acquired/Disposed"; workSheet.Cells["N2:P2"].Merge = true; workSheet.Cells["N2:P2"].Value = "Securities held post*"; workSheet.Cells["Q2:R2"].Merge = true; workSheet.Cells["Q2:R2"].Value = "Date of allotment advice/acquisition of shares/sale of shares*specify*"; workSheet.Cells["S2"].Merge = true; workSheet.Cells["S2"].Value = "Date of intimation to Company*"; workSheet.Cells["T2"].Merge = true; workSheet.Cells["T2"].Value = "Mode of Acquisition/Disposal"; workSheet.Cells["U2"].Merge = true; workSheet.Cells["U2"].Value = "Type of Contract"; workSheet.Cells["V2"].Merge = true; workSheet.Cells["V2"].Value = "Contract Specification from type of security"; workSheet.Cells["W2:X2"].Merge = true; workSheet.Cells["W2:X2"].Value = "Buy"; workSheet.Cells["Y2:Z2"].Merge = true; workSheet.Cells["Y2:Z2"].Value = "Sell"; workSheet.Cells["AA2"].Merge = true; workSheet.Cells["AA2"].Value = "Exchange on which the trade was Executed*"; workSheet.Cells["AB2"].Merge = true; workSheet.Cells["AB2"].Value = "Total Value In Aggregate"; string cellRangeHeader = "A2:AB2"; using (ExcelRange rngHeader = workSheet.Cells[cellRangeHeader]) { rngHeader.Style.WrapText = true; rngHeader.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center; rngHeader.Style.Font.Bold = true; rngHeader.Style.VerticalAlignment = ExcelVerticalAlignment.Center; rngHeader.Style.Border.Top.Style = rngHeader.Style.Border.Bottom.Style = rngHeader.Style.Border.Left.Style = rngHeader.Style.Border.Right.Style = ExcelBorderStyle.Thin; } for (var col = 1; col <= totalCols; col++) { workSheet.Cells[3, col].Value = dt.Columns[col - 1].ColumnName; workSheet.Cells[3, col].Style.Font.Name = "Arial"; workSheet.Cells[3, col].Style.Font.Size = 10; workSheet.Cells[3, col].Style.Font.Color.SetColor(System.Drawing.Color.Black); string cellRange = "A3:AB3"; using (ExcelRange rng = workSheet.Cells[cellRange]) { rng.Style.WrapText = true; rng.Style.HorizontalAlignment = ExcelHorizontalAlignment.Left; rng.Style.Font.Bold = true; rng.Style.VerticalAlignment = ExcelVerticalAlignment.Center; rng.Style.Border.Top.Style = rng.Style.Border.Bottom.Style = rng.Style.Border.Left.Style = rng.Style.Border.Right.Style = ExcelBorderStyle.Thin; } } int excelRow = 3; for (var row = 0; row < totalRows; row++) { for (var col = 0; col < totalCols; col++) { workSheet.Cells[excelRow + 1, col + 1].Value = dt.Rows[row][col].ToString(); workSheet.Cells[excelRow + 1, col + 1].Style.Border.Top.Style = workSheet.Cells[excelRow + 1, col + 1].Style.Border.Bottom.Style = workSheet.Cells[excelRow + 1, col + 1].Style.Border.Left.Style = workSheet.Cells[excelRow + 1, col + 1].Style.Border.Right.Style = ExcelBorderStyle.Thin; workSheet.Cells[excelRow + 1, col + 1].Style.WrapText = true; workSheet.Cells[excelRow + 1, col + 1].Style.VerticalAlignment = ExcelVerticalAlignment.Center; } excelRow++; } using (var memoryStream = new MemoryStream()) { Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AddHeader("content-disposition", exlFilename); excel.SaveAs(memoryStream); memoryStream.WriteTo(Response.OutputStream); Response.Flush(); Response.End(); } }