public ActionResult DeleteFuelRecordByID(int id) { FuelRecord_DetailRepo fuelrecord = new FuelRecord_DetailRepo(); var model = fuelrecord.deleteFuelRecord(id); return(Json(model, JsonRequestBehavior.AllowGet)); }
public ActionResult CreateFuelRecord(FuelRecordDto fuel) { var obj = new FuelRecordRepo(); int statusLst = 0; if (fuel.Id > 0) { if (obj.updateFuelRecord(fuel)) { statusLst = fuel.Id; } } else { statusLst = obj.InsertFuelRecord(fuel); } if (statusLst != 0) { FuelRecord_DetailRepo objDetail = new FuelRecord_DetailRepo(); bool result = objDetail.InsertFuelRecordDetail((TempData.Peek("lstFuelRecod") as List <FuelRecord_DetailDto>), statusLst); TempData.Remove("lstFuelRecod"); return(Json("Record saved successfully.")); } else { return(Json("Something went wrong.")); } }
public ActionResult CreateFuelManualRecord(FuelRecord_DetailDto model) { var obj = new FuelRecord_DetailRepo(); List <FuelRecord_DetailDto> lstfuelRecordManuals = new List <FuelRecord_DetailDto>(); if (TempData.ContainsKey("lstFuelRecod")) { lstfuelRecordManuals = (TempData.Peek("lstFuelRecod") as List <FuelRecord_DetailDto>); } if (model.FuelRecord_DetailId > 0) { obj.updateFuelRecordManual(model); lstfuelRecordManuals = obj.getFuelDetails(model.FuelRecordId); return(Json(new { msg = "Record added successfully", Html = lstfuelRecordManuals }, JsonRequestBehavior.AllowGet)); } else if (model.FuelRecordId > 0 && model.FuelRecord_DetailId == 0) { List <FuelRecord_DetailDto> lstNewRecords = new List <FuelRecord_DetailDto>(); lstNewRecords.Add(model); obj.InsertFuelRecordDetail(lstNewRecords, model.FuelRecordId); lstfuelRecordManuals = obj.getFuelDetails(model.FuelRecordId); return(Json(new { msg = "Record added successfully", Html = lstfuelRecordManuals }, JsonRequestBehavior.AllowGet)); } else { lstfuelRecordManuals.Add(model); } TempData["lstFuelRecod"] = lstfuelRecordManuals; TempData.Keep("lstFuelRecod"); return(Json(new { msg = "Record added successfully", Html = lstfuelRecordManuals }, JsonRequestBehavior.AllowGet)); }
public ActionResult DisplayFileData() { ListFuelRecord = new List <FuelRecord_DetailDto>(); Regex decimalRegex = new Regex(@"^[0-9]*(\.[0-9]{1,2})?$"); int id = Convert.ToInt32(((System.Web.HttpRequestWrapper)Request).Form[0]); if (Path.GetExtension(Request.Files[0].FileName) == ".xlsx") { string validationMsg = string.Empty; int chkInt = 0; double chkDouble; DateTime chkDate; using (var package = new ExcelPackage(Request.Files[0].InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfCol = workSheet.Dimension.End.Column; var noOfRow = workSheet.Dimension.End.Row; if (noOfRow >= 2) { int rowid = 1; FuelRecordRepo objRecord = new FuelRecordRepo(); var fillingStation = objRecord.GetFillingStation(); var registationNumber = objRecord.GetRegistrationNo(); for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++) { if (workSheet.Cells[rowIterator, 1].Value == null && workSheet.Cells[rowIterator, 2].Value == null && workSheet.Cells[rowIterator, 3].Value == null && workSheet.Cells[rowIterator, 4].Value == null && workSheet.Cells[rowIterator, 5].Value == null && workSheet.Cells[rowIterator, 6].Value == null && workSheet.Cells[rowIterator, 7].Value == null && workSheet.Cells[rowIterator, 8].Value == null && workSheet.Cells[rowIterator, 9].Value == null && workSheet.Cells[rowIterator, 10].Value == null && workSheet.Cells[rowIterator, 11].Value == null && workSheet.Cells[rowIterator, 12].Value == null && workSheet.Cells[rowIterator, 13].Value == null && workSheet.Cells[rowIterator, 14].Value == null && workSheet.Cells[rowIterator, 15].Value == null ) { continue; } FuelRecord_DetailDto model = new FuelRecord_DetailDto(); if (workSheet.Cells[rowIterator, 1].Value != null) { if (DateTime.TryParse(workSheet.Cells[rowIterator, 1].Value.ToString(), out chkDate)) { model.Date = chkDate; } else { validationMsg = "Invalid Date format in excel sheet."; break; } if (DateTime.TryParse(workSheet.Cells[rowIterator, 1].Value.ToString(), out chkDate)) { model.Date = chkDate; } else { validationMsg = "Invalid Date format in excel sheet."; break; } double d; if (double.TryParse(workSheet.Cells[rowIterator, 1].Value.ToString(), out d)) { model.Date = DateTime.FromOADate(d); //model.Period = DateTime.FromOADate(d); //model.PeriodTo = DateTime.FromOADate(d); } else { model.Date = Convert.ToDateTime(workSheet.Cells[rowIterator, 1].Value); //model.PeriodFrom = Convert.ToDateTime(workSheet.Cells[rowIterator, 1].Value); //model.PeriodTo = Convert.ToDateTime(workSheet.Cells[rowIterator, 1].Value); //model.Date = DateTime.ParseExact(workSheet.Cells[rowIterator, 1].Value.ToString(), @"dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); } } else { validationMsg = "Date is required in excel sheet"; break; } if (workSheet.Cells[rowIterator, 2].Value != null) { if (DateTime.TryParse(workSheet.Cells[rowIterator, 2].Value.ToString(), out chkDate)) { model.DateCreated = chkDate; } else { validationMsg = "Invalid Created Date format in excel sheet."; break; } if (DateTime.TryParse(workSheet.Cells[rowIterator, 2].Value.ToString(), out chkDate)) { model.DateCreated = chkDate; } else { validationMsg = "Invalid Created Date format in excel sheet."; break; } double d; if (double.TryParse(workSheet.Cells[rowIterator, 2].Value.ToString(), out d)) { model.DateCreated = DateTime.FromOADate(d); } else { model.DateCreated = Convert.ToDateTime(workSheet.Cells[rowIterator, 2].Value); //model.Date = DateTime.ParseExact(workSheet.Cells[rowIterator, 1].Value.ToString(), @"dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); } } else { validationMsg = "Created Date is required in excel sheet"; break; } if (workSheet.Cells[rowIterator, 3].Value != null) { model.VoucherNumber = Convert.ToString(workSheet.Cells[rowIterator, 3].Value); } else { validationMsg = "Voucher Number is required in excel sheet"; break; } if (workSheet.Cells[rowIterator, 4].Value != null) { model.CostCentreLocation = Convert.ToString(workSheet.Cells[rowIterator, 4].Value); } else { validationMsg = "Cost Center Location is required in excel sheet"; break; } if (workSheet.Cells[rowIterator, 5].Value != null) { model.RegistrationNo = Convert.ToString(workSheet.Cells[rowIterator, 5].Value); if (!registationNumber.Any(x => x.Value.Trim().ToLower() == model.RegistrationNo.Trim().ToLower())) { validationMsg = "Registration No. " + model.RegistrationNo + " Does not exists in database"; break; } else { model.RegistrationNo = registationNumber.Where(x => x.Value.Trim().ToLower() == model.RegistrationNo.Trim().ToLower()).FirstOrDefault().Key.ToString(); } } else { validationMsg = "Registration No. is required in excel sheet"; break; } model.FillingStation = Convert.ToString(workSheet.Cells[rowIterator, 6].Value); if (!string.IsNullOrEmpty(model.FillingStation) && !fillingStation.Any(x => x.Value.Trim().ToLower() == model.FillingStation.Trim().ToLower())) { validationMsg = "Filling Station " + model.FillingStation + " Does not exists in database"; break; } else { model.FillingStation = fillingStation.Where(x => x.Value.Trim().ToLower() == model.FillingStation.Trim().ToLower()).FirstOrDefault().Key.ToString(); } model.Driver = Convert.ToString(workSheet.Cells[rowIterator, 7].Value); if (workSheet.Cells[rowIterator, 8].Value != null) { model.FuelType = workSheet.Cells[rowIterator, 8].Value.ToString(); } else { validationMsg = "Fuel Type is required in excel sheet"; break; } if (workSheet.Cells[rowIterator, 9].Value != null) { if (int.TryParse(workSheet.Cells[rowIterator, 9].Value.ToString(), out chkInt)) { model.QuantityLitres = chkInt; } else { validationMsg = "Invalid Number format for Quantity Litres in excel sheet."; break; } } else { validationMsg = "Quantity Litres is required in excel sheet"; break; } if (workSheet.Cells[rowIterator, 10].Value != null && int.TryParse(workSheet.Cells[rowIterator, 10].Value.ToString(), out chkInt)) { model.ActualMilage = chkInt; } else { validationMsg = "Invalid Number format for Actual Milage in excel sheet."; break; } if (workSheet.Cells[rowIterator, 11].Value != null && int.TryParse(workSheet.Cells[rowIterator, 11].Value.ToString(), out chkInt)) { model.CurrentMilage = chkInt; } else { validationMsg = "Invalid Number format for Current Milage in excel sheet."; break; } if (workSheet.Cells[rowIterator, 12].Value != null && double.TryParse(workSheet.Cells[rowIterator, 12].Value.ToString(), out chkDouble) && decimalRegex.IsMatch(workSheet.Cells[rowIterator, 12].Value.ToString())) { model.AmountExVal = chkDouble; } else { validationMsg = "Invalid Number format for Amount (Excl. Vat) in excel sheet."; break; } if (workSheet.Cells[rowIterator, 13].Value != null && int.TryParse(workSheet.Cells[rowIterator, 13].Value.ToString(), out chkInt)) { if (chkInt > 100) { validationMsg = "Discount (%) must be less than 100%"; break; } model.DiscountAmount = chkInt; } else { validationMsg = "Invalid Number format for Discount (%) in excel sheet."; break; } if (workSheet.Cells[rowIterator, 14].Value != null && double.TryParse(workSheet.Cells[rowIterator, 14].Value.ToString(), out chkDouble) && decimalRegex.IsMatch(workSheet.Cells[rowIterator, 14].Value.ToString())) { model.VatAmount = chkDouble; } else { validationMsg = "Invalid Number format for Vat Amount in excel sheet."; break; } if (workSheet.Cells[rowIterator, 15].Value != null && double.TryParse(workSheet.Cells[rowIterator, 15].Value.ToString(), out chkDouble) && decimalRegex.IsMatch(workSheet.Cells[rowIterator, 15].Value.ToString())) { model.AmountInVal = chkDouble; } else { validationMsg = "Invalid Number format for Amount inc. vat (Rs) in excel sheet."; break; } if (id == 0) { model.FuelRecord_DetailId = rowid; rowid++; } ListFuelRecord.Add(model); } if (!string.IsNullOrEmpty(validationMsg)) { return(Json(new { msg = validationMsg, Html = ListFuelRecord }, JsonRequestBehavior.AllowGet)); } if (id > 0) { var obj = new FuelRecord_DetailRepo(); obj.InsertFuelRecordDetail(ListFuelRecord, id); ListFuelRecord = obj.getFuelDetails(id); return(Json(new { msg = validationMsg, Html = ListFuelRecord }, JsonRequestBehavior.AllowGet)); } else { if (TempData.ContainsKey("lstFuelRecod")) { ListFuelRecord.AddRange((TempData.Peek("lstFuelRecod") as List <FuelRecord_DetailDto>)); } TempData["lstFuelRecod"] = ListFuelRecord; TempData.Keep("lstFuelRecod"); return(Json(new { msg = validationMsg, Html = ListFuelRecord }, JsonRequestBehavior.AllowGet)); } } else { validationMsg = "Excel File can not bt empty."; } return(Json(new { msg = "Please upload Excel Files only", Html = ListFuelRecord }, JsonRequestBehavior.AllowGet)); } } else { return(Json(new { msg = "Please upload Excel Files only", Html = ListFuelRecord }, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetFuelManualDetails(int fuelmanagemaualbyid) { var obj = new FuelRecord_DetailRepo(); return(Json(new { msg = "Record added successfully", Html = obj.getFuelDetailsByid(fuelmanagemaualbyid) }, JsonRequestBehavior.AllowGet)); }