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