public ActionResult Edit(PickUpEnquiryVM v) { if (ModelState.IsValid) { CustomerEnquiry _enquiry = new CustomerEnquiry(); _enquiry.EnquiryID = v.EnquiryID; _enquiry.EnquiryNo = v.EnquiryNo; _enquiry.EnquiryDate = Convert.ToDateTime(v.EnquiryDate); _enquiry.AWBNo = v.AWBNo; _enquiry.DescriptionID = 4; _enquiry.ConsignerCountryId = v.ConsignerCountryId; _enquiry.ConsignerCityId = v.ConsignerCityId; _enquiry.ConsignerLocationId = v.ConsignerLocationId; _enquiry.ConsigneeCountryID = v.ConsigneeCountryID; _enquiry.ConsigneeCityId = v.ConsigneeCityId; _enquiry.ConsigneeLocationId = v.ConsigneeLocationId; _enquiry.ConsigneeLocationName = v.ConsigneeLocationName; _enquiry.ConsignorLocationName = v.ConsignorLocationName; _enquiry.Weight = v.Weight; _enquiry.AcCompanyID = 1; _enquiry.CustomerID = v.CustomerID; _enquiry.Consignee = v.Consignee; _enquiry.Consignor = v.Consignor; _enquiry.ConsignorAddress = v.ConsignorAddress; _enquiry.ConsignorAddress1 = v.ConsignorAddress1; _enquiry.ConsignorAddress2 = v.ConsignorAddress2; _enquiry.ConsigneeAddress = v.ConsigneeAddress; _enquiry.ConsigneeAddress1 = v.ConsigneeAddress1; _enquiry.ConsigneeAddress2 = v.ConsigneeAddress2; _enquiry.ConsignorPhone = v.ConsignorPhone; _enquiry.ConsigneePhone = v.ConsigneePhone; _enquiry.EmployeeID = v.EmployeeID; _enquiry.Remarks = v.Remarks; _enquiry.CollectedEmpID = v.CollectedEmpID; _enquiry.IsEnquiry = true; _enquiry.ShipmentType = v.ShipmentType; if (v.vehreq == true) { _enquiry.Vehicle = v.Vehicle; _enquiry.VehicleID = v.VehicleID; } _enquiry.ConsigneeContact = v.ConsigneeContact; _enquiry.ConsignorContact = v.ConsignorContact; _enquiry.EnteredByID = v.EnteredByID; _enquiry.ReadyTime = v.ReadyTime; _enquiry.OfficeTimeFrom = v.OfficeTimeFrom; _enquiry.OfficeTimeTo = v.OfficeTimeTo; _enquiry.RequestSource = v.RequestSource; db.Entry(_enquiry).State = EntityState.Modified; db.SaveChanges(); TempData["SuccessMsg"] = "You have successfully Updated PickUp Enquiry."; return(RedirectToAction("Index")); } return(View()); }
public ActionResult Create(PickUpEnquiryVM v) { int uid = Convert.ToInt32(Session["UserID"].ToString()); UserRegistration u = (from c in db.UserRegistrations where c.UserID == uid select c).FirstOrDefault(); int empid = u.UserID; string empname = u.UserName; CustomerEnquiry _enquiry = new CustomerEnquiry(); int id = (from c in db.CustomerEnquiries orderby c.EnquiryID descending select c.EnquiryID).FirstOrDefault(); _enquiry.EnquiryID = id + 1; _enquiry.EnquiryNo = (id + 1).ToString(); _enquiry.AWBNo = GetMaxAWBNo(); _enquiry.EnquiryDate = Convert.ToDateTime(v.EnquiryDate); _enquiry.DescriptionID = 4; _enquiry.ConsignerCountryId = v.ConsignerCountryId; _enquiry.ConsignerCityId = v.ConsignerCityId; _enquiry.ConsigneeLocationName = v.ConsigneeLocationName; _enquiry.ConsignorLocationName = v.ConsignorLocationName; _enquiry.ConsigneeCountryID = v.ConsigneeCountryID; _enquiry.ConsigneeCityId = v.ConsigneeCityId; _enquiry.Weight = v.Weight; _enquiry.AcCompanyID = 1; _enquiry.CustomerID = v.CustomerID; _enquiry.Consignee = v.Consignee; _enquiry.Consignor = v.Consignor; _enquiry.ConsignorAddress = v.ConsignorAddress; _enquiry.ConsignorAddress1 = v.ConsignorAddress1; _enquiry.ConsignorAddress2 = v.ConsignorAddress2; _enquiry.ConsigneeAddress = v.ConsigneeAddress; _enquiry.ConsigneeAddress1 = v.ConsigneeAddress1; _enquiry.ConsigneeAddress2 = v.ConsigneeAddress2; _enquiry.ConsignorPhone = v.ConsignorPhone; _enquiry.ConsigneePhone = v.ConsigneePhone; _enquiry.EmployeeID = v.EmployeeID; _enquiry.Remarks = v.Remarks; _enquiry.CollectedEmpID = v.CollectedEmpID; _enquiry.ShipmentType = v.ShipmentType; if (v.vehreq == true) { _enquiry.Vehicle = v.Vehicle; _enquiry.VehicleID = v.VehicleID; } _enquiry.ConsigneeContact = v.ConsigneeContact; _enquiry.ConsignorContact = v.ConsignorContact; _enquiry.EnteredByID = empid; _enquiry.IsEnquiry = true; _enquiry.ReadyTime = v.ReadyTime; _enquiry.OfficeTimeFrom = v.OfficeTimeFrom; _enquiry.OfficeTimeTo = v.OfficeTimeTo; _enquiry.RequestSource = v.RequestSource; db.CustomerEnquiries.Add(_enquiry); TempData["SuccessMsg"] = "You have successfully Added PickUp Enquiry."; db.SaveChanges(); return(RedirectToAction("Index")); return(View()); }
public ActionResult Edit(int id) { int uid = Convert.ToInt32(Session["UserID"].ToString()); UserRegistration u = (from c in db.UserRegistrations where c.UserID == uid select c).FirstOrDefault(); int empid = u.UserID; string empname = u.UserName; ViewBag.Country = db.CountryMasters.ToList(); ViewBag.Location = db.LocationMasters.ToList(); ViewBag.Vehicle = db.VehicleMasters.ToList(); ViewBag.Employee = db.EmployeeMasters.ToList(); ViewBag.Customer = db.CustomerMasters.ToList(); ViewBag.empname = empname; ViewBag.empid = empid; PickUpEnquiryVM v = new PickUpEnquiryVM(); CustomerEnquiry a = db.CustomerEnquiries.Find(id); if (a == null) { return(HttpNotFound()); } else { v.EnquiryID = a.EnquiryID; v.EnquiryNo = a.EnquiryNo; v.AWBNo = "101"; v.EnquiryDate = a.EnquiryDate; v.DescriptionID = 4; v.ConsignerCountryId = a.ConsignerCountryId; v.ConsignerCityId = a.ConsignerCityId; v.ConsignerLocationId = a.ConsignerLocationId; v.ConsigneeCountryID = a.ConsigneeCountryID; v.ConsigneeCityId = a.ConsigneeCityId; v.ConsigneeLocationId = a.ConsigneeLocationId; v.ConsigneeLocationName = a.ConsigneeLocationName; v.ConsignorLocationName = a.ConsignorLocationName; v.Weight = a.Weight; v.AcCompanyID = 1; v.CustomerID = a.CustomerID; v.Consignee = a.Consignee; v.Consignor = a.Consignor; v.ConsignorAddress = a.ConsignorAddress; v.ConsignorAddress1 = a.ConsignorAddress1; v.ConsignorAddress2 = a.ConsignorAddress2; v.ConsigneeAddress = a.ConsigneeAddress; v.ConsigneeAddress1 = a.ConsigneeAddress1; v.ConsigneeAddress2 = a.ConsigneeAddress2; v.ConsignorPhone = a.ConsignorPhone; v.ConsigneePhone = a.ConsigneePhone; v.EmployeeID = a.EmployeeID; v.Remarks = a.Remarks; v.CollectedEmpID = a.CollectedEmpID; v.ShipmentType = a.ShipmentType; if (a.VehicleID != null) { v.VehicleID = a.VehicleID.Value; v.Vehicle = a.Vehicle; v.vehreq = true; } else { v.vehreq = false; v.Vehicle = ""; } v.IsEnquiry = a.IsEnquiry; v.ConsigneeContact = a.ConsigneeContact; v.ConsignorContact = a.ConsignorContact; v.EnteredByID = empid; v.ReadyTime = a.ReadyTime; v.OfficeTimeFrom = a.OfficeTimeFrom; v.OfficeTimeTo = a.OfficeTimeTo; v.RequestSource = a.RequestSource; } var obj = (from c in db.CityMasters where c.CountryID == a.ConsignerCountryId select c).ToList(); ViewBag.City = (from c in db.CityMasters where c.CountryID == a.ConsignerCountryId select c).ToList(); ViewBag.CityConsignee = (from c in db.CityMasters where c.CountryID == a.ConsigneeCountryID select c).ToList(); return(View(v)); }