private void dataGridView1_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
var loc = e.Location;
DataGridView oDgv = sender as DataGridView;
if (oDgv != null && e.Button.ToString() == "Right")
{
if (oDgv.SelectedRows.Count > 0)
{
DialogResult res = MessageBox.Show("Please confirm this transaction", "Confirmation Required", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
using (var context = new TTI2Entities())
{
if (res == DialogResult.OK)
{
var Pk = (int)oDgv.CurrentRow.Cells[0].Value;
TLADM_Shifts shifts = context.TLADM_Shifts.Find(Pk);
if (shifts != null)
{
context.TLADM_Shifts.Remove(shifts);
try
{
context.SaveChanges();
oDgv.Rows.Clear();
MessageBox.Show("Data successfully saved to database");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
}
}
}
else
{
MessageBox.Show("Please select a row in the datagrid", "Information");
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
Button oBtn = sender as Button;
bool success = true;
bool lAdd;
if (oBtn != null && formloaded)
{
var Department = (TLADM_Departments)cmbDepartments.SelectedItem;
if (Department != null)
{
using (var context = new TTI2Entities())
{
foreach (DataGridViewRow dr in dataGridView1.Rows)
{
TLADM_Shifts shifts = new TLADM_Shifts();
if (dr.Cells[1].Value == null)
{
continue;
}
lAdd = true;
if (dr.Cells[0].Value != null)
{
if ((int)dr.Cells[0].Value != 0)
{
lAdd = false;
shifts = context.TLADM_Shifts.Find((int)dr.Cells[0].Value);
}
}
shifts.Shft_Dept_FK = Department.Dep_Id;
shifts.Shft_Description = dr.Cells[1].Value.ToString();
shifts.Shft_Start = (TimeSpan)dr.Cells[2].Value;
shifts.Shft_End = (TimeSpan)dr.Cells[3].Value;
if (lAdd)
{
context.TLADM_Shifts.Add(shifts);
}
try
{
context.SaveChanges();
}
catch (Exception ex)
{
var exceptionMessages = new StringBuilder();
do
{
exceptionMessages.Append(ex.Message);
ex = ex.InnerException;
}while (ex != null);
MessageBox.Show(exceptionMessages.ToString());
success = false;
}
}
}
if (success)
{
dataGridView1.Rows.Clear();
MessageBox.Show("data save to database");
}
}
}
}
