private void btn_Grabar_Click_1(object sender, EventArgs e)
{
if (this.esGrupoNuevo)
{
var tiposSocio = new TiposSocio
{
Nombre = txt_Nombre.Text,
Descripcion = rtb_Descripcion.Text,
EstaActivo = cb_EstaActivo.Checked
};
_Contexto.TipoSocios.Add(tiposSocio);
_Contexto.SaveChanges();
this.ActualizarListadoGruposClientes();
this.disableAll();
this.clearAll();
}
else
{
var idGrupo = int.Parse(txt_Id.Text);
var grupoCliente = _Contexto.TipoSocios.FirstOrDefault(t => t.Id_TipoSocio == idGrupo);
grupoCliente.Nombre = txt_Nombre.Text;
grupoCliente.Descripcion = rtb_Descripcion.Text;
grupoCliente.EstaActivo = cb_EstaActivo.Checked;
_Contexto.SaveChanges();
this.ActualizarListadoGruposClientes();
this.disableAll();
this.clearAll();
}
this.esGrupoNuevo = false;
}
public ActionResult Create([Bind(Include = "ProductID,ProductName,CompanyName,CategoryName,QuantityPerUnit,UnitPrice,InStock,OnOrder,Discontinue")] Products products)
{
if (ModelState.IsValid)
{
db.Products.Add(products);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(products));
}
public ActionResult Create([Bind(Include = "CategoryID,CategoryName,PhotoPath")] Categories categories)
{
if (ModelState.IsValid)
{
db.Categories.Add(categories);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(categories));
}
public ActionResult Create([Bind(Include = "SupplierID,CompanyName,Address,Phone,Homepage")] Suppliers suppliers)
{
if (ModelState.IsValid)
{
db.Suppliers.Add(suppliers);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(suppliers));
}
public ActionResult Create([Bind(Include = "Cat_id,Product_id,Product_Name,Product_Price,Product_QTY,Product_Writing_Date,Product_Description,Product_Image")] Products products)
{
if (ModelState.IsValid)
{
db.Products.Add(products);
db.SaveChanges();
var prods = db.Products.Include(p => p.Categories);
return(PartialView("PartialProductsTable", prods.ToList()));
}
ViewBag.Cat_id = new SelectList(db.Categories, "Cat_id", "Cat_Name", products.Cat_id);
return(View(products));
}
//Methods
public bool Save(Orden order)
{
try
{
var data = ConvertToTable(order);
db.TOrden.Add(data);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public IHttpActionResult Create([FromBody] ProductViewModel dataBody)
{
using (var db = new DB_Context())
{
try
{
Dictionary <string, object> result = new Dictionary <string, object>();
Product newProduct = new Product()
{
ProductID = dataBody.ProductID,
ProductName = dataBody.ProductName,
SupplierID = dataBody.SupplierID,
CategoryID = dataBody.CategoryID,
QuantityPerUnit = dataBody.QuantityPerUnit,
UnitPrice = dataBody.UnitPrice,
UnitsInStock = dataBody.UnitsInStock,
UnitsOnOrder = dataBody.UnitsOnOrder,
ReorderLevel = dataBody.ReorderLevel,
Discontinued = dataBody.Discontinued
};
// menambahkan kategori baru ke Category Entity Database
db.Products.Add(newProduct);
// method yang digunakan untuk menyimpan perubahan baru di database
db.SaveChanges();
result.Add("Message", "Insert data success");
return(Ok(result));
}
catch (Exception)
{
throw;
}
}
}
public IHttpActionResult Update([FromBody] ProductViewModel dataBody)
{
// membuat koneksi DB
var db = new DB_Context();
try
{
Dictionary <string, object> result = new Dictionary <string, object>();
// Buat Object dan menginisialisasi dengan data dari database menggunakan method Find(Primary Key)
Product product = db.Products.Find(dataBody.ProductID);
// inisialisasi data yang akan dirubah
product.ProductID = dataBody.ProductID;
product.ProductName = dataBody.ProductName;
product.SupplierID = dataBody.SupplierID;
product.CategoryID = dataBody.CategoryID;
product.QuantityPerUnit = dataBody.QuantityPerUnit;
product.UnitPrice = dataBody.UnitPrice;
product.UnitsInStock = dataBody.UnitsInStock;
product.UnitsOnOrder = dataBody.UnitsOnOrder;
product.ReorderLevel = dataBody.ReorderLevel;
product.Discontinued = dataBody.Discontinued;
db.SaveChanges();
db.Dispose();
result.Add("Message", "Update data success");
return(Ok(result));
}
catch (Exception)
{
throw;
}
}
public string CreateTransaction(DateTime transactionTime, Guid userId, string notes, decimal amount)
{
try
{
var user = _context.Users.FirstOrDefault(f => f.UserId == userId);
var transaction = new PaymentTransaction();
if (user != null)
{
if ((user.Amount - amount) <= 0)
{
throw new AppExeption("Недостаточно средств на счету.");
}
transaction = new PaymentTransaction(transactionTime, userId, notes, amount);
_context.Transactions.Add(transaction);
user.Amount -= amount;
_context.SaveChanges();
}
else
{
throw new AppExeption("Пользователь не найден");
}
return("Транзакция успешна. Ид транзакции: " + transaction.TransactionId);
}
catch (Exception exc)
{
throw new AppExeption(exc.Message, exc);
}
}
public IHttpActionResult Update([FromBody] RegionViewModel dataBody)
{
using (var db = new DB_Context())
{
try
{
Dictionary <string, object> result = new Dictionary <string, object>();
List <RegionViewModel> listRegion = new List <RegionViewModel>();
Region regionTemp = db.Regions.Find(dataBody.RegionID);
regionTemp.RegionID = dataBody.RegionID;
regionTemp.RegionDescription =
dataBody.RegionName + "|" +
dataBody.RegionLangitude + "|" +
dataBody.RegionLatitude + "|" +
dataBody.Country;
RegionViewModel region = new RegionViewModel(regionTemp);
listRegion.Add(region);
db.SaveChanges();
result.Add("Message", "Update data success");
result.Add("data", listRegion);
return(Ok(result));
}
catch (Exception)
{
throw;
}
}
}
private void btn_GrabarTipo_Click(object sender, EventArgs e)
{
if (_tipoArticulosNueno)
{
_contexto.Dispose();
_contexto = new DB_Context();
var NuevoTipoArticulo = new TipoArticulo
{
Nombre = txt_Nombre.Text,
Descripcion = rtb_Descripcion.Text,
EstasActivo = ckb_EstaAciva.Checked
};
_contexto.TipoArticulos.Add(NuevoTipoArticulo);
_contexto.SaveChanges();
MessageBox.Show(" Tipo de articulo ha sido creado exitosamente");
this.ClearAll("all");
this.LoadListaArticulos();
}
else
{
_contexto.Dispose();
_contexto = new DB_Context();
int IdTipoArticulo = int.Parse(txt_Id.Text);
var ModificarTipoArticulo = _contexto.TipoArticulos.FirstOrDefault(t => t.Id_TipoArticulo == IdTipoArticulo);
ModificarTipoArticulo.Nombre = txt_Nombre.Text;
ModificarTipoArticulo.Descripcion = rtb_Descripcion.Text;
ModificarTipoArticulo.EstasActivo = ckb_EstaAciva.Checked;
_contexto.SaveChanges();
MessageBox.Show(" Tipo de articulo ha sido Modificado exitosamente");
this.ClearAll("all");
this.LoadListaArticulos();
}
}
public IHttpActionResult calculateProductUnitPrice([FromBody] ProductDetailCalculatorParameter parameter)
{
try
{
using (var db = new DB_Context())
{
var temp = db.Products.AsQueryable();
Dictionary <string, object> result = new Dictionary <string, object>();
var listProduct = db.Products.OrderByDescending(data => data.ProductID).ToList();
ProductCalculator calculator = new ProductCalculator(';');
foreach (var item in listProduct)
{
calculator.calculateProductUnitPrice(item, parameter);
}
db.SaveChanges();
return(Ok("Data Saved Successfully"));
}
}
catch (Exception)
{
throw;
}
}
public void AddList(string userId, TList list)
{
if (string.IsNullOrEmpty(userId))
{
throw new ArgumentNullException(nameof(userId));
}
if (list == null)
{
throw new ArgumentNullException(nameof(list));
}
list.UserId = userId;
_Db.TList.Add(list);
_Db.SaveChanges();
}
public IHttpActionResult Update([FormBody] ProductViewModel databody)
{
using (var db = new DB_Context())
{
try
{
Dictionary <string, object> result = new Dictionary <string, object>();
Product product = db.Products.Find(databody.ProductID);
product.ProductID = databody.ProductID;
product.ProductName = databody.ProductName;
product.SupplierID = databody.SupplierID;
product.CategoryID = databody.CategoryID;
product.QuantityPerUnit = databody.QuantityPerUnit;
product.UnitPrice = databody.UnitPrice;
product.UnitsInStock = databody.UnitsInStock;
product.UnitsOnOrder = databody.UnitsOnOrder;
product.ReorderLevel = databody.ReorderLevel;
product.Discontinued = databody.Discontinued;
db.SaveChanges();
result.Add("Message", "Update Data Success");
return(Ok(result));
}
catch (Exception)
{
throw;
}
}
}
public void AddTask(int idList, TTask task)
{
if (idList == 0)
{
throw new ArgumentNullException(nameof(idList));
}
if (task == null)
{
throw new ArgumentNullException(nameof(task));
}
task.IdList = idList;
_Db.TTask.Add(task);
_Db.SaveChanges();
}
public IHttpActionResult Update([FormBody] CategoryViewModel databody)
{
var db = new DB_Context();
try
{
Dictionary <string, object> result = new Dictionary <string, object>();
Category category = db.Categories.Find(databody.CategoryID);
category.CategoryID = databody.CategoryID;
category.CategoryName = databody.CategoryName;
category.Description = databody.Description;
category.Picture = databody.Picture;
db.SaveChanges();
db.Dispose();
result.Add("Message", "Update Data Success");
return(Ok(result));
}
catch (Exception)
{
throw;
}
}
public IHttpActionResult Create([FormBody] CategoryViewModel databody)
{
var db = new DB_Context();
try
{
Dictionary <string, object> result = new Dictionary <string, object>();
Category newCategory = new Category()
{
CategoryID = databody.CategoryID,
CategoryName = databody.CategoryName,
Description = databody.Description,
Picture = databody.Picture
};
db.Categories.Add(newCategory);
db.SaveChanges();
db.Dispose();
result.Add("Message", "Insert Data Success");
return(Ok(result));
}
catch (Exception)
{
throw;
}
}
public IHttpActionResult Update([FromBody] RegDetailViewModel databody)
{
using (var db = new DB_Context())
{
try
{
Dictionary <string, object> result = new Dictionary <string, object>();
List <RegDetailViewModel> regUpdate = new List <RegDetailViewModel>();
Region region = db.Regions.Find(databody.RegionID);
databody.updateRegion(region);
var reg = db.Regions.Where(data => data.RegionID == databody.RegionID).AsEnumerable().ToList();
foreach (var item in reg)
{
RegDetailViewModel regView = new RegDetailViewModel(item);
regUpdate.Add(regView);
}
db.SaveChanges();
result.Add("Data", regUpdate);
return(Ok(result));
}
catch (Exception)
{
throw;
}
}
}
public IHttpActionResult Create([FromBody] RegDetailViewModel databody)
{
using (var db = new DB_Context())
{
try
{
Dictionary <string, object> result = new Dictionary <string, object>();
List <RegDetailViewModel> listRegion = new List <RegDetailViewModel>();
var temp = databody.convertToRegion();
db.Regions.Add(temp);
db.SaveChanges();
var reg = db.Regions.Where(data => data.RegionID == databody.RegionID).AsEnumerable().ToList();
foreach (var item in reg)
{
RegDetailViewModel regView = new RegDetailViewModel(item);
listRegion.Add(regView);
}
databody.insTeritory(db);
result.Add("Data", listRegion);
return(Ok(result));
}
catch (Exception)
{
throw;
}
}
}
public IHttpActionResult Create([FormBody] ProductViewModel databody)
{
using (var db = new DB_Context())
{
try
{
Dictionary <string, object> result = new Dictionary <string, object>();
Product newProduct = new Product()
{
ProductID = databody.ProductID,
ProductName = databody.ProductName,
SupplierID = databody.SupplierID,
CategoryID = databody.CategoryID,
QuantityPerUnit = databody.QuantityPerUnit,
UnitPrice = databody.UnitPrice,
UnitsInStock = databody.UnitsInStock,
UnitsOnOrder = databody.UnitsOnOrder,
ReorderLevel = databody.ReorderLevel,
Discontinued = databody.Discontinued
};
db.Products.Add(newProduct);
db.SaveChanges();
result.Add("Message", "Insert Data Success");
return(Ok(result));
}
catch (Exception)
{
throw;
}
}
}
//DB_Context context = new DB_Context();
public ActionResult UploadDocument(string project = "", string uploadFile = "")
// Uploads file from client to server - uses async task
{
// Check that Project Name is set, if so save it to database
if (project != "")
{
// Get UrserId if logged on
string myId = User.Identity.GetUserId();
if (CheckExistProject(myId, project))
{
ViewBag.Message = "Project " + project + " exists already. Choose another name!";
return(View());
}
DB_Context context = new DB_Context();
Project myProject = new Project();
myProject.ProjectId = 1;
myProject.UserId = myId;
myProject.ProjectName = project;
context.Project.Add(myProject);
context.SaveChanges();
context.Dispose();
// return with the action to show file content on screen
return(RedirectToAction("FileParser", new { project = project, csvFile = uploadFile }));
//return View("../Home/Index");
}
else
{
return(View());
}
}
public static Usuario registrarse(string _usuario, string _contraseña)
{
if (!ValidadorDeContraseña.getInstanceValidadorContra().validarContraseña(_contraseña))
{
return(null);
}
else
{
var contexto = new DB_Context();
var usuarioExistente = contexto.usuario
.Where(u => u.NombreUsuario == _usuario)
.FirstOrDefault();
if (usuarioExistente == null)
{
Usuario usuarioNuevo = new Usuario(_contraseña, _usuario);
contexto.usuario.Add(usuarioNuevo);
contexto.SaveChanges();
Logger.getInstance.update("Se agrega un nuevo usuario." + " ID Usuario:" + usuarioNuevo.ID_Usuario.ToString());
return(usuarioNuevo);
}
else
{
return(null);
}
}
}
//BOTON GRABAR
private void button4_Click(object sender, EventArgs e)
{
if (this.EsMarcaNueva)
{
bool _estaActivo;
if (comboBox1.Text == "Activo")
{
_estaActivo = true;
}
else
{
_estaActivo = false;
}
var MarcaGrabar = new Marca
{
Nombre = textBox2.Text,
Descripcion = richTextBox1.Text,
EstasActivo = _estaActivo
};
_Contexto.Marcas.Add(MarcaGrabar);
_Contexto.SaveChanges();
MessageBox.Show("Marca NUEVA grabada con exito.");
this.EsMarcaNueva = false;
}
this.Disable_All_Controls();
this.Clear_All_Controls();
}
public IHttpActionResult Create([FromBody] ProductsViewModel dataBody)
{
var DB = new DB_Context();
try
{
Dictionary <string, object> result = new Dictionary <string, object>();
Product newProduct = new Product()
{
ProductID = dataBody.ProductID,
ProductName = dataBody.ProductName,
SupplierID = dataBody.SupplierID,
CategoryID = dataBody.CategoryID,
QuantityPerUnit = dataBody.QuantityPerUnit,
UnitPrice = dataBody.UnitPrice,
UnitsInStock = dataBody.UnitsInStock,
ReorderLevel = dataBody.ReorderLevel,
Discontinued = dataBody.Discontinued
};
DB.Products.Add(newProduct);
DB.SaveChanges();
DB.Dispose();
result.Add("Message", "Read Data Succses");
return(Ok(result));
}
catch (Exception)
{
throw;
}
}
public IHttpActionResult Update([FromBody] ProductsViewModel dataBody)
{
var DB = new DB_Context();
try
{
Dictionary <string, object> result = new Dictionary <string, object>();
Product product = DB.Products.Find(dataBody.ProductID);
product.ProductID = dataBody.ProductID;
product.ProductName = dataBody.ProductName;
product.CategoryID = dataBody.CategoryID;
product.QuantityPerUnit = dataBody.QuantityPerUnit;
product.UnitPrice = dataBody.UnitPrice;
product.UnitsInStock = dataBody.UnitsInStock;
product.ReorderLevel = dataBody.ReorderLevel;
product.Discontinued = dataBody.Discontinued;
DB.SaveChanges();
DB.Dispose();
result.Add("Message", "Update Data Succses");
return(Ok(result));
}
catch (Exception)
{
throw;
}
}
public bool Delete(int id)
{
try
{
var data = db.TCuestionarioRegistro.Find(id);
db.TCuestionarioRegistro.Remove(data);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public bool Delete(int id)
{
try
{
var data = db.TReparacion.Find(id);
db.TReparacion.Remove(data);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public IHttpActionResult Create([FromBody] CategoryViewModel dataBody)
{
var db = new DB_Context();
try
{
Dictionary <string, object> result = new Dictionary <string, object>();
// Buat Object dan menginisialisasi dengan data dari body
Category newCategory = new Category()
{
CategoryID = dataBody.CategoryID,
CategoryName = dataBody.CategoryName,
Description = dataBody.Description,
Picture = dataBody.picture
};
// menambahkan kategori baru ke Category Entity Database
db.Categories.Add(newCategory);
// method yang digunakan untuk menyimpan perubahan baru di database
db.SaveChanges();
db.Dispose();
result.Add("Message", "Insert data success");
return(Ok(result));
}
catch (Exception)
{
throw;
}
}
public IHttpActionResult Update([FromBody] CategoryViewModel dataBody)
{
// membuat koneksi DB
var db = new DB_Context();
try
{
Dictionary <string, object> result = new Dictionary <string, object>();
// Buat Object dan menginisialisasi dengan data dari database menggunakan method Find(Primary Key)
Category category = db.Categories.Find(dataBody.CategoryID);
// inisialisasi data yang akan dirubah
category.CategoryID = dataBody.CategoryID;
category.CategoryName = dataBody.CategoryName;
category.Description = dataBody.Description;
category.Picture = dataBody.picture;
db.SaveChanges();
db.Dispose();
result.Add("Message", "Update data success");
return(Ok(result));
}
catch (Exception)
{
throw;
}
}
public IActionResult Register(Movie movie)
{
if (!ModelState.IsValid)
{
return(RedirectToAction("Index"));
}
_context.Movies.Add(movie);
_context.SaveChanges();
return(View(movie));
}
