public JsonResult AddUpdateItineraryMasterConsignment(ItineraryMasterConsignmentModel model)
{
string Messages = string.Empty;
if (ModelState.IsValid && ItineraryMasterConsignmentService.Instance.ValidateItinerary(model, out Messages))
{
return(Json(ItineraryMasterConsignmentService.Instance.SaveItineraryHouseMasterConsignment(model, GetUserInfo().iUserId)));
}
else
{
return(Json(new { Status = false, Message = string.Join(",", ModelState.Values.SelectMany(z => z.Errors).Select(z => z.ErrorMessage)) + Messages }));
}
}
public bool ValidateItinerary(ItineraryMasterConsignmentModel model, out string Messages)
{
Messages = string.Empty;
bool valid = true;
using (var db = new SeaManifestEntities())
{
if (db.tblItineraryMasterConsignmentMaps.Any(z => z.iItineraryId != model.iItineraryId && z.dPortOfCallSequenceNo == model.dPortOfCallSequenceNo && z.iMasterConsignmentId == model.iMasterConsignmentId))
{
valid = false; Messages = "Port of call seq no already exists";
}
}
return(valid);
}
//save ItemDeatilsMasterConsignment
public object SaveItineraryHouseMasterConsignment(ItineraryMasterConsignmentModel model, int iUserId)
{
try
{
using (var db = new SeaManifestEntities())
{
var data = db.tblItineraryMasterConsignmentMaps.Where(z => z.iItineraryId == model.iItineraryId).SingleOrDefault();
if (data != null)
{
data.iMasterConsignmentId = model.iMasterConsignmentId ?? 0;
data.iMessageImplementationId = model.iMessageImplementationId;
data.dPortOfCallSequenceNo = model.dPortOfCallSequenceNo;
data.sPortOfCallCd = model.sPortOfCallCd;
data.sPortOfCallName = model.sPortOfCallName;
data.sNextPortOfCallCdd = model.sNextPortOfCallCdd;
data.sNextPortOfCallName = model.sNextPortOfCallName;
data.sModeOfTransport = model.sModeOfTransport;
data.iActionBy = iUserId;
data.dtActionDate = DateTime.Now;
db.Entry(data).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
data = new tblItineraryMasterConsignmentMap
{
iMasterConsignmentId = model.iMasterConsignmentId ?? 0,
iMessageImplementationId = model.iMessageImplementationId,
dPortOfCallSequenceNo = model.dPortOfCallSequenceNo,
sPortOfCallCd = model.sPortOfCallCd,
sPortOfCallName = model.sPortOfCallName,
sNextPortOfCallCdd = model.sNextPortOfCallCdd,
sNextPortOfCallName = model.sNextPortOfCallName,
sModeOfTransport = model.sModeOfTransport,
iActionBy = iUserId,
dtActionDate = DateTime.Now,
};
db.tblItineraryMasterConsignmentMaps.Add(data);
db.SaveChanges();
}
return(new { Status = true, Message = "Itinerary saved successfully!" });
}
}
catch (Exception)
{
return(new { Status = false, Message = "Something went wrong" });
}
}
