public bool Validate(ItemDetailsHouseCargoModel model, out string Messages)
{
Messages = string.Empty;
bool valid = true;
using (var db = new SeaManifestEntities())
{
if (db.tblItemDetailsHouseCargoMaps.Any(z => z.iHouseCargoDescId == model.iHouseCargoDescId && z.dCargoItemSequenceNo == model.dCargoItemSequenceNo && z.iItemsDetailsId != model.iItemsDetailsId))
{
valid = false; Messages = "Cargo Item Sequence no already exists.";
}
}
return(valid);
}
//save ItemDeatilsHouseCargo
public object SaveItemDetailssHouseCargo(ItemDetailsHouseCargoModel model, int iUserId)
{
try
{
using (var db = new SeaManifestEntities())
{
var data = db.tblItemDetailsHouseCargoMaps.Where(z => z.iItemsDetailsId == model.iItemsDetailsId).SingleOrDefault();
if (data != null)
{
data.iHouseCargoDescId = model.iHouseCargoDescId ?? 0;
data.iMasterConsignmentId = model.iMasterConsignmentId;
data.dCargoItemSequenceNo = model.dCargoItemSequenceNo;
data.sHsCd = model.sHsCd;
data.sCargoItemDesc = model.sCargoItemDesc;
data.sUnoCd = model.sUnoCd;
data.sIMDGCd = model.sIMDGCd;
data.dNoOfPakages = model.dNoOfPakages;
data.sTypesOfPackages = model.sTypesOfPackages;
data.iActionBy = iUserId;
data.dtActionDate = DateTime.Now;
db.Entry(data).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
data = new tblItemDetailsHouseCargoMap
{
iHouseCargoDescId = model.iHouseCargoDescId ?? 0,
iMasterConsignmentId = model.iMasterConsignmentId,
dCargoItemSequenceNo = model.dCargoItemSequenceNo,
sHsCd = model.sHsCd,
sCargoItemDesc = model.sCargoItemDesc,
sUnoCd = model.sUnoCd,
sIMDGCd = model.sIMDGCd,
dNoOfPakages = model.dNoOfPakages,
sTypesOfPackages = model.sTypesOfPackages,
iActionBy = iUserId,
dtActionDate = DateTime.Now,
};
db.tblItemDetailsHouseCargoMaps.Add(data);
db.SaveChanges();
}
return(new { Status = true, Message = "Item Details saved successfully!" });
}
}
catch (Exception)
{
return(new { Status = false, Message = "Something went wrong" });
}
}
