// [ValidateAntiForgeryToken] public ActionResult Validate() { try { //var rv = new SetReconUpldSession(); //var errCount = ValidateUpload(); //var rec = rv.GetSetReconUpload(User.Identity.Name); //var sucCount = rec.Count - errCount; var rv = new SetReconDualUpldSession(); var rec = rv.DualReconcileBatch(User.Identity.Name); var html = PartialView("_SetReconDualUpld", rec).RenderToString(); return(Json(new { data_html = html, RespCode = 0, RespMessage = "Record ", SucCount = 0, FailCount = 0 })); } catch (Exception ex) { return(Json(new { RespCode = 1, RespMessage = "Problem Processing Validation. " })); } }
public ActionResult DownloadSetRecon(string id) { try { //Call to get Excel byte array. string fileName = string.Format("Settlement Reconciliation for {0}.xlsx", DateTime.Now.ToString("dd-MM-yyyy")); var rv = new SetReconDualUpldSession(); var data = rv.GetSetReconDual(User.Identity.Name); var dt = SmartObj.ToDataTable(data); var excelBytes = DumpExcelLoginUser(dt, fileName); //Set file name. return(excelBytes != null?File(excelBytes, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName) : null); } catch { return(null); } }
// [ValidateAntiForgeryToken] public ActionResult Process() { string batchId = ""; try { var rv = new SetReconDualUpldSession(); var rec = rv.GetSetReconDualUpload(User.Identity.Name); // isUp = userInstitutionItbid == 1 ? true : false; //using (var txscope = new TransactionScope(TransactionScopeOption.RequiresNew, new TimeSpan(0, 30, 0))) //{ int errorcnt = 0; DateTime curDate = DateTime.Now; batchId = SmartObj.GenRefNo2(); int i = 0; int valCount = rec.Count(f => f.VALIDATIONERRORSTATUS == false); foreach (var d in rec) { if (i == 0) { SM_AUTHLIST auth = new SM_AUTHLIST() { CREATEDATE = DateTime.Now, EVENTTYPE = eventInsert, MENUID = menuId, //MENUNAME = "", // RECORDID = objG.ITBID, STATUS = open, //TABLENAME = "SM_FREQUENCY", URL = Request.FilePath, USERID = User.Identity.Name, INSTITUTION_ITBID = institutionId, BATCHID = batchId, POSTTYPE = Batch }; repoAuth.Insert(auth); } i++; if (d.VALIDATIONERRORSTATUS == true) { errorcnt++; continue; } // var obj = new SM_UPLOADSETRECON_TEMP()// SM_MERCHANTTERMINALUPLD() // { // REFERENCENO = d.REFERENCENO, // CARDTYPE = d.CARDTYPE, // TRANSACTIONTYPE = d.TRANSACTIONTYPE, // TRANSACTIONDATETIME = d.TRANSACTIONDATETIME, // SETTLEMENTDATE = d.SETTLEMENTDATE, // MASKEDPAN = d.MASKEDPAN, // MERCHANTID = d.MERCHANTID, // MERCHANTACCOUNT = d.MERCHANTACCOUNT, // MERCHANTNAME = d.MERCHANTNAME, // MERCHANTLOCATION = d.MERCHANTLOCATION, // TERMINALID = d.TERMINALID, // TRANAMOUNT = d.TRANAMOUNT, // AMOUNTCHARGED = d.AMOUNTCHARGED, // SETTLEMENTAMOUNT = d.SETTLEMENTAMOUNT, // MSCRATE = d.MSCRATE, // BATCHTYPE = d.BATCHTYPE, // BATCHID = batchId, // CREATEDATE = curDate, // STATUS = open, // USERID = User.Identity.Name, // }; // repoSetReconDualUploadTemp.Insert(obj); // //cnt++; } var rst = uow.Save(User.Identity.Name); if (rst > 0) { //SessionHelper.GetCart(Session).Clear(); rv.PurgeSetReconDualUpload(User.Identity.Name); try { EmailerNotification.SendForAuthorization(menuId, fullName, deptCode, institutionId, string.Format("Setttlement Reconciliation Upload Batch #{0}", batchId)); } catch { } //txscope.Complete(); } else { return(Json(new { RespCode = 1, RespMessage = "Problem Processing Request." })); } //} } catch (Exception ex) { return(Json(new { RespCode = 1, RespMessage = ex.Message })); } var msg = string.Format("<i class='fa fa-check' ></i> Record with Batch-ID #{0} Processed SuccessFully and has been forwarded for authorization", batchId); return(Json(new { RespCode = 0, RespMessage = msg })); }
public ActionResult UploadFilesB() { IList <SetReconDualUpldObj> model = null; try { var rc = Request.Files; // var dd = Request.Form["requestType"]; if (rc != null) { var file = rc[0]; if (file != null && file.ContentLength > 0) { var stream = file.InputStream; var fileName = Path.GetFileName(file.FileName); var ext = Path.GetExtension(file.FileName); if (ext != ".xlsx") { return(Json(new { RespCode = 1, RespMessage = "Please Upload Using .xlsx file" })); } if (!Directory.Exists(Server.MapPath("~/UploadFiles"))) { Directory.CreateDirectory(Server.MapPath("~/UploadFiles")); } var path = Path.Combine(Server.MapPath("~/UploadFiles"), fileName); using (var fileStream = System.IO.File.Create(path)) { stream.CopyTo(fileStream); } var dataList = ExcelReader.GetDataToList(path, addRecord); // ExxcellReaderClosedXml.GetDataToList(path, addRecord); //int cnt = 0; var rv = new SetReconDualUpldSession(); var obj = new SetReconDualUpldObj(); //if (obj.BATCHTYPE == null) //{ var cnt = rv.PostSetReconDualUploadBulkB(dataList.ToList(), User.Identity.Name); if (cnt > 0) { var rst = rv.GetSetReconDualUpload(User.Identity.Name); var html = PartialView("_SetReconDualUpld", rst).RenderToString(); return(Json(new { data_html = html, RespCode = 0, RespMessage = "Please Upload Using .xlsx file" })); } else { var html = PartialView("_SetReconDualUpld").RenderToString(); return(Json(new { RespCode = 1, RespMessage = "Problem processing file upload." })); } //} //else //{ // var cntb = rv.PostSetReconDualUploadBulkb(dataList.ToList(), User.Identity.Name); // if (cntb > 0) // { // var rst = rv.GetSetReconDualUpload(User.Identity.Name); // var html = PartialView("_SetReconDualUpld", rst).RenderToString(); // return Json(new { data_html = html, RespCode = 0, RespMessage = "Please Upload Using .xlsx file" }); // } // else // { // var html = PartialView("_SetReconDualUpld").RenderToString(); // return Json(new { RespCode = 1, RespMessage = "Problem processing file upload." }); // } //} } } // If we got this far, something failed, redisplay form //return Json(new { RespCode = 1, RespMessage = errorMsg }); } catch (SqlException ex) { return(Json(new { data = model, RespCode = 1, RespMessage = ex.Message })); } catch (Exception ex) { return(Json(new { data = model, RespCode = 1, RespMessage = ex.Message })); } return(Json(new { data = model, BatchId = "", RespCode = 0, RespMessage = "File Uploaded Successfully" })); }