private void gridWorkExp_AddingNewDataItem(object sender, GridViewAddingNewEventArgs e)
{
try
{
var work = new t_TempEmpWorkExp();
work.EmpID = adminusers.Text;
work.CompanyName = compName;
work.CompanyAddress = compAddress;
work.DateFrom = Convert.ToDateTime(compFrom);;
work.DateTo = Convert.ToDateTime(compTo);;
work.Position = compPosition;
work.LastUpdate = DateTime.Now;
e.NewObject = work;
db.t_TempEmpWorkExp.Add(work);
}
catch { }
}
private void gridWorkExp_RowEditEnded(object sender, GridViewRowEditEndedEventArgs e)
{
if (e.EditAction == GridViewEditAction.Cancel)
{
return;
}
if (e.EditOperationType == GridViewEditOperationType.Insert)
{
try
{
db.SaveChanges();
bindWorkExp();
}
catch { }
}
else if (e.EditOperationType == GridViewEditOperationType.Edit)
{
try
{
foreach (var data in gridWorkExp.SelectedItems)
{
t_TempEmpWorkExp myData = data as t_TempEmpWorkExp;
compName = myData.CompanyName;
compAddress = myData.CompanyAddress;
compPosition = myData.Position;
compFrom = Convert.ToString(myData.DateFrom);
compTo = Convert.ToString(myData.DateTo);
t_TempEmpWorkExp workexp = db.t_TempEmpWorkExp.First(p => p.EmpID == adminusers.Text);
workexp.CompanyName = compName;
workexp.CompanyAddress = compAddress;
workexp.Position = compPosition;
workexp.DateFrom = Convert.ToDateTime(compFrom);
workexp.DateTo = Convert.ToDateTime(compTo);
db.SaveChanges();
bindWorkExp();
}
}
catch { }
}
}
private void gridWorkExp_PreviewKeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.Key == Key.Delete)
{
foreach (var data in gridWorkExp.SelectedItems)
{
t_TempEmpWorkExp myData = data as t_TempEmpWorkExp;
var delete = db.t_TempEmpWorkExp.Where(p => p.EmpID == adminusers.Text && p.CompanyName == myData.CompanyName).FirstOrDefault();
db.t_TempEmpWorkExp.Remove(delete);
db.SaveChanges();
}
}
else
{
return;
}
}
catch { }
}
