public PelayaranView(VisitaJayaPerkasa.Entities.Pelayaran pelayaran) { InitializeComponent(); 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; lblPelayaranName.Text = pelayaran.supplierName; }
public RptContainerControl() { InitializeComponent(); pickerATD.Value = DateTime.Today; SqlPelayaranRepository pelayaranRepository = new SqlPelayaranRepository(); listPelayaran = pelayaranRepository.GetVessels(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cbVessel.DataSource = listPelayaran; cbVessel.DisplayMember = "VesselName"; cbVessel.ValueMember = "PelayaranDetailID"; cbVessel.SelectedIndex = -1; cbVessel.Text = Constant.VisitaJayaPerkasaApplication.cboDefaultText; }
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() { sqlPelataranRepository = new SqlPelayaranRepository(); pelayaran = null; string searchValue = radTextBoxElementSearchWord.Text; string searchKey = radComboBoxElement.Text; pelayaran = sqlPelataranRepository.GetPelayaran(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else if (pelayaran != null) { if (!string.IsNullOrEmpty(searchValue) && !string.IsNullOrEmpty(searchKey)) { switch (searchKey) { case "Name": showPelayaran = pelayaran.Where(c => c.supplierName.Contains(searchValue)).ToList<VisitaJayaPerkasa.Entities.Pelayaran>(); break; } } else showPelayaran = pelayaran; } else showPelayaran = null; if (showPelayaran != null) { totalPage = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(showPelayaran.Count() / Convert.ToDecimal(pageSize)))); currentPage = 1; } else totalPage = 0; }
private void SaveData() { SqlPelayaranRepository sqlPelayaranRepository = null; if (wantToCreateVessel) { sqlPelayaranRepository = new SqlPelayaranRepository(); Guid newGuid = Guid.NewGuid(); string[] strSqlParam = getStringSqlParameter(); object[] objSqlParam = GetObjSqlParameter(newGuid); SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(strSqlParam, objSqlParam); if (sqlPelayaranRepository.CheckPelayaran(sqlParam, Guid.Empty, true)) { DialogResult dResult = MessageBox.Show(this, "Pelayaran has already deleted. Do you want to activate ?", "Confirmation", MessageBoxButtons.YesNo); if (dResult == DialogResult.Yes) { if (sqlPelayaranRepository.ActivatePelayaran(sqlParam)) { MessageBox.Show(this, "Success Activate Pelayaran", "Information"); radButtonElement2.PerformClick(); } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else MessageBox.Show(this, "Cannot Activate Pelayaran", "Information"); sqlParam = null; } return; } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (sqlPelayaranRepository.CheckPelayaran(sqlParam, Guid.Empty)) { MessageBox.Show(this, "Pelayaran has already exists", "Information"); return; } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (sqlPelayaranRepository.CreatePelayaran(sqlParam)) { MessageBox.Show(this, "Success insert pelayaran data", "Information"); Constant.VisitaJayaPerkasaApplication.mainForm.ShowUserControl(new SupplierList()); } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else { MessageBox.Show(this, "Cannot insert pelayaran data", "Information"); } sqlPelayaranRepository = null; strSqlParam = null; objSqlParam = null; sqlParam = null; } else { sqlPelayaranRepository = new SqlPelayaranRepository(); string[] strSqlParam = getStringSqlParameter(); object[] objSqlParam = GetObjSqlParameter(pelayaran.ID); SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(strSqlParam, objSqlParam); if (sqlPelayaranRepository.CheckPelayaran(sqlParam, this.pelayaran.ID)) { MessageBox.Show(this, "Pelayaran has already exist. if it has already deleted. you must activate it with create new data", "Information"); return; } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (sqlPelayaranRepository.EditPelayaran(sqlParam)) { MessageBox.Show(this, "Success edit pelayaran data", "Information"); Constant.VisitaJayaPerkasaApplication.mainForm.ShowUserControl(new SupplierList()); } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else { MessageBox.Show(this, "Cannot edit pelayaran data", "Information"); } sqlPelayaranRepository = null; strSqlParam = null; objSqlParam = null; sqlParam = null; } }
public ScheduleEdit(VisitaJayaPerkasa.Entities.Schedule schedule) { InitializeComponent(); sqlCityRepository = new SqlCityRepository(); sqlPelayaranRepository = new SqlPelayaranRepository(); this.schedule = schedule; List<VisitaJayaPerkasa.Entities.City> listCity = sqlCityRepository.GetCity(); List<VisitaJayaPerkasa.Entities.PelayaranDetail> listPelayaran = sqlPelayaranRepository.GetVessels(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cboTujuan.DataSource = listCity; cboTujuan.DisplayMember = "CityName"; cboTujuan.ValueMember = "ID"; cboKapal.DataSource = listPelayaran; cboKapal.DisplayMember = "VesselName"; cboKapal.ValueMember = "VesselCodeAndPelayaranID"; if (schedule == null) { wantToCreateVessel = true; cboTujuan.SelectedIndex = -1; cboTujuan.Text = Constant.VisitaJayaPerkasaApplication.cboDefaultText; cboKapal.SelectedIndex = -1; cboKapal.Text = Constant.VisitaJayaPerkasaApplication.cboDefaultText; lblETA.Visible = false; lblTA.Visible = false; lblTD.Visible = false; lblUnloading.Visible = false; pickerETA.Visible = false; pickerTA.Visible = false; pickerTD.Visible = false; pickerUnLoading.Visible = false; pickerETD.Value = DateTime.Now; pickerUnLoading.Value = DateTime.Now; pickerTglClosing.Value = DateTime.Now; } else { wantToCreateVessel = false; DialogResult dResult = MessageBox.Show(this, "Are you sure want to edit TD, TA and etc ? ", "Confirmation", MessageBoxButtons.YesNo); if (dResult == DialogResult.Yes) wantToEditTdETC = true; else wantToEditTdETC = false; cboTujuan.SelectedItem = schedule.berangkatTujuan; cboKapal.SelectedItem = schedule.namaKapal; etVOY.Text = schedule.voy; pickerETD.Value = schedule.etd; pickerUnLoading.Value = schedule.unLoading.GetValueOrDefault(DateTime.Now); pickerTglClosing.Value = schedule.tglclosing; etRObegin20.Text = schedule.ro_begin_20.ToString(); etRObegin40.Text = schedule.ro_begin_40.ToString(); etKet.Text = schedule.keterangan; lblETA.Visible = true; lblTA.Visible = true; lblTD.Visible = true; pickerETA.Visible = true; pickerTA.Visible = true; pickerTD.Visible = true; pickerETA.Value = DateTime.Now; pickerTA.Value = DateTime.Now; pickerTD.Value = DateTime.Now; if (wantToEditTdETC) { cboTujuan.Enabled = false; cboKapal.Enabled = false; etVOY.Enabled = false; pickerETD.Enabled = false; pickerTglClosing.Enabled = false; pickerUnLoading.Enabled = false; etRObegin20.Enabled = false; etRObegin40.Enabled = false; etKet.Enabled = false; VisitaJayaPerkasa.Entities.City tempCity = sqlCityRepository.GetCityByID(cboTujuan.SelectedValue.ToString()); if (tempCity.Deleted == 1) MessageBox.Show(this, "ETA not same like city, because city has already be deleted", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); else { pickerETA.Value = DateTime.Now.AddDays(tempCity.Days); pickerTA.Value = DateTime.Now.AddDays(tempCity.Days); } tempCity = null; } else { lblETA.Visible = false; lblTA.Visible = false; lblTD.Visible = false; pickerETA.Visible = false; pickerTA.Visible = false; pickerTD.Visible = false; } } listCity = null; sqlCityRepository = null; }
private void SaveData() { SqlSupplierRepository sqlSupplierRepository = null; if (wantToCreateVessel) { sqlSupplierRepository = new SqlSupplierRepository(); newGuid = Guid.NewGuid(); string[] strSqlParam = getStringSqlParameter(); object[] objSqlParam = GetObjSqlParameter(newGuid); SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(strSqlParam, objSqlParam); if (sqlSupplierRepository.CheckSupplier(sqlParam, Guid.Empty, true)) { DialogResult dResult = MessageBox.Show(this, "Supplier has already deleted. Do you want to activate ?", "Confirmation", MessageBoxButtons.YesNo); if (dResult == DialogResult.Yes) { if (sqlSupplierRepository.ActivateSupplier(sqlParam)) { MessageBox.Show(this, "Success Activate Supplier", "Information"); radButtonElement2.PerformClick(); } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else MessageBox.Show(this, "Cannot Activate Supplier", "Information"); sqlParam = null; } return; } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (sqlSupplierRepository.CheckSupplier(sqlParam, Guid.Empty)) { MessageBox.Show(this, "Supplier has already exists", "Information"); return; } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (sqlSupplierRepository.CreateSupplier(sqlParam, (groupBoxTrucking.Visible) ? gvTrucking.RowCount : 0, (groupBoxDestination.Visible) ? gvDestination.RowCount : 0)) { MessageBox.Show(this, "Success insert supplier data", "Information"); if (isSaveMasterSupplierDetail) { SqlPelayaranRepository sqlPelayaranRepository = new SqlPelayaranRepository(); VisitaJayaPerkasa.Entities.Pelayaran pelayaran = sqlPelayaranRepository.GetPelayaranBySupplierID((wantToCreateVessel) ? newGuid.ToString() : this.supplier.Id.ToString()); UserControl controllers = new Pelayaran.PelayaranEdit(pelayaran, this); Constant.VisitaJayaPerkasaApplication.mainForm.ShowUserControl(controllers); sqlPelayaranRepository = null; } else radButtonElement2.PerformClick(); } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else { MessageBox.Show(this, "Cannot insert supplier data", "Information"); } sqlSupplierRepository = null; strSqlParam = null; objSqlParam = null; sqlParam = null; } else { sqlSupplierRepository = new SqlSupplierRepository(); string[] strSqlParam = getStringSqlParameter(); object[] objSqlParam = GetObjSqlParameter(supplier.Id); SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(strSqlParam, objSqlParam); if (sqlSupplierRepository.CheckSupplier(sqlParam, this.supplier.Id)) { MessageBox.Show(this, "supplier has already exist. if it has already deleted. you must activate it with create new data", "Information"); return; } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (sqlSupplierRepository.EditSupplier(sqlParam, (groupBoxTrucking.Visible) ? gvTrucking.RowCount : 0, (groupBoxDestination.Visible) ? gvDestination.RowCount : 0)) { MessageBox.Show(this, "Success edit supplier data", "Information"); if (isSaveMasterSupplierDetail) { SqlPelayaranRepository sqlPelayaranRepository = new SqlPelayaranRepository(); VisitaJayaPerkasa.Entities.Pelayaran pelayaran = sqlPelayaranRepository.GetPelayaranBySupplierID(this.supplier.Id.ToString()); UserControl controllers = new Pelayaran.PelayaranEdit(pelayaran, this); Constant.VisitaJayaPerkasaApplication.mainForm.ShowUserControl(controllers); sqlPelayaranRepository = null; } else radButtonElement2.PerformClick(); } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else { MessageBox.Show(this, "Cannot edit supplier data", "Information"); } sqlSupplierRepository = null; strSqlParam = null; objSqlParam = null; sqlParam = null; } }
private void cboKeySearch_SelectedIndexChanged(object sender, EventArgs e) { if (cboKeySearch.Text.Equals("Destination")) { SqlCityRepository sqlCityRepository = new SqlCityRepository(); List<VisitaJayaPerkasa.Entities.City> listCity = sqlCityRepository.GetCity(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cboValueSearch.DataSource = null; cboValueSearch.DataSource = listCity; cboValueSearch.DisplayMember = "CityName"; cboValueSearch.ValueMember = "ID"; txtRoSearch.Visibility = Telerik.WinControls.ElementVisibility.Collapsed; cboValueSearch.Visibility = Telerik.WinControls.ElementVisibility.Visible; listCity = null; sqlCityRepository = null; } else if (cboKeySearch.Text.Equals("VOY")) { cboValueSearch.Visibility = Telerik.WinControls.ElementVisibility.Collapsed; txtRoSearch.Visibility = Telerik.WinControls.ElementVisibility.Visible; } else if (cboKeySearch.Text.Equals("Vessel")) { SqlPelayaranRepository sqlPelayaranRepository = new SqlPelayaranRepository(); List<VisitaJayaPerkasa.Entities.PelayaranDetail> listPelayaran = sqlPelayaranRepository.GetVessels(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cboValueSearch.DataSource = null; cboValueSearch.DataSource = listPelayaran; cboValueSearch.DisplayMember = "VesselName"; cboValueSearch.ValueMember = "VesselCode"; txtRoSearch.Visibility = Telerik.WinControls.ElementVisibility.Collapsed; cboValueSearch.Visibility = Telerik.WinControls.ElementVisibility.Visible; listPelayaran = null; sqlPelayaranRepository = null; } else if (cboKeySearch.Text.Equals("All")) { cboValueSearch.Visibility = Telerik.WinControls.ElementVisibility.Collapsed; txtRoSearch.Visibility = Telerik.WinControls.ElementVisibility.Collapsed; } }
private void radButtonElementRemove_Click(object sender, EventArgs e) { if (PelayaranGridView.SelectedRows.Count == 1) { sqlPelataranRepository = new SqlPelayaranRepository(); DialogResult dResult = MessageBox.Show(this, "Are you sure want delete this data ? ", "Confirmation", MessageBoxButtons.YesNo); if (dResult == DialogResult.Yes) { GridViewRowInfo gridInfo = PelayaranGridView.SelectedRows.First(); string id = gridInfo.Cells[0].Value.ToString(); SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(new string[] { "pelayaran_id" }, new object[] { id }); if (sqlPelataranRepository.DeletePelayaran(sqlParam)) { MessageBox.Show("Data Deleted !"); LoadData(); } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else MessageBox.Show("Cannot Delete Data !"); sqlParam = null; } } }
private void cboSelected_SelectedIndexChanged(object sender, EventArgs e) { sqlPelayaranRepository = new SqlPelayaranRepository(); try { RadComboBox cbo = sender as RadComboBox; if (cbo.Tag != null) { if (cbo.Tag.ToString() == "111") { List<VisitaJayaPerkasa.Entities.Schedule> listSchedule = sqlScheduleRepository.ListScheduleByDestination((Guid)cbo.SelectedValue); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cboPelayaranDetail.DataSource = listSchedule; cboPelayaranDetail.DisplayMember = "namaKapal"; //cboPelayaranDetail.ValueMember = "PelayaranDetailID"; cboPelayaranDetail.SelectedIndex = -1; cboPelayaranDetail.Text = "-- Choose --"; if (listSchedule == null) { MessageBox.Show(this, "No schedule in list", "Information"); return; } selectedIdx = cbo.SelectedIndex; dtpETA.Value = (dtpTD.Value.ToShortDateString() == DateTime.Today.ToShortDateString()) ? DateTime.Now : dtpTD.Value.AddDays(days.ElementAt(selectedIdx)); } else if (cbo.Tag.ToString() == "cboCustomer") { List<VisitaJayaPerkasa.Entities.WareHouse> listWarehouse = (this.customerTrans == null) ? sqlWarehouseRepository.GetWareHouse() : sqlWarehouseRepository.GetWareHouseByCustomer(customerTrans.CustomerID); List<VisitaJayaPerkasa.Entities.Recipient> listRecipient = (this.customerTrans == null) ? sqlRecipientRepository.GetRecipient() : sqlRecipientRepository.GetRecipientByCustomer(customerTrans.CustomerID); cboStuffingPlace.DataSource = listWarehouse; cboStuffingPlace.DisplayMember = "Address"; cboStuffingPlace.ValueMember = "Id"; cboStuffingPlace.SelectedIndex = -1; cboStuffingPlace.Text = "-- Choose --"; cboRecipient.DataSource = listRecipient; cboRecipient.DisplayMember = "Name"; cboRecipient.ValueMember = "ID"; cboRecipient.SelectedIndex = -1; cboRecipient.Text = "-- Choose --"; } } String custID, destID, typeID, condID; custID = destID = typeID = condID = null; if (!cboCustomer.Text.Equals(Constant.VisitaJayaPerkasaApplication.cboDefaultText)) custID = cboCustomer.SelectedValue.ToString(); if (!cboDestination.Text.Equals(Constant.VisitaJayaPerkasaApplication.cboDefaultText)) destID = cboDestination.SelectedValue.ToString(); if (!cboType.Text.Equals(Constant.VisitaJayaPerkasaApplication.cboDefaultText)) typeID = cboType.SelectedValue.ToString(); if (!cboCondition.Text.Equals(Constant.VisitaJayaPerkasaApplication.cboDefaultText)) condID = cboCondition.SelectedValue.ToString(); if (custID != null && destID != null && typeID != null && condID != null) { etPrice.Text = sqlPriceListRepository.SearchPriceList(DateTime.Now, custID, destID, typeID, condID).ToString(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (etPrice.Text.Equals("0")) etPrice.Text = sqlPriceListRepository.SearchPriceListGeneral(DateTime.Now, destID, typeID, condID).ToString(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else if (etPrice.Text.Equals("0")) MessageBox.Show(this, "No price for this customer", "Information"); } } catch (NullReferenceException ex) { etPrice.Text = "0"; Logging.Error("CustomerTransEdit.cs - CBSelected_Changed '" + ex.Message + "'"); } sqlPelayaranRepository = null; }
public CustomerTransEdit(VisitaJayaPerkasa.Entities.CustomerTrans customerTrans) { InitializeComponent(); this.customerTrans = customerTrans; sqlCustomerRepository = new SqlCustomerRepository(); sqlTypeContRepository = new SqlTypeContRepository(); sqlCityRepository = new SqlCityRepository(); sqlPelayaranRepository = new SqlPelayaranRepository(); sqlConditionRepository = new SqlConditionRepository(); sqlPriceListRepository = new SqlPriceListRepository(); sqlWarehouseRepository = new SqlWareHouseRepository(); sqlRecipientRepository = new SqlRecipientRepository(); sqlScheduleRepository = new SqlScheduleRepository(); sqlTruckingRepository = new SqlTruckingRepository(); sqlJenisBarangRepository = new SqlJenisBarangRepository(); List<VisitaJayaPerkasa.Entities.Customer> listCustomer = sqlCustomerRepository.ListCustomers(); List<VisitaJayaPerkasa.Entities.TypeCont> listType = sqlTypeContRepository.GetTypeCont(); List<VisitaJayaPerkasa.Entities.City> listOrigin = sqlCityRepository.GetCity(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } List<VisitaJayaPerkasa.Entities.City> listDestination = sqlCityRepository.GetCity(); List<VisitaJayaPerkasa.Entities.PelayaranDetail> listPelayaran = sqlPelayaranRepository.GetVessels(); List<VisitaJayaPerkasa.Entities.Schedule> listSchedule = sqlScheduleRepository.ListSchedule(); List<VisitaJayaPerkasa.Entities.Condition> listCondition = sqlConditionRepository.GetConditions(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } List<VisitaJayaPerkasa.Entities.WareHouse> listWarehouse; List<VisitaJayaPerkasa.Entities.Recipient> listRecipient; if (customerTrans != null) { listWarehouse = (this.customerTrans == null) ? sqlWarehouseRepository.GetWareHouse() : sqlWarehouseRepository.GetWareHouseByCustomer(customerTrans.CustomerID); listRecipient = (this.customerTrans == null) ? sqlRecipientRepository.GetRecipient() : sqlRecipientRepository.GetRecipientByCustomer(customerTrans.CustomerID); } else { listWarehouse = new List<Entities.WareHouse>(); listRecipient = new List<Entities.Recipient>(); } List<VisitaJayaPerkasa.Entities.Trucking> listTrucking = new List<Entities.Trucking>(); List<VisitaJayaPerkasa.Entities.JenisBarang> listJenisBarang = sqlJenisBarangRepository.ListJenisBarang(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } cboCustomer.DataSource = listCustomer; cboCustomer.DisplayMember = "CustomerName"; cboCustomer.ValueMember = "ID"; cboCustomer.SelectedIndex = -1; cboCustomer.Text = "-- Choose --"; cboCustomer.Tag = "cboCustomer"; cboType.DataSource = listType; cboType.DisplayMember = "TypeName"; cboType.ValueMember = "ID"; cboType.SelectedIndex = -1; cboType.Text = "-- Choose --"; cboOrigin.DataSource = listOrigin; cboOrigin.DisplayMember = "CityName"; cboOrigin.ValueMember = "ID"; cboOrigin.SelectedIndex = -1; cboOrigin.Text = "-- Choose --"; cboDestination.DataSource = listDestination; cboDestination.DisplayMember = "CityName"; cboDestination.ValueMember = "ID"; cboDestination.SelectedIndex = -1; cboDestination.Text = "-- Choose --"; days = from p in listDestination select p.Days; cboPelayaranDetail.DataSource = listSchedule; cboPelayaranDetail.DisplayMember = "namaKapal"; //cboPelayaranDetail.ValueMember = "ID"; cboPelayaranDetail.SelectedIndex = -1; cboPelayaranDetail.Text = "-- Choose --"; cboCondition.DataSource = listCondition; cboCondition.DisplayMember = "ConditionName"; cboCondition.ValueMember = "ID"; cboCondition.SelectedIndex = -1; cboCondition.Text = "-- Choose --"; cboStuffingPlace.DataSource = listWarehouse; cboStuffingPlace.DisplayMember = "Address"; cboStuffingPlace.ValueMember = "Id"; cboStuffingPlace.SelectedIndex = -1; cboStuffingPlace.Text = "-- Choose --"; cboRecipient.DataSource = listRecipient; cboRecipient.DisplayMember = "Name"; cboRecipient.ValueMember = "ID"; cboRecipient.SelectedIndex = -1; cboRecipient.Text = "-- Choose --"; cboTrucking.DataSource = listTrucking; cboTrucking.DisplayMember = "TruckNo"; cboTrucking.ValueMember = "ID"; cboTrucking.SelectedIndex = -1; cboTrucking.Text = "-- Choose --"; cboJenisBarang.DataSource = listJenisBarang; cboJenisBarang.DisplayMember = "Nama"; cboJenisBarang.ValueMember = "Nama"; cboJenisBarang.SelectedIndex = -1; cboJenisBarang.Text = "-- Type or Choose --"; if (customerTrans == null) { wantToCreateVessel = true; listCustomerTransDetail = new List<Entities.CustomerTransDetail>(); } else { wantToCreateVessel = false; cboCustomer.SelectedValue = customerTrans.CustomerID; cboCustomer.Enabled = false; SqlCustomerTransRepository sqlCustomerTransRepository = new SqlCustomerTransRepository(); listCustomerTransDetail = sqlCustomerTransRepository.ListCustomerTransDetail(customerTrans.CustomerTransID); ID = customerTrans.CustomerTransID; if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else if (listCustomerTransDetail != null) CustomerTransDetailGridView.DataSource = listCustomerTransDetail; else listCustomerTransDetail = new List<VisitaJayaPerkasa.Entities.CustomerTransDetail>(); sqlCustomerTransRepository = null; } cboCustomer.SelectedIndexChanged += new EventHandler(cboSelected_SelectedIndexChanged); cboType.SelectedIndexChanged += new EventHandler(cboSelected_SelectedIndexChanged); cboDestination.SelectedIndexChanged += new EventHandler(cboSelected_SelectedIndexChanged); cboCondition.SelectedIndexChanged += new EventHandler(cboSelected_SelectedIndexChanged); sqlCustomerRepository = null; sqlTypeContRepository = null; sqlCityRepository = null; sqlPelayaranRepository = null; sqlConditionRepository = null; if (wantToCreateVessel) { dtpTD.Visible = false; dtpETA.Visible = false; dtpTA.Visible = false; dtpUnloading.Visible = false; } }