public rptSIControl() { InitializeComponent(); sqlScheduleRepository = new SqlScheduleRepository(); sqlCityRepository = new SqlCityRepository(); List<VisitaJayaPerkasa.Entities.Supplier> listSupplier; SqlSupplierRepository sqlSupplierRepository = new SqlSupplierRepository(); listSupplier = sqlSupplierRepository.ListSuppliers(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cboSupplier.DataSource = listSupplier; cboSupplier.DisplayMember = "SupplierName"; cboSupplier.SelectedIndex = -1; cboSupplier.ValueMember = "Id"; cboSupplier.Text = "-- Choose --"; List<VisitaJayaPerkasa.Entities.Schedule> listSchedule = sqlScheduleRepository.ListSchedule(); cboKapal.DataSource = listSchedule; cboKapal.DisplayMember = "namaKapal"; cboKapal.SelectedIndex = -1; cboKapal.Text = "-- Choose --"; List<VisitaJayaPerkasa.Entities.City> listDestination = sqlCityRepository.GetCity(); cboCity.DataSource = listDestination; cboCity.DisplayMember = "CityName"; cboCity.ValueMember = "ID"; cboCity.SelectedIndex = -1; cboCity.Text = "-- Choose --"; }
public PelayaranEdit(VisitaJayaPerkasa.Entities.Pelayaran pelayaran, UserControl ucSupplier) { InitializeComponent(); this.ucSupplier = ucSupplier; this.pelayaran = pelayaran; List<VisitaJayaPerkasa.Entities.Supplier> listSupplier; SqlSupplierRepository sqlSupplierRepository = new SqlSupplierRepository(); listSupplier = sqlSupplierRepository.ListSuppliers(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cbSupplier.DataSource = listSupplier; cbSupplier.DisplayMember = "SupplierName"; cbSupplier.ValueMember = "Id"; if (pelayaran == null) { wantToCreateVessel = true; listPelayaranDetail = new List<Entities.PelayaranDetail>(); cbSupplier.SelectedValue = ((SupplierEdit)ucSupplier).newGuid; } else { wantToCreateVessel = false; cbSupplier.SelectedValue = pelayaran.supplierID; SqlPelayaranRepository sqlPelayaranRepository = new SqlPelayaranRepository(); listPelayaranDetail = sqlPelayaranRepository.ListPelayaranDetail(pelayaran.ID); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else if (listPelayaranDetail != null) PelayaranDetailGridView.DataSource = listPelayaranDetail; else listPelayaranDetail = new List<VisitaJayaPerkasa.Entities.PelayaranDetail>(); sqlPelayaranRepository = null; } }
public void LoadDataInBackground() { sqlSupplierRepository = new SqlSupplierRepository(); Supliers = null; string searchValue = radTextBoxElementSearchWord.Text; string searchKey = radComboBoxElement.Text; Supliers = sqlSupplierRepository.ListSuppliers(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else if (Supliers != null) { if (!string.IsNullOrEmpty(searchValue) && !string.IsNullOrEmpty(searchKey)) { SqlParameter[] sqlParam; switch (searchKey) { case "Supplier Name": sqlParam = SqlUtility.SetSqlParameter(new string[] { "first_name" }, new object[] { searchValue }); Supliers = Supliers.Where(c => c.SupplierName.Contains(searchValue)).ToList<Entities.Supplier>(); break; } sqlParam = null; } } if (Supliers != null) { totalPage = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(Supliers.Count() / Convert.ToDecimal(pageSize)))); currentPage = 1; } else totalPage = 0; }