public object GetSupportDocMasterConsignment(int iMasterConsignmentId, string search, int start, int length, out int recordsTotal)
{
using (var db = new SeaManifestEntities())
{
var userId = GetUserInfo().iUserId;
var query = from t in db.tblSupportDocMasterConsignmentMaps
where (t.sTagRef.Contains(search) || t.sRefSerialNo.Contains(search) ||
t.sSubSerialNoRef.Contains(search) ||
t.sIcegateUserId.Contains(search) ||
t.sIRNNo.Contains(search) ||
t.sDocRefNo.Contains(search) ||
t.sDocTypeCd.Contains(search) ||
t.sBeneficiaryCd.Contains(search)
) &&
t.iMasterConsignmentId == iMasterConsignmentId &&
t.iActionBy == userId
select t;
recordsTotal = query.Count();
return(query.OrderBy(z => z.sIRNNo).Skip(start).Take(length).ToList().Select(t => new
{
t.iMessageImplementationId,
t.iMasterConsignmentId,
t.sTagRef,
t.sRefSerialNo,
t.sSubSerialNoRef,
t.sIcegateUserId,
t.sIRNNo,
t.sDocRefNo,
t.sDocTypeCd,
t.sBeneficiaryCd,
t.iSupportDocsId
}).ToList());
}
}
public async Task <RolePermissionModel> GetRolePermissions(byte iRoleId)
{
using (var db = new SeaManifestEntities())
{
var rolePermissions = await db.tblRolePermissionsMs.Where(z => z.iRoleId == iRoleId).Select(z => z.iPermissionId).ToListAsync();
return(new RolePermissionModel
{
lstPermissionModel = (await db.tblPermissionMs.Where(z => z.iParentId == 0).OrderBy(z => z.iOrder).ToListAsync()).Select(z => new PermissionModel
{
iPermissionId = z.iPermissionId,
sPermissionName = z.sPermissionName,
isChecked = rolePermissions.Contains(z.iPermissionId),
sPath = z.sPath,
childs = db.tblPermissionMs.Where(zx => zx.iParentId == z.iPermissionId).OrderBy(xz => xz.iOrder).ToList().Select(c => new PermissionModel
{
iPermissionId = c.iPermissionId,
sPath = c.sPath,
sPermissionName = c.sPermissionName,
isChecked = rolePermissions.Contains(c.iPermissionId),
}).ToList(),
}).ToList(),
iRoleId = iRoleId
});
}
}
public object GetPort(string search, int start, int length, out int recordsTotal)
{
using (var db = new SeaManifestEntities())
{
var query = from t in db.tblPortMs
join C in db.tblCountryMs on t.sCountryCode equals C.sCountryCode
join S in db.tblCodeMs.Where(Z => Z.tblCodeTypeM.sCodeType == "State_Code") on t.SstateCode equals S.sCode into tp
from S in tp.DefaultIfEmpty()
where (t.sPortCode.Contains(search) ||
t.sPortDescription.Contains(search) ||
C.sCountryName.Contains(search) ||
S.sCodeName.Contains(search)
)
select new { t, S.sCodeName, C.sCountryName };
recordsTotal = query.Count();
return(query.OrderBy(z => z.t.sPortCode).Skip(start).Take(length).ToList().Select(z => new
{
z.t.sPortCode,
z.t.sPortDescription,
z.sCountryName,
sStateName = z.sCodeName,
z.t.iPortId
}).ToList());
}
}
public object GetAmendmentDetailsMessageImlementation(int iMessageImplementationId, string search, int start, int length, out int recordsTotal)
{
using (var db = new SeaManifestEntities())
{
var userId = GetUserInfo().iUserId;
var query = from t in db.tblAmendmentDetailsMessageImlementationMaps
where (
t.sAmendRefNo.Contains(search) ||
t.sAmendFlag.Contains(search) ||
t.sAmendType.Contains(search)
) &&
t.iMessageImplementationId == iMessageImplementationId &&
t.iActionBy == userId
select t;
recordsTotal = query.Count();
return(query.OrderBy(z => z.sAmendRefNo).Skip(start).Take(length).ToList().Select(t => new
{
t.iMessageImplementationId,
t.sAmendRefNo,
t.sAmendFlag,
t.sAmendType,
t.iAmendmentId
}).ToList());
}
}
public object GetAdditionalDetailsMessageImplementation(int iMessageImplementationId, string search, int start, int length, out int recordsTotal)
{
using (var db = new SeaManifestEntities())
{
var userId = GetUserInfo().iUserId;
var query = from t in db.tblAdditionalDetailsMessageImplementationMaps
where (
t.sInfoMsr.Contains(search) || SqlFunctions.StringConvert(t.dRefSerialNo).Contains(search) ||
t.sTagRef.Contains(search) || t.sInfoType.Contains(search) || t.sInfoQualifier.Contains(search) ||
t.sInfoCd.Contains(search) || t.sInfoText.Contains(search) || t.sInfoMsr.Contains(search)
) &&
t.iActionBy == userId &&
t.iMessageImplementationId == iMessageImplementationId
select t;
recordsTotal = query.Count();
return(query.OrderBy(z => z.sInfoCd).Skip(start).Take(length).ToList().Select(z => new
{
z.iAdditionalDetailsId,
z.iMessageImplementationId,
z.sInfoCd,
z.sInfoMsr,
z.sInfoQualifier,
z.sInfoText,
z.sInfoType,
z.sTagRef,
z.dRefSerialNo,
sInfoDate = z.dtInfoDate.ToDateString()
}).ToList());
}
}
public TransportEquipmentHouseCargoModel GetTransportEquipmentHouseCargoByTransporterEquipmentId(int?iTransporterEquipmentId)
{
using (var db = new SeaManifestEntities())
{
return(db.tblTransportEquipmentHouseCargoMaps.Where(z => z.iTransporterEquipmentId == iTransporterEquipmentId).ToList().Select(model => new TransportEquipmentHouseCargoModel
{
iMasterConsignmentId = model.iMasterConsignmentId,
iHouseCargoDescId = model.iHouseCargoDescId,
iEquipmentSequenceNo = model.iEquipmentSequenceNo ?? 0,
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,
dContainerWeight = model.dContainerWeight ?? 0,
dTotalNoOfPackages = model.dTotalNoOfPackages ?? 0,
iTransporterEquipmentId = model.iTransporterEquipmentId,
sReportingEvent = model.tblMasterConsignmentMessageImplementationMap.tblMessageImplementation.sDecRefReportingEvent,
}).SingleOrDefault());
}
}
public object GetPersonOnBoardMessageImplementation(int iMessageImplementationId, string search, int start, int length, out int recordsTotal)
{
using (var db = new SeaManifestEntities())
{
var userId = GetUserInfo().iUserId;
var query = from t in db.tblPersonOnBoardMessageImplementationMaps
where (
t.sPersonDetailsPersonTypeCdd.Contains(search) ||
t.sPersonDetailsPersonFamilyName.Contains(search) ||
t.sPersonDetailsPersonGivenName.Contains(search) ||
t.sPersonDetailsPersonNationalityCdd.Contains(search) ||
t.sPersonDetailsCrewMemberRankOrRatingName.Contains(search) ||
t.sPersonDetailsCrewMemberRankOrRatingCdd.Contains(search) ||
t.sPersonDetailsPassangerPartOfEmbarkTnCdd.Contains(search) ||
t.sPersonDetailsPassangerPartOfEmbarkTnName.Contains(search) ||
t.sPersonDetailsPassangerPartOfDsmbarkTnCdd.Contains(search) ||
t.sPersonDetailsPassangerPartOfDsmbarkTnName.Contains(search) ||
t.sPersonDetailsPersonGenderCdd.Contains(search) ||
t.sPersonDetailsPersonPlaceOfBirthName.Contains(search) ||
t.sPersonDetailsPersonCountryOfBirthCdd.Contains(search) ||
t.sPersonIdOrTravelDocIssuingNationCdd.Contains(search) ||
t.sPersonIdOrTravelDocNo.Contains(search) ||
t.sPersonIdOrTravelDocTypeCdd.Contains(search) ||
t.sVisaDetailsPersonVisa.Contains(search) ||
t.sVisaDetailsPNRNo.Contains(search)
) &&
t.iActionBy == userId &&
t.iMessageImplementationId == iMessageImplementationId
select t;
recordsTotal = query.Count();
return(query.OrderBy(z => z.sPersonDetailsPersonFamilyName).Skip(start).Take(length).ToList().Select(t => new
{
t.iMessageImplementationId,
t.dPersonOnBaordSeqNo,
t.iPersonOnBoardId,
t.sPersonDetailsPersonTypeCdd,
t.sPersonDetailsPersonFamilyName,
t.sPersonDetailsPersonGivenName,
t.sPersonDetailsPersonNationalityCdd,
t.dPersonDetailsPassengersInTransitIndicator,
t.sPersonDetailsCrewMemberRankOrRatingName,
t.sPersonDetailsCrewMemberRankOrRatingCdd,
t.sPersonDetailsPassangerPartOfEmbarkTnCdd,
t.sPersonDetailsPassangerPartOfEmbarkTnName,
t.sPersonDetailsPassangerPartOfDsmbarkTnCdd,
t.sPersonDetailsPassangerPartOfDsmbarkTnName,
t.sPersonDetailsPersonGenderCdd,
dtPersonDetailsPersonDateOfBirth = t.dtPersonDetailsPersonDateOfBirth.ToDateString(),
t.sPersonDetailsPersonPlaceOfBirthName,
t.sPersonDetailsPersonCountryOfBirthCdd,
dtPersonIdDocExpiryDate = t.dtPersonIdDocExpiryDate.ToDateString(),
t.sPersonIdOrTravelDocIssuingNationCdd,
t.sPersonIdOrTravelDocNo,
t.sPersonIdOrTravelDocTypeCdd,
t.sVisaDetailsPersonVisa,
t.sVisaDetailsPNRNo
}).ToList());
}
}
public string GetMessageTypeByMasterConsignmentId(int iMasterConsignmentId, out int iMessageImplementationId)
{
using (var db = new SeaManifestEntities())
{
var query = db.tblMasterConsignmentMessageImplementationMaps.Where(z => z.iMasterConsignmentId == iMasterConsignmentId);
iMessageImplementationId = query.Select(z => z.iMessageImplementationId ?? 0).SingleOrDefault();
return(query.Select(z => z.tblMessageImplementation.sDecRefReportingEvent).SingleOrDefault());
}
}
public void Validate(int?iMasterConsignmentId)
{
using (var db = new SeaManifestEntities())
{
if (!db.tblMasterConsignmentMessageImplementationMaps.Any(z => z.iMasterConsignmentId == iMasterConsignmentId))
{
throw new Exception("Invalid Master Consignment Id");
}
}
}
public void Validate(int?iHouseCargoDescId)
{
using (var db = new SeaManifestEntities())
{
if (!db.tblHouseCargoDescriptionMasterConsignmentMaps.Any(z => z.iHouseCargoDescId == iHouseCargoDescId))
{
throw new Exception("Invalid House Cargo Desc Id");
}
}
}
public List <SelectListItem> GetCodesByType(string Type)
{
using (var db = new SeaManifestEntities())
{
return(db.tblCodeMs.Where(z => z.tblCodeTypeM.sCodeType == Type).ToList().Select(z => new SelectListItem
{
Value = z.sCode.ToString(),
Text = z.sCodeName
}).ToList());
}
}
public List <SelectListItem> GetCurrencyCodes()
{
using (var db = new SeaManifestEntities())
{
return(db.tblCurrencyCodesMs.Select(z => new SelectListItem
{
Text = z.sCurrencyName,
Value = z.sCurrencyCode
}).ToList());
}
}
public RoleModel GetRoleById(byte iRoleId)
{
using (var db = new SeaManifestEntities())
{
return(db.tblRoleMs.Where(x => x.iRoleId == iRoleId).Select(z => new RoleModel
{
iRoleId = z.iRoleId,
sRolename = z.sRoleName,
}).SingleOrDefault());
}
}
public List <SelectListItem> GetPorts()
{
using (var db = new SeaManifestEntities())
{
return(db.tblPortMs.ToList().Select(z => new SelectListItem
{
Value = z.sPortCode.ToString(),
Text = z.sPortDescription
}).ToList());
}
}
public List <SelectListItem> GetPermissions()
{
using (var db = new SeaManifestEntities())
{
return(db.tblPermissionMs.ToList().Select(z => new SelectListItem
{
Text = z.sPermissionName,
Value = z.iPermissionId.ToString()
}).ToList());
}
}
public object GetRoles()
{
using (var db = new SeaManifestEntities())
{
return(db.tblRoleMs.ToList().Select(z => new
{
Text = z.sRoleName,
Value = z.iRoleId.ToString()
}).ToList());
}
}
//save SupportDocMasterConsignment
public object SaveSupportDocMasterConsignment(SupportDocMasterConsignmentModel model, int iUserId)
{
try
{
using (var db = new SeaManifestEntities())
{
var data = db.tblSupportDocMasterConsignmentMaps.Where(z => z.iSupportDocsId == model.iSupportDocsId).SingleOrDefault();
if (data != null)
{
data.iMasterConsignmentId = model.iMasterConsignmentId ?? 0;
data.iMessageImplementationId = model.iMessageImplementationId;
data.sTagRef = model.sTagRef;
data.sRefSerialNo = model.sRefSerialNo;
data.sSubSerialNoRef = model.sSubSerialNoRef;
data.sIcegateUserId = model.sIcegateUserId;
data.sIRNNo = model.sIRNNo;
data.sDocRefNo = model.sDocRefNo;
data.sDocTypeCd = model.sDocTypeCd;
data.sBeneficiaryCd = model.sBeneficiaryCd;
data.iActionBy = iUserId;
data.dtActionDate = DateTime.Now;
db.Entry(data).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
data = new tblSupportDocMasterConsignmentMap
{
iMasterConsignmentId = model.iMasterConsignmentId ?? 0,
iMessageImplementationId = model.iMessageImplementationId,
sTagRef = model.sTagRef,
sRefSerialNo = model.sRefSerialNo,
sSubSerialNoRef = model.sSubSerialNoRef,
sIcegateUserId = model.sIcegateUserId,
sIRNNo = model.sIRNNo,
sDocRefNo = model.sDocRefNo,
sDocTypeCd = model.sDocTypeCd,
sBeneficiaryCd = model.sBeneficiaryCd,
iActionBy = iUserId,
dtActionDate = DateTime.Now,
};
db.tblSupportDocMasterConsignmentMaps.Add(data);
db.SaveChanges();
}
return(new { Status = true, Message = "Support Doc saved successfully!" });
}
}
catch (Exception)
{
return(new { Status = false, Message = "Something went wrong" });
}
}
public List <RoleModel> GetRoles(int draw, int displayStart, int displayLength, out int recordsTotal)
{
using (var db = new SeaManifestEntities())
{
var data = db.tblRoleMs.OrderBy(z => z.sRoleName).Skip(displayStart).Take(displayLength).Select(z => new RoleModel
{
iRoleId = z.iRoleId,
sRolename = z.sRoleName,
}).ToList();
recordsTotal = db.tblRoleMs.Count();
return(data);
}
}
public PortModel GetPortByPortId(int?iPortId)
{
using (var db = new SeaManifestEntities())
{
return(db.tblPortMs.Where(z => z.iPortId == iPortId).ToList().Select(model => new PortModel
{
sPortCode = model.sPortCode,
sPortDescription = model.sPortDescription,
sCountryCode = model.sCountryCode,
SstateCode = model.SstateCode,
}).SingleOrDefault());
}
}
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);
}
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);
}
public PermissionInputModel GetPermissionById(byte iPermissionId)
{
using (var db = new SeaManifestEntities())
{
return(db.tblPermissionMs.Where(x => x.iPermissionId == iPermissionId).Select(z => new PermissionInputModel
{
iPermissionId = z.iPermissionId,
sPermissionName = z.sPermissionName,
iOrder = z.iOrder ?? 0,
iParentId = z.iParentId,
sPath = z.sPath
}).SingleOrDefault());
}
}
public object SaveUser(UserModel model, int iUserId)
{
using (var db = new SeaManifestEntities())
{
var data = db.tblUserMs.Where(z => z.iUserId == model.iUserId).SingleOrDefault();
if (data == null)
{
if (db.tblUserMs.Any(z => z.sUserName == model.sUsername))
{
return(new { Status = false, Message = "User already exists" });
}
else
{
data = new tblUserM
{
sFirstName = model.sFirstName,
sLastName = model.sLastName,
sPassword = Crypto.Encrypt(model.sPassword),
iRoleId = model.iRoleId,
sPhoneNumber = model.sPhoneNo,
sUserName = model.sUsername,
sEmailId = model.sEmailID,
};
db.tblUserMs.Add(data);
db.SaveChanges();
return(new { Status = true, Message = "User saved successfully!" });
}
}
else
{
if (db.tblUserMs.Any(z => z.sUserName == model.sUsername && z.iUserId != model.iUserId))
{
return(new { Status = false, Message = "User already exists" });
}
else
{
data.sFirstName = model.sFirstName;
data.sLastName = model.sLastName;
data.sPassword = Crypto.Encrypt(model.sPassword);
data.iRoleId = model.iRoleId;
data.sPhoneNumber = model.sPhoneNo;
data.sUserName = model.sUsername;
data.sEmailId = model.sEmailID;
db.Entry(data).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(new { Status = true, Message = "User saved successfully!" });
}
}
}
}
//save AdditionalDetailsHouseCargo
public object SaveAdditionalDetailsHouseCargo(AdditionalDetailsHouseCargoModel model, int iUserId)
{
try
{
using (var db = new SeaManifestEntities())
{
var data = db.tblAdditionalDetailsHouseCargoMaps.Where(z => z.iAdditionalDetailsId == model.iAdditionalDetailsId).SingleOrDefault();
if (data != null)
{
data.iHouseCargoDescId = model.iHouseCargoDescId;
data.sTagRef = model.sTagRef;
data.dRefSerialNo = model.dRefSerialNo;
data.sInfoType = model.sInfoType;
data.sInfoQualifier = model.sInfoQualifier;
data.sInfoCd = model.sInfoCd;
data.sInfoText = model.sInfoText;
data.sInfoMsr = model.sInfoMsr;
data.dtInfoDate = model.sInfoDate.ToDate();
data.iActionBy = iUserId;
data.dtActionDate = DateTime.Now;
db.Entry(data).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
data = new tblAdditionalDetailsHouseCargoMap
{
iHouseCargoDescId = model.iHouseCargoDescId,
sTagRef = model.sTagRef,
dRefSerialNo = model.dRefSerialNo,
sInfoType = model.sInfoType,
sInfoQualifier = model.sInfoQualifier,
sInfoCd = model.sInfoCd,
sInfoText = model.sInfoText,
sInfoMsr = model.sInfoMsr,
dtInfoDate = model.sInfoDate.ToDate(),
iActionBy = iUserId,
dtActionDate = DateTime.Now,
};
db.tblAdditionalDetailsHouseCargoMaps.Add(data);
db.SaveChanges();
}
return(new { Status = true, Message = "Additional Details saved successfully!" });
}
}
catch (Exception)
{
return(new { Status = false, Message = "Something went wrong" });
}
}
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" });
}
}
public void Validate(int?iHouseCargoDescId)
{
using (var db = new SeaManifestEntities())
{
if (!db.tblHouseCargoDescriptionMasterConsignmentMaps.Any(z => z.iHouseCargoDescId == iHouseCargoDescId))
{
throw new Exception("Invalid House Cargo Id");
}
if (db.tblHouseCargoDescriptionMasterConsignmentMaps.Any(z => z.iHouseCargoDescId == iHouseCargoDescId && (z.tblMessageImplementation.sDecRefReportingEvent == "SEI" || z.tblMessageImplementation.sDecRefReportingEvent == "SDN")))
{
throw new Exception("Item Details cannot be filled with SEI or SDN reporting type");
}
}
}
public bool ValidateHouseCargo(HouseCargoModel model, out string Messages)
{
Messages = string.Empty;
bool valid = true;
using (var db = new SeaManifestEntities())
{
if (db.tblHouseCargoDescriptionMasterConsignmentMaps.Any(z => (model.sReportingEvent != "SEI" && model.sReportingEvent != "SDN") && z.iHouseCargoDescId != model.iHouseCargoDescId && z.dHCRefSubLineNo == model.dHCRefSubLineNo && z.iMasterConsignmentId == model.iMasterConsignmentId))
{
valid = false; Messages = "Sub Line No already exists";
}
}
return(valid);
}
public AmendmentDetailsMessageImlementationModel GetAmendmentDetailsMessageImlementationByAmendmentId(int?iAmendmentId)
{
using (var db = new SeaManifestEntities())
{
return(db.tblAmendmentDetailsMessageImlementationMaps.Where(z => z.iAmendmentId == iAmendmentId).ToList().Select(model => new AmendmentDetailsMessageImlementationModel
{
iMessageImplementationId = model.iMessageImplementationId,
iAmendmentId = model.iAmendmentId,
sAmendRefNo = model.sAmendRefNo,
sAmendFlag = model.sAmendFlag,
sAmendType = model.sAmendType,
}).SingleOrDefault());
}
}
public object GetTransportEquipmentMessageImplementation(int iMessageImplementationId, string search, int start, int length, out int recordsTotal)
{
using (var db = new SeaManifestEntities())
{
var userId = GetUserInfo().iUserId;
var query = from t in db.tblVoyageTransporterEquipmentMessageImplementationMaps
where
(t.sEquipmentId.Contains(search) ||
t.sEquipmentType.Contains(search) ||
t.sEquipmentSize.Contains(search) ||
t.sEquipmentLoadStatus.Contains(search) ||
t.sAdditionalEquipmentHold.Contains(search) ||
t.sEquipmentSealType.Contains(search) ||
t.sEquipmentSealNo.Contains(search) ||
t.sOtherEquipmentId.Contains(search) ||
t.sSOCFlag.Contains(search) ||
t.sContainerAgentCode.Contains(search) ||
SqlFunctions.StringConvert(t.dContainerWeight).Contains(search) ||
SqlFunctions.StringConvert(t.dTotalNoOfPackages).Contains(search)
) &&
t.iActionBy == userId &&
t.iMessageImplementationId == iMessageImplementationId
select t;
recordsTotal = query.Count();
return(query.OrderBy(z => z.sEquipmentType).Skip(start).Take(length).ToList().Select(t => new
{
t.iVoyageTransportId,
t.iMessageImplementationId,
t.iEquipmentSequenceNo,
t.sEquipmentId,
t.sEquipmentType,
t.sEquipmentSize,
t.sEquipmentLoadStatus,
t.sAdditionalEquipmentHold,
sEventDate = t.dtEventDate.ToDateString(),
t.sEquipmentSealType,
t.sEquipmentSealNo,
t.sOtherEquipmentId,
t.sSOCFlag,
t.sContainerAgentCode,
t.dContainerWeight,
t.dTotalNoOfPackages,
t.sEquipmentStatus,
t.sFinalLocation,
t.sStoragePositionCoded,
}).ToList());
}
}
