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)); }