private void handleGridKey(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
try
{
Guid rekapkoliid = (Guid)dataGridView1.SelectedCells[0].OwningRow.Cells["RowID"].Value;
DataTable dt = new DataTable();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_PengirimanEkspedisiDetail_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@trID", SqlDbType.VarChar, _trID));
db.Commands[0].Parameters.Add(new Parameter("@recordID", SqlDbType.VarChar, Tools.CreateFingerPrint()));
db.Commands[0].Parameters.Add(new Parameter("@rekapKoliID", SqlDbType.UniqueIdentifier, rekapkoliid));
db.Commands[0].Parameters.Add(new Parameter("@ketPending", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
dt = db.Commands[0].ExecuteDataTable();
string uraian;
db.Commands.Add(db.CreateCommand("usp_fnUraian"));
db.Commands[1].Parameters.Add(new Parameter("@idTr", SqlDbType.VarChar, _trID));
DataTable dts = new DataTable();
dts = db.Commands[1].ExecuteDataTable();
uraian = Tools.isNull(dts.Rows[0]["Uraian"], "").ToString();
dtRekapKoliDetail = new DataTable();
using (Database dbListDetail = new Database())
{
dbListDetail.Commands.Add(db.CreateCommand("usp_RekapKoliDetail_LIST"));
dbListDetail.Commands[0].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, rekapkoliid));
dtRekapKoliDetail = dbListDetail.Commands[0].ExecuteDataTable();
}
DataTable dtt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_RekapKoliDetail_UPDATE"));
db.Commands[2].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, (Guid)dtRekapKoliDetail.Rows[0]["RowID"]));
db.Commands[2].Parameters.Add(new Parameter("@recordID", SqlDbType.VarChar, Tools.isNull(dtRekapKoliDetail.Rows[0]["RecordID"], "").ToString()));
db.Commands[2].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, rekapkoliid));
db.Commands[2].Parameters.Add(new Parameter("@htrID", SqlDbType.VarChar, Tools.isNull(dtRekapKoliDetail.Rows[0]["HtrID"], "").ToString()));
db.Commands[2].Parameters.Add(new Parameter("@notaJualID", SqlDbType.UniqueIdentifier, (Guid)dtRekapKoliDetail.Rows[0]["NotaJualID"]));
db.Commands[2].Parameters.Add(new Parameter("@noNota", SqlDbType.VarChar, Tools.isNull(dtRekapKoliDetail.Rows[0]["NoNota"], "").ToString()));
db.Commands[2].Parameters.Add(new Parameter("@notaJualRecID", SqlDbType.VarChar, Tools.isNull(dtRekapKoliDetail.Rows[0]["NotaJualRecID"], "").ToString()));
db.Commands[2].Parameters.Add(new Parameter("@tunaiKredit", SqlDbType.VarChar, Tools.isNull(dtRekapKoliDetail.Rows[0]["TunaiKredit"], "").ToString()));
db.Commands[2].Parameters.Add(new Parameter("@nominal", SqlDbType.Money, dtRekapKoliDetail.Rows[0]["Nominal"]));
db.Commands[2].Parameters.Add(new Parameter("@uraian", SqlDbType.VarChar, uraian));
db.Commands[2].Parameters.Add(new Parameter("@keterangan", SqlDbType.VarChar, Tools.isNull(dtRekapKoliDetail.Rows[0]["Keterangan"], "").ToString()));
db.Commands[2].Parameters.Add(new Parameter("@noResi", SqlDbType.VarChar, Tools.isNull(dtRekapKoliDetail.Rows[0]["NoResi"], "").ToString()));
db.Commands[2].Parameters.Add(new Parameter("@syncFlag", SqlDbType.Bit, 0));
db.Commands[2].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[2].ExecuteNonQuery();
dtt = db.Commands[2].ExecuteDataTable();
db.Commands.Add(db.CreateCommand("usp_RekapKoli_UPDATE_KP"));
db.Commands[3].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, rekapkoliid));
db.Commands[3].Parameters.Add(new Parameter("@kp", SqlDbType.VarChar, "KP"));
db.Commands[3].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[3].ExecuteNonQuery();
//INSERT INTO CxpdcKp (IdRec,No_Nota,Kd_Sales,Tk,Uraian) VALUES ;
//(cIdRec,Dxpdc.No_nota,Dxpdc.Sales,Dxpdc.Tk,cUraian)
//db.Commands[1].Parameters.Add(new Parameter("@idTr", SqlDbType.VarChar, _trID));
}
//if (dt.Rows.Count > 0)
//{
// dataGridView1.DataSource = dt;
//}
//if (dataGridView1.SelectedCells.Count > 0)
//{
// label1.Text = dataGridView1.SelectedCells[0].OwningRow.Cells["NamaToko"].Value.ToString() + " " + dataGridView1.SelectedCells[0].OwningRow.Cells["Alamat"].Value.ToString() + " " + dataGridView1.SelectedCells[0].OwningRow.Cells["Kota"].Value.ToString();
//}
MessageBox.Show(Messages.Confirm.UpdateSuccess);
this.DialogResult = DialogResult.OK;
frmEkspedisiPengirimanBrowse frmCaller = (frmEkspedisiPengirimanBrowse)this.Caller;
frmCaller.RefreshDataHeader();
frmCaller.FindHeader("RowID", _rowID.ToString());
this.Close();
frmCaller.Show();
}
catch (Exception ex)
{
Error.LogError(ex);
}
}
}
private void cmdSave_Click(object sender, EventArgs e)
{
if (IsValid())
{
try
{
GlobalVar.LastClosingDate = (DateTime)txtTglKirim.DateValue;
if ((DateTime)txtTglKirim.DateValue <= GlobalVar.LastClosingDate)
{
throw new Exception(string.Format(ISA.Toko.Messages.Error.AlreadyClosingPJT, GlobalVar.LastClosingDate));
}
switch (formMode)
{
case enumFormMode.New:
//GENERATE Nomor Numerator
DataTable dtNum = Tools.GetGeneralNumerator(docNoPengiriman);
int lebar = 3;
int iNomor = int.Parse(dtNum.Rows[0]["Nomor"].ToString());
string depan = Tools.GeneralInitial();
string belakang = dtNum.Rows[0]["Belakang"].ToString();
iNomor++;
string strNumerator = Tools.FormatNumerator(iNomor, lebar, depan, belakang);
using (Database db = new Database())
{
DataTable dt = new DataTable();
_rowID = Guid.NewGuid();
db.Commands.Add(db.CreateCommand("usp_PengirimanEkspedisi_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@trID", SqlDbType.VarChar, Tools.CreateFingerPrint()));
db.Commands[0].Parameters.Add(new Parameter("@noKirim", SqlDbType.VarChar, strNumerator));
db.Commands[0].Parameters.Add(new Parameter("@tglKirim", SqlDbType.DateTime, txtTglKirim.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@tglKembali", SqlDbType.DateTime, SqlDateTime.Null));
db.Commands[0].Parameters.Add(new Parameter("@tujuan", SqlDbType.VarChar, cboTujuan.SelectedValue));
db.Commands[0].Parameters.Add(new Parameter("@sopir", SqlDbType.VarChar, cboSopir.SelectedValue));
db.Commands[0].Parameters.Add(new Parameter("@kernet", SqlDbType.VarChar, cboKernet.SelectedValue));
db.Commands[0].Parameters.Add(new Parameter("@noPolisi", SqlDbType.VarChar, txtNoPolisis.Text));
db.Commands[0].Parameters.Add(new Parameter("@kasBon", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@bbmltr", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@bbmRp", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@umSopir", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@umKernet", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@parkir", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@tol", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@kuli", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@lain", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@ketLain", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@nPrint", SqlDbType.Int, 0));
db.Commands[0].Parameters.Add(new Parameter("@tarikan", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@jamKirim", SqlDbType.VarChar, txtJamKirim.Text));
db.Commands[0].Parameters.Add(new Parameter("@jamKembali", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@kmBerangkat", SqlDbType.Int, (string.IsNullOrEmpty(txtKMBerangkat.Text) == true ? 0 : int.Parse(txtKMBerangkat.Text))));
db.Commands[0].Parameters.Add(new Parameter("@kmKirim", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@izinMasuk", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@timbangan", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@inTepatWaktu", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@inPengiriman", SqlDbType.Money, 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, docNoPengiriman));
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();
}
MessageBox.Show(Messages.Confirm.UpdateSuccess + "\nNo Pengiriman " + strNumerator);
break;
case enumFormMode.Update:
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand("usp_PengirimanEkspedisi_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@trID", SqlDbType.VarChar, Tools.CreateFingerPrint()));
db.Commands[0].Parameters.Add(new Parameter("@noKirim", SqlDbType.VarChar, txtNoPengiriman.Text));
db.Commands[0].Parameters.Add(new Parameter("@tglKirim", SqlDbType.DateTime, txtTglKirim.DateValue));
db.Commands[0].Parameters.Add(new Parameter("@tglKembali", SqlDbType.DateTime, SqlDateTime.Null));
db.Commands[0].Parameters.Add(new Parameter("@tujuan", SqlDbType.VarChar, cboTujuan.SelectedValue));
db.Commands[0].Parameters.Add(new Parameter("@sopir", SqlDbType.VarChar, cboSopir.SelectedValue));
db.Commands[0].Parameters.Add(new Parameter("@kernet", SqlDbType.VarChar, cboKernet.SelectedValue));
db.Commands[0].Parameters.Add(new Parameter("@noPolisi", SqlDbType.VarChar, txtNoPolisis.Text));
db.Commands[0].Parameters.Add(new Parameter("@kasBon", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@bbmltr", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@bbmRp", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@umSopir", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@umKernet", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@parkir", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@tol", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@kuli", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@lain", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@ketLain", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@nPrint", SqlDbType.Int, 0));
db.Commands[0].Parameters.Add(new Parameter("@tarikan", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@jamKirim", SqlDbType.VarChar, txtJamKirim.Text));
db.Commands[0].Parameters.Add(new Parameter("@jamKembali", SqlDbType.VarChar, ""));
db.Commands[0].Parameters.Add(new Parameter("@kmBerangkat", SqlDbType.Int, (string.IsNullOrEmpty(txtKMBerangkat.Text) == true ? 0 : int.Parse(txtKMBerangkat.Text))));
db.Commands[0].Parameters.Add(new Parameter("@kmKirim", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@izinMasuk", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@timbangan", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@inTepatWaktu", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@inPengiriman", SqlDbType.Money, 0));
db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
MessageBox.Show(Messages.Confirm.UpdateSuccess);
break;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
this.DialogResult = DialogResult.OK;
frmEkspedisiPengirimanBrowse frmCaller = (frmEkspedisiPengirimanBrowse)this.Caller;
frmCaller.RefreshDataHeader();
frmCaller.FindHeader("RowID", _rowID.ToString());
this.Close();
frmCaller.Show();
}
}
