public bool AddOrUpdate(Company company, WTCCeresEntities db)
{
bool isSaved = true;
try
{
if (company.CompanyId == 0)
{
db.Company.Add(company);
}
else
{
db.Company.AddOrUpdate(company);
}
db.SaveChanges();
cp = company;
}
catch (Exception e)
{
string error = e.Message;
isSaved = false;
}
return(isSaved);
}
public bool AddOrUpdate(BookingDestination bookingDestination)
{
bool isSaved = true;
using (WTCCeresEntities db = new WTCCeresEntities())
{
try
{
if (bookingDestination.BookingDestinationId == 0)
{
db.BookingDestination.Add(bookingDestination);
}
else
{
db.BookingDestination.AddOrUpdate(bookingDestination);
}
db.SaveChanges();
}
catch (Exception ex)
{
string message = ex.Message;
isSaved = false;
}
}
return(isSaved);
}
public VW_BookingDestination GetVWById(int BookingDestinationId)
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.VW_BookingDestination.Where(bd => bd.BookingDestinationId == BookingDestinationId).ToList()[0]);
}
}
public List <UnitStatus> GetAll()
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.UnitStatus.OrderBy(us => us.StatusName).ToList());
}
}
public List <YardLocation> GetAll()
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.YardLocation.OrderBy(y => y.YardName).ToList());
}
}
public RelDistChangeReqSchedule GetById(int RelDistChangeReqScheduleId)
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.RelDistChangeReqSchedule.Find(RelDistChangeReqScheduleId));
}
}
public List <VW_CeresExcelPendingSyncBooking> GetAllVW()
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.VW_CeresExcelPendingSyncBooking.OrderBy(c => c.CreatedAt).ToList());
}
}
public VW_InboundRequest GetVWById(int InboundRequestId)
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.VW_InboundRequest.Where(ir => ir.InboundRequestId == InboundRequestId).ToList()[0]);
}
}
public List <VW_InboundRequest> GetByOpenStatus(bool isOpenRequest)
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.VW_InboundRequest.Where(ir => ir.IsOpenRequest == isOpenRequest).ToList());
}
}
public List <VW_CompanyCompanyType> GetAllCompany()
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.VW_CompanyCompanyType.ToList());
}
}
public InboundRequest GetById(int InboundRequestId)
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.InboundRequest.Find(InboundRequestId));
}
}
public List <VW_Company> GetAllActiveVWCompany()
{
var cList = new List <VW_Company>();
using (WTCCeresEntities db = new WTCCeresEntities())
{
foreach (Company c in db.Company.Where(c => c.IsActive == true).ToList())
{
VW_Company cvw = new VW_Company();
cvw.CompanyId = c.CompanyId;
cvw.CompanyCode = c.CompanyCode;
cvw.CompanyName = c.CompanyName;
cvw.Email = c.Email;
cvw.Website = c.Website;
cvw.Notes = c.Notes;
cvw.Rating = c.Rating;
cvw.Attention = c.Attention;
cvw.CompanyCategoryId = c.CompanyCategoryId;
cvw.CategoryName = c.CompanyCategory.Category;
cList.Add(cvw);
}
}
return(cList.OrderBy(c => c.CompanyName).ToList());
}
public CompanyType GetCompanyTypeIdByName(string CompanyType)
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.CompanyType.Where(c => c.DescCompanyType == CompanyType).ToList()[0]);
}
}
public List <CompanyType> GetAllCompanyType()
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.CompanyType.OrderBy(c => c.DescCompanyType).ToList());
}
}
public void loadForm()
{
ClearFields();
firstLoad = true;
using (var db = new WTCCeresEntities())
{
{
var withBlock = cboRateTier;
withBlock.DataSource = CompanyRateTypeService.GetAllCustomerRateType(db);
withBlock.DisplayMember = "RateCode";
withBlock.ValueMember = "CustomerRateTypeId";
}
cblCompanyType.DataSource = null;
{
var withBlock1 = cblCompanyType;
withBlock1.DataSource = CompanyTypeService.GetAll(db);
withBlock1.DisplayMember = "DescCompanyType";
withBlock1.ValueMember = "CompanyTypeId";
}
{
var withBlock2 = cboCompanyCategory;
withBlock2.DataSource = CompanyCategoryService.GetAll(db);
withBlock2.DisplayMember = "Category";
withBlock2.ValueMember = "CompanyCategoryId";
}
cboRateTier.SelectedValue = 0;
}
cboCompanyCategory.SelectedValue = 1;
isCustomer = true;
firstLoad = false;
}
public bool AddOrUpdate(InboundRequest inboundRequest)
{
bool isSaved = true;
using (WTCCeresEntities db = new WTCCeresEntities())
{
try
{
if (inboundRequest.InboundRequestId == 0)
{
db.InboundRequest.Add(inboundRequest);
}
else
{
db.InboundRequest.AddOrUpdate(inboundRequest);
}
db.SaveChanges();
ir = inboundRequest;
}
catch (Exception ex)
{
string msg = ex.Message;
isSaved = false;
}
}
return(isSaved);
}
public bool Insert(string VesselName, string VesselOwner, string Manager, decimal Capacity, int VesselYear, string Flag, bool IsActiveVessel)
{
bool isSave = true;
try
{
using (WTCCeresEntities d = new WTCCeresEntities())
{
v.VesselName = VesselName;
v.VesselOwner = VesselOwner;
v.Manager = Manager;
v.Capacity = Capacity;
v.VesselYear = VesselYear;
v.Flag = Flag;
v.IsActiveVessel = IsActiveVessel;
d.Vessel.Add(v);
d.SaveChanges();
}
}
catch (Exception ex)
{
string msg = ex.ToString();
isSave = false;
}
return(isSave);
}
public List <CompanyAddress> GetAll()
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.CompanyAddress.ToList());
}
}
public List <CeresExcelPendingSync> GetAll()
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.CeresExcelPendingSync.OrderBy(c => c.CreatedAt).ToList());
}
}
public CompanyAddress GetById(int Id)
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.CompanyAddress.Find(Id));
}
}
public List <CargoType> GetAll()
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.CargoType.OrderBy(ct => ct.CargoTypeName).ToList());
}
}
public List <VW_UnitSourceMiniUnit> GetAll(List <string> ExceptUnitStatuses)
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.VW_UnitSourceMiniUnit.Where(mu => ExceptUnitStatuses.Contains(mu.UnitStatus)).ToList());
}
}
public List <Country> GetAll()
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.Country.ToList());
}
}
public MiniUnit GetById(int MiniUnitId)
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.MiniUnit.Find(MiniUnitId));
}
}
public bool Delete(int MinibookingMiniUnitAssignmentId, bool IsStorageUnit)
{
bool isDeleted = true;
try
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
if (IsStorageUnit == false)
{
bus = db.MinibookingMiniUnitAssignment.Find(MinibookingMiniUnitAssignmentId);
db.MinibookingMiniUnitAssignment.Remove(bus);
}
else
{
gima = db.GrainInvMinibookingAssignment.Find(MinibookingMiniUnitAssignmentId);
db.GrainInvMinibookingAssignment.Remove(gima);
}
db.SaveChanges();
}
}
catch
{
isDeleted = false;
}
return(isDeleted);
}
public VW_UnitSourceMiniUnit GetVWByMUId(int MiniUnitId)
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.VW_UnitSourceMiniUnit.Where(mu => mu.MiniUnitId == MiniUnitId).ToList()[0]);
}
}
public BookingDestination GetById(int BookingDestinationId)
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.BookingDestination.Find(BookingDestinationId));
}
}
public bool InsertOrUpdate(MiniUnit MURecord)
{
bool isSaved = true;
using (WTCCeresEntities db = new WTCCeresEntities())
{
try
{
if (MURecord.MiniUnitId == 0)
{
db.MiniUnit.Add(MURecord);
}
else
{
db.MiniUnit.AddOrUpdate(MURecord);
}
db.SaveChanges();
}
catch (Exception ex)
{
string message = ex.Message;
isSaved = false;
}
}
return(isSaved);
}
public List <VesselVoyage> GetAll()
{
using (WTCCeresEntities d = new WTCCeresEntities())
{
return(d.VesselVoyage.ToList());
}
}
public List <VesselVoyageStatus> GetAll()
{
using (WTCCeresEntities db = new WTCCeresEntities())
{
return(db.VesselVoyageStatus.ToList());
}
}
