private void MaxTglPinjam_Validating(object sender, CancelEventArgs e)
{
if (!valid())
{
MaxTglPinjam.Focus();
return;
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
//txtNoBukti.Text = cmbPenSales.Text;
if (lookupSales.SalesID == "")
{
lookupSales.Focus();
return;
}
if (!valid())
{
MaxTglPinjam.Focus();
return;
}
switch (formMode)
{
case enumFormMode.New:
try
{
GlobalVar.LastClosingDate = (DateTime)tglPinjam.DateValue;
if ((DateTime)tglPinjam.DateValue <= GlobalVar.LastClosingDate)
{
throw new Exception(string.Format(ISA.Toko.Messages.Error.AlreadyClosingPJT, GlobalVar.LastClosingDate));
}
this.Cursor = Cursors.WaitCursor;
_recID = Tools.CreateFingerPrint();
_rowID = Guid.NewGuid();
using (Database db = new Database())
{
DataTable dtNum = Tools.GetGeneralNumerator(docNoDO);
int lebar = int.Parse(dtNum.Rows[0]["Lebar"].ToString());
iNomor = int.Parse(dtNum.Rows[0]["Nomor"].ToString());
iNomor++;
string depan = Tools.GeneralInitial();
string belakang = dtNum.Rows[0]["Belakang"].ToString();
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_Peminjaman_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@RowID ", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@NoBukti ", SqlDbType.VarChar, txtNoBukti.Text));
db.Commands[0].Parameters.Add(new Parameter("@RecordID ", SqlDbType.VarChar, Tools.CreateFingerPrint()));
db.Commands[0].Parameters.Add(new Parameter("@TglKeluar ", SqlDbType.DateTime, tglPinjam.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@TglBatas ", SqlDbType.DateTime, MaxTglPinjam.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@StaffPenjualan", SqlDbType.VarChar, cmbPenSales.Text));
db.Commands[0].Parameters.Add(new Parameter("@Catatan ", SqlDbType.VarChar, txtCatatan.Text));
db.Commands[0].Parameters.Add(new Parameter("@KodeSales", SqlDbType.VarChar, lookupSales.SalesID));
db.Commands[0].Parameters.Add(new Parameter("@NPrint", SqlDbType.Int, 0));
db.Commands[0].Parameters.Add(new Parameter("@SyncFlag", SqlDbType.Bit, 0));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands.Add(db.CreateCommand("usp_Numerator_UPDATE"));
db.Commands[1].Parameters.Add(new Parameter("@doc", SqlDbType.VarChar, docNoDO));
db.Commands[1].Parameters.Add(new Parameter("@depan", SqlDbType.VarChar, depan));
db.Commands[1].Parameters.Add(new Parameter("@belakang", SqlDbType.VarChar, belakang));
db.Commands[1].Parameters.Add(new Parameter("@nomor", SqlDbType.Int, iNomor));
db.Commands[1].Parameters.Add(new Parameter("@lebar", SqlDbType.VarChar, lebar));
db.Commands[1].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.BeginTransaction();
db.Commands[0].ExecuteNonQuery();
db.Commands[1].ExecuteNonQuery();
db.CommitTransaction();
db.Dispose();
this.DialogResult = DialogResult.OK;
iNomor++;
_noBukti = Tools.FormatNumerator(iNomor, lebar, depan, belakang);
txtNoBukti.Text = _noBukti;
lookupSales.SalesID = "";
lookupSales.NamaSales = "";
txtCatatan.Text = "";
this.Close();
}
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
break;
case enumFormMode.Update:
try
{
GlobalVar.LastClosingDate = (DateTime)tglPinjam.DateValue;
if ((DateTime)tglPinjam.DateValue <= GlobalVar.LastClosingDate)
{
throw new Exception(string.Format(ISA.Toko.Messages.Error.AlreadyClosingPJT, GlobalVar.LastClosingDate));
}
this.Cursor = Cursors.WaitCursor;
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_Peminjaman_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@TglKeluar", SqlDbType.DateTime, tglPinjam.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@TglBatas", SqlDbType.DateTime, tglPinjam.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@StaffPenjualan", SqlDbType.VarChar, cmbPenSales.Text));
db.Commands[0].Parameters.Add(new Parameter("@KodeSales", SqlDbType.VarChar, lookupSales.SalesID));
db.Commands[0].Parameters.Add(new Parameter("@Catatan", SqlDbType.VarChar, txtCatatan.Text));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
this.DialogResult = DialogResult.OK;
cmdClose.PerformClick();
}
}
catch (System.Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
break;
}
}
