private void cmdSave_Click(object sender, EventArgs e) { switch (formMode) { case enumSelectedMod.Edit: { try { using (Database db = new Database(GlobalVar.DBName)) { db.Commands.Add(db.CreateCommand("[usp_Libur_Update]")); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _RowID)); db.Commands[0].Parameters.Add(new Parameter("@Tahun", SqlDbType.Int, Setorans.Year)); db.Commands[0].Parameters.Add(new Parameter("@bulan", SqlDbType.Int, cboMonth.SelectedIndex + 1)); db.Commands[0].Parameters.Add(new Parameter("@Tanggal", SqlDbType.Int, txtTanggal.Value)); db.Commands[0].ExecuteNonQuery(); } } catch (System.Exception ex) { Error.LogError(ex); } } break; case enumSelectedMod.Insert: { try { using (Database db = new Database(GlobalVar.DBName)) { db.Commands.Add(db.CreateCommand("[usp_Libur_Insert]")); _RowID = Guid.NewGuid(); db.Commands[0].Parameters.Add(new Parameter("@RowID", SqlDbType.UniqueIdentifier, _RowID)); db.Commands[0].Parameters.Add(new Parameter("@Year", SqlDbType.Int, Setorans.Year)); db.Commands[0].Parameters.Add(new Parameter("@MOnth", SqlDbType.Int, cboMonth.SelectedIndex + 1)); db.Commands[0].Parameters.Add(new Parameter("@Day", SqlDbType.Int, txtTanggal.Value)); db.Commands[0].ExecuteNonQuery(); } } catch (System.Exception ex) { Error.LogError(ex); } } break; } DataTable df = new DataTable(); df = dt.Clone(); df.Rows.Add(_RowID, txtTanggal.Value, cboMonth.SelectedIndex + 1, Setorans.Year); customGridView1.RefreshDataRow(df.Rows[0], "RowID", _RowID.ToString()); formMode = enumSelectedMod.View; SetMode(); customGridView1.FindRow("RowID", _RowID.ToString()); }
private void refreshData() { DataTable df = new DataTable(); df = LoadData(_RowID).Copy(); customGridView1.RefreshDataRow(df.Rows[0], "RowID", _RowID.ToString()); formMode = enumSelectedMod.View; SetMode(); customGridView1.FindRow("RowID", _RowID.ToString()); }
private void cmdEdit_Click(object sender, EventArgs e) { formMode = enumSelectedMod.Edit; SetMode(); }
private void cmdAdd_Click(object sender, EventArgs e) { formMode = enumSelectedMod.Insert; SetMode(); }
private void cmdCancel_Click(object sender, EventArgs e) { formMode = enumSelectedMod.View; SetMode(); customGridView1.Focus(); }