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