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);
}
}
