private void frmServiceTransjUpdate_FormClosed(object sender, FormClosedEventArgs e)
{
if (this.DialogResult == DialogResult.OK)
{
if (this.Caller is frmServiceBrowser)
{
frmServiceBrowser formCaller = (frmServiceBrowser)this.Caller;
formCaller.RefreshDataNotaPOS();
formCaller.FindRow(FormTools.detailIndex.detail2, "RowID", _rowID.ToString());
}
}
}
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;
}
}
private void cmdSAVE_Click(object sender, EventArgs e)
{
if (!ValidateInput())
{
return;
}
if (lookupToko1.KodeToko == "" || lookupToko1.KodeToko == "[CODE]" && (Perbaikan_ != "UMUM" || Perbaikan_ == "INSTANSI" || Perbaikan_ == "SEKOLAH"))
{
MessageBox.Show("Toko Harus di isi");
return;
}
double Qty = 0, Hrg = 0;
Qty = Convert.ToDouble(txtQty.Text);
Hrg = Convert.ToDouble(txtHargaSat.Text);
if (Qty == 0)
{
MessageBox.Show("QTY masih kosong");
return;
}
if (Hrg == 0)
{
MessageBox.Show("Harga Jual masih kosong");
return;
}
try
{
using (Database db = new Database())
{
DataTable dtc = new DataTable();
db.Commands.Add(db.CreateCommand("usp_StokBengkelCekIdbrg_LIST"));
db.Commands[0].Parameters.Add(new Parameter("@id_brg", SqlDbType.VarChar, lkpStokBkl.KodeStokBkl));
dtc = db.Commands[0].ExecuteDataTable();
if (dtc.Rows.Count == 0)
{
MessageBox.Show("Barang ini tidak ada di master stok bengkel");
return;
}
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
try
{
this.Cursor = Cursors.WaitCursor;
switch (_formMode)
{
case FormTools.enumFormMode.New:
_rowID = Guid.NewGuid();
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_bkl_djual_INSERT"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, (Guid)dtService.Rows[0]["RowID"]));
db.Commands[0].Parameters.Add(new Parameter("@Idtr", SqlDbType.VarChar, HtrID_));
db.Commands[0].Parameters.Add(new Parameter("@id_brg", SqlDbType.VarChar, lkpStokBkl.KodeStokBkl));
db.Commands[0].Parameters.Add(new Parameter("@nama_stok", SqlDbType.VarChar, lkpStokBkl.NamaStokBkl));
db.Commands[0].Parameters.Add(new Parameter("@j_nota", SqlDbType.Decimal, txtQty.GetDoubleValue));
db.Commands[0].Parameters.Add(new Parameter("@h_jual", SqlDbType.Decimal, txtHargaSat.GetDoubleValue));
db.Commands[0].Parameters.Add(new Parameter("@satuan", SqlDbType.VarChar, txtSatuan.Text));
db.Commands[0].Parameters.Add(new Parameter("@RowStokBkl", SqlDbType.UniqueIdentifier, lkpStokBkl.RowStokBkl));
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("@Gudang", SqlDbType.VarChar, GlobalVar.Gudang));
db.Commands[0].Parameters.Add(new Parameter("@kd_toko", SqlDbType.VarChar, lookupToko1.KodeToko));
db.Commands[0].ExecuteNonQuery();
}
UpdateServiceFlagStokBkl();
this.DialogResult = DialogResult.OK;
MessageBox.Show("Data telah disimpan");
//Clear();
if (this.Caller is frmServiceBrowser)
{
frmServiceBrowser formCaller = (frmServiceBrowser)this.Caller;
formCaller.RefreshDataJual();
formCaller.FindRow(FormTools.detailIndex.detail3, "RowID4", _rowID.ToString());
}
this.Close();
break;
case FormTools.enumFormMode.Update:
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand("usp_bkl_djual_UPDATE"));
db.Commands[0].Parameters.Add(new Parameter("@rowID", SqlDbType.UniqueIdentifier, _rowID));
db.Commands[0].Parameters.Add(new Parameter("@headerID", SqlDbType.UniqueIdentifier, dtServiceJual.Rows[0]["HeaderID"]));
db.Commands[0].Parameters.Add(new Parameter("@j_nota", SqlDbType.Decimal, txtQty.GetDoubleValue));
db.Commands[0].Parameters.Add(new Parameter("@h_jual", SqlDbType.Decimal, txtHargaSat.GetDoubleValue));
db.Commands[0].Parameters.Add(new Parameter("@satuan", SqlDbType.VarChar, txtSatuan.Text));
db.Commands[0].Parameters.Add(new Parameter("@lastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserID));
db.Commands[0].ExecuteNonQuery();
}
this.DialogResult = DialogResult.OK;
MessageBox.Show("Data telah disimpan");
if (this.Caller is frmServiceBrowser)
{
frmServiceBrowser formCaller = (frmServiceBrowser)this.Caller;
formCaller.RefreshDataJual();
formCaller.FindRow(FormTools.detailIndex.detail3, "RowID4", _rowID.ToString());
}
this.Close();
break;
}
}
catch (Exception ex)
{
Error.LogError(ex);
}
finally
{
this.Cursor = Cursors.Default;
}
}
