void rootgridViewFamiliesHk_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
GridView view = sender as GridView;
if (CurrentState == ActionsStates.Edit)
{
FamilyHK tmpFamilyHK = new FamilyHK();
object idFamilyHk = view.GetRowCellValue(view.FocusedRowHandle, nameof(FamilyHK.IdFamilyHk));
object description = view.GetRowCellValue(view.FocusedRowHandle, nameof(FamilyHK.Description));
tmpFamilyHK.IdFamilyHk = (idFamilyHk ?? string.Empty).ToString();
tmpFamilyHK.Description = (description ?? string.Empty).ToString();
AddModifiedFamilyHkToList(tmpFamilyHK);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void AddModifiedFamilyHkToList(FamilyHK modifiedFamilyHK)
{
try
{
var familyHk = _modifiedFamiliesHk.FirstOrDefault(a => a.IdFamilyHk.Equals(modifiedFamilyHK.IdFamilyHk));
if (familyHk == null)
{
_modifiedFamiliesHk.Add(modifiedFamilyHK);
}
else
{
familyHk.Description = modifiedFamilyHK.Description;
}
}
catch (Exception ex)
{
throw ex;
}
}
public FamilyHK NewFamilyHK(FamilyHK newFamilyHK)
{
try
{
if (newFamilyHK == null)
{
throw new ArgumentNullException("newFamilyHK");
}
using (var db = new HKSupplyContext())
{
using (var dbTrans = db.Database.BeginTransaction())
{
try
{
var familiesHK = db.FamiliesHK.FirstOrDefault(a => a.IdFamilyHk.Equals(newFamilyHK.IdFamilyHk));
if (familiesHK != null)
{
//throw new NewExistingRoleException(GlobalSetting.ResManager.GetString("RoleAlreadyExist"));
throw new Exception("Families HK Already Exist");
}
db.FamiliesHK.Add(newFamilyHK);
db.SaveChanges();
dbTrans.Commit();
return(GetFamilyHKById(newFamilyHK.IdFamilyHk));
}
catch (SqlException sqlex)
{
dbTrans.Rollback();
for (int i = 0; i < sqlex.Errors.Count; i++)
{
_log.Error("Index #" + i + "\n" +
"Message: " + sqlex.Errors[i].Message + "\n" +
"Error Number: " + sqlex.Errors[i].Number + "\n" +
"LineNumber: " + sqlex.Errors[i].LineNumber + "\n" +
"Source: " + sqlex.Errors[i].Source + "\n" +
"Procedure: " + sqlex.Errors[i].Procedure + "\n");
switch (sqlex.Errors[i].Number)
{
case -1: //connection broken
case -2: //timeout
throw new DBServerConnectionException(GlobalSetting.ResManager.GetString("DBServerConnectionError"));
}
}
throw sqlex;
}
catch (DbEntityValidationException e)
{
dbTrans.Rollback();
_log.Error(e.Message, e);
throw e;
}
catch (Exception ex)
{
dbTrans.Rollback();
_log.Error(ex.Message, ex);
throw ex;
}
}
}
}
catch (ArgumentNullException nrex)
{
_log.Error(nrex.Message, nrex);
throw nrex;
}
}
