private void commandButton1_Click(object sender, EventArgs e) { using (Database db = new Database(GlobalVar.DBName)) { db.Commands.Add(db.CreateCommand("usp_CF_RencanaPembayaranDetail_UPDATE")); if (Modus == enumModus.Update) { db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, dgDetail.SelectedCells[0].OwningRow.Cells["RowIDD"].Value)); } else { db.Commands[0].Parameters.Add(new Parameter("@HeaderRowID", SqlDbType.UniqueIdentifier, dgJnsTransaksi.SelectedCells[0].OwningRow.Cells["RowID"].Value)); } db.Commands[0].Parameters.Add(new Parameter("@TglBukti", SqlDbType.Date, dateBukti.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@NoBukti", SqlDbType.VarChar, textNoBukti.Text.ToString())); db.Commands[0].Parameters.Add(new Parameter("@TglTempo", SqlDbType.Date, dateTempo.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserInitial)); db.Commands[0].ExecuteNonQuery(); } dgDetail.Focus(); panelUPDATE.Visible = false; Modus = enumModus.Clear; SetEnableDisable(); RefreshDataGridDetail(); }
public frmDebetKreditNotaUpdate(Form Caller) { InitializeComponent(); Modus = enumModus.New; Brow = enumBrow.Header; this.Caller = Caller; }
private void cmdEDIT_Click(object sender, EventArgs e) { panelUPDATE.Visible = true; Modus = enumModus.Update; SetEnableDisable(); RefreshDataUpdate(); }
private void commandButton2_Click(object sender, EventArgs e) { dgDetail.Focus(); panelUPDATE.Visible = false; Modus = enumModus.Clear; SetEnableDisable(); }
private void cmdEDIT1_Click(object sender, EventArgs e) { Modus = enumModus.Update; SetupEnableDisable(true); DisplayHeader(); txtTransakiCF.Focus(); }
private void cmdEDIT2_Click(object sender, EventArgs e) { Modus = enumModus.Update; SetupEnableDisable(true); DisplayDetail(); cboTransaksiFinance.Focus(); }
private void frmCF_RencanaPembayaran_Load(object sender, EventArgs e) { InitControl(); RefreshDataGrid(); RefreshData(); Modus = enumModus.Clear; }
private void cmdSAVE_Click(object sender, EventArgs e) { Guid _RowID = Guid.Empty; if (Modus == enumModus.Update) { _RowID = (Guid)dgPerkiraan.SelectedCells[0].OwningRow.Cells["RowID"].Value; } string _NoPerkiraan = lookupPerkiraan1.NoPerkiraan; string _Uraian = lookupPerkiraan1.NamaPerkiraan; using (Database db = new Database(GlobalVar.DBName)) { db.Commands.Add(db.CreateCommand("usp_AccBy_Tabel_UPDATE")); if (Modus == enumModus.Update) { db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _RowID)); } db.Commands[0].Parameters.Add(new Parameter("@NoPerkiraan", SqlDbType.VarChar, _NoPerkiraan)); db.Commands[0].Parameters.Add(new Parameter("@Uraian", SqlDbType.VarChar, _Uraian)); db.Commands[0].ExecuteNonQuery(); } Modus = enumModus.Clear; SetupEnableDisable(); RefreshGrid(); RefreshText(); }
private void cmdADD_Click(object sender, EventArgs e) { Modus = enumModus.New; lookupPerkiraan1.NoPerkiraan = ""; lookupPerkiraan1.NamaPerkiraan = ""; SetupEnableDisable(); }
public frmHiRegisterUpdate(Form Caller) { InitializeComponent(); Modus = enumModus.New; Brow = enumBrow.Header; this.Caller = Caller; }
private void cmdSAVED_Click(object sender, EventArgs e) { Double Nominal = Convert.ToDouble(textAmount.Text) * Convert.ToDouble(textKurs.Text); int Tgl = dateTempo.DateValue.Value.Day; using (Database db = new Database(GlobalVar.DBName)) { db.Commands.Add(db.CreateCommand("usp_CF_RencanaPembayaranDetail_UPDATE")); if (Modus == enumModus.Update) { db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, dgDetail.SelectedCells[0].OwningRow.Cells["RowIDD"].Value)); } else { db.Commands[0].Parameters.Add(new Parameter("@HeaderRowID", SqlDbType.UniqueIdentifier, dgVendor.SelectedCells[0].OwningRow.Cells["RowID"].Value)); } db.Commands[0].Parameters.Add(new Parameter("@TglBukti", SqlDbType.Date, dateBukti.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@NoBukti", SqlDbType.VarChar, textNoBukti.Text.ToString())); db.Commands[0].Parameters.Add(new Parameter("@TglTempo", SqlDbType.Date, dateTempo.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@Amount", SqlDbType.Money, Convert.ToDouble(textAmount.Text))); db.Commands[0].Parameters.Add(new Parameter("@Kurs", SqlDbType.Money, Convert.ToDouble(textKurs.Text))); db.Commands[0].Parameters.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, SecurityManager.UserInitial)); db.Commands[0].ExecuteNonQuery(); } dgDetail.Focus(); panelUPDATE.Visible = false; Modus = enumModus.Clear; SetEnableDisable(); RefreshDataGridDetail(); dgDetail.FindRow("NoBukti", textNoBukti.Text.ToString()); _lTxtJumlah[Tgl - 1].Text = Nominal.ToString(); cmdSAVE_Click(sender, e); }
private void frmAccBiaya_Load(object sender, EventArgs e) { Modus = enumModus.Clear; SetEnable(); IsiComboDownload(); RefreshGrid(); }
private void cmdADD1_Click(object sender, EventArgs e) { Modus = enumModus.New; SetupEnableDisable(true); txtTransakiCF.Text = ""; cboGroupCF.SelectedValue = ""; txtTransakiCF.Focus(); }
private void frmCF_RencanaLuarNegeri_Load(object sender, EventArgs e) { InitControl(); SetEnableDisable(); RefreshDataGrid(); RefreshData(); Modus = enumModus.Clear; }
public frmDebetKreditNotaUpdate(Form Caller, Guid HeaderID) { InitializeComponent(); Modus = enumModus.Update; Brow = enumBrow.Header; _HeaderID = HeaderID; this.Caller = Caller; }
public frmHiRegisterUpdate(Form Caller, Guid HeaderID) { InitializeComponent(); Modus = enumModus.Update; Brow = enumBrow.Header; _HeaderID = HeaderID; this.Caller = Caller; }
private void cmdDownloadGo_Click(object sender, EventArgs e) { string _paths = string.Empty; string PilData = _Data; Stream myStream = null; OpenFileDialog openFileDialog1 = new OpenFileDialog(); openFileDialog1.InitialDirectory = "C:\\TEMP\\FTP\\DOWNLOAD"; //GlobalVar.DbfDownload; openFileDialog1.Filter = "xml files (*.xml)|*" + PilData + "*.xml"; //openFileDialog1.FilterIndex = 1; //openFileDialog1.RestoreDirectory = true; if (openFileDialog1.ShowDialog() == DialogResult.OK) { if ((myStream = openFileDialog1.OpenFile()) != null) { _paths = openFileDialog1.FileName; if (MessageBox.Show("Download Data ini " + openFileDialog1.FileNames[0].ToString() + " ?", "Download", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } this.Cursor = Cursors.WaitCursor; try { //lblStatus.Text = "Download file from FTP ..."; DataSet ds = ReadData(_paths); //lblStatus.Text = "Upload data to ISA ...."; refreshForm(); ProcessTable(ds); MessageBox.Show(Messages.Confirm.DownloadSuccess); //RefreshBudget(); } catch (Exception ex) { Error.LogError(ex); } finally { this.Cursor = Cursors.Default; } } Modus = enumModus.Clear; SetEnable(); RefreshDetail(); RefreshHeader(); } }
public frmPerkiraanKoneksiArusKasUpdate(Guid HeaderID, Form Caller) { InitializeComponent(); _HeaderID = HeaderID; this.Caller = Caller; if (GlobalVar.PerusahaanID != "HLD") { lookUpPerkiraan1.Enabled = false; } Modus = enumModus.New; }
private void cmdUPLOAD_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); string Physical = GlobalVar.DbfUpload + "\\" + "TransAccTmp.DBF"; files.Add(Physical); if (File.Exists(Physical)) { File.Delete(Physical); } using (Database db = new Database(GlobalVar.DBName)) { db.Commands.Add(db.CreateCommand("usp_AccBy_Ajuan_UPLOAD")); db.Commands[0].Parameters.Add(new Parameter("@FromDate", SqlDbType.Date, rangeDateBox1.FromDate)); db.Commands[0].Parameters.Add(new Parameter("@ToDate", SqlDbType.Date, rangeDateBox1.ToDate)); db.Commands[0].Parameters.Add(new Parameter("@GudangID", SqlDbType.VarChar, GlobalVar.Gudang)); db.Commands[0].Parameters.Add(new Parameter("@UploadKe11", SqlDbType.Date, DateTime.Today)); dt = db.Commands[0].ExecuteDataTable(); } List <Foxpro.DataStruct> fields = new List <Foxpro.DataStruct>(); fields.Add(new Foxpro.DataStruct("RowID", "RowID", Foxpro.enFoxproTypes.Char, 36)); fields.Add(new Foxpro.DataStruct("CabangID", "CabangID", Foxpro.enFoxproTypes.Char, 4)); fields.Add(new Foxpro.DataStruct("TglAjuan", "TglAjuan", Foxpro.enFoxproTypes.DateTime, 8)); fields.Add(new Foxpro.DataStruct("Transaksi", "Transaksi", Foxpro.enFoxproTypes.Char, 5)); fields.Add(new Foxpro.DataStruct("NoPerk", "NoPerk", Foxpro.enFoxproTypes.Char, 12)); fields.Add(new Foxpro.DataStruct("NoBukti", "NoBukti", Foxpro.enFoxproTypes.Char, 15)); fields.Add(new Foxpro.DataStruct("Uraian", "Uraian", Foxpro.enFoxproTypes.Char, 55)); fields.Add(new Foxpro.DataStruct("Rp", "Rp", Foxpro.enFoxproTypes.Numeric, 17)); fields.Add(new Foxpro.DataStruct("NoAcc", "NoAcc", Foxpro.enFoxproTypes.Char, 15)); fields.Add(new Foxpro.DataStruct("TglAcc", "TglAcc", Foxpro.enFoxproTypes.DateTime, 8)); fields.Add(new Foxpro.DataStruct("Keterangan", "Keterangan", Foxpro.enFoxproTypes.Char, 55)); fields.Add(new Foxpro.DataStruct("UploadKe11", "UploadKe11", Foxpro.enFoxproTypes.DateTime, 8)); fields.Add(new Foxpro.DataStruct("UploadKe00", "UploadKe00", Foxpro.enFoxproTypes.DateTime, 8)); Foxpro.WriteFile(GlobalVar.DbfUpload, "TransAccTmp", fields, dt); ZipFile(files); MessageBox.Show(Messages.Confirm.ProcessFinished + ". Lokasi file: " + GlobalVar.DbfUpload + "\\ISA-AjuanACCBiaya.zip"); using (Database db = new Database(GlobalVar.DBName)) { db.Commands.Add(db.CreateCommand("usp_AccBy_Ajuan_UPLOAD")); db.Commands[0].Parameters.Add(new Parameter("@FromDate", SqlDbType.Date, rangeDateBox1.FromDate)); db.Commands[0].Parameters.Add(new Parameter("@ToDate", SqlDbType.Date, rangeDateBox1.ToDate)); db.Commands[0].Parameters.Add(new Parameter("@GudangID", SqlDbType.VarChar, GlobalVar.Gudang)); db.Commands[0].Parameters.Add(new Parameter("@UploadKe11", SqlDbType.Date, DateTime.Today)); db.Commands[0].Parameters.Add(new Parameter("@IsUpdate", SqlDbType.Bit, true)); db.Commands[0].ExecuteNonQuery(); } Modus = enumModus.Clear; RefreshGrid(); }
private void frmBiayaOperasionalBrowse_Load(object sender, EventArgs e) { this.WindowState = FormWindowState.Maximized; rdbTanggal.FromDate = GlobalVar.DateOfServer; rdbTanggal.ToDate = GlobalVar.DateOfServer; selectedGrid = GridSelection.Header; cmdSearch_Click(sender, e); Modus = enumModus.Clear; SetEnable(); }
public frmPerkiraanKoneksiArusKasUpdate(string noPerkiraan, string keterangan, Guid RowID, Form Caller) { InitializeComponent(); lookUpPerkiraan1.NoPerkiraan = noPerkiraan; txtKeterangan.Text = keterangan; _RowID = RowID; this.Caller = Caller; if (GlobalVar.PerusahaanID != "HLD") { lookUpPerkiraan1.Enabled = false; } Modus = enumModus.Update; }
private void cmdADD1_Click(object sender, EventArgs e) { eModus = enumModus.New; SetupEnable(true); if (eGrid == enumGrid.Satu) { txtCF.Text = ""; } else { txtTrans.Text = ""; } }
public frmHiRegisterUpdate(Form Caller, Guid HeaderID, Guid DetailID) { InitializeComponent(); Brow = enumBrow.Detail; if (DetailID == Guid.Empty) { Modus = enumModus.New; } else { Modus = enumModus.Update; } _HeaderID = HeaderID; _DetailID = DetailID; this.Caller = Caller; }
private void cmdDELETE_Click(object sender, EventArgs e) { if (MessageBox.Show("Anda yakin akan menghapus data ini?", "Hapus data", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { Guid _RowID = (Guid)dgPerkiraan.SelectedCells[0].OwningRow.Cells["RowID"].Value; using (Database db = new Database(GlobalVar.DBName)) { db.Commands.Add(db.CreateCommand("usp_AccBy_Tabel_UPDATE")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _RowID)); db.Commands[0].ExecuteNonQuery(); } Modus = enumModus.Clear; SetupEnableDisable(); RefreshGrid(); RefreshText(); } }
public frmDebetKreditNotaUpdate(Form Caller, Guid HeaderID, Guid DetailID, string IsiPin) { InitializeComponent(); Brow = enumBrow.Detail; if (DetailID == Guid.Empty) { Modus = enumModus.New; } else { Modus = enumModus.Update; } _HeaderID = HeaderID; _DetailID = DetailID; _IsiPin = IsiPin; this.Caller = Caller; }
public frmDKNupdate(Form Caller, Guid HeaderID, Guid DetailID, string RecID, string RecIDDetail) { InitializeComponent(); Brow = enumBrow.Detail; if (DetailID == Guid.Empty) { Modus = enumModus.New; } else { Modus = enumModus.Update; } _HeaderID = HeaderID; _DetailID = DetailID; _RecID = RecID; _RecIDDetail = RecIDDetail; this.Caller = Caller; }
private void cmdUPDATE_Click(object sender, EventArgs e) { if (Tools.isNull(dgTransAccBiaya.SelectedCells[0].OwningRow.Cells["TglAcc"].Value, "").ToString() == "") { txt00.Text = dgTransAccBiaya.SelectedCells[0].OwningRow.Cells["CabangID"].Value.ToString(); txtTglAjuan.DateValue = (DateTime)dgTransAccBiaya.SelectedCells[0].OwningRow.Cells["TglPengajuan"].Value; txtTransaksi.Text = dgTransAccBiaya.SelectedCells[0].OwningRow.Cells["Transaksi"].Value.ToString(); txtUraian.Text = dgTransAccBiaya.SelectedCells[0].OwningRow.Cells["Uraian"].Value.ToString(); txtJumlah.Text = dgTransAccBiaya.SelectedCells[0].OwningRow.Cells["Jumlah"].Value.ToString(); txtNoAcc.Text = dgTransAccBiaya.SelectedCells[0].OwningRow.Cells["NoAcc"].Value.ToString(); txtTglAcc.DateValue = GlobalVar.GetServerDate; txtKeterangan.Text = dgTransAccBiaya.SelectedCells[0].OwningRow.Cells["Keterangan"].Value.ToString(); Modus = enumModus.Update; SetEnable(); } else { MessageBox.Show("Data dimaksud sudah pernah diAcc/diTolak", "Perhatian!"); } }
private void cmdUpdateSave_Click(object sender, EventArgs e) { if (txtNoAcc.Text == "" && txtKeterangan.Text == "") { MessageBox.Show("Jika ditolak, silahkan isi alasan penolakannya di kolom Keterangan", "Perhatian!"); } else { Guid _RowID = (Guid)dgTransAccBiaya.SelectedCells[0].OwningRow.Cells["RowID"].Value; using (Database db = new Database(GlobalVar.DBName)) { db.Commands.Add(db.CreateCommand("usp_AccBy_Ajuan_UPDATE")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _RowID)); db.Commands[0].Parameters.Add(new Parameter("@NoAcc", SqlDbType.VarChar, txtNoAcc.Text)); db.Commands[0].Parameters.Add(new Parameter("@TglAcc", SqlDbType.Date, txtTglAcc.DateValue)); db.Commands[0].Parameters.Add(new Parameter("@Keterangan", SqlDbType.VarChar, txtKeterangan.Text)); db.Commands[0].ExecuteNonQuery(); } Modus = enumModus.Clear; RefreshData(); SetEnable(); } }
private void cmdDownloadGo_Click(object sender, EventArgs e) { _tempPath = GlobalVar.DbfDownload + "\\AccBiaya\\"; if (!Directory.Exists(_tempPath)) { Directory.CreateDirectory(_tempPath); } else { string[] files = Directory.GetFiles(_tempPath); foreach (string file in files) { File.Delete(file); } } Zip.UnZipFiles(fileZipName, _tempPath, false); DownloadProses(); MessageBox.Show(Messages.Confirm.ProcessFinished); Modus = enumModus.Clear; SetEnable(); RefreshGrid(); }
private void cmdDownloadClose_Click(object sender, EventArgs e) { Modus = enumModus.Clear; SetEnable(); }