public JsonResult UpdateAuditer(Libraries.CommonLibrary.CBE.TransactionCBE transaction) { JsonResult result = new JsonResult(); try { transaction.TMSId = Libraries.CommonLibrary.Constants.GetCurrentTMSId(); transaction.PlazaId = Libraries.CommonLibrary.Constants.GetCurrentPlazaId(); transaction.AuditDate = DateTime.Now; transaction.AuditorId = Convert.ToInt32(Session["LoggedUserId"].ToString()); transaction.AuditStatus = (int)Libraries.CommonLibrary.Constants.AuditStatus.Reviewed; Libraries.CommonLibrary.BLL.TransactionBLL.UpdateAuditSection(transaction); result.Data = "Sucess"; } catch (Exception ex) { result.Data = "Failure"; HelperClass.LogMessage("Failed To Post Transaction List" + ex); } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult JoinTransactions(string[] AssociatedTransactionIds, string TransactionId, string VehRegNo, string vehicleClassID) { JsonResult result = new JsonResult(); int vehicleClassId = Convert.ToInt32(vehicleClassID);//Get by Audited DateTime transactionDatetime = DateTime.Now; int isBalanceUpdated = 0; long childOneTranasactionId = 0; long childTwoTranasactionId = 0; StringBuilder returnMessage = new StringBuilder(); String message = ""; //get Parent Transaction Data Libraries.CommonLibrary.CBE.TransactionCBE transaction = new Libraries.CommonLibrary.CBE.TransactionCBE(); transaction.TransactionId = Convert.ToInt32(TransactionId); DataTable parentTransaction = new DataTable(); parentTransaction = Libraries.CommonLibrary.BLL.TransactionBLL.Transaction_GetById(transaction); if (parentTransaction != null && parentTransaction.Rows != null && parentTransaction.Rows.Count > 0) { if (parentTransaction.Rows[0]["IS_BALANCE_UPDATED"].ToString() == "1") { isBalanceUpdated = 1; } transaction.LaneId = Convert.ToInt32(parentTransaction.Rows[0]["LANE_ID"].ToString()); transactionDatetime = Convert.ToDateTime(parentTransaction.Rows[0]["TRANSACTION_DATETIME"].ToString()); } if (AssociatedTransactionIds != null) { //Check Reviewer Selected One Child if (AssociatedTransactionIds.Length > 0) { childOneTranasactionId = Convert.ToInt64(AssociatedTransactionIds[0]); } if (AssociatedTransactionIds.Length > 1) { childTwoTranasactionId = Convert.ToInt64(AssociatedTransactionIds[1]); } } transaction.IsBalanceUpdated = isBalanceUpdated; transaction.TransactionDateTime = transactionDatetime; transaction.ModifierId = Convert.ToInt32(Session["LoggedUserId"].ToString()); transaction.ModificationDate = DateTime.Now; transaction.TMSId = Libraries.CommonLibrary.Constants.GetCurrentTMSId(); transaction.PlazaId = Libraries.CommonLibrary.Constants.GetCurrentPlazaId(); #region Financial and Notification By Manual Review if (isBalanceUpdated != 1) { //Charging and Notification Logics //get Customer Vehicle from customer VRN Libraries.CommonLibrary.CBE.CustomerVehicleCBE customerVehicleInfo = new Libraries.CommonLibrary.CBE.CustomerVehicleCBE(); customerVehicleInfo.VehRegNo = VehRegNo; customerVehicleInfo = Libraries.CommonLibrary.BLL.CustomerVehicleBLL.GetCustomerVehicleByVehRegNo(customerVehicleInfo); customerVehicleInfo.VehicleClassId = vehicleClassId; //get customer account info from customer VRN Libraries.CommonLibrary.CBE.CustomerAccountCBE customerAccountInfo = new Libraries.CommonLibrary.CBE.CustomerAccountCBE(); customerAccountInfo.AccountId = customerVehicleInfo.AccountId; customerAccountInfo.TmsId = 1; customerAccountInfo = Libraries.CommonLibrary.BLL.CustomerAccountBLL.GetCustomerById(customerAccountInfo); //financial operation here FinancialProcessing(customerVehicleInfo, customerAccountInfo, transaction); //Update Is Blanace Updated =1 isBalanceUpdated = 1; HelperClass.LogMessage("Financial processing has been done."); //notification operation here //NotificationProcessing(customerVehicleInfo, customerAccountInfo, transaction); message = "SucessFully Audited and Join Transaction"; } else { returnMessage.Append("Balance not Deducted as Balance already deducted for this Transaction"); message = "Balance not Deducted as Balance already deducted for this Transaction"; } #endregion //In this region i have to call new package #region Join and Audit Section of Transactions //Call Function UpdateAuditJoinTransaction Here Libraries.CommonLibrary.BLL.TransactionBLL.JoinAuditTransaction(transaction.TransactionId, childOneTranasactionId, childTwoTranasactionId, VehRegNo, vehicleClassId, Convert.ToInt32(Session["LoggedUserId"].ToString())); #endregion //returnMessage.Append("SucessFully Audited and Join Transaction"); //result.Data = returnMessage; result.Data = message; return(Json(result)); }
public ActionResult AssociatedTransaction(string transactionId, string TransactionCategoryId) { DateTime transactiondatetime = DateTime.Now; string strTransactionTime = string.Empty; int ctEntryId = 0; int nffrontEntryId = 0; int nfRearEntryId = 0; string strfilter = " WHERE 1=1 "; strfilter += " AND T.TRANSACTION_ID = " + transactionId; Libraries.CommonLibrary.CBE.TransactionCBE transaction = new Libraries.CommonLibrary.CBE.TransactionCBE(); transaction.TransactionId = Convert.ToInt32(transactionId); //Get TransactionTime from Transaction Id DataTable transactiondata = Libraries.CommonLibrary.BLL.TransactionBLL.GetDataTableFilteredRecords(strfilter); if (transactiondata != null && transactiondata.Rows != null && transactiondata.Rows.Count > 0) { transactiondatetime = Convert.ToDateTime(transactiondata.Rows[0]["TRANSACTION_DATETIME"].ToString()); strTransactionTime = transactiondatetime.ToString("dd/MM/yyyy HH:mm:ss"); ViewBag.TransactionId = transactionId; ViewBag.TransactionTime = strTransactionTime; ViewBag.CrossTalkVRN = transactiondata.Rows[0]["CTP_VRN"].ToString(); ViewBag.Class = transactiondata.Rows[0]["CTP_VEHICLE_CLASS_NAME"].ToString(); ViewBag.NFRear = transactiondata.Rows[0]["REAR_IMAGE"].ToString(); ViewBag.NFFront = transactiondata.Rows[0]["FRONT_IMAGE"].ToString(); ViewBag.NFFrontVideo = transactiondata.Rows[0]["FRONT_VIDEO_URL"].ToString(); ViewBag.NFRearVideo = transactiondata.Rows[0]["REAR_VIDEO_URL"].ToString(); ViewBag.VehicleSpeed = transactiondata.Rows[0]["VEHICLESPEED"].ToString(); //check CT_Entry_ID exists if yes we will not fetch CT_entry_ID associated transaction if (transactiondata.Rows[0]["CT_ENTRY_ID"].ToString() != null && transactiondata.Rows[0]["CT_ENTRY_ID"].ToString() != "") { ctEntryId = Convert.ToInt32(transactiondata.Rows[0]["CT_ENTRY_ID"].ToString()); } //check NFFrontEntryID exists if yes we will not fetch NFFrontEntryID associated transaction if (transactiondata.Rows[0]["NF_ENTRY_ID_FRONT"].ToString() != null && transactiondata.Rows[0]["NF_ENTRY_ID_FRONT"].ToString() != "") { nffrontEntryId = Convert.ToInt32(transactiondata.Rows[0]["NF_ENTRY_ID_FRONT"].ToString()); } //check NFREAREntryID exists if yes we will not fetch NFREAREntryID associated transaction if (transactiondata.Rows[0]["NF_ENTRY_ID_REAR"].ToString() != null && transactiondata.Rows[0]["NF_ENTRY_ID_REAR"].ToString() != "") { nfRearEntryId = Convert.ToInt32(transactiondata.Rows[0]["NF_ENTRY_ID_REAR"].ToString()); } #region Vehicle Class Dropdown List <SelectListItem> vehicleClass = new List <SelectListItem>(); List <VaaaN.MLFF.Libraries.CommonLibrary.CBE.VehicleClassCBE> vehicle = VaaaN.MLFF.Libraries.CommonLibrary.BLL.VehicleClassBLL.GetAll(); vehicleClass.Add(new SelectListItem() { Text = "--Select All--", Value = "0" }); foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.VehicleClassCBE vc in vehicle) { vehicleClass.Add(new SelectListItem() { Text = vc.Name, Value = System.Convert.ToString(vc.Id) }); } ViewBag.AuditorVehicleClass = vehicleClass; #endregion } string strQuery = " WHERE 1=1 "; strQuery += " AND T.TRANSACTION_ID <> " + transactionId; strQuery += " AND TRANSACTION_DATETIME BETWEEN TO_DATE('" + strTransactionTime + "','DD/MM/YYYY HH24:MI:SS') - INTERVAL '1' MINUTE AND TO_DATE('" + strTransactionTime + "','DD/MM/YYYY HH24:MI:SS') + INTERVAL '1' MINUTE"; if (Convert.ToInt32(TransactionCategoryId) == 0) { //Case 1 Cross Talk entry Id Exists and Nodeflux Front Entry Id Exists and Nodeflux Rear Entry Id Exists if (ctEntryId != 0 && nffrontEntryId != 0 && nfRearEntryId == 0) { //Return No Transaction } //Case 2 Cross Talk entry Id Exists and Nodeflux Front Entry Id Exists and Nodeflux Rear Entry Id not Exists else if (ctEntryId != 0 && nffrontEntryId != 0 && nfRearEntryId == 0) { strQuery += " AND T.NF_ENTRY_ID_REAR IS NOT NULL"; } //Case 3 Cross Talk entry Id Exists and Nodeflux Front Entry Id Not Exists and Nodeflux Rear Entry Id Exists else if (ctEntryId != 0 && nffrontEntryId == 0 && nfRearEntryId != 0) { strQuery += " AND T.NF_ENTRY_ID_FRONT IS NOT NULL"; } //Case 4 Cross Talk entry Id Exists and Nodeflux Front Entry Id Not Exists and Nodeflux Rear Entry Id NOT Exists else if (ctEntryId != 0 && nffrontEntryId == 0 && nfRearEntryId == 0) { strQuery += " AND (T.NF_ENTRY_ID_FRONT IS NOT NULL OR T.NF_ENTRY_ID_REAR IS NOT NULL)"; } //Case 5 Cross Talk entry Id Not Exists and Nodeflux Front Entry Id Exists and Nodeflux Rear Entry Id Exists else if (ctEntryId == 0 && nffrontEntryId != 0 && nfRearEntryId != 0) { strQuery += " AND T.CT_ENTRY_ID IS NOT NULL "; } //Case 6 Cross Talk entry Id Not Exists and Nodeflux Front Entry Id Exists and Nodeflux Rear Entry Id NOT Exists else if (ctEntryId == 0 && nffrontEntryId != 0 && nfRearEntryId == 0) { strQuery += " AND (T.CT_ENTRY_ID IS NOT NULL OR T.NF_ENTRY_ID_REAR IS NOT NULL) "; } //Case 7 Cross Talk entry Id Not Exists and Nodeflux Front Entry Id Not Exists and Nodeflux Rear Entry Id Exists else if (ctEntryId == 0 && nffrontEntryId == 0 && nfRearEntryId != 0) { strQuery += " AND (T.CT_ENTRY_ID IS NOT NULL OR T.NF_ENTRY_ID_FRONT IS NOT NULL) "; } } else if (Convert.ToInt32(TransactionCategoryId) == 1) { strQuery += " AND NVL(T.CT_ENTRY_ID,0) = 0 AND ((NVL(T.NF_ENTRY_ID_FRONT, 0) > 0 AND LOWER(NFPF.PLATE_NUMBER)<>'unidentified') OR (NVL(T.NF_ENTRY_ID_REAR, 0) > 0 AND LOWER(NFPR.PLATE_NUMBER) <> 'unidentified')) AND NVL(IS_BALANCE_UPDATED,0) <> 1 "; } else if (Convert.ToInt32(TransactionCategoryId) == 2) { strQuery += " AND NVL(T.CT_ENTRY_ID,0) = 0 AND NVL(T.NF_ENTRY_ID_FRONT, 0)= 0 AND NVL(T.NF_ENTRY_ID_REAR,0)>0 AND LOWER(NFPR.PLATE_NUMBER)<>'unidentified' AND NVL(IS_BALANCE_UPDATED,0) <> 1 "; } else if (Convert.ToInt32(TransactionCategoryId) == 3) { strQuery += " AND NVL(T.CT_ENTRY_ID,0) = 0 AND NVL(T.NF_ENTRY_ID_FRONT,0)>0 AND LOWER(NFPF.PLATE_NUMBER)<>'unidentified' AND NVL(IS_BALANCE_UPDATED,0) <> 1 "; } else if (Convert.ToInt32(TransactionCategoryId) == 4) { strQuery += " AND NVL(T.NF_ENTRY_ID_FRONT,0) = 0 AND (NVL(T.CT_ENTRY_ID,0)>0 OR (NVL(T.NF_ENTRY_ID_REAR,0)>0 AND LOWER(NFPR.PLATE_NUMBER)<>'unidentified')) AND NVL(IS_BALANCE_UPDATED,0) <> 1 "; } else if (Convert.ToInt32(TransactionCategoryId) == 5) { strQuery += " AND NVL(T.NF_ENTRY_ID_REAR,0) = 0 AND (NVL(T.CT_ENTRY_ID,0)>0 OR (NVL(T.NF_ENTRY_ID_FRONT,0)>0 AND LOWER(NFPF.PLATE_NUMBER)<>'unidentified')) AND NVL(IS_BALANCE_UPDATED,0) <> 1 "; } else if (Convert.ToInt32(TransactionCategoryId) == 6) { strQuery += " AND NVL(T.CT_ENTRY_ID,0) > 0 AND NVL(IS_BALANCE_UPDATED,0) <> 1 "; } else if (Convert.ToInt32(TransactionCategoryId) == 7) { strQuery += " AND (LOWER(NFPR.PLATE_NUMBER)='unidentified' OR NVL(T.CT_ENTRY_ID,0) > 0 ) AND NVL(IS_BALANCE_UPDATED,0) <> 1 "; } else if (Convert.ToInt32(TransactionCategoryId) == 8) { strQuery += " AND (LOWER(NFPF.PLATE_NUMBER)='unidentified' OR NVL(T.CT_ENTRY_ID,0) > 0 ) AND NVL(IS_BALANCE_UPDATED,0) <> 1 "; } DataTable dt = new DataTable(); dt = VaaaN.MLFF.Libraries.CommonLibrary.BLL.TransactionBLL.GetDataTableFilteredRecords(strQuery); ViewData["apiPath"] = HelperClass.GetAPIUrl(); return(PartialView("_AssociatedTimeTransaction", dt)); }
public string GetTransactionData(Libraries.CommonLibrary.CBE.TransactionCBE transaction) { string Det = JsonConvert.SerializeObject(VaaaN.MLFF.Libraries.CommonLibrary.BLL.TransactionBLL.Transaction_GetById(transaction), Formatting.Indented); return(Det.Replace("\r", "").Replace("\n", "")); }