public JsonResult GetAWB(int id) { List <InBoundAWBList> obj = new List <InBoundAWBList>(); QuickInscanMaster _qinscanvm = db.QuickInscanMasters.Where(cc => cc.QuickInscanID == id).FirstOrDefault(); //InScanVM _qinscanvm = new InScanVM(); //_qinscanvm = (from _qmaster in db.QuickInscanMasters // where _qmaster.InscanSheetNumber == id // select new InScanVM { QuickInscanID=_qmaster.QuickInscanID,QuickInscanDateTime=_qmaster.QuickInscanDateTime,BranchId=_qmaster.BranchId,DepotID=_qmaster.DepotId,VehicleId=_qmaster.VehicleId,DriverName = _qmaster.DriverName });.first if (_qinscanvm != null) { obj = (from _qmaster in db.QuickInscanMasters join _shipdetail in db.ImportShipmentDetails on _qmaster.QuickInscanID equals _shipdetail.QuickInscanID join _shipment in db.ImportShipments on _shipdetail.ImportID equals _shipment.ID where _qmaster.QuickInscanID == id orderby _shipdetail.AWB descending select new InBoundAWBList { ShipmentDetailID = _shipdetail.ShipmentDetailID, AWB = _shipdetail.AWB, OriginCity = _shipment.ConsignorCityName, OriginCountry = _shipment.ConsignorCountryName, DestinationCity = _shipdetail.DestinationCity, DestinationCountry = _shipdetail.DestinationCountry, Shipper = _shipdetail.Shipper, Receiver = _shipdetail.Reciver }).ToList(); return(Json(new { status = "ok", masterdata = _qinscanvm, data = obj, message = "Data Found" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = "failed", masterdata = _qinscanvm, data = obj, message = "Data Not Found" }, JsonRequestBehavior.AllowGet)); } //List<AWBList> obj = new List<AWBList>(); //var lst = (from c in db.CustomerEnquiries where c.CollectedEmpID == id select c).ToList(); //foreach (var item in lst) //{ // obj.Add(new AWBList { AWB=item.AWBNo}); //} //return Json(obj, JsonRequestBehavior.AllowGet); }
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); } }