public ActionResult Edit(int id)
{
HoldVM obj = new HoldVM();
var item = (from d in db.InScans where d.InScanID == id select d).FirstOrDefault();
if (item == null)
{
return(HttpNotFound());
}
else
{
obj.OriginCountry = (from c in db.CountryMasters where c.CountryID == item.ConsignorCountryID select c.CountryName).FirstOrDefault();
obj.ConsigneeCountry = (from c in db.CountryMasters where c.CountryID == item.ConsigneeCountryID select c.CountryName).FirstOrDefault();
obj.InScanID = item.InScanID;
obj.AWBNo = item.AWBNo;
obj.date = item.InScanDate;
obj.CollectedBy = item.CollectedBy;
obj.Weight = item.Weight;
obj.Pieces = item.Pieces;
obj.CourierCharges = item.CourierCharge;
obj.OriginID = item.ConsigneeCountryID.Value;
obj.Consignee = item.Consignee;
obj.DestinationID = item.ConsigneeCountryID;
obj.StatusPaymentMOde = item.StatusPaymentMode;
obj.Consignor = item.Consignor;
//obj.HeldBy = item.HeldBy;
//obj.HeldOn = item.HeldOn;
obj.HeldResoan = item.HeldReason;
}
return(View(obj));
}
public JsonResult GetAWBData(string id)
{
//Received at Origin Facility
//var l = (from c in db.InScans where c.InScanDate >= s && c.InScanDate <= e select c).ToList();
int courierstatusid = db.CourierStatus.Where(cc => cc.CourierStatus == "Received at Origin Facility").FirstOrDefault().CourierStatusID;
var l = (from c in db.InScanMasters where c.ConsignmentNo == id && c.DRSID == null && c.CourierStatusID == courierstatusid select c).FirstOrDefault();
if (l != null)
{
HoldVM obj = new HoldVM();
if (l != null)
{
obj.AWBNo = l.ConsignmentNo;
obj.InScanID = l.InScanID;
obj.Consignor = l.Consignor;
obj.Consignee = l.Consignee;
obj.CollectedBy = l.PickedUpEmpID;
obj.date = l.TransactionDate;
obj.Weight = l.Weight;
obj.Pieces = l.Pieces;
obj.OriginCountry = l.ConsignorCountryName;
obj.CourierCharges = 0;
obj.StatusPaymentMOde = db.tblPaymentModes.Find(l.PaymentModeId).PaymentModeText;
obj.CollectedByName = db.EmployeeMasters.Find(l.PickedUpEmpID).EmployeeName;
obj.ConsigneeCountry = l.ConsigneeCountryName.ToString();
}
return(Json(new { status = "ok", data = obj, message = "Data Found" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = "failed", data = l, message = "Data Not Found" }, JsonRequestBehavior.AllowGet));
}
//return Json(obj, JsonRequestBehavior.AllowGet);
}
public ActionResult Create(int id = 0)
{
ViewBag.HeldBy = db.EmployeeMasters.ToList();
HoldVM vm = new HoldVM();
if (id > 0)
{
vm = (from c in db.InScanMasters
join p in db.tblPaymentModes on c.PaymentModeId equals p.ID
join cs in db.CourierStatus on c.CourierStatusID equals cs.CourierStatusID
join hr in db.HoldReleases on c.InScanID equals hr.InScanId
join em in db.EmployeeMasters on c.PickedUpEmpID equals em.EmployeeID
where c.InScanID == id
select new HoldVM
{
InScanID = c.InScanID,
AWBNo = c.ConsignmentNo,
date = hr.EntryDate,
TransactionnDate = c.TransactionDate,
CollectedByName = em.EmployeeName,
Consignor = c.Consignor,
OriginCountry = c.ConsignorCountryName,
CourierStatus = cs.CourierStatus,
Weight = c.Weight,
Pieces = c.Pieces,
CourierCharges = 0,
Consignee = c.Consignee,
ConsigneeCountry = c.ConsigneeCountryName,
StatusPaymentMOde = p.PaymentModeText
}).FirstOrDefault();
vm.Action = "Edit";
if (vm.CourierStatus == "OnHold")
{
vm.ActionType = "Hold";
var releasedata = db.HoldReleases.Where(cc => cc.InScanId == id && cc.ActionType == "Hold").FirstOrDefault();
if (releasedata != null)
{
vm.HeldOn = releasedata.EntryDate;
vm.HeldBy = releasedata.EmployeeId;
vm.HeldResoan = releasedata.Remarks;
}
ViewBag.Title = "AWB Hold - Modify";
}
else
{
vm.ActionType = "Release";
var releasedata = db.HoldReleases.Where(cc => cc.InScanId == id && cc.ActionType == "Release").FirstOrDefault();
if (releasedata != null)
{
vm.HeldOn = releasedata.EntryDate;
vm.HeldBy = releasedata.EmployeeId;
vm.HeldResoan = releasedata.Remarks;
}
ViewBag.Title = "Air WayBill Released - Modify";
}
}
else
{
vm.Action = "Create";
vm.InScanID = 0;
ViewBag.Title = "Air WayBill Hold - Create";
}
return(View(vm));
}
public ActionResult Create(HoldVM item)
{
int branchid = Convert.ToInt32(Session["CurrentBranchID"].ToString());
int UserId = Convert.ToInt32(Session["UserID"].ToString());
if (item.Action == "Create")
{
var inscan = db.InScanMasters.Where(itm => itm.InScanID == item.InScanID).FirstOrDefault();
HoldRelease v = new HoldRelease();
v.InScanId = item.InScanID;
v.EntryDate = item.HeldOn;
v.EmployeeId = item.HeldBy;
v.Remarks = item.HeldResoan;
v.ActionType = "Hold";
v.BranchId = branchid;
db.HoldReleases.Add(v);
db.SaveChanges();
//updating status to inscan
inscan.StatusTypeId = db.tblStatusTypes.Where(cc => cc.Name == "HOLD").First().ID;
inscan.CourierStatusID = db.CourierStatus.Where(cc => cc.StatusTypeID == inscan.StatusTypeId && cc.CourierStatus == "OnHold").FirstOrDefault().CourierStatusID;
// db.Entry(obj).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();
TempData["SuccessMsg"] = "You have successfully added AWB to Hold Status";
}
else
{
HoldRelease v = db.HoldReleases.Where(cc => cc.InScanId == item.InScanID && cc.ActionType == item.ActionType).First();
v.EntryDate = item.HeldOn;
v.EmployeeId = item.HeldBy;
v.Remarks = item.HeldResoan;
db.Entry(v).State = EntityState.Modified;
db.SaveChanges();
TempData["SuccessMsg"] = "You have successfully Updated AWB to " + item.ActionType + " Entry";
}
return(RedirectToAction("Index"));
}
