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()); } }