public static Response SaveChanges(EcomerceDataContext db)
{
try
{
db.SaveChanges();
return(new Response {
Succeded = true,
});
}
catch (Exception ex)
{
var response = new Response {
Succeded = false,
};
if (ex.InnerException != null &&
ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("_Index"))
{
response.Message = "There is a record with the same value";
}
else if (ex.InnerException != null &&
ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("REFERENCE"))
{
response.Message = "The record can't be delete because it has related records";
}
else
{
response.Message = ex.Message;
}
return(response);
}
}
public static int GetState(string description, EcomerceDataContext db)
{
var state = db.States.Where(s => s.Description == description).FirstOrDefault();
if (state == null)
{
state = new State {
Description = description,
};
db.States.Add(state);
db.SaveChanges();
}
return(state.StateId);
}
public ActionResult Edit(User user)
{
if (ModelState.IsValid)
{
var pic = user.Photo;
var folder = "~/Content/Users";
if (user.PhotoFile != null)
{
if (pic == null || pic == string.Empty)
{
pic = FilesHelper.GetNamePhoto(user.UserId);
}
else
{
pic = pic.Substring(16);
}
if (pic != null)
{
pic = FilesHelper.UploadPhoto(user.PhotoFile, pic, folder);
pic = string.Format("{0}/{1}", folder, pic);
}
}
user.Photo = pic;
var db2 = new EcomerceDataContext();
var currenrUser = db2.Users.Find(user.UserId);
if (currenrUser.UserName != user.UserName)
{
UsersHelper.UpdateUserName(currenrUser.UserName, user.UserName);
}
db2.Dispose();
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
var respons = DBHelper.SaveChanges(db);
if (!respons.Succeded)
{
ModelState.AddModelError(string.Empty, respons.Message);
return(View(user));
}
return(RedirectToAction("Index"));
}
ViewBag.CityId = new SelectList(CombosHelper.GetCities(user.DepartmentId), "CityId", "Name", user.CityId);
ViewBag.CompanyId = new SelectList(CombosHelper.GetCompanies(), "CompanyId", "Name", user.CompanyId);
ViewBag.DepartmentId = new SelectList(CombosHelper.GetDepartments(), "DepartmentId", "Name", user.DepartmentId);
return(View(user));
}
