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