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