public ActionResult Create(InScanVM v) { try { return(View()); } catch { return(View()); } }
public ActionResult Create(int id = 0) { int BranchId = Convert.ToInt32(Session["CurrentBranchID"].ToString()); int depotid = Convert.ToInt32(Session["CurrentDepotID"].ToString()); int companyid = Convert.ToInt32(Session["CurrentCompanyID"].ToString()); //ViewBag.depot = db.tblDepots.ToList(); ViewBag.depot = (from c in db.tblDepots where c.BranchID == BranchId select c).ToList(); ViewBag.employee = db.EmployeeMasters.ToList(); ViewBag.employeerec = db.EmployeeMasters.ToList(); ViewBag.Vehicles = db.VehicleMasters.ToList(); ViewBag.Agents = db.AgentMasters.ToList(); ViewBag.CourierService = db.CourierServices.ToList(); if (id == 0) { ViewBag.Title = "InScan Import -Create"; InScanVM vm = new InScanVM(); vm.QuickInscanID = 0; PickupRequestDAO _dao = new PickupRequestDAO(); vm.InScanSheetNo = _dao.GetMaxInScanSheetNo(companyid, BranchId, "Import"); vm.DepotID = depotid; ViewBag.EditMode = "false"; return(View(vm)); } else { QuickInscanMaster qvm = db.QuickInscanMasters.Find(id); InScanVM vm = new InScanVM(); vm.QuickInscanID = qvm.QuickInscanID; vm.AgentID = Convert.ToInt32(qvm.AgentID); vm.ReceivedByID = Convert.ToInt32(qvm.ReceivedByID); vm.DriverName = qvm.DriverName; vm.InScanSheetNo = qvm.InscanSheetNumber; vm.VehicleId = Convert.ToInt32(qvm.VehicleId); vm.DepotID = Convert.ToInt32(qvm.DepotId); vm.BranchId = Convert.ToInt32(qvm.BranchId); ViewBag.EditMode = "true"; ViewBag.Title = "InScan Import - Modify"; return(View(vm)); } }
public JsonResult SaveQuickInScan(InScanVM v) { //InScan inscan = new InScan(); int UserId = Convert.ToInt32(Session["UserID"].ToString()); int BranchId = Convert.ToInt32(Session["CurrentBranchID"].ToString()); int CompanyId = Convert.ToInt32(Session["CurrentCompanyID"].ToString()); int yearid = Convert.ToInt32(Session["fyearid"].ToString()); var inscanitems = v.SelectedInScanId.Split(','); try { QuickInscanMaster _qinscan = new QuickInscanMaster(); if (v.QuickInscanID > 0) { _qinscan = db.QuickInscanMasters.Find(v.QuickInscanID); } else { int?maxid = (from c in db.QuickInscanMasters orderby c.QuickInscanID descending select c.QuickInscanID).FirstOrDefault(); if (maxid == null) { _qinscan.QuickInscanID = 1; } else { _qinscan.QuickInscanID = Convert.ToInt32(maxid) + 1; } _qinscan.AcFinancialYearID = yearid; } _qinscan.InscanSheetNumber = v.InScanSheetNo; _qinscan.AcCompanyId = CompanyId; _qinscan.ReceivedByID = v.ReceivedByID; _qinscan.CollectedByID = v.CollectedByID; _qinscan.QuickInscanDateTime = v.QuickInscanDateTime; _qinscan.VehicleId = v.VehicleId; _qinscan.DriverName = v.DriverName; _qinscan.BranchId = BranchId; _qinscan.DepotId = v.DepotID; _qinscan.UserId = UserId; _qinscan.Source = "Inhouse"; if (v.QuickInscanID > 0) { db.Entry(_qinscan).State = EntityState.Modified; var removeinscanitems = v.RemovedInScanId.Split(','); foreach (var _item in removeinscanitems) { int _inscanid = Convert.ToInt32(_item); var _inscan = db.InScanMasters.Find(_inscanid); _inscan.QuickInscanID = null; _inscan.PickedUpEmpID = null; _inscan.DepotReceivedBy = null; //_inscan.TransactionDate = v.QuickInscanDateTime; //_inscan.VehicleID = null; _inscan.StatusTypeId = db.tblStatusTypes.Where(cc => cc.Name == "PICKUP REQUEST").First().ID; _inscan.CourierStatusID = db.CourierStatus.Where(cc => cc.StatusTypeID == _inscan.StatusTypeId && cc.CourierStatus == "Assigned For Collections").FirstOrDefault().CourierStatusID; db.Entry(_inscan).State = EntityState.Modified; db.SaveChanges(); //updateing awbstaus table for tracking AWBTrackStatu _awbstatus = new AWBTrackStatu(); int? id = (from c in db.AWBTrackStatus orderby c.AWBTrackStatusId descending select c.AWBTrackStatusId).FirstOrDefault(); if (id == null) { id = 1; } else { id = id + 1; } _awbstatus.AWBTrackStatusId = Convert.ToInt32(id); _awbstatus.AWBNo = _inscan.ConsignmentNo; _awbstatus.EntryDate = DateTime.Now; _awbstatus.InScanId = _inscan.InScanID; _awbstatus.StatusTypeId = Convert.ToInt32(_inscan.StatusTypeId); _awbstatus.CourierStatusId = Convert.ToInt32(_inscan.CourierStatusID); _awbstatus.ShipmentStatus = db.tblStatusTypes.Find(_inscan.StatusTypeId).Name; _awbstatus.CourierStatus = db.CourierStatus.Find(_inscan.CourierStatusID).CourierStatus; _awbstatus.UserId = UserId; db.AWBTrackStatus.Add(_awbstatus); db.SaveChanges(); } } else { db.QuickInscanMasters.Add(_qinscan); db.SaveChanges(); } foreach (var item in inscanitems) { int _inscanid = Convert.ToInt32(item); InScanMaster _inscan = db.InScanMasters.Find(_inscanid); _inscan.QuickInscanID = _qinscan.QuickInscanID; _inscan.PickedUpEmpID = v.CollectedByID; _inscan.DepotReceivedBy = v.ReceivedByID; //_inscan.TransactionDate = v.QuickInscanDateTime; //_inscan.VehicleID = v.VehicleId; _inscan.StatusTypeId = db.tblStatusTypes.Where(cc => cc.Name == "INSCAN").First().ID; _inscan.CourierStatusID = db.CourierStatus.Where(cc => cc.StatusTypeID == _inscan.StatusTypeId && cc.CourierStatus == "Received at Origin Facility").FirstOrDefault().CourierStatusID; db.Entry(_inscan).State = EntityState.Modified; db.SaveChanges(); } //TempData["SuccessMsg"] = "You have successfully Saved InScan Items."; return(Json(new { status = "ok", message = "You have successfully Saved InScan Items.!" }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { status = "Failed", message = ex.Message }, JsonRequestBehavior.AllowGet)); //return Json("Failed", JsonRequestBehavior.AllowGet); } }
public ActionResult Create(InScanVM v) { //InScan inscan = new InScan(); int UserId = Convert.ToInt32(Session["UserID"].ToString()); int BranchId = Convert.ToInt32(Session["CurrentBranchID"].ToString()); int CompanyId = Convert.ToInt32(Session["CurrentCompanyID"].ToString()); int yearid = Convert.ToInt32(Session["fyearid"].ToString()); var inscanitems = v.SelectedInScanId.Split(','); try { QuickInscanMaster _qinscan = new QuickInscanMaster(); if (v.QuickInscanID > 0) { _qinscan = db.QuickInscanMasters.Find(v.QuickInscanID); } else { int?maxid = (from c in db.QuickInscanMasters orderby c.QuickInscanID descending select c.QuickInscanID).FirstOrDefault(); if (maxid == null) { _qinscan.QuickInscanID = 1; } else { _qinscan.QuickInscanID = Convert.ToInt32(maxid) + 1; } _qinscan.AcFinancialYearID = yearid; } _qinscan.InscanSheetNumber = v.InScanSheetNo; _qinscan.AcCompanyId = CompanyId; _qinscan.ReceivedByID = v.ReceivedByID; _qinscan.AgentID = v.AgentID; //_qinscan.CollectedByID = v.CollectedByID; _qinscan.QuickInscanDateTime = v.QuickInscanDateTime; _qinscan.VehicleId = v.VehicleId; _qinscan.DriverName = v.DriverName; _qinscan.BranchId = BranchId; _qinscan.DepotId = v.DepotID; _qinscan.UserId = UserId; _qinscan.Source = "Import"; if (v.QuickInscanID > 0) { db.Entry(_qinscan).State = EntityState.Modified; if (v.RemovedInScanId != null) { var removeinscanitems = v.RemovedInScanId.Split(','); foreach (var _item in removeinscanitems) { int _inscanid = Convert.ToInt32(_item); var _inscan = db.ImportShipmentDetails.Find(_inscanid); _inscan.QuickInscanID = null; var couriercstatus = db.CourierStatus.Where(c => c.CourierStatus == "Export Manifest Prepared").FirstOrDefault(); if (couriercstatus != null) { _inscan.CourierStatusID = couriercstatus.CourierStatusID; } var statustype = db.tblStatusTypes.Where(c => c.Name == "READY TO EXPORT").FirstOrDefault(); if (statustype != null) { _inscan.StatusTypeId = statustype.ID; } db.Entry(_inscan).State = EntityState.Modified; db.SaveChanges(); //updateing awbstaus table for tracking AWBTrackStatu _awbstatus = new AWBTrackStatu(); int? id = (from c in db.AWBTrackStatus orderby c.AWBTrackStatusId descending select c.AWBTrackStatusId).FirstOrDefault(); if (id == null) { id = 1; } else { id = id + 1; } _awbstatus.AWBTrackStatusId = Convert.ToInt32(id); _awbstatus.AWBNo = _inscan.HAWB; _awbstatus.EntryDate = DateTime.Now; _awbstatus.ShipmentDetailID = _inscan.ShipmentDetailID; _awbstatus.StatusTypeId = Convert.ToInt32(_inscan.StatusTypeId); _awbstatus.CourierStatusId = Convert.ToInt32(_inscan.CourierStatusID); _awbstatus.ShipmentStatus = db.tblStatusTypes.Find(_inscan.StatusTypeId).Name; _awbstatus.CourierStatus = db.CourierStatus.Find(_inscan.CourierStatusID).CourierStatus; _awbstatus.UserId = UserId; db.AWBTrackStatus.Add(_awbstatus); db.SaveChanges(); } } } else { db.QuickInscanMasters.Add(_qinscan); db.SaveChanges(); } if (v.SelectedInScanId != null) { foreach (var item in inscanitems) { int _inscanid = Convert.ToInt32(item); ImportShipmentDetail _inscan = db.ImportShipmentDetails.Find(_inscanid); _inscan.QuickInscanID = _qinscan.QuickInscanID; _inscan.StatusTypeId = db.tblStatusTypes.Where(cc => cc.Name == "INSCAN").First().ID; _inscan.CourierStatusID = db.CourierStatus.Where(cc => cc.StatusTypeID == _inscan.StatusTypeId && cc.CourierStatus == "Received at Origin Facility").FirstOrDefault().CourierStatusID; db.Entry(_inscan).State = EntityState.Modified; db.SaveChanges(); //updateing awbstaus table for tracking AWBTrackStatu _awbstatus = new AWBTrackStatu(); int? id = (from c in db.AWBTrackStatus orderby c.AWBTrackStatusId descending select c.AWBTrackStatusId).FirstOrDefault(); if (id == null) { id = 1; } else { id = id + 1; } _awbstatus.AWBTrackStatusId = Convert.ToInt32(id); _awbstatus.AWBNo = _inscan.HAWB; _awbstatus.EntryDate = DateTime.Now; _awbstatus.ShipmentDetailID = _inscan.ShipmentDetailID; _awbstatus.StatusTypeId = Convert.ToInt32(_inscan.StatusTypeId); _awbstatus.CourierStatusId = Convert.ToInt32(_inscan.CourierStatusID); _awbstatus.ShipmentStatus = db.tblStatusTypes.Find(_inscan.StatusTypeId).Name; _awbstatus.CourierStatus = db.CourierStatus.Find(_inscan.CourierStatusID).CourierStatus; _awbstatus.UserId = UserId; db.AWBTrackStatus.Add(_awbstatus); db.SaveChanges(); } } TempData["SuccessMsg"] = "You have successfully Saved InScan Import Items."; return(RedirectToAction("Index")); // return Json(new { status = "ok", message = "You have successfully Saved InScan Items.!" }, JsonRequestBehavior.AllowGet); } catch (Exception ex) { TempData["WarningMsg"] = ex.Message; ViewBag.depot = (from c in db.tblDepots where c.BranchID == BranchId select c).ToList(); ViewBag.employee = db.EmployeeMasters.ToList(); ViewBag.employeerec = db.EmployeeMasters.ToList(); ViewBag.Vehicles = db.VehicleMasters.ToList(); ViewBag.Agents = db.AgentMasters.ToList(); ViewBag.CourierService = db.CourierServices.ToList(); return(View(v)); //return Json(new { status = "Failed", message = ex.Message }, JsonRequestBehavior.AllowGet); //return Json("Failed", JsonRequestBehavior.AllowGet); } }