private void SaveData()
{
SqlPelayaranRepository sqlPelayaranRepository = null;
if (wantToCreateVessel)
{
sqlPelayaranRepository = new SqlPelayaranRepository();
Guid newGuid = Guid.NewGuid();
string[] strSqlParam = getStringSqlParameter();
object[] objSqlParam = GetObjSqlParameter(newGuid);
SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(strSqlParam, objSqlParam);
if (sqlPelayaranRepository.CheckPelayaran(sqlParam, Guid.Empty, true))
{
DialogResult dResult = MessageBox.Show(this, "Pelayaran has already deleted. Do you want to activate ?", "Confirmation", MessageBoxButtons.YesNo);
if (dResult == DialogResult.Yes)
{
if (sqlPelayaranRepository.ActivatePelayaran(sqlParam))
{
MessageBox.Show(this, "Success Activate Pelayaran", "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 Pelayaran", "Information");
sqlParam = null;
}
return;
}
else if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
{
MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else if (sqlPelayaranRepository.CheckPelayaran(sqlParam, Guid.Empty))
{
MessageBox.Show(this, "Pelayaran has already exists", "Information");
return;
}
else if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
{
MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (sqlPelayaranRepository.CreatePelayaran(sqlParam))
{
MessageBox.Show(this, "Success insert pelayaran data", "Information");
Constant.VisitaJayaPerkasaApplication.mainForm.ShowUserControl(new SupplierList());
}
else if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
else
{
MessageBox.Show(this, "Cannot insert pelayaran data", "Information");
}
sqlPelayaranRepository = null;
strSqlParam = null;
objSqlParam = null;
sqlParam = null;
}
else
{
sqlPelayaranRepository = new SqlPelayaranRepository();
string[] strSqlParam = getStringSqlParameter();
object[] objSqlParam = GetObjSqlParameter(pelayaran.ID);
SqlParameter[] sqlParam = SqlUtility.SetSqlParameter(strSqlParam, objSqlParam);
if (sqlPelayaranRepository.CheckPelayaran(sqlParam, this.pelayaran.ID))
{
MessageBox.Show(this, "Pelayaran 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 (sqlPelayaranRepository.EditPelayaran(sqlParam))
{
MessageBox.Show(this, "Success edit pelayaran data", "Information");
Constant.VisitaJayaPerkasaApplication.mainForm.ShowUserControl(new SupplierList());
}
else if (!Constant.VisitaJayaPerkasaApplication.anyConnection)
MessageBox.Show(this, "Please check your connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
else
{
MessageBox.Show(this, "Cannot edit pelayaran data", "Information");
}
sqlPelayaranRepository = null;
strSqlParam = null;
objSqlParam = null;
sqlParam = null;
}
}
