public rptSupplyPriceControl() { InitializeComponent(); SqlCityRepository sqlCityRepository = new SqlCityRepository(); SqlTypeContRepository sqlTypeContRepository = new SqlTypeContRepository(); List<TypeCont> listTypeCont = sqlTypeContRepository.GetTypeCont(); List<City> listCity = sqlCityRepository.GetCity(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cboTypeCont.DataSource = listTypeCont; cboTypeCont.DisplayMember = "TypeName"; cboTypeCont.Value = "ID"; cboDestination.DataSource = listCity; cboDestination.DisplayMember = "CityName"; cboDestination.Value = "ID"; cboDestination.SelectedIndex = -1; cboDestination.Text = Constant.VisitaJayaPerkasaApplication.cboDefaultText; cboTypeCont.SelectedIndex = -1; cboTypeCont.Text = Constant.VisitaJayaPerkasaApplication.cboDefaultText; sqlCityRepository = null; sqlTypeContRepository = null; listTypeCont = null; listCity = null; }
public PriceListCustomer() { InitializeComponent(); listPriceDeleteExistsData = new List<Guid>(); listIndexPriceDeleteExistsData = new List<int>(); sqlTypeContRepository = new SqlTypeContRepository(); ListTypeCont = sqlTypeContRepository.GetTypeCont(); cboType.DataSource = ListTypeCont; cboType.DisplayMember = "TypeName"; cboType.ValueMember = "ID"; cboType.SelectedIndex = -1; cboType.SelectedText = Constant.VisitaJayaPerkasaApplication.cboDefaultText; sqlTypeContRepository = null; sqlCityRepository = new SqlCityRepository(); listCity = sqlCityRepository.GetCity(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); cbDestination.DataSource = listCity; cbDestination.DisplayMember = "CityName"; cbDestination.ValueMember = "ID"; cbDestination.SelectedIndex = -1; cbDestination.SelectedText = Constant.VisitaJayaPerkasaApplication.cboDefaultText; pickerFrom.Value = DateTime.Now; pickerTo.Value = DateTime.Now; sqlCityRepository = null; }
public void LoadDataInBackground() { sqlTypeContRepository = new SqlTypeContRepository(); TypeCont = null; string searchValue = radTextBoxElementSearchWord.Text; string searchKey = radComboBoxElement.Text; TypeCont = sqlTypeContRepository.GetTypeCont(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); else if (TypeCont != null) { if (!string.IsNullOrEmpty(searchValue) && !string.IsNullOrEmpty(searchKey)) { switch (searchKey) { case "Code": ShowTypeCont = TypeCont.Where(c => c.TypeCode.Contains(searchValue)).ToList<VisitaJayaPerkasa.Entities.TypeCont>(); break; case "Name": ShowTypeCont = TypeCont.Where(c => c.TypeName.Contains(searchValue)).ToList<VisitaJayaPerkasa.Entities.TypeCont>(); break; } } else ShowTypeCont = TypeCont; } else ShowTypeCont = null; if (ShowTypeCont != null) { totalPage = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(ShowTypeCont.Count() / Convert.ToDecimal(pageSize)))); currentPage = 1; } else totalPage = 0; }
private void radButtonElementRemove_Click(object sender, EventArgs e) { if (TypeContGridView.SelectedRows.Count == 1) { sqlTypeContRepository = new SqlTypeContRepository(); DialogResult dResult = MessageBox.Show(this, "Are you sure want delete this data ? ", "Confirmation", MessageBoxButtons.YesNo); if (dResult == DialogResult.Yes) { GridViewRowInfo gridInfo = TypeContGridView.SelectedRows.First(); string id = gridInfo.Cells[0].Value.ToString(); SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(new string[] { "type_id" }, new object[] { id }); if (sqlTypeContRepository.DeleteTypeCont(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 LoadCboGridView() { sqlSupplierRepository = new SqlSupplierRepository(); sqlCityRepository = new SqlCityRepository(); sqlTypeContRepository = new SqlTypeContRepository(); sqlConditionRepository = new SqlConditionRepository(); List<VisitaJayaPerkasa.Entities.Supplier> listTempSupplier = new List<Entities.Supplier>(); listTempSupplier.Add(listSupplier.ElementAt(cbSupplier.SelectedIndex)); ((GridViewComboBoxColumn)this.PriceListGridView.Columns[3]).DataSource = listTempSupplier; ((GridViewComboBoxColumn)this.PriceListGridView.Columns[3]).DisplayMember = "SupplierName"; ((GridViewComboBoxColumn)this.PriceListGridView.Columns[3]).ValueMember = "Id"; if (cboTypeSupplier.Text.ToLower().Equals("shipping lines") || cboTypeSupplier.Text.ToLower().Equals("dooring agent") ) { List<VisitaJayaPerkasa.Entities.City> listTempCity = new List<Entities.City>(); listTempCity.Add(listCity.ElementAt(cbDestination.SelectedIndex)); ((GridViewComboBoxColumn)this.PriceListGridView.Columns[4]).DataSource = listTempCity; ((GridViewComboBoxColumn)this.PriceListGridView.Columns[4]).DisplayMember = "CityName"; ((GridViewComboBoxColumn)this.PriceListGridView.Columns[4]).ValueMember = "ID"; listTempCity = null; } listType = sqlTypeContRepository.GetTypeCont(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); ((GridViewComboBoxColumn)this.PriceListGridView.Columns[5]).DataSource = listType; ((GridViewComboBoxColumn)this.PriceListGridView.Columns[5]).DisplayMember = "TypeName"; ((GridViewComboBoxColumn)this.PriceListGridView.Columns[5]).ValueMember = "ID"; if (cboTypeSupplier.Text.ToLower().Equals("shipping lines")) { listCondition = sqlConditionRepository.GetConditions(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); ((GridViewComboBoxColumn)this.PriceListGridView.Columns[6]).DataSource = listCondition; ((GridViewComboBoxColumn)this.PriceListGridView.Columns[6]).DisplayMember = "ConditionName"; ((GridViewComboBoxColumn)this.PriceListGridView.Columns[6]).ValueMember = "ID"; } if (cboTypeSupplier.Text.ToLower().Equals("shipping lines") || cboTypeSupplier.Text.ToLower().Equals("trucking") ) { listCustomer = sqlCustomerRepository.ListCustomers(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); ((GridViewComboBoxColumn)this.PriceListGridView.Columns[10]).DataSource = listCustomer; ((GridViewComboBoxColumn)this.PriceListGridView.Columns[10]).DisplayMember = "CustomerName"; ((GridViewComboBoxColumn)this.PriceListGridView.Columns[10]).ValueMember = "ID"; } listTempSupplier = null; if (cboTypeSupplier.Text.ToLower().Equals("dooring agent")) { List<VisitaJayaPerkasa.Entities.Recipient> tempListRecipient = sqlRecipientRepository.GetRecipient(); if (!Constant.VisitaJayaPerkasaApplication.anyConnection) MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); ((GridViewComboBoxColumn)this.PriceListGridView.Columns[8]).DataSource = tempListRecipient; ((GridViewComboBoxColumn)this.PriceListGridView.Columns[8]).DisplayMember = "Name"; ((GridViewComboBoxColumn)this.PriceListGridView.Columns[8]).ValueMember = "ID"; tempListRecipient = null; } if (cboTypeSupplier.Text.ToLower().Equals("trucking")) { List<VisitaJayaPerkasa.Entities.WareHouse> tempListWarehouse = new List<Entities.WareHouse>(); tempListWarehouse.Add(listWarehouse.ElementAt(cboStuffingPlace.SelectedIndex)); ((GridViewComboBoxColumn)this.PriceListGridView.Columns[7]).DataSource = tempListWarehouse; ((GridViewComboBoxColumn)this.PriceListGridView.Columns[7]).DisplayMember = "Address"; ((GridViewComboBoxColumn)this.PriceListGridView.Columns[7]).ValueMember = "Id"; tempListWarehouse = null; } sqlSupplierRepository = null; sqlCityRepository = null; sqlTypeContRepository = null; sqlConditionRepository = 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; } }
private void radButtonElement1_Click(object sender, EventArgs e) { if (etTypeCode.Text.Trim().Length == 0) MessageBox.Show(this, "Please fill type code", "Information"); else if (etTypeName.Text.Trim().Length == 0) MessageBox.Show(this, "Please fill type name", "Information"); else { SqlTypeContRepository sqlTypeContRepository = new SqlTypeContRepository(); SqlParameter[] param = SqlUtility.SetSqlParameter(new string[] { "type_code", "type_name" }, new object[] { etTypeCode.Text.Trim(), etTypeName.Text.Trim() }); if (wantToCreateVessel) { VisitaJayaPerkasa.Entities.TypeCont typeCont = new VisitaJayaPerkasa.Entities.TypeCont(); typeCont.ID = Guid.NewGuid(); typeCont.TypeCode = etTypeCode.Text.Trim(); typeCont.TypeName = etTypeName.Text.Trim(); typeCont.Deleted = 0; if (sqlTypeContRepository.CheckTypeCont(param, Guid.Empty, true)) { DialogResult dResult = MessageBox.Show(this, "Type cont has already deleted. Do you want to activate ?", "Confirmation", MessageBoxButtons.YesNo); if (dResult == DialogResult.Yes) { SqlParameter[] parameters = SqlUtility.SetSqlParameter(new string[] { "type_id", "type_code", "type_name", "deleted" } , new object[] { typeCont.ID, typeCont.TypeCode, typeCont.TypeName, typeCont.Deleted }); if (sqlTypeContRepository.ActivateTypeCont(parameters)) { MessageBox.Show(this, "Success Activate Type Cont", "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 Type Cont", "Information"); parameters = null; } return; } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else if (sqlTypeContRepository.CheckTypeCont(param, Guid.Empty)) { MessageBox.Show(this, "Type cont has already exists", "Information"); return; } else if (!Constant.VisitaJayaPerkasaApplication.anyConnection) { MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(new string[] { "type_id", "type_code", "type_name", "deleted" } , new object[] { typeCont.ID, typeCont.TypeCode, typeCont.TypeName, typeCont.Deleted }); if (sqlTypeContRepository.CreateTypeCont(sqlParam)) { MessageBox.Show(this, "Success create type cont", "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 Create type cont", "Information"); } } else { typeCont.ID = this.typeCont.ID; typeCont.TypeCode = etTypeCode.Text.Trim(); typeCont.TypeName = etTypeName.Text.Trim(); typeCont.Deleted = 0; if (sqlTypeContRepository.CheckTypeCont(param, typeCont.ID)) { MessageBox.Show(this, "Type cont 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; } SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(new string[] { "type_id", "type_code", "type_name", "deleted" } , new object[] { typeCont.ID, typeCont.TypeCode, typeCont.TypeName, typeCont.Deleted }); if (sqlTypeContRepository.EditTypeCont(sqlParam)) { MessageBox.Show(this, "Success edit type cont", "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 edit type cont", "Information"); } } // SqlParameter[] param; // if (wantToCreateVessel) // { // //Check vessel code has already exists ? // param = SqlUtility.SetSqlParameter(new string[] { "type_code" }, new object[] { etTypeCode.Text.Trim() }); // if (sqlTypeContRepository.CheckTypeCont(param)) // { // MessageBox.Show(this, "Type Cont has already exists !", "Information"); // return; // } // param = null; // param = SqlUtility.SetSqlParameter(new string[] { "type_id", "type_code", "type_name", "deleted" }, new object[] { Guid.NewGuid(), etTypeCode.Text.Trim(), etTypeName.Text.Trim(), 0 }); // if (sqlTypeContRepository.CreateTypeCont(param)) // { // MessageBox.Show(this, "Success create type cont", "Information"); // radButtonElement2.PerformClick(); // } // else // { // MessageBox.Show(this, "Cannot Create type cont", "Information"); // } // } // else // { // param = SqlUtility.SetSqlParameter(new string[] { "type_code", "type_name", "type_id" }, new object[] { etTypeCode.Text.Trim(), etTypeName.Text.Trim(), typeCont.ID }); // if (sqlTypeContRepository.EditTypeCont(param)) // { // MessageBox.Show(this, "Success Edit type cont", "Information"); // radButtonElement2.PerformClick(); // } // else // { // MessageBox.Show(this, "Cannot Edit type cont", "Information"); // } // } // param = null; // sqlTypeContRepository = null; } }