private void frmServiceDetailPosUpdate_FormClosed(object sender, FormClosedEventArgs e) { if (this.DialogResult == DialogResult.OK) { if (this.Caller is frmServiceBrowser) { frmServiceBrowser formCaller = (frmServiceBrowser)this.Caller; formCaller.RefreshDataService(); formCaller.FindRowBkl("RowID", _HeaderID.ToString()); //formCaller.FindRowNotaJualDetail("DetailRowID", _rowID.ToString()); //formCaller.FindRow(FormTools.detailIndex.detail1, "RowID", _rowID.ToString()); //frmServiceBrowser formCaller = (frmServiceBrowser)this.Caller; //formCaller.RefreshDataService(); ////formCaller.RefreshDataNotaPOS(); //formCaller.FindRow(FormTools.detailIndex.detail2, "RowIDPart", _rowID.ToString()); } } }
private void cmdSAVE_Click(object sender, EventArgs e) { if (!ValidateInput()) { return; } string valcust = ValidateCust(_RowIDCust); if (cboService.SelectedIndex != 1 && valcust == "") { MessageBox.Show("Customer Belum terdaftar di Tabel Instansi, Silahkan di daftarkan terlebih dahulu di \n" + "Master -> Master Instansi -> Add Grid ke 2"); return; } try { this.Cursor = Cursors.WaitCursor; if (txtTglService.DateValue <= GlobalVar.LastClosingDate) { throw new Exception(String.Format(Messages.Error.AlreadyClosingPJT, GlobalVar.LastClosingDate)); } switch (formMode) { case enumFormMode.New: _rowID = Guid.NewGuid(); string _noService, numeratorDoc = "NOMOR_SERVICE", depan = "", belakang = ""; int iNomor, lebar; depan = GetInitialPT(); DataTable dtNum = Tools.GetGeneralNumerator(numeratorDoc); lebar = int.Parse(dtNum.Rows[0]["Lebar"].ToString()); belakang = dtNum.Rows[0]["Belakang"].ToString(); if (Tools.isNull(dtNum.Rows[0]["Depan"], "").ToString() != depan) { iNomor = 1; } else { iNomor = int.Parse(dtNum.Rows[0]["Nomor"].ToString()); iNomor++; } _noService = Tools.FormatNumerator(iNomor, lebar, depan, belakang); string HtrId = GlobalVar.PerusahaanID + Tools.CreateFingerPrint().Substring(0, 16) + SecurityManager.UserInitial; //BarcodeNota = _noService.Trim() + "S" + GlobalVar.DateTimeOfServer.ToString("yyyy").Substring(2, 2) + // GlobalVar.DateTimeOfServer.ToString("MM"); //BarcodeNota = txtNoDoc.Text.Trim() + "S" + GlobalVar.DateTimeOfServer.ToString("yyyy").Substring(2, 2) + // GlobalVar.DateTimeOfServer.ToString("MM"); using (Database db = new Database()) { db.Commands.Add(db.CreateCommand("usp_bkl_service_INSERT")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _rowID)); db.Commands[0].Parameters.Add(new Parameter("@tgl_srv", SqlDbType.DateTime, txtTglService.DateValue)); //db.Commands[0].Parameters.Add(new Parameter("@nomor", SqlDbType.VarChar, txtNoDoc.Text)); //db.Commands[0].Parameters.Add(new Parameter("@no_antri", SqlDbType.VarChar, txtNoDoc.Text)); //if (cbxPerbaikan.Checked) // db.Commands[0].Parameters.Add(new Parameter("@perbaikan", SqlDbType.VarChar, "Y")); //else // db.Commands[0].Parameters.Add(new Parameter("@perbaikan", SqlDbType.VarChar, "N")); if (cboService.Text.Trim() == "Umum") { db.Commands[0].Parameters.Add(new Parameter("@perbaikan", SqlDbType.VarChar, "N")); } else if (cboService.Text.Trim() == "Perbaikan Inventaris") { db.Commands[0].Parameters.Add(new Parameter("@perbaikan", SqlDbType.VarChar, "Y")); } else if (cboService.Text.Trim() == "Instansi") { db.Commands[0].Parameters.Add(new Parameter("@perbaikan", SqlDbType.VarChar, "I")); } else if (cboService.Text.Trim() == "Sekolah") { db.Commands[0].Parameters.Add(new Parameter("@perbaikan", SqlDbType.VarChar, "S")); } else if (cboService.Text.Trim() == "Perbaikan Karyawan") { db.Commands[0].Parameters.Add(new Parameter("@perbaikan", SqlDbType.VarChar, "K")); } db.Commands[0].Parameters.Add(new Parameter("@nomor", SqlDbType.VarChar, _noService)); db.Commands[0].Parameters.Add(new Parameter("@no_antri", SqlDbType.VarChar, txtNoUrut.Text)); db.Commands[0].Parameters.Add(new Parameter("@shift", SqlDbType.VarChar, txtShift.Text)); db.Commands[0].Parameters.Add(new Parameter("@idcust", SqlDbType.VarChar, "BENGKEL")); db.Commands[0].Parameters.Add(new Parameter("@kd_cust", SqlDbType.VarChar, lookupCustomerBengkel1.KodeCust)); db.Commands[0].Parameters.Add(new Parameter("@no_pol", SqlDbType.VarChar, txtNoPol.Text)); db.Commands[0].Parameters.Add(new Parameter("@spm", SqlDbType.VarChar, txtSPMTypeDesc.Text)); db.Commands[0].Parameters.Add(new Parameter("@warna", SqlDbType.VarChar, txtWarna.Text)); db.Commands[0].Parameters.Add(new Parameter("@tahun", SqlDbType.VarChar, txtTahun.Text)); db.Commands[0].Parameters.Add(new Parameter("@kd_spm", SqlDbType.VarChar, lookupSepedaMotor1.KodeSepedaMotor)); db.Commands[0].Parameters.Add(new Parameter("@jns_spm", SqlDbType.VarChar, txtSPMType.Text)); db.Commands[0].Parameters.Add(new Parameter("@km", SqlDbType.Int, Convert.ToInt32(txtKM.Text))); db.Commands[0].Parameters.Add(new Parameter("@keluhan", SqlDbType.VarChar, txtKeluhan.Text)); db.Commands[0].Parameters.Add(new Parameter("@nama_cust", SqlDbType.VarChar, txtPemilik.Text)); db.Commands[0].Parameters.Add(new Parameter("@alamat", SqlDbType.VarChar, txtAlamat.Text)); db.Commands[0].Parameters.Add(new Parameter("@no_id", SqlDbType.VarChar, txtNoKTP_SIM.Text)); db.Commands[0].Parameters.Add(new Parameter("@id_member", SqlDbType.VarChar, txtIDMember.Text)); db.Commands[0].Parameters.Add(new Parameter("@no_telp", SqlDbType.VarChar, txtTelp.Text)); db.Commands[0].Parameters.Add(new Parameter("@kd_mk", SqlDbType.VarChar, lkpMekanik.KodeMekanik)); db.Commands[0].Parameters.Add(new Parameter("@mekanik", SqlDbType.VarChar, lkpMekanik.NamaMekanik)); db.Commands[0].Parameters.Add(new Parameter("@saran1", SqlDbType.VarChar, txtSaran1.Text)); db.Commands[0].Parameters.Add(new Parameter("@saran2", SqlDbType.VarChar, txtSaran2.Text)); db.Commands[0].Parameters.Add(new Parameter("@saran3", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@kd_sales", SqlDbType.VarChar, lookupSales1.KodeSales)); db.Commands[0].Parameters.Add(new Parameter("@Idtr", SqlDbType.VarChar, HtrId)); 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[0].Parameters.Add(new Parameter("@JmlService", SqlDbType.Int, Convert.ToInt32(Tools.isNull(txtService.Text, "0").ToString()))); db.Commands.Add(db.CreateCommand("usp_Numerator_UPDATE")); db.Commands[1].Parameters.Add(new Parameter("@doc", SqlDbType.VarChar, numeratorDoc)); 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)); //EXECUTE COMMANDS db.BeginTransaction(); db.Commands[0].ExecuteNonQuery(); db.Commands[1].ExecuteNonQuery(); db.CommitTransaction(); } break; case enumFormMode.Update: using (Database db = new Database()) { DateTime tglService = (DateTime)dtService.Rows[0]["tgl_srv"]; NoServis = Tools.isNull(dtService.Rows[0]["nomor"], "").ToString(); //BarcodeNota = NoServis.Trim() + "S" + tglService.ToString("yyyy").Substring(2, 2) + tglService.ToString("MM"); _rowID = (Guid)dtService.Rows[0]["RowID"]; _rowIDNota = (Guid)Tools.isNull(dtService.Rows[0]["RowIDNota"], Guid.Empty); db.Commands.Add(db.CreateCommand("usp_bkl_service_UPDATE")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _rowID)); db.Commands[0].Parameters.Add(new Parameter("@RowIDNota", SqlDbType.UniqueIdentifier, _rowIDNota)); db.Commands[0].Parameters.Add(new Parameter("@shift", SqlDbType.VarChar, txtShift.Text)); db.Commands[0].Parameters.Add(new Parameter("@idcust", SqlDbType.VarChar, "BENGKEL")); db.Commands[0].Parameters.Add(new Parameter("@kd_cust", SqlDbType.VarChar, lookupCustomerBengkel1.KodeCust)); db.Commands[0].Parameters.Add(new Parameter("@no_pol", SqlDbType.VarChar, txtNoPol.Text)); db.Commands[0].Parameters.Add(new Parameter("@spm", SqlDbType.VarChar, txtSPMTypeDesc.Text)); db.Commands[0].Parameters.Add(new Parameter("@warna", SqlDbType.VarChar, txtWarna.Text)); db.Commands[0].Parameters.Add(new Parameter("@tahun", SqlDbType.VarChar, txtTahun.Text)); db.Commands[0].Parameters.Add(new Parameter("@kd_spm", SqlDbType.VarChar, lookupSepedaMotor1.KodeSepedaMotor)); db.Commands[0].Parameters.Add(new Parameter("@jns_spm", SqlDbType.VarChar, txtSPMType.Text)); db.Commands[0].Parameters.Add(new Parameter("@km", SqlDbType.VarChar, txtKM.Text)); db.Commands[0].Parameters.Add(new Parameter("@keluhan", SqlDbType.VarChar, txtKeluhan.Text)); db.Commands[0].Parameters.Add(new Parameter("@nama_cust", SqlDbType.VarChar, txtPemilik.Text)); db.Commands[0].Parameters.Add(new Parameter("@alamat", SqlDbType.VarChar, txtAlamat.Text)); db.Commands[0].Parameters.Add(new Parameter("@no_id", SqlDbType.VarChar, txtNoKTP_SIM.Text)); db.Commands[0].Parameters.Add(new Parameter("@id_member", SqlDbType.VarChar, txtIDMember.Text)); db.Commands[0].Parameters.Add(new Parameter("@no_telp", SqlDbType.VarChar, txtTelp.Text)); db.Commands[0].Parameters.Add(new Parameter("@kd_mk", SqlDbType.VarChar, lkpMekanik.KodeMekanik)); db.Commands[0].Parameters.Add(new Parameter("@mekanik", SqlDbType.VarChar, lkpMekanik.NamaMekanik)); db.Commands[0].Parameters.Add(new Parameter("@saran1", SqlDbType.VarChar, txtSaran1.Text)); db.Commands[0].Parameters.Add(new Parameter("@saran2", SqlDbType.VarChar, txtSaran2.Text)); db.Commands[0].Parameters.Add(new Parameter("@saran3", SqlDbType.VarChar, "")); db.Commands[0].Parameters.Add(new Parameter("@kd_sales", SqlDbType.VarChar, lookupSales1.KodeSales)); 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[0].Parameters.Add(new Parameter("@JmlService", SqlDbType.Int, Convert.ToInt32(txtService.Text))); if (cbxPerbaikan.Checked) { db.Commands[0].Parameters.Add(new Parameter("@perbaikan", SqlDbType.VarChar, "Y")); } else { db.Commands[0].Parameters.Add(new Parameter("@perbaikan", SqlDbType.VarChar, "N")); }; db.Commands[0].ExecuteNonQuery(); } break; } MessageBox.Show("Data telah tersimpan"); this.DialogResult = DialogResult.OK; if (this.Caller is frmServiceBrowser) { frmServiceBrowser frmCaller = (frmServiceBrowser)this.Caller; frmCaller.RefreshDataService(); frmCaller.FindRowBkl("RowID", _rowID.ToString()); } this.Close(); } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } }