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