//[HttpPost] //public ActionResult TransactionQuery(string searchkey,DateTime startdate,DateTime enddate) //{ // if (HttpContext.Session["UID"] == null) // { // return RedirectToAction("Index", "Portal", null); // } // List<mTransaction> Transactions = new List<mTransaction>(); // using (Models.MerchantService db = new Models.MerchantService()) // { // List<v_Transactions> trans = db.v_Transactions.Where(x => (x.MPU_Merchant_ID.Contains(searchkey) || x.Merchant_Name.Contains(searchkey)) && (x.TrxDate >= startdate && x.TrxDate <= enddate)).ToList(); // Transactions = trans.Select(x => new mTransaction { MPU_Merchant_ID = x.MPU_Merchant_ID, Merchant_Name = x.Merchant_Name, CardNo = x.CardNo, CardType = x.CardType, TrxDate = x.TrxDate, TrxAmount = x.TrxAmount, SettAmount = x.SettAmount }).ToList(); // } // //mTransaction tran = new mTransaction(); // //Transactions = tran.transaction_query(searchkey, startdate, enddate); // return View(Transactions); //} public PartialViewResult TransactionQueryResult(string searchkey, string startdate, string enddate) { List <mTransaction> Transactions = new List <mTransaction>(); if (HttpContext.Session["UID"] == null) { TempData["ErrorMessage"] = "Session Error"; TempData.Keep(); return(PartialView(Transactions)); } try { DateTime sDate = Convert.ToDateTime(startdate); DateTime eDate = Convert.ToDateTime(enddate); mTransaction T = new mTransaction(); Transactions = T.transaction_query(searchkey, sDate, eDate); return(PartialView(Transactions)); } catch (Exception ex) { TempData["ErrorMessage"] = ex.Message; TempData.Keep(); return(PartialView(Transactions)); } //mTransaction tran = new mTransaction(); //Transactions = tran.transaction_query(searchkey, startdate, enddate); }
public ActionResult Delete(string[] trxid) { var data = new { status = "", message = "" }; if (HttpContext.Session["UID"] == null) { return(RedirectToAction("Index", "Portal", null)); } mUser u = new mUser(); if (!u.check_user_right(Session["UID"].ToString(), 2)) { return(RedirectToAction("Denied", "Portal", null)); } if (trxid == null) { data = new { status = "ok", message = "Invalid TRXID" }; } try { ViewBag.TRXId = trxid; string uid = Session["UID"].ToString(); for (int i = 0; i < trxid.Length; i++) { string tx = trxid[i]; mTransaction t = new mTransaction(); t.TrxID = int.Parse(tx); t.Delete(uid); } var message = String.Format("No of Transactions : {0} had been deleted...", trxid.Length); data = new { status = "ok", message = message }; } catch (Exception ex) { data = new { status = "ok", message = "Transaction List is empty or\n" + ex.Message }; } return(Json(data, JsonRequestBehavior.AllowGet)); }
internal FileResult TransactionExportToExcel(string searchkey, string startdate, string enddate) { if (HttpContext.Session["UID"] != null && startdate != null && enddate != null) { List <mTransaction> srl = new List <mTransaction>(); mTransaction sr = new mTransaction(); DateTime sdate = Convert.ToDateTime(startdate); DateTime edate = Convert.ToDateTime(enddate); srl = sr.transaction_query(searchkey, sdate, edate); ExcelPackage.LicenseContext = LicenseContext.NonCommercial; ExcelPackage Ep = new ExcelPackage(); ExcelWorksheet Sheet = Ep.Workbook.Worksheets.Add("TransactionQuery"); Sheet.Cells["A1"].Value = "TrxDate"; Sheet.Cells["B1"].Value = "MID"; Sheet.Cells["C1"].Value = "Merchant Name"; Sheet.Cells["D1"].Value = "Card No"; Sheet.Cells["E1"].Value = "Card Type"; Sheet.Cells["F1"].Value = "MDR Rate"; Sheet.Cells["G1"].Value = "Tran Amount"; Sheet.Cells["H1"].Value = "MDR Value"; Sheet.Cells["I1"].Value = "Settlement Amount"; int row = 2; foreach (mTransaction item in srl) { Sheet.Cells[string.Format("A{0}", row)].Value = item.TrxDate.Value.Date.ToString("MM/dd/yyyy"); Sheet.Cells[string.Format("B{0}", row)].Value = item.MPU_Merchant_ID; Sheet.Cells[string.Format("C{0}", row)].Value = item.Merchant_Name; Sheet.Cells[string.Format("D{0}", row)].Value = item.CardNo; Sheet.Cells[string.Format("E{0}", row)].Value = item.CardType; Sheet.Cells[string.Format("F{0}", row)].Value = item.TRXMDRRate; Sheet.Cells[string.Format("G{0}", row)].Value = item.TrxAmount; Sheet.Cells[string.Format("H{0}", row)].Value = item.MDRValue; Sheet.Cells[string.Format("I{0}", row)].Value = item.SettAmount; row++; } using (ExcelRange rng = Sheet.Cells[string.Format("F{0}:H{1}", 2, row + 1)]) { rng.Style.Numberformat.Format = "###,###,##0.00"; } Sheet.Cells[string.Format("A{0}:F{1}", row, row)].Merge = true; Sheet.Cells[string.Format("A{0}", row)].Value = "Total"; Sheet.Cells[string.Format("G{0}", row)].Value = srl.Sum(i => i.TrxAmount); Sheet.Cells[string.Format("H{0}", row)].Value = srl.Sum(i => i.MDRValue); Sheet.Cells[string.Format("I{0}", row)].Value = srl.Sum(i => i.SettAmount); Sheet.Cells["A:AZ"].AutoFitColumns(); Response.Clear(); var FileByteArray = Ep.GetAsByteArray(); return(File(FileByteArray, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", sdate.ToString("MM/dd/yyyy") + "-" + edate.ToString("MM/dd/yyyy") + "_TransactionQuery.xlsx")); //Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; //Response.AddHeader("content-disposition", "attachment: filename=" +trxdate.ToString("MM/dd/yyyy")+chkType+ "_SettlementReport.xlsx"); //Response.BinaryWrite(Ep.GetAsByteArray()); //Response.End(); } else { return(File(new byte[0], "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")); } }
internal List <mTransaction> ReadJCB_INC(string filepath) { if (HttpContext.Session["UID"] == null) { return(new List <mTransaction>()); } List <mTransaction> Tran_List = new List <mTransaction>(); string error_Lines = "Terminated!!!\nError : "; try { if (!string.IsNullOrEmpty(filepath)) { //Get Trx Date string datestr = Path.GetFileName(filepath); string year = "20" + datestr.Substring(3, 2); string month = datestr.Substring(5, 2); string day = datestr.Substring(7, 2); DateTime TRXDate = DateTime.ParseExact(year + "-" + month + "-" + day, "yyyy-MM-dd", null); //Read File string[] lines = System.IO.File.ReadAllLines(filepath); foreach (string line in lines) { if (line.Substring(0, 3) == "100") { mTransaction tran = new mTransaction(); tran.CardNo = line.Substring(3, 19).Replace(" ", ""); //To Get Card Type mCardType cardType = new mCardType(); cardType.BINCode = tran.CardNo.Substring(0, 4); tran.CardType = cardType.get_card_type(); tran.ProcessingCode = line.Substring(22, 6); Double decplace_scr = 1; int dec_place = int.Parse(line.Substring(52, 1)); for (int i = 0; i < dec_place; i++) { decplace_scr = decplace_scr * 10; } tran.SettConversationRate = Convert.ToDouble(line.Substring(53, 9)) / decplace_scr; tran.CurrencyCode = line.Substring(62, 3); tran.SettCurrencyCode = line.Substring(65, 3); tran.TerminalID = line.Substring(132, 8); //This is from raw file //tran.TrxID = 0001; tran.TrxAmount = Convert.ToDouble(line.Substring(28, 12)) / 100; tran.MPU_Merchant_ID = line.Substring(140, 15); double rate = 0; if (tran.MPU_Merchant_ID.Substring(0, 3) != "202") { //To get mdr rate from db mMerchant merchant = new mMerchant(); merchant.MPU_Merchant_ID = tran.MPU_Merchant_ID; rate = merchant.get_mdr_rate_jcbnotonus(merchant); //rate = getMDRrate(mid, "MPU"); if (rate == -123) { // rate -123 means that cannot get merchant's MDR rate or merchant info does not exist // so we need to block transaction to upload and show warning Global_Error = true; error_Lines += merchant.MPU_Merchant_ID + ","; TempData["MerchantInfoError"] = error_Lines; TempData.Keep(); } tran.TRXMDRRate = rate; tran.MDRValue = (tran.TrxAmount * rate) / 100; tran.SettAmount = tran.TrxAmount - tran.MDRValue; tran.TrxDate = TRXDate; tran.TRXRemark = Session["UID"].ToString(); tran.RecordType = "JCB_Not_ONUS"; Tran_List.Add(tran); } } } } } catch (Exception ex) { TempData["MerchantInfoError"] = ex.Message; TempData.Keep(); } return(Tran_List); }
internal List <mTransaction> ReadMPU_BCOM(string filepath) { if (HttpContext.Session["UID"] == null) { return(new List <mTransaction>()); } List <mTransaction> Tran_List = new List <mTransaction>(); string error_Lines = "Terminated!!! \nError : "; try { if (!string.IsNullOrEmpty(filepath)) { //Get Trx Date string datestr = Path.GetFileName(filepath); string year = "20" + datestr.Substring(3, 2); string month = datestr.Substring(5, 2); string day = datestr.Substring(7, 2); DateTime TRXDate = DateTime.ParseExact(year + "-" + month + "-" + day, "yyyy-MM-dd", null); //Read File string[] lines = System.IO.File.ReadAllLines(filepath); foreach (var line in lines) { string[] arr = line.Split(new char[0], StringSplitOptions.RemoveEmptyEntries); mTransaction tran = new mTransaction(); tran.CardNo = arr[4].ToString(); mCardType cardtype = new mCardType(); cardtype.BINCode = tran.CardNo.Substring(0, 4).ToString(); tran.CardType = cardtype.get_card_type(); tran.TrxAmount = Convert.ToDouble(arr[5].ToString()) / 100; tran.MPU_Merchant_ID = arr[12].ToString(); tran.ProcessingCode = arr[19].ToString(); tran.TerminalID = arr[11].ToString(); if (tran.ProcessingCode.Length > 3) { tran.ProcessingCode = arr[18].ToString(); tran.TerminalID = arr[15].ToString(); } double rate = 0; mMerchant merchant = new mMerchant(); merchant.MPU_Merchant_ID = tran.MPU_Merchant_ID; rate = merchant.get_mdr_rate_mpuonus(merchant); if (rate == -123) { // rate -123 means that cannot get merchant's MDR rate or merchant info does not exist // so we need to block transaction to upload and show warning Global_Error = true; error_Lines += merchant.MPU_Merchant_ID + ","; TempData["MerchantInfoError"] = error_Lines; TempData.Keep(); } tran.TRXMDRRate = rate; tran.MDRValue = (tran.TrxAmount * rate) / 100; tran.SettAmount = tran.TrxAmount - tran.MDRValue; tran.TrxDate = TRXDate; tran.TRXRemark = Session["UID"].ToString(); tran.RecordType = "MPU_ON_US"; Tran_List.Add(tran); } } } catch (Exception ex) { TempData["MerchantInfoError"] = ex.Message; TempData.Keep(); } return(Tran_List); }