private void SaveWystTrasa()
{
string LastMessage;
try
{
if (Kontrah != null && TrasaUpdate != null)
{
IHP_WYSTTRASAKONTRAH wtk = new IHP_WYSTTRASAKONTRAH();
wtk.ID_IHP_WYSTTRASAKONTRAH = GetNextNumer(19);
wtk.ID_IHP_KONTRAHENT = Kontrah.ID_IHP_KONTRAHENT;
wtk.ID_IHP_TRASY = TrasaUpdate.ID_IHP_TRASY;
context.IHP_WYSTTRASAKONTRAH.Add(wtk);
context.SaveChanges();
LoadWystColection();
TrasaUpdate = null;
}
}
catch (Exception ex)
{
LastMessage = ex.ToString();
if (LastMessage == String.Empty)
{
LastMessage = ex.InnerException.ToString();
}
LogManager.WriteLogMessage(LogManager.LogType.Error, LastMessage);
throw ex;
}
}
private void DeleteWysTrasaKart()
{
string LastMessage;
try
{
if (TrasaSelect != null)
{
// IHP_WYSTTRASAKART wtk = context.IHP_WYSTTRASAKART?.FirstOrDefault(x => x.ID_IHP_KONTRAHENT.Equals(TrasaSelect.ID_IHP_KONTRAHENT) && x.ID_IHP_TRASY.Equals(TrasaSelect.ID_IHP_TRASY));
//if(wtk!=null)
// {
// context.IHP_WYSTTRASAKART.Remove(wtk);
// context.SaveChanges();
// Clear();
// LoadWystColection();
// TrasaUpdate = null;
// }
IHP_WYSTTRASAKONTRAH wtk = context.IHP_WYSTTRASAKONTRAH.Find(TrasaSelect.ID_IHP_WYSTTRASAKONTRAH);
context.Entry(wtk).State = EntityState.Deleted;
context.IHP_WYSTTRASAKONTRAH.Remove(wtk);
context.SaveChanges();
LoadWystColection();
TrasaUpdate = null;
}
}
catch (DbUpdateException Ex)
{
LogManager.WriteLogMessage(LogManager.LogType.Error, String.Format("DbUpdateException \"{0}\" :", Ex.InnerException.Message));
throw Ex;
}
catch (SqlException exc)
{
//here you might still get some exceptions but not about validation.
LogManager.WriteLogMessage(LogManager.LogType.Error, String.Format("SqlException \"{0}\" :", exc.Message));
//sometimes you may want to throw the exception to upper layers for handle it better over there!
throw;
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
LogManager.WriteLogMessage(LogManager.LogType.Error, String.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State));
foreach (var ve in eve.ValidationErrors)
{
LogManager.WriteLogMessage(LogManager.LogType.Error, String.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage));
}
}
throw;
}
catch (Exception ex)
{
LastMessage = ex.ToString();
if (LastMessage == String.Empty)
{
LastMessage = ex.InnerException.ToString();
}
LogManager.WriteLogMessage(LogManager.LogType.Error, LastMessage);
throw ex;
}
}