public ActionResult Create(User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
UserHelper.CreateUserASP(user.UserName, "User");
if (user.PhotoFile != null)
{
var folder = "~/Content/Users";
var file = string.Format("{0}.jpg", user.UserId);
var response = FilesHelper.UploadPhoto(user.PhotoFile, folder, file);
if (response)
{
var pic = string.Format("{0}/{1}.jpg", folder, user.UserId);
user.Photo = pic;
db.Entry(user).State = EntityState.Modified;
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
ViewBag.CityId = new SelectList(CombosHelper.GetCities(), "CityId", "Name", user.CityId);
ViewBag.CompanyId = new SelectList(CombosHelper.GetCompanies(), "CompanyId", "Name", user.CompanyId);
ViewBag.CountryId = new SelectList(CombosHelper.GetCountries(), "CountryId", "Name", user.CountryId);
return(View(user));
}
public ActionResult Create(Category category)
{
if (ModelState.IsValid)
{
db.Categories.Add(category);
db.SaveChanges();
if (category.ImageFile != null)
{
var folder = "~/Content/Categories";
var file = string.Format("{0}.jpg", category.CategoryId);
var response = FilesHelper.UploadPhoto(category.ImageFile, folder, file);
if (response)
{
var pic = string.Format("{0}/{1}.jpg", folder, category.CategoryId);
category.Image = pic;
db.Entry(category).State = EntityState.Modified;
db.SaveChanges();
}
}
return(RedirectToAction("Index"));
}
ViewBag.CompanyId = new SelectList(db.Companies, "CompanyId", "Name", category.CompanyId);
return(View(category));
}
public static Response SaveChanges(StartupContext db)
{
try
{
db.SaveChanges();
return(new Response {
Succedeed = true,
});
}
catch (Exception ex)
{
var response = new Response {
Succedeed = false,
};
if (ex.InnerException != null &&
ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("_Index"))
{
response.Message = "Ya existe un registro con ese nombre";
}
else if (ex.InnerException != null &&
ex.InnerException.InnerException != null &&
ex.InnerException.InnerException.Message.Contains("REFERENCE"))
{
response.Message = "El registro no puede ser borrado porque tiene otros registros relacionados";
}
else
{
response.Message = ex.Message;
}
return(response);
}
}
public ActionResult DeleteCity(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var city = db.Cities.Find(id);
if (city == null)
{
return(HttpNotFound());
}
db.Cities.Remove(city);
db.SaveChanges();
return(RedirectToAction($"{nameof(Details)}/{city.CountryId}"));
}
public ActionResult Create(Customer customer)
{
if (ModelState.IsValid)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Customers.Add(customer);
var response = DBHelper.SaveChanges(db);
if (!response.Succedeed)
{
ModelState.AddModelError(string.Empty, response.Message);
transaction.Rollback();
ViewBag.CityId = new SelectList(CombosHelper.GetCities(), "CityId", "Name", customer.CityId);
ViewBag.DepartmentId = new SelectList(CombosHelper.GetCountries(), "CountryId", "Name", customer.CountryId);
}
UserHelper.CreateUserASP(customer.UserName, "Customer");
var user = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
var companyCustomer = new CompanyCustomer
{
CompanyId = user.CompanyId,
CustomerId = customer.CustomerId,
};
db.CompanyCustomers.Add(companyCustomer);
db.SaveChanges();
transaction.Commit();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
transaction.Rollback();
ModelState.AddModelError(string.Empty, ex.Message);
}
}
}
ViewBag.CityId = new SelectList(CombosHelper.GetCities(), "CityId", "Name", customer.CityId);
ViewBag.CountryId = new SelectList(CombosHelper.GetCountries(), "CountryId", "Name", customer.CountryId);
return(View(customer));
}
