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