public ActionResult Admin_add_type(tblNoteType model)
{
if (User.Identity.IsAuthenticated)
{
string name = User.Identity.Name;
int access = (from user in _Context.tblUsers where user.EmailID == name select user.ID).Single();
bool isvalid = _Context.tblNoteTypes.Any(m => m.Name == model.Name);
if (!isvalid)
{
tblNoteType obj = new tblNoteType();
obj.Name = model.Name;
obj.Description = model.Description;
obj.CreatedDate = DateTime.Now;
obj.CreatedBy = access;
obj.IsActive = true;
if (ModelState.IsValid)
{
_Context.tblNoteTypes.Add(obj);
try
{
_Context.SaveChanges();
ModelState.Clear();
return(RedirectToAction("Admin_dashboard", "Admin"));
}
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);
}
}
}
}
}
else
{
ViewBag.Message = "Note type already exists";
}
}
return(View());
}
public ActionResult addNoteType(tblNoteType model)
{
if (User.Identity.IsAuthenticated)
{
var connectionDB = new NotesMarketPlaceEntities();
string name = User.Identity.Name;
int u = (from user in _Context.tblUsers where user.EmailID == name select user.ID).Single();
bool isvalid = _Context.tblNoteTypes.Any(m => m.Name == model.Name);
if (!isvalid)
{
tblNoteType obj = new tblNoteType();
obj.Name = model.Name;
obj.Description = model.Description;
obj.CreatedDate = DateTime.Now;
obj.CreatedBy = u;
obj.IsActive = true;
if (ModelState.IsValid)
{
_Context.tblNoteTypes.Add(obj);
try
{
// Your code...
// Could also be before try if you know the exception occurs in SaveChanges
_Context.SaveChanges();
ModelState.Clear();
return(View());
}
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);
}
}
}
}
}
else
{
ViewBag.Message = "Note Type already exists";
}
}
return(View());
}
