public static void SubmitAndCatchErrors(ref ConnectOfflineDBEntities db)
{
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
var text = "";
foreach (var eEntityValidationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in eEntityValidationErrors.ValidationErrors)
{
text += "Property: " + validationError.PropertyName + "Error: " + validationError.ErrorMessage + Environment.NewLine;
}
}
if (text != "")
{
MessageBox.Show(text);
}
}
MessageBox.Show("done");
}
public Register(string fName, string lName, string email, string password)
{
ConnectOfflineDBEntities db = new ConnectOfflineDBEntities();
User_Details_OfflineTable user = new User_Details_OfflineTable
{
iFK_AccountTypeId = 1,
vcFirstName = fName,
vcLastName = lName,
vcEmail = email,
};
db.User_Details_OfflineTable.AddOrUpdate(user);
//db.SaveChanges();
SubmitAndCatchErrors(ref db);
var query = from it in db.User_Details_OfflineTable
orderby it.vcFirstName
select it;
string text = "";
foreach (User_Details_OfflineTable v in query)
{
text += String.Format("{0} {1} {2} {3}", v.vcFirstName, v.vcLastName, v.vcEmail, v.vcProfilePicturePath);
}
MessageBox.Show(text);
}
