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();
}
