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