public ActionResult Edit(int id)
{
ViewBag.Deliverdby = db.EmployeeMasters.ToList();
ViewBag.vehicle = db.VehicleMasters.ToList();
ViewBag.CheckedBy = db.EmployeeMasters.ToList();
DR d = db.DRS.Find(id);
DRSVM v = new DRSVM();
if (d == null)
{
return(HttpNotFound());
}
else
{
v.DRSID = d.DRSID;
v.DRSNo = d.DRSNo;
v.DRSDate = d.DRSDate;
v.DeliveredBy = d.DeliveredBy;
v.CheckedBy = d.CheckedBy;
v.TotalAmountCollected = d.TotalAmountCollected;
v.VehicleID = d.VehicleID;
v.StatusDRS = d.StatusDRS;
v.AcCompanyID = d.AcCompanyID;
v.StatusInbound = d.StatusInbound;
v.DrsType = d.DrsType;
}
return(View(v));
}
public ActionResult Create(int id = 0)
{
int BranchId = Convert.ToInt32(Session["CurrentBranchID"].ToString());
int CompanyId = Convert.ToInt32(Session["CurrentCompanyID"].ToString());
ViewBag.Deliverdby = db.EmployeeMasters.ToList();
ViewBag.vehicle = db.VehicleMasters.ToList();
ViewBag.Checkedby = db.EmployeeMasters.ToList();
DRSVM v = new DRSVM();
if (id > 0)
{
DR d = db.DRS.Find(id);
v.DRSID = d.DRSID;
v.DRSNo = d.DRSNo;
v.DRSDate = d.DRSDate;
v.DeliveredBy = d.DeliveredBy;
v.CheckedBy = d.CheckedBy;
v.TotalAmountCollected = d.TotalAmountCollected;
v.VehicleID = d.VehicleID;
v.StatusDRS = d.StatusDRS;
v.AcCompanyID = d.AcCompanyID;
v.StatusInbound = d.StatusInbound;
v.DrsType = d.DrsType;
ViewBag.EditMode = "true";
ViewBag.Title = "OutScan - Modify";
}
else
{
PickupRequestDAO _dao = new PickupRequestDAO();
v.DRSID = 0;
v.DRSNo = _dao.GetMaxDRSNo(CompanyId, BranchId);
ViewBag.EditMode = "false";
ViewBag.Title = "OutScan - Create";
}
return(View(v));
}
public ActionResult Edit(DRSVM v)
{
int UserId = Convert.ToInt32(Session["UserID"].ToString());
int BranchId = Convert.ToInt32(Session["CurrentBranchID"].ToString());
int CompanyId = Convert.ToInt32(Session["CurrentCompanyID"].ToString());
try
{
//var data = (from c in db.DRSDetails where c.DRSID == v.DRSID select c).ToList();
//foreach (var item in data)
//{
// db.DRSDetails.Remove(item);
// db.SaveChanges();
//}
var data = (from c in db.InScanMasters where c.DRSID == v.DRSID select c).ToList();
foreach (var item in data)
{
var _inscan = db.InScanMasters.Find(item.InScanID);
_inscan.DRSID = null;
db.Entry(_inscan).State = EntityState.Modified;
db.SaveChanges();
var awbtrack = db.AWBTrackStatus.Where(cc => cc.InScanId == item.InScanID && cc.ShipmentStatus == "OUTSCAN" && cc.CourierStatus == "Out for Delivery at Origin").First();
db.AWBTrackStatus.Remove(awbtrack);
db.SaveChanges();
}
DR objdrs = db.DRS.Find(v.DRSID);
//objdrs.DRSNo = objdrs.DRSID.ToString();
objdrs.DRSDate = v.DRSDate;
objdrs.DeliveredBy = v.DeliveredBy;
objdrs.CheckedBy = v.CheckedBy;
objdrs.TotalAmountCollected = 0;
objdrs.VehicleID = v.VehicleID;
objdrs.StatusDRS = "0";
objdrs.AcCompanyID = Convert.ToInt32(Session["CurrentCompanyID"].ToString());
objdrs.StatusInbound = false;
objdrs.DrsType = "Courier";
db.Entry(objdrs).State = EntityState.Modified;
db.SaveChanges();
foreach (var item in v.lst)
{
var _inscan = db.InScanMasters.Find(item.InScanID);
_inscan.DRSID = objdrs.DRSID;
_inscan.StatusTypeId = db.tblStatusTypes.Where(cc => cc.Name == "OUTSCAN").First().ID;
_inscan.CourierStatusID = db.CourierStatus.Where(cc => cc.StatusTypeID == _inscan.StatusTypeId && cc.CourierStatus == "Out for Delivery at Origin").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();
}
//foreach (var item in v.lst)
//{
// DRSDetail d = new DRSDetail();
// d.DRSID = objdrs.DRSID;
// d.AWBNO = item.AWB;
// d.InScanID = item.InScanID;
// d.CourierCharge = item.COD;
// d.MaterialCost = 0;
// d.StatusPaymentMode = "PKP";
// d.CCReceived = 0;
// d.CCStatuspaymentType = "CS";
// d.MCReceived = 0;
// d.MCStatuspaymentType = "CS";
// d.Remarks = "";
// d.ReceiverName = item.Consignee;
// d.CourierStatusID = 9;
// d.StatusAWB = "DD";
// d.EmployeeID = Convert.ToInt32(Session["UserID"].ToString());
// d.ReturnTime = DateTime.Now;
// db.DRSDetails.Add(d);
// db.SaveChanges();
//}
TempData["success"] = "DRS Updated Successfully.";
return(RedirectToAction("Index"));
}
catch (Exception c)
{
}
return(View());
}
