// [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 SetReconUpldSession();
var rec = rv.ReconcileBatch(User.Identity.Name);
var html = PartialView("_SetReconUpld", 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("System Settlement Reconciliation for {0}.xlsx", DateTime.Now.ToString("dd-MM-yyyy"));
var rv = new SetReconUpldSession();
var data = rv.GetSetRecon(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 SetReconUpldSession();
var rec = rv.GetSetReconUpload(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_SETRECONCILIATION_TEMP()// SM_MERCHANTTERMINALUPLD()
{
PAYREFNO = d.PAYREFNO,
AMOUNT = d.AMOUNT,
PAYMENTDATE = d.PAYMENTDATE,
VALUEDATE = d.VALUEDATE,
//RECEIPTNO = d.RECEIPTNO,
CUSTOMERNAME = d.CUSTOMERNAME,
PAYMENTMETHOD = d.PAYMENTMETHOD,
//TRANSACTIONSTATUS = d.TRANSACTIONSTATUS,
//DEPOSITSLIPNO = d.DEPOSITSLIPNO,
BANKNAME = d.BANKNAME,
//BRANCHNAME = d.BRANCHNAME,
//PAYERID = d.PAYERID,
//VALUEGRANTED = d.VALUEGRANTED,
//RECONCILE = d.RECONCILE,
BATCHID = batchId,
CREATEDATE = curDate,
STATUS = open,
USERID = User.Identity.Name,
};
repoSetReconciliationTemp.Insert(obj);
//cnt++;
}
var rst = uow.Save(User.Identity.Name);
if (rst > 0)
{
//SessionHelper.GetCart(Session).Clear();
rv.PurgeSetReconUpload(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 }));
}
// [ValidateAntiForgeryToken]
public ActionResult UploadFiles()
{
IList <SetReconUpldObj> 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 SetReconUpldSession();
var cnt = rv.PostSetReconUploadBulk(dataList.ToList(), User.Identity.Name);
if (cnt > 0)
{
var rst = rv.GetSetReconUpload(User.Identity.Name);
var html = PartialView("_SetReconUpld", rst).RenderToString();
return(Json(new { data_html = html, RespCode = 0, RespMessage = "Please Upload Using .xlsx file" }));
}
else
{
var html = PartialView("_SetReconUpld").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" }));
}
