private void cmdSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtdate.Text)) { KotakPesan.Warning("Anda belum mengisi Tanggal", "Cek Tanggal"); txtdate.Focus(); return; } if (txtdate.DateValue < GlobalVar.DateOfServer) { KotakPesan.Warning("Tanggal tidak boleh kurang dari datetime server", "Cek Tanggal"); txtdate.Focus(); return; } if (txtHargaJual.GetDoubleValue <= 0) { KotakPesan.Warning("Harga Jual Harus Lebih besar dari 0", "Cek Harga Jual"); txtHargaJual.Focus(); return; } try { // using (Database db = new Database(GlobalVar.DBFinance)) using (Database db = new Database()) { db.Open(); DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand("usp_JasaHarga_Insert")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID)); db.Commands[0].Parameters.Add(new Parameter("@JasaRowID", SqlDbType.UniqueIdentifier, JasaRowID)); db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.DateTime, txtdate.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@HargaJual", SqlDbType.Money, txtHargaJual.GetDoubleValue)); db.Commands[0].Parameters.Add(new Parameter("@Keterangan", SqlDbType.VarChar, txtKeterangan.Text)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserName)); dt = db.Commands[0].ExecuteDataTable(); db.Close(); db.Dispose(); if (dt.Rows.Count > 0) { KotakPesan.Warning(string.Format("Jasa Harga Tanggal {0:dd-MM-yyyy} sudah ada. Mohon gunakan Tombol Edit jika ingin merubah.", txtdate.DateValue), "Cek Tanggal"); txtdate.Focus(); return; } } this.DialogResult = DialogResult.OK; frmJasaBrowse frmcaller = (frmJasaBrowse)this.Caller; frmcaller.RefreshData(); this.Close(); frmcaller.Show(); } catch (Exception ex) { Error.LogError(ex); } }
private void frmHPPUpdate_FormClosed(object sender, FormClosedEventArgs e) { if (this.DialogResult == DialogResult.OK) { if (this.Caller is frmJasaBrowse) { frmJasaBrowse frmCaller = (frmJasaBrowse)this.Caller; frmCaller.RefreshData(); frmCaller.FindRow("TMT", txttglBerlaku.ToString()); } } }
private void frmJasaUpdate_FormClosed(object sender, FormClosedEventArgs e) { if (this.DialogResult == DialogResult.OK) { if (this.Caller is frmJasaBrowse) { frmJasaBrowse frmCaller = (frmJasaBrowse)this.Caller; frmCaller.RefreshData(); frmCaller.FindRow("Kode", txtKode.Text); } } }
private void frmJasaHargaUpdate_FormClosed(object sender, FormClosedEventArgs e) { if (this.DialogResult == DialogResult.OK) { if (this.Caller is frmJasaBrowse) { frmJasaBrowse frmCaller = (frmJasaBrowse)this.Caller; frmCaller.RefreshDataDetail(JasaRowID); frmCaller.FindRowDetail("DRowID", RowID.ToString()); } } }
private void cmdSave_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(txtNama.Text)) { MessageBox.Show("Anda belum mengisi Nama Nama"); txtNama.Focus(); return; } try { switch (formMode) { case enumFormMode.NEW: using (Database db = new Database()) { db.Open(); DataTable dt = new DataTable(); int Status = cbaktif.Checked == true? 0:1; db.Commands.Add(db.CreateCommand("usp_Jasa_Insert_Update_Delete")); db.Commands[0].Parameters.Add(new Parameter("@do", SqlDbType.Int, 0)); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID)); db.Commands[0].Parameters.Add(new Parameter("@Nama", SqlDbType.VarChar, txtNama.Text)); db.Commands[0].Parameters.Add(new Parameter("@Status", SqlDbType.VarChar, Status)); db.Commands[0].Parameters.Add(new Parameter("@Catatan", SqlDbType.VarChar, txtCatatan.Text)); db.Commands[0].Parameters.Add(new Parameter("@Createdby", SqlDbType.VarChar, SecurityManager.UserName)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserName)); dt = db.Commands[0].ExecuteDataTable(); db.Close(); db.Dispose(); if (dt.Rows.Count > 0) { MessageBox.Show(dt.Rows[0]["pesan"].ToString()); if (dt.Rows[0]["pesan"].ToString() == "Data Sudah Ada") { txtKode.Text = string.Empty; txtKode.Focus(); return; } else if (dt.Rows[0]["pesan"].ToString().Substring(dt.Rows[0]["pesan"].ToString().Length - 14) == " Sudah Ada !!!") { txtNama.Text = string.Empty; txtNama.Focus(); return; } } } break; case enumFormMode.UPDATE: using (Database db = new Database()) { if (Tools.cekDuplikasiDataOnDatabase("Jasa", "Nama", txtNama.Text, "Kode", txtKode.Text)) { MessageBox.Show("Jasa Dengan Nama " + txtNama.Text + " Sudah Ada !!"); txtNama.Focus(); return; } db.Open(); DataTable dt = new DataTable(); int Status = cbaktif.Checked == true ? 0 : 1; db.Commands.Add(db.CreateCommand("usp_Jasa_Insert_Update_Delete")); db.Commands[0].Parameters.Add(new Parameter("@do", SqlDbType.Int, 1)); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, RowID)); db.Commands[0].Parameters.Add(new Parameter("@Nama", SqlDbType.VarChar, txtNama.Text)); db.Commands[0].Parameters.Add(new Parameter("@Kode", SqlDbType.VarChar, txtKode.Text)); db.Commands[0].Parameters.Add(new Parameter("@Status", SqlDbType.VarChar, Status)); db.Commands[0].Parameters.Add(new Parameter("@Catatan", SqlDbType.VarChar, txtCatatan.Text)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserName)); dt = db.Commands[0].ExecuteDataTable(); db.Close(); db.Dispose(); if (dt.Rows.Count > 0) { MessageBox.Show(dt.Rows[0]["pesan"].ToString()); if (dt.Rows[0]["pesan"].ToString() == "Data Sudah Ada") { txtKode.Text = string.Empty; txtKode.Focus(); return; } } } break; } this.DialogResult = DialogResult.OK; frmJasaBrowse frmcaller = (frmJasaBrowse)this.Caller; frmcaller.RefreshData(); this.Close(); frmcaller.Show(); } catch (Exception ex) { Error.LogError(ex); } }