public bool Validate(TransportEquipmentMasterConsignmentModel model, out string Messages)
{
Messages = string.Empty;
bool valid = true;
using (var db = new SeaManifestEntities())
{
if (db.tblTransportEquipmentMasterConsignmentMaps.Any(z => (model.sReportingEvent != "SEI" && model.sReportingEvent != "SDN") && z.iTransporterEquipmentId != model.iTransporterEquipmentId && z.iEquipmentSequenceNo == model.iEquipmentSequenceNo && z.iMasterConsignmentId == model.iMasterConsignmentId))
{
valid = false; Messages = "Sequence No already exists";
}
}
return(valid);
}
//save TransportEquipmentMasterConsignment
public object SaveTransportEquipmentMasterConsignment(TransportEquipmentMasterConsignmentModel model, int iUserId)
{
try
{
using (var db = new SeaManifestEntities())
{
var data = db.tblTransportEquipmentMasterConsignmentMaps.Where(z => z.iTransporterEquipmentId == model.iTransporterEquipmentId).SingleOrDefault();
if (data != null)
{
data.iMasterConsignmentId = model.iMasterConsignmentId;
data.iEquipmentSequenceNo = model.iEquipmentSequenceNo;
data.sEquipmentId = model.sEquipmentId;
data.sEquipmentType = model.sEquipmentType;
data.sEquipmentSize = model.sEquipmentSize;
data.sEquipmentLoadStatus = model.sEquipmentLoadStatus;
data.sAdditionalEquipmentHold = model.sAdditionalEquipmentHold;
data.sEquipmentSealType = model.sEquipmentSealType;
data.sEquipmentSealNo = model.sEquipmentSealNo;
data.sOtherEquipmentId = model.sOtherEquipmentId;
data.sSOCFlag = model.sSOCFlag;
data.sContainerAgentCd = model.sContainerAgentCd;
data.iMessageImplementationId = model.iMessageImplementationId;
data.dContainerWeight = model.dContainerWeight;
data.dTotalNoOfPackages = model.dTotalNoOfPackages;
data.iActionBy = iUserId;
data.dtActionDate = DateTime.Now;
data.iActionBy = iUserId;
data.dtActionDate = DateTime.Now;
db.Entry(data).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
data = new tblTransportEquipmentMasterConsignmentMap
{
iMasterConsignmentId = model.iMasterConsignmentId,
iEquipmentSequenceNo = model.iEquipmentSequenceNo,
sEquipmentId = model.sEquipmentId,
sEquipmentType = model.sEquipmentType,
sEquipmentSize = model.sEquipmentSize,
sEquipmentLoadStatus = model.sEquipmentLoadStatus,
sAdditionalEquipmentHold = model.sAdditionalEquipmentHold,
sEquipmentSealType = model.sEquipmentSealType,
sEquipmentSealNo = model.sEquipmentSealNo,
sOtherEquipmentId = model.sOtherEquipmentId,
sSOCFlag = model.sSOCFlag,
sContainerAgentCd = model.sContainerAgentCd,
iMessageImplementationId = model.iMessageImplementationId,
dContainerWeight = model.dContainerWeight,
dTotalNoOfPackages = model.dTotalNoOfPackages,
iActionBy = iUserId,
dtActionDate = DateTime.Now,
};
db.tblTransportEquipmentMasterConsignmentMaps.Add(data);
db.SaveChanges();
}
return(new { Status = true, Message = "Transport Equipment saved successfully!" });
}
}
catch (Exception)
{
return(new { Status = false, Message = "Something went wrong" });
}
}
