public ActionResult AddOrRemoveShipment(ImportShipmentFormModel s_ImportShipment, int?i)
{
var Prevshipmentsession = Session["PreviousShipments"] as List <ImportShipmentDetail>;
if (i.HasValue)
{
if (Prevshipmentsession == null)
{
}
else
{
foreach (var item in Prevshipmentsession)
{
s_ImportShipment.Shipments.Add(item);
}
}
s_ImportShipment.Shipments.RemoveAt(i.Value);
Session["PreviousShipments"] = s_ImportShipment.Shipments;
}
else
{
if (s_ImportShipment.Shipments == null)
{
s_ImportShipment.Shipments = new List <ImportShipmentDetail>();
}
var shipmentsession = Session["Shipmentdetails"] as ImportShipmentDetail;
var Serialnumber = Convert.ToInt32(Session["ShipSerialNumber"]);
var isupdate = Convert.ToBoolean(Session["IsUpdate"]);
if (Prevshipmentsession == null)
{
}
else
{
foreach (var item in Prevshipmentsession)
{
s_ImportShipment.Shipments.Add(item);
}
}
if (isupdate == true)
{
//s_ImportShipment.Shipments.RemoveAt(Serialnumber);
s_ImportShipment.Shipments[Serialnumber] = shipmentsession;
}
else
{
s_ImportShipment.Shipments.Add(shipmentsession);
}
Session["Shipmentdetails"] = new ImportShipmentDetail();
Session["ShipSerialNumber"] = "";
Session["IsUpdate"] = false;
}
ViewBag.Cities = db.CityMasters.ToList();
ViewBag.Countries = db.CountryMasters.ToList();
ViewBag.DestinationCountryID = db.CountryMasters.ToList();
ViewBag.CurrencyID = db.CurrencyMasters.ToList();
ViewBag.Currencies = db.CurrencyMasters.ToList();
return(PartialView("ShipmentList", s_ImportShipment));
}
// GET: ImportShipment/Details/5
public ActionResult Details(int?id)
{
//AuthHelp Token = repos.Authenticate();
//if (Token.Status)
//{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var s_ImportShipment = db.ImportShipments.Where(x => x.ID == id)
.FirstOrDefault();
if (s_ImportShipment == null)
{
return(HttpNotFound());
}
ImportShipmentFormModel model = new ImportShipmentFormModel();
model = db.ImportShipments.Where(x => x.ID == id).Select(x => new ImportShipmentFormModel
{
ID = x.ID,
AgentID = x.AgentID,
AgentLoginID = x.AgentLoginID,
Bags = x.Bags,
CD = x.CD,
ConsignorName = x.ConsignorName,
ConsignorAddress1_Building = x.ConsignorAddress1_Building,
ConsignorAddress2_Street = x.ConsignorAddress2_Street,
ConsignorAddress3_PinCode = x.ConsignorAddress3_PinCode,
ConsignorCountryName = x.ConsignorCountryName,
ConsignorCityName = x.ConsignorCityName,
ConsigneeName = x.ConsigneeName,
ConsigneeAddress1_Building = x.ConsigneeAddress1_Building,
ConsigneeAddress2_Street = x.ConsigneeAddress2_Street,
ConsigneeAddress3_PinCode = x.ConsigneeAddress3_PinCode,
ConsigneeCountryName = x.ConsigneeCountryName,
ConsigneeCityName = x.ConsigneeCityName,
CreatedDate = x.CreatedDate,
FlightDate = x.FlightDate,
FlightNo = x.FlightNo,
LastEditedByLoginID = x.LastEditedByLoginID,
ManifestNumber = x.ManifestNumber,
MAWB = x.MAWB,
OriginAirportCity = x.OriginAirportCity,
DestinationAirportCity = x.DestinationAirportCity,
RunNo = x.RunNo,
TotalAWB = x.TotalAWB,
ShipmentTypeId = x.ShipmentTypeId
}).FirstOrDefault();
model.ConsigneeAddress = model.ConsigneeAddress1_Building + "," + model.ConsigneeAddress2_Street + "\n" + model.ConsigneeAddress3_PinCode;
model.ConsignorAddress = model.ConsignorAddress1_Building + "," + model.ConsignorAddress2_Street + "\n" + model.ConsignorAddress3_PinCode;
model.Shipments = db.ImportShipmentDetails.Where(d => d.ImportID == id).ToList();
return(View(model));
}
public JsonResult GetShipmentDetails(ImportShipmentFormModel s_ImportShipment, int?i)
{
if (i.HasValue)
{
var s = s_ImportShipment.Shipments[i.Value];
return(Json(new { success = true, data = s, ival = i.Value }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Create(ImportShipmentFormModel model)
{
var today = DateTime.Now.Date;
var userid = Convert.ToInt32(Session["UserID"]);
//var agent1 = (from u2 in db.UserRegistrations join c1 in db.AgentMasters on u2.UserID equals c1.UserID where u2.UserID == userid select c1).FirstOrDefault();
//var user = (from u2 in db.UserRegistrations select u2).FirstOrDefault();
var agent = db.AgentMasters.Where(aa => aa.UserID == userid).FirstOrDefault();
var fwdagent = db.ForwardingAgentMasters.FirstOrDefault();
//var company = db.AcCompanies.Select(x => new { Address = x.Address1 + ", " + x.Address2 + ", " + x.Address3, x.CountryID, x.Phone, x.AcCompany1, x.CountryName }).FirstOrDefault();
var company = db.AcCompanies.FirstOrDefault(); //. Select(x => new { Address = x.Address1 + ", " + x.Address2 + ", " + x.Address3, x.CountryID, x.Phone, x.AcCompany1, x.CountryName }).FirstOrDefault();
ImportShipment importShipment = new ImportShipment();
if (ModelState.IsValid)
{
if (model.ID == 0)
{
importShipment.ID = db.ImportShipments.Select(x => x.ID).DefaultIfEmpty(0).Max() + 1;
long manifestNumber = 0;
manifestNumber = db.ImportShipments.Where(x => x.AgentID == agent.AgentID).Count() + 1;
var Manifest = $"{DateTime.Now.ToString("yyyyMMdd")}{agent.AgentCode}{(manifestNumber.ToString("D4"))}";
importShipment.ManifestNumber = Manifest;
importShipment.AgentID = agent.AgentID;
importShipment.CreatedDate = DateTime.Now;
importShipment.ConsignorName = agent.Name;
importShipment.ConsignorCityName = agent.CityName;
importShipment.ConsignorCountryName = agent.CountryName;
importShipment.ConsignorAddress1_Building = agent.Address1;
importShipment.ConsignorAddress2_Street = agent.Address2;
importShipment.ConsignorAddress3_PinCode = agent.Address3;
importShipment.ConsignorLocationName = agent.LocationName;
importShipment.ConsigneeName = company.AcCompany1;
importShipment.ConsigneeCountryName = company.CountryName;
importShipment.ConsigneeCityName = company.CityName;
importShipment.ConsigneeLocationName = company.LocationName;
importShipment.ConsigneeAddress1_Building = company.Address1;
importShipment.ConsigneeAddress2_Street = company.Address2;
importShipment.ConsigneeAddress3_PinCode = company.Address3;
importShipment.AgentLoginID = userid;
}
else
{
importShipment = db.ImportShipments.Find(model.ID);
}
importShipment.Bags = model.Bags;
importShipment.CD = model.CD;
importShipment.FlightDate = model.FlightDate;
importShipment.FlightNo = model.FlightNo;
importShipment.LastEditedByLoginID = userid;
importShipment.MAWB = model.MAWB;
importShipment.RunNo = model.RunNo;
importShipment.TotalAWB = model.TotalAWB;
importShipment.Type = model.Type;
importShipment.DestinationAirportCity = model.DestinationAirportCity;
importShipment.OriginAirportCity = model.OriginAirportCity;
if (model.ID == 0)
{
db.ImportShipments.Add(importShipment);
db.SaveChanges();
}
else
{
db.Entry(importShipment).State = EntityState.Modified;
db.SaveChanges();
}
var max = db.ImportShipmentDetails.Select(x => x.ShipmentDetailID).DefaultIfEmpty(0).Max() + 1;
if (model.Shipments != null)
{
//model.Shipments.ForEach(x =>
//{
// x.ShipmentDetailID = max;
// x.ImportID = importShipment.ID;
// x.Status = 1;
// max++;
//});
foreach (var det in model.Shipments)
{
if (det.ShipmentDetailID == 0)
{
det.ShipmentDetailID = max;
det.ImportID = importShipment.ID;
det.StatusTypeId = db.tblStatusTypes.Where(cc => cc.Name == "FORWARDED").FirstOrDefault().ID;
det.CourierStatusID = db.CourierStatus.Where(cc => cc.CourierStatus == "Forwarded to Agent").FirstOrDefault().CourierStatusID;
db.ImportShipmentDetails.Add(det);
db.SaveChanges();
max++;
}
else
{
det.ImportID = importShipment.ID;
det.StatusTypeId = db.tblStatusTypes.Where(cc => cc.Name == "FORWARDED").FirstOrDefault().ID;
det.CourierStatusID = db.CourierStatus.Where(cc => cc.CourierStatus == "Forwarded to Agent").FirstOrDefault().CourierStatusID;
db.Entry(det).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 = det.HAWB;
_awbstatus.EntryDate = DateTime.Now;
_awbstatus.ShipmentDetailID = det.ShipmentDetailID;
_awbstatus.StatusTypeId = Convert.ToInt32(det.StatusTypeId);
_awbstatus.CourierStatusId = Convert.ToInt32(det.CourierStatusID);
_awbstatus.ShipmentStatus = db.tblStatusTypes.Find(det.StatusTypeId).Name;
_awbstatus.CourierStatus = db.CourierStatus.Find(det.CourierStatusID).CourierStatus;
_awbstatus.UserId = userid;
db.AWBTrackStatus.Add(_awbstatus);
db.SaveChanges();
}
var li = model.Shipments.Select(x => x.ShipmentDetailID).ToList();
var importdetails = db.ImportShipmentDetails.Where(x => !li.Contains(x.ShipmentDetailID) && x.ImportID == importShipment.ID).ToList();
foreach (var import in importdetails)
{
db.ImportShipmentDetails.Add(import);
db.SaveChanges();
}
}
else
{
var remove_datas = db.ImportShipmentDetails.Where(s => s.ImportID == importShipment.ID).ToList();
foreach (var rdata in remove_datas)
{
db.ImportShipmentDetails.Remove(rdata);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
model.ConsignorName = agent.Name;
model.ConsignorCountryName = agent.CountryName;
model.ConsignorCityName = agent.CityName;
model.ConsignorAddress = agent.Address1 + "," + agent.Address2 + "," + agent.Address3;
model.ConsigneeName = company.AcCompany1;
model.ConsigneeCityName = company.CityName;
model.ConsigneeCountryName = company.CountryName;
model.ConsigneeAddress = company.Address1 + "," + company.Address2 + "," + company.Address3;
if (model.Shipments == null)
{
model.Shipments = new List <ImportShipmentDetail>();
}
var countries = db.CountryMasters.ToList();// db.CountryMasters.ToList();
ViewBag.OriginCityID = new SelectList(new List <CityMaster>(), "CityID", "City");
ViewBag.DestinationCityID = new SelectList(new List <CityMaster>(), "CityID", "City");
ViewBag.OriginCountryID = countries;
ViewBag.DestinationCountryID = countries;
ViewBag.CurrencyID = db.CurrencyMasters.ToList();
ViewBag.Cities = db.CityMasters.ToList();
ViewBag.Countries = db.CountryMasters.ToList();
string selectedVal = null;
var types = new List <SelectListItem>
{
new SelectListItem {
Text = "Transhipment", Value = "Transhipment", Selected = selectedVal == "Transhipment"
},
new SelectListItem {
Text = "Import", Value = "Import", Selected = selectedVal == "Import"
},
};
ViewBag.Type = types;
ViewBag.Currencies = db.CurrencyMasters.ToList();
ViewBag.AgentName = agent.Name;
ViewBag.AgentCity = agent.CityName;
ViewBag.CompanyName = company.AcCompany1;
return(View(model));
}
// GET: ImportShipment/Create
public ActionResult Create(int?id = 0)
{
var userid = Convert.ToInt32(Session["UserID"]);
var agent = db.AgentMasters.Where(cc => cc.UserID == userid).FirstOrDefault();
var company = db.AcCompanies.FirstOrDefault(); // .Select(x => new { Address = x.Address1 + ", " + x.Address2 + ", " + x.Address3, x.CountryID, x.Phone, x.AcCompany1, x.CountryName }).FirstOrDefault();
ImportShipmentFormModel model = new ImportShipmentFormModel();
if (id == 0)
{
model.ConsignorName = agent.Name;
model.ConsignorCountryName = agent.CountryName;
model.ConsignorCityName = agent.CityName;
model.ConsignorAddress = agent.Address1 + "," + agent.Address2 + "," + agent.Address3;
model.ConsigneeName = company.AcCompany1;
model.ConsigneeCityName = company.CityName;
model.ConsigneeCountryName = company.CountryName;
model.ConsigneeAddress = company.Address1 + "," + company.Address2 + "," + company.Address3;
long manifestNumber = 0;
manifestNumber = db.ImportShipments.Where(x => x.AgentID == agent.AgentID).Count() + 1;
var Manifest = $"{DateTime.Now.ToString("yyyyMMdd")}{agent.AgentCode}{(manifestNumber.ToString("D4"))}";
model.ManifestNumber = Manifest;
model.FlightDate = DateTime.Now;
model.CreatedDate = DateTime.Now;
if (model.Shipments == null)
{
model.Shipments = new List <ImportShipmentDetail>();
}
}
else
{
model = db.ImportShipments.Where(x => x.ID == id).Select(x => new ImportShipmentFormModel
{
ID = x.ID,
AgentID = x.AgentID,
AgentLoginID = x.AgentLoginID,
Bags = x.Bags,
CD = x.CD,
ConsignorName = x.ConsignorName,
ConsignorAddress1_Building = x.ConsignorAddress1_Building,
ConsignorAddress2_Street = x.ConsignorAddress2_Street,
ConsignorAddress3_PinCode = x.ConsignorAddress3_PinCode,
ConsignorCountryName = x.ConsignorCountryName,
ConsignorCityName = x.ConsignorCityName,
ConsigneeName = x.ConsigneeName,
ConsigneeAddress1_Building = x.ConsigneeAddress1_Building,
ConsigneeAddress2_Street = x.ConsigneeAddress2_Street,
ConsigneeAddress3_PinCode = x.ConsigneeAddress3_PinCode,
ConsigneeCountryName = x.ConsigneeCountryName,
ConsigneeCityName = x.ConsigneeCityName,
CreatedDate = x.CreatedDate,
FlightDate = x.FlightDate,
FlightNo = x.FlightNo,
LastEditedByLoginID = x.LastEditedByLoginID,
ManifestNumber = x.ManifestNumber,
MAWB = x.MAWB,
OriginAirportCity = x.OriginAirportCity,
DestinationAirportCity = x.DestinationAirportCity,
RunNo = x.RunNo,
TotalAWB = x.TotalAWB,
Type = x.Type
}).FirstOrDefault();
model.ConsigneeAddress = model.ConsigneeAddress1_Building + "," + model.ConsigneeAddress2_Street + "\n" + model.ConsigneeAddress3_PinCode;
model.ConsignorAddress = model.ConsignorAddress1_Building + "," + model.ConsignorAddress2_Street + "\n" + model.ConsignorAddress3_PinCode;
model.Shipments = db.ImportShipmentDetails.Where(d => d.ImportID == id).ToList();
}
string selectedVal = model.Type;
var types = new List <SelectListItem>
{
new SelectListItem {
Text = "Select Shipment Type", Value = null, Selected = selectedVal == null
},
new SelectListItem {
Text = "Transhipment", Value = "Transhipment", Selected = selectedVal == "Transhipment"
},
new SelectListItem {
Text = "Import", Value = "Import", Selected = selectedVal == "Import"
},
};
ViewBag.Type = types;
var currency = new SelectList(db.CurrencyMasters.OrderBy(x => x.CurrencyName), "CurrencyID", "CurrencyName").ToList();
ViewBag.CurrencyID = db.CurrencyMasters.ToList(); // db.CurrencyMasters.ToList();
ViewBag.Currencies = db.CurrencyMasters.ToList();
ViewBag.AgentName = agent.Name;
ViewBag.AgentCity = agent.CityName;
ViewBag.CompanyName = company.AcCompany1;
return(View(model));
}
public ActionResult Create(ImportShipmentFormModel model)
{
int yearid = Convert.ToInt32(Session["fyearid"].ToString());
var today = DateTime.Now.Date;
var userid = Convert.ToInt32(Session["UserID"]);
//var agent1 = (from u2 in db.UserRegistrations join c1 in db.AgentMasters on u2.UserID equals c1.UserID where u2.UserID == userid select c1).FirstOrDefault();
//var user = (from u2 in db.UserRegistrations select u2).FirstOrDefault();
var agent = db.AgentMasters.Where(aa => aa.UserID == userid).FirstOrDefault();
var fwdagent = db.ForwardingAgentMasters.FirstOrDefault();
//var company = db.AcCompanies.Select(x => new { Address = x.Address1 + ", " + x.Address2 + ", " + x.Address3, x.CountryID, x.Phone, x.AcCompany1, x.CountryName }).FirstOrDefault();
var company = db.AcCompanies.FirstOrDefault(); //. Select(x => new { Address = x.Address1 + ", " + x.Address2 + ", " + x.Address3, x.CountryID, x.Phone, x.AcCompany1, x.CountryName }).FirstOrDefault();
ImportShipment importShipment = new ImportShipment();
if (ModelState.IsValid)
{
if (model.ID == 0)
{
importShipment.ID = db.ImportShipments.Select(x => x.ID).DefaultIfEmpty(0).Max() + 1;
long manifestNumber = 0;
manifestNumber = db.ImportShipments.Where(x => x.AgentID == agent.AgentID).Count() + 1;
var Manifest = $"{DateTime.Now.ToString("yyyyMMdd")}{agent.AgentCode}{(manifestNumber.ToString("D4"))}";
importShipment.ManifestNumber = Manifest;
importShipment.AgentID = agent.AgentID;
importShipment.CreatedDate = DateTime.Now;
importShipment.ConsignorName = agent.Name;
importShipment.ConsignorCityName = agent.CityName;
importShipment.ConsignorCountryName = agent.CountryName;
importShipment.ConsignorAddress1_Building = agent.Address1;
importShipment.ConsignorAddress2_Street = agent.Address2;
importShipment.ConsignorAddress3_PinCode = agent.Address3;
importShipment.ConsignorLocationName = agent.LocationName;
importShipment.ConsigneeName = company.AcCompany1;
importShipment.ConsigneeCountryName = company.CountryName;
importShipment.ConsigneeCityName = company.CityName;
importShipment.ConsigneeLocationName = company.LocationName;
importShipment.ConsigneeAddress1_Building = company.Address1;
importShipment.ConsigneeAddress2_Street = company.Address2;
importShipment.ConsigneeAddress3_PinCode = company.Address3;
importShipment.AcFinancialYearID = yearid;
importShipment.AgentLoginID = userid;
importShipment.Status = 0; // db.CourierStatus.Where(cc => cc.CourierStatus == "Forwarded to Agent").First().CourierStatusID;
}
else
{
importShipment = db.ImportShipments.Find(model.ID);
}
importShipment.Bags = model.Bags;
importShipment.CD = model.CD;
importShipment.FlightDate = model.FlightDate;
importShipment.FlightNo = model.FlightNo;
importShipment.LastEditedByLoginID = userid;
importShipment.MAWB = model.MAWB;
importShipment.RunNo = model.RunNo;
importShipment.TotalAWB = model.TotalAWB;
importShipment.ShipmentTypeId = model.ShipmentTypeId;
importShipment.DestinationAirportCity = model.DestinationAirportCity;
importShipment.OriginAirportCity = model.OriginAirportCity;
importShipment.Type = "import"; //not used
if (model.ID == 0)
{
db.ImportShipments.Add(importShipment);
db.SaveChanges();
}
else
{
db.Entry(importShipment).State = EntityState.Modified;
db.SaveChanges();
}
var max = db.ImportShipmentDetails.Select(x => x.ShipmentDetailID).DefaultIfEmpty(0).Max() + 1;
if (model.Shipments != null)
{
//model.Shipments.ForEach(x =>
//{
// x.ShipmentDetailID = max;
// x.ImportID = importShipment.ID;
// x.Status = 1;
// max++;
//});
foreach (var det in model.Shipments)
{
if (det.ShipmentDetailID == 0)
{
det.HAWB = "";
det.ShipmentDetailID = max;
det.ImportID = importShipment.ID;
var couriercstatus = db.CourierStatus.Where(c => c.CourierStatus == "Export Manifest Prepared").FirstOrDefault();
if (couriercstatus != null)
{
det.CourierStatusID = couriercstatus.CourierStatusID;
}
var statustype = db.tblStatusTypes.Where(c => c.Name == "READY TO EXPORT").FirstOrDefault();
if (statustype != null)
{
det.StatusTypeId = statustype.ID;
}
db.ImportShipmentDetails.Add(det);
db.SaveChanges();
max++;
}
else
{
if (det.CourierStatusID == null)
{
det.HAWB = "";
var couriercstatus = db.CourierStatus.Where(c => c.CourierStatus == "Export Manifest Prepared").FirstOrDefault();
if (couriercstatus != null)
{
det.CourierStatusID = couriercstatus.CourierStatusID;
}
}
if (det.StatusTypeId == null)
{
det.HAWB = "";
var statustype = db.tblStatusTypes.Where(c => c.Name == "READY TO EXPORT").FirstOrDefault();
if (statustype != null)
{
det.StatusTypeId = statustype.ID;
}
}
det.HAWB = "";
det.ImportID = importShipment.ID;
db.Entry(det).State = EntityState.Modified;
db.SaveChanges();
}
}
var li = model.Shipments.Select(x => x.ShipmentDetailID).ToList();
var importdetails = db.ImportShipmentDetails.Where(x => !li.Contains(x.ShipmentDetailID) && x.ImportID == importShipment.ID).ToList();
foreach (var import in importdetails)
{
db.ImportShipmentDetails.Remove(import);
//db.ImportShipmentDetails.Add(import);
db.SaveChanges();
}
}
else
{
var remove_datas = db.ImportShipmentDetails.Where(s => s.ImportID == importShipment.ID).ToList();
foreach (var rdata in remove_datas)
{
db.ImportShipmentDetails.Remove(rdata);
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
model.ConsignorName = agent.Name;
model.ConsignorCountryName = agent.CountryName;
model.ConsignorCityName = agent.CityName;
model.ConsignorAddress = agent.Address1 + "," + agent.Address2 + "," + agent.Address3;
model.ConsigneeName = company.AcCompany1;
model.ConsigneeCityName = company.CityName;
model.ConsigneeCountryName = company.CountryName;
model.ConsigneeAddress = company.Address1 + "," + company.Address2 + "," + company.Address3;
if (model.Shipments == null)
{
model.Shipments = new List <ImportShipmentDetail>();
}
var countries = db.CountryMasters.ToList();// db.CountryMasters.ToList();
ViewBag.OriginCityID = new SelectList(new List <CityMaster>(), "CityID", "City");
ViewBag.DestinationCityID = new SelectList(new List <CityMaster>(), "CityID", "City");
ViewBag.OriginCountryID = countries;
ViewBag.DestinationCountryID = countries;
ViewBag.CurrencyID = db.CurrencyMasters.ToList();
ViewBag.Cities = db.CityMasters.ToList();
ViewBag.Countries = db.CountryMasters.ToList();
ViewBag.Type = db.tblShipmentTypes.ToList();
ViewBag.Currencies = db.CurrencyMasters.ToList();
ViewBag.AgentName = agent.Name;
ViewBag.AgentCity = agent.CityName;
ViewBag.CompanyName = company.AcCompany1;
return(View(model));
}
