public IActionResult Insert_Product([FromQuery] ProductAddandEditParam model) // done { string status; status = repository_product.Insert_Product(model); return(Json(status)); }
public string Update_Product(ProductAddandEditParam product) { string status; using (var transaction = context.Database.BeginTransaction()) { try { var count_row_product = (from b in context.Product where b.IdProduct != product.IdProduct && b.ProductName.ToLower().Contains(product.ProductName.ToLower()) && b.IdUnit == product.IdUnit select b.IdProduct).Count(); if (count_row_product == 0) { var result = context.Product.SingleOrDefault(b => b.IdProduct == product.IdProduct); if (result != null) { result.ProductName = product.ProductName; result.ProductPrice = product.ProductPrice; result.IdUnit = product.IdUnit; context.SaveChanges(); status = constant.SUCCEES; } else { status = constant.NULL; } } else { status = constant.DUPLICATE; } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); status = constant.ERROR; } } return(status); }
public string Insert_Product(ProductAddandEditParam product) { string status; using (var transaction = context.Database.BeginTransaction()) { try { var id_product = (from b in context.Product where b.ProductName.ToLower().Contains(product.ProductName.ToLower()) && b.IdUnit == product.IdUnit select b.IdProduct).Count(); if (id_product == 0) { var product1 = new Product() { ProductName = product.ProductName, ProductPrice = product.ProductPrice, IdUnit = product.IdUnit }; context.Product.Add(product1); context.SaveChanges(); status = constant.SUCCEES; } else { status = constant.DUPLICATE; } transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); status = constant.ERROR; } } return(status); }