public SupplierView(Entities.Supplier supplier)
{
InitializeComponent();
sqlSupplierRepository = new SqlSupplierRepository();
listSupplierDetail = sqlSupplierRepository.ListSupplierDetail(supplier.Id);
if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
else if (listSupplierDetail != null)
SupplierDetailGridView.DataSource = listSupplierDetail;
lblSupplierName.Text = supplier.SupplierName;
lblCategoryName.Text = supplier.CategoryName;
lblAddres.Text = supplier.Address;
lblEmail.Text = supplier.Email;
lblPhone.Text = supplier.Phone;
lblFax.Text = supplier.Fax;
lblContactPerson.Text = supplier.ContactPerson;
if (supplier.CategoryName.Equals("Trucking")) {
gbTrucking.Visible = true;
List<string> listTemp = sqlSupplierRepository.ListTruckingNumber(supplier.Id);
if (listTemp != null)
for (int i = 0; i < listTemp.Count; i++)
gvTrucking.Rows.Add(listTemp.ElementAt(i));
listTemp = null;
}
}
public rptSIControl()
{
InitializeComponent();
sqlScheduleRepository = new SqlScheduleRepository();
sqlCityRepository = new SqlCityRepository();
List<VisitaJayaPerkasa.Entities.Supplier> listSupplier;
SqlSupplierRepository sqlSupplierRepository = new SqlSupplierRepository();
listSupplier = sqlSupplierRepository.ListSuppliers();
if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cboSupplier.DataSource = listSupplier;
cboSupplier.DisplayMember = "SupplierName";
cboSupplier.SelectedIndex = -1;
cboSupplier.ValueMember = "Id";
cboSupplier.Text = "-- Choose --";
List<VisitaJayaPerkasa.Entities.Schedule> listSchedule = sqlScheduleRepository.ListSchedule();
cboKapal.DataSource = listSchedule;
cboKapal.DisplayMember = "namaKapal";
cboKapal.SelectedIndex = -1;
cboKapal.Text = "-- Choose --";
List<VisitaJayaPerkasa.Entities.City> listDestination = sqlCityRepository.GetCity();
cboCity.DataSource = listDestination;
cboCity.DisplayMember = "CityName";
cboCity.ValueMember = "ID";
cboCity.SelectedIndex = -1;
cboCity.Text = "-- Choose --";
}
public PelayaranEdit(VisitaJayaPerkasa.Entities.Pelayaran pelayaran, UserControl ucSupplier)
{
InitializeComponent();
this.ucSupplier = ucSupplier;
this.pelayaran = pelayaran;
List<VisitaJayaPerkasa.Entities.Supplier> listSupplier;
SqlSupplierRepository sqlSupplierRepository = new SqlSupplierRepository();
listSupplier = sqlSupplierRepository.ListSuppliers();
if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cbSupplier.DataSource = listSupplier;
cbSupplier.DisplayMember = "SupplierName";
cbSupplier.ValueMember = "Id";
if (pelayaran == null)
{
wantToCreateVessel = true;
listPelayaranDetail = new List<Entities.PelayaranDetail>();
cbSupplier.SelectedValue = ((SupplierEdit)ucSupplier).newGuid;
}
else
{
wantToCreateVessel = false;
cbSupplier.SelectedValue = pelayaran.supplierID;
SqlPelayaranRepository sqlPelayaranRepository = new SqlPelayaranRepository();
listPelayaranDetail = sqlPelayaranRepository.ListPelayaranDetail(pelayaran.ID);
if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
else if (listPelayaranDetail != null)
PelayaranDetailGridView.DataSource = listPelayaranDetail;
else
listPelayaranDetail = new List<VisitaJayaPerkasa.Entities.PelayaranDetail>();
sqlPelayaranRepository = null;
}
}
public void LoadDataInBackground()
{
sqlSupplierRepository = new SqlSupplierRepository();
Supliers = null;
string searchValue = radTextBoxElementSearchWord.Text;
string searchKey = radComboBoxElement.Text;
Supliers = sqlSupplierRepository.ListSuppliers();
if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
else if (Supliers != null)
{
if (!string.IsNullOrEmpty(searchValue) && !string.IsNullOrEmpty(searchKey))
{
SqlParameter[] sqlParam;
switch (searchKey)
{
case "Supplier Name":
sqlParam = SqlUtility.SetSqlParameter(new string[] { "first_name" }, new object[] { searchValue });
Supliers = Supliers.Where(c => c.SupplierName.Contains(searchValue)).ToList<Entities.Supplier>();
break;
}
sqlParam = null;
}
}
if (Supliers != null)
{
totalPage = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(Supliers.Count() / Convert.ToDecimal(pageSize))));
currentPage = 1;
}
else
totalPage = 0;
}
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;
}
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;
}
}
public SupplierEdit(VisitaJayaPerkasa.Entities.Supplier supplier)
{
InitializeComponent();
sqlCategoryRepository = new SqlCategoryRepository();
sqlPaymentRepository = new SqlPaymentRepository();
sqlCityRepository = new SqlCityRepository();
List<Category> listCategory = sqlCategoryRepository.GetCategories();
List<Payment> listPayment = sqlPaymentRepository.GetListPayment();
List<Entities.City> listCity = sqlCityRepository.GetCity();
cboCategory.DataSource = listCategory;
cboCategory.DisplayMember = "CategoryName";
cboCategory.ValueMember = "ID";
cbTypeOfPayment.DataSource = listPayment;
cbTypeOfPayment.DisplayMember = "Name";
cbTypeOfPayment.ValueMember = "ID";
cboDestination.DataSource = listCity;
cboDestination.DisplayMember = "CityName";
cboDestination.ValueMember = "ID";
cboDestination.SelectedIndex = -1;
cboDestination.Text = Constant.VisitaJayaPerkasaApplication.cboDefaultText;
this.supplier = supplier;
this.isSaveMasterSupplierDetail = false;
sqlCityRepository = null;
sqlPaymentRepository = null;
if (supplier == null)
{
if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
wantToCreateVessel = true;
listSupplierDetail = new List<Entities.SupplierDetail>();
cboCategory.SelectedIndex = -1;
cboCategory.Text = "-- Choose --";
cbTypeOfPayment.SelectedIndex = -1;
cbTypeOfPayment.Text = Constant.VisitaJayaPerkasaApplication.cboDefaultText;
}
else
{
wantToCreateVessel = false;
etSupplierName.Text = supplier.SupplierName;
cboCategory.SelectedItem = supplier.CategoryName;
if (supplier.TypeOfPayment == null)
{
cbTypeOfPayment.SelectedIndex = -1;
cbTypeOfPayment.Text = Constant.VisitaJayaPerkasaApplication.cboDefaultText;
}
else
cbTypeOfPayment.SelectedValue = supplier.TypeOfPayment;
etTermOfPayment.Text = supplier.TermOfPayment;
etAddress.Text = supplier.Address;
etEmail.Text = supplier.Email;
etPhone.Text = supplier.Phone;
etFax.Text = supplier.Fax;
etContactPerson.Text = supplier.ContactPerson;
SqlSupplierRepository sqlSupplierRepository = new SqlSupplierRepository();
listSupplierDetail = sqlSupplierRepository.ListSupplierDetail(supplier.Id);
if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
{
MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else if (listSupplierDetail != null)
supplierDetailGridView.DataSource = listSupplierDetail;
else
listSupplierDetail = new List<VisitaJayaPerkasa.Entities.SupplierDetail>();
if (supplier.CategoryName.Equals("Trucking"))
{
List<string> listTemp = sqlSupplierRepository.ListTruckingNumber(supplier.Id);
if(listTemp != null)
for (int i = 0; i < listTemp.Count; i++)
gvTrucking.Rows.Add(listTemp.ElementAt(i));
listTemp = null;
}
else if (supplier.CategoryName.Equals("Dooring Agent"))
{
List<Entities.City> listTemp = sqlSupplierRepository.ListCitySupplier(supplier.Id);
groupBoxDestination.Visible = true;
if (listTemp != null)
for (int i = 0; i < listTemp.Count; i++)
{
gvDestination.Rows.AddNew();
GridViewDataRowInfo gridViewRow = gvDestination.Rows[i];
gridViewRow.Cells["ID"].Value = listTemp.ElementAt(i).ID.ToString();
gridViewRow.Cells["CityName"].Value = listTemp.ElementAt(i).CityName;
}
listTemp = null;
}
sqlSupplierRepository = null;
}
}
private void radButtonElementRemove_Click(object sender, EventArgs e)
{
if (SupplierGridView.SelectedRows.Count == 1)
{
sqlSupplierRepository = new SqlSupplierRepository();
DialogResult dResult = MessageBox.Show(this, "Are you sure want delete master and detail this supplier ? ", "Confirmation", MessageBoxButtons.YesNo);
if (dResult == DialogResult.Yes)
{
GridViewRowInfo gridInfo = SupplierGridView.SelectedRows.First();
string id = gridInfo.Cells[0].Value.ToString();
SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(new string[] { "supplier_id" }, new object[] { id });
if (sqlSupplierRepository.DeleteSupplier(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;
}
}
}