public void AddToCustomFields(CustomField custField)
{
using (var myContext = new customerDbEntities())
{
myContext.CustomFields.Add(custField);
try
{
myContext.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Console.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
}
public void DeleteNote(Note deleteNote)
{
using (var myContext = new customerDbEntities())
{
myContext.Notes.Attach(deleteNote);
myContext.Notes.Remove(deleteNote);
try
{
myContext.SaveChanges();
}
catch (DbEntityValidationException ex)
{
foreach (var entityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in entityValidationErrors.ValidationErrors)
{
Console.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
}
}
}
}
public override int SaveChanges()
{
try
{
using (var myContext = new customerDbEntities())
{
return(myContext.SaveChanges());
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("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)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
public BindingList <StandardLookups> GetAlCustomersForSearch()
{
BindingList <StandardLookups> lookups = new BindingList <StandardLookups>();
using (var myContext = new customerDbEntities())
{
var q = from lookup in myContext.Customers
orderby lookup.id ascending
select new
{
Code = lookup.id,
Description = lookup.CustomerName,
};
if (q != null)
{
Array.ForEach(q.ToArray(), l =>
{
lookups.Add(new StandardLookups(l.Code, l.Description, ""));
});
}
}
return(lookups);
}
