private void frmPenjualanPotonganUpdate_FormClosed(object sender, FormClosedEventArgs e)
{
if (this.DialogResult == DialogResult.OK)
{
if (this.Caller is frmPenjualanPotonganBrowser)
{
frmPenjualanPotonganBrowser frmCaller = (frmPenjualanPotonganBrowser)this.Caller;
frmCaller.RefreshData();
frmCaller.FindRow("RowID", _rowID.ToString());
}
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
//if (SecurityManager.AppRole == "004")
// {
if (IsValid())
{
try
{
switch (formMode)
{
case enumFormMode.New:
using (Database db = new Database())
{
_rowID = Guid.NewGuid();
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_PenjualanPotongan_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@notaPenjualanID", SqlDbType.UniqueIdentifier, _row));
db.Commands[0].Parameters.Add(new Parameter("@trID", SqlDbType.VarChar, trID));
db.Commands[0].Parameters.Add(new Parameter("@potID", SqlDbType.VarChar, Tools.CreateFingerPrint()));
db.Commands[0].Parameters.Add(new Parameter("@noPot", SqlDbType.VarChar, txtNoPot.Text));
db.Commands[0].Parameters.Add(new Parameter("@tglPot", SqlDbType.DateTime, txtTglPot.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@dil", SqlDbType.Money, Convert.ToDouble(txtPotLumRp.Text)));
db.Commands[0].Parameters.Add(new Parameter("@disc", SqlDbType.Money, Convert.ToDouble(txtPotLumPersen.Text)));
db.Commands[0].Parameters.Add(new Parameter("@rpNet", SqlDbType.Money, Convert.ToDouble(txtNetto.Text)));
db.Commands[0].Parameters.Add(new Parameter("@catatan", SqlDbType.VarChar, txtCatPot.Text));
db.Commands[0].Parameters.Add(new Parameter("@tglACC", SqlDbType.DateTime, SqlDateTime.Null));
db.Commands[0].Parameters.Add(new Parameter("@dilACC", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@catACC", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@discACC", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@syncFlag", SqlDbType.Bit, 0));
db.Commands[0].Parameters.Add(new Parameter("@idLink", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@statusACC", SqlDbType.Bit, 0));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
//);
break;
case enumFormMode.Update:
if (txtTglACC.DateValue.HasValue)
{
GlobalVar.LastClosingDate = (DateTime)txtTglACC.DateValue;
if ((DateTime)txtTglACC.DateValue <= GlobalVar.LastClosingDate)
{
throw new Exception(String.Format(ISA.Toko.Messages.Error.AlreadyClosingPJT, GlobalVar.LastClosingDate));
}
}
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_PenjualanPotongan_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@notaPenjualanID", SqlDbType.UniqueIdentifier, _row));
db.Commands[0].Parameters.Add(new Parameter("@trID", SqlDbType.VarChar, trID));
db.Commands[0].Parameters.Add(new Parameter("@potID", SqlDbType.VarChar, potID));
db.Commands[0].Parameters.Add(new Parameter("@noPot", SqlDbType.VarChar, txtNoPot.Text));
db.Commands[0].Parameters.Add(new Parameter("@tglPot", SqlDbType.DateTime, txtTglPot.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@dil", SqlDbType.Money, Convert.ToDouble(txtPotLumRp.Text)));
db.Commands[0].Parameters.Add(new Parameter("@disc", SqlDbType.Money, Convert.ToDouble(txtPotLumPersen.Text)));
db.Commands[0].Parameters.Add(new Parameter("@rpNet", SqlDbType.Money, Convert.ToDouble(txtNetto.Text)));
db.Commands[0].Parameters.Add(new Parameter("@catatan", SqlDbType.VarChar, txtCatPot.Text));
db.Commands[0].Parameters.Add(new Parameter("@tglACC", SqlDbType.DateTime, txtTglACC.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@dilACC", SqlDbType.Money, Math.Round(Convert.ToDouble(txtACCRp.Text), 0)));
db.Commands[0].Parameters.Add(new Parameter("@catACC", SqlDbType.VarChar, txtCatACC.Text));
if (ajukan == true)
{
db.Commands[0].Parameters.Add(new Parameter("@statusACC", SqlDbType.Bit, 0));
}
else if (acc == true)
{
//cAcc = IIF(nDil_acc > 0,'v',' ')
if (txtACCRp.GetDoubleValue > 0)
{
db.Commands[0].Parameters.Add(new Parameter("@statusACC", SqlDbType.Bit, 1));
// LinkToPiutang();
}
else
{
db.Commands[0].Parameters.Add(new Parameter("@statusACC", SqlDbType.Bit, 0));
}
}
db.Commands[0].Parameters.Add(new Parameter("@discACC", SqlDbType.Decimal, Convert.ToDecimal(txtACCPersen.Text)));
db.Commands[0].Parameters.Add(new Parameter("@syncFlag", SqlDbType.Bit, 0));
db.Commands[0].Parameters.Add(new Parameter("@idLink", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
if (ajukan == false)
{
if (acc == true)
{
//cAcc = IIF(nDil_acc > 0,'v',' ')
if (txtACCRp.GetDoubleValue > 0)
{
LinkToPiutang();
}
}
}
break;
}
MessageBox.Show("Data telah tersimpan");
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
Error.LogError(ex);
}
finally
{
frmPenjualanPotonganBrowser frmCaller = (frmPenjualanPotonganBrowser)this.Caller;
frmCaller.RefreshData();
frmCaller.FindRow("RowID", _rowID.ToString());
this.Close();
frmCaller.Show();
}
}
//}
}