public ActionResult Create([Bind(Include = "ArsId,ArsCodigo,ArsNombre,ArsActivo,InstitucionId,ArsUsuarioRegistra,ArsFechaRegistro,ArsUsuarioModifica,ArsFechaModifica")] Ars ars)
{
if (ModelState.IsValid)
{
db.Ars.Add(ars);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ars));
}
public ActionResult Create([Bind(Include = "SupplierID,rowguid,Name,Code,CompanyName,NRC,NIT,CreationDate,CreatedBy,ModifiedDate,ModifiedBy")] Supplier supplier)
{
if (ModelState.IsValid)
{
db.Supplier.Add(supplier);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(supplier));
}
public ActionResult Create([Bind(Include = "ComponentID,Code,Description,ComponentCategoryID,UomID,CustomerID,CustomerCode,CountryOfOrigin,SupplierID,SupplierCode,Description2,PurchasingPrice,PurchasingTerms,ListPrice,HtsID,SacID,IsActive,DiscontinuedDate,CreationDate,CreatedBy,ModifiedDate,ModifiedBy,rowguid")] Component component)
{
if (ModelState.IsValid)
{
db.Component.Add(component);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ComponentCategoryID = new SelectList(db.ComponentCategory, "ComponentCategoryID", "Name", component.ComponentCategoryID);
ViewBag.CustomerID = new SelectList(db.Customer, "CustomerID", "CreatedBy", component.CustomerID);
ViewBag.SupplierID = new SelectList(db.Supplier, "SupplierID", "Name", component.SupplierID);
ViewBag.UomID = new SelectList(db.UnitMeasure, "UomID", "Code", component.UomID);
return(View(component));
}
public ActionResult Create([Bind(Include = "CustomerID,Name,Code,CompanyName,NRC,NIT")] Customer customer)
{
customer.CreationDate = DateTime.Now.Date;
customer.CreatedBy = User.Identity.GetUserId();
customer.rowguid = Guid.NewGuid();
if (ModelState.IsValid)
{
db.Customer.Add(customer);
var item = from a in db.Customer
where a.Name == customer.Name || a.NIT == customer.NIT || a.NRC == customer.NRC
select a;
if (item.Count() == 0)
{
try
{
db.SaveChanges();
TempData["ResultMessage"] = "Data saved correctly";
TempData["ResultType"] = "S";
return(View("Index"));
}
catch (Exception ex)
{
TempData["ResultMessage"] = "Fail while saving data. " + ex.Message;
TempData["ResultType"] = "E";
return(View(customer));
}
}
else
{
TempData["ResultMessage"] = "Color " + customer.Name + " already exist in the system";
TempData["ResultType"] = "E";
return(View(customer));
}
}
else
{
TempData["ResultMessage"] = "Data are not valid";
TempData["ResultType"] = "W";
return(View(customer));
}
}
public ActionResult CategoryCreate([Bind(Include = "Name,Description")] ComponentCategory category)
{
category.CreationDate = DateTime.Now.Date;
category.CreatedBy = User.Identity.GetUserId();
category.rowguid = Guid.NewGuid();
if (ModelState.IsValid)
{
db.ComponentCategory.Add(category);
var item = from a in db.ComponentCategory
where a.Name == category.Name
select a;
if (item.Count() == 0)
{
try
{
db.SaveChanges();
TempData["ResultMessage"] = "Data saved correctly";
TempData["ResultType"] = "S";
}
catch (Exception ex)
{
TempData["ResultMessage"] = "Fail while saving data. " + ex.Message;
TempData["ResultType"] = "E";
}
}
else
{
TempData["ResultMessage"] = "Color " + category.Name + " already exist in the system";
TempData["ResultType"] = "E";
}
}
else
{
TempData["ResultMessage"] = "Data are not valid";
TempData["ResultType"] = "W";
}
return(RedirectToAction("CategoryIndex"));
}
public ActionResult ColorCreate([Bind(Include = "Name, Description")] Colors color)
{
color.ModifiedDate = DateTime.Now.Date;
if (ModelState.IsValid)
{
db.Colors.Add(color);
var item = from a in db.Colors
where a.Name == color.Name
select a;
if (item.Count() == 0)
{
try
{
db.SaveChanges();
TempData["ResultMessage"] = "Data saved correctly";
TempData["ResultType"] = "S";
}
catch (Exception ex)
{
TempData["ResultMessage"] = "Fail while saving data. " + ex.Message;
TempData["ResultType"] = "E";
}
}
else
{
TempData["ResultMessage"] = "Color " + color.Name + " already exist in the system";
TempData["ResultType"] = "E";
//return PartialView("_ColorCreate", color);
}
}
else
{
TempData["ResultMessage"] = "Data are not valid";
TempData["ResultType"] = "W";
//return PartialView("_ColorCreate", color);
}
return(RedirectToAction("ColorIndex"));
}
public ActionResult SavePermission(string query, string qtype)
{
string fquery = "{\"PERMISSION\":" + query + "}";
if (qtype == "r")
{
/*DELETING ROWS*/
var data = Newtonsoft.Json.Linq.JObject.Parse(fquery);
String roleId = Convert.ToString(data["PERMISSION"][0]["RoleID"]);
var rows = from r in db.Permission
where r.RoleID == roleId
select r;
foreach (var row in rows)
{
db.Permission.Remove(row);
}
db.SaveChanges();
int menu;
string role;
for (int i = 0; i < data["PERMISSION"].Count(); i++)
{
menu = (int)data["PERMISSION"][i]["MenuID"];
role = (string)data["PERMISSION"][i]["RoleID"];
db.Permission.Add(new Permission {
MenuID = menu, RoleID = role
});
}
try
{
db.SaveChanges();
TempData["ResultMessage"] = "Los datos se guardaron correctamente";
TempData["ResultType"] = "S";
}
catch (Exception ex)
{
TempData["ResultMessage"] = "Error al guardar los datos! " + ex.Message;
TempData["ResultType"] = "E";
}
}
if (qtype == "u")
{
/*DELETING ROWS*/
var data = Newtonsoft.Json.Linq.JObject.Parse(fquery);
String userId = Convert.ToString(data["PERMISSION"][0]["UserID"]);
var rows = from r in db.CustomPermission
where r.UserID == userId
select r;
foreach (var row in rows)
{
db.CustomPermission.Remove(row);
}
db.SaveChanges();
int menu;
string user;
for (int i = 0; i < data["PERMISSION"].Count(); i++)
{
menu = (int)data["PERMISSION"][i]["MenuID"];
user = (String)data["PERMISSION"][i]["UserID"];
db.CustomPermission.Add(new CustomPermission {
MenuID = menu, UserID = user
});
}
try
{
db.SaveChanges();
TempData["ResultMessage"] = "Los datos se guardaron correctamente";
TempData["ResultType"] = "S";
}
catch (Exception ex)
{
TempData["ResultMessage"] = "Error al guardar los datos! " + ex.Message;
TempData["ResultType"] = "E";
}
}
return(RedirectToAction("Index"));
}
