public IActionResult AddValue(Products model) { try { Trainee1334Context context = new Trainee1334Context(); bool codeExists = context.Products.Any(x => x.ProductCode == model.ProductCode); if (!codeExists) { Products pro = new Products(); if (string.IsNullOrEmpty(model.ProductCode) && string.IsNullOrEmpty(model.ProdcuctName) && model.ProductPrice != null && string.IsNullOrEmpty(model.ProductDesc)) { pro.ProductCode = model.ProductCode; pro.ProdcuctName = model.ProdcuctName; pro.ProductDesc = model.ProductDesc; pro.ProductPrice = model.ProductPrice; context.SaveChanges(); } } } catch (Exception ex) { throw ex; } return(RedirectToAction("Index")); }
public IActionResult Delete(int?id) { using (var context = new Trainee1334Context()) { Products pro = context.Products.Find(id); if (pro != null) { context.Products.Remove(pro); context.SaveChanges(); } } return(RedirectToAction("Index")); }
public List <int> Disable(List <int> ProductIds) { using (var context = new Trainee1334Context()) { var products = context.Products.Where(p => ProductIds.Contains(p.ProductId)); foreach (var product in products) { product.ActiveFlag = "0"; } context.SaveChanges(); } return(ProductIds); }
public List <int> Delete(List <int> ProductIds) { using (var context = new Trainee1334Context()) { var products = context.Products.Where(p => ProductIds.Contains(p.ProductId)); foreach (var product in products) { context.Products.Remove(product); } context.SaveChanges(); } return(ProductIds); }
public IActionResult AddnEdit(ProductsViewModel model) { if (ModelState.IsValid) { using (var context = new Trainee1334Context()) { //var query = context.Products.Where(x => x.ProductId==model.ProductId).Select(x=>x.ProductId); Products pro = context.Products.Where(x => x.ProductId == model.ProductId).FirstOrDefault(); if (pro != null) //Edit { if (pro.ProductCode != model.ProductCode) { var codeExist = context.Products.Any(x => x.ProductCode == model.ProductCode); if (codeExist) { ModelState.AddModelError("ProductCode", "Product Code not available | EDIT"); return(View(model)); } } pro.ProductCode = model.ProductCode; pro.ProdcuctName = model.ProdcuctName; pro.ProductDesc = model.ProductDesc; pro.ProductPrice = model.ProductPrice; context.SaveChanges(); return(RedirectToAction("Index")); } else //Add { var codeExist = context.Products.Any(x => x.ProductCode == model.ProductCode); if (codeExist) { ModelState.AddModelError("ProductCode", "Product Code not available | ADD"); return(View(model)); } Products product = new Products(); product.ProductCode = model.ProductCode; product.ProdcuctName = model.ProdcuctName; product.ProductDesc = model.ProductDesc; product.ProductPrice = model.ProductPrice; context.Products.Add(product); context.SaveChanges(); return(RedirectToAction("Index")); } } } return(View(model)); }
public ProductsViewModel Add(ProductsViewModel model) { var prd = new Products(); using (var context = new Trainee1334Context()) { prd.ProdcuctName = model.ProductName; prd.ProductCode = model.ProductCode; prd.ProductDesc = model.ProductDes; prd.ProductPrice = Convert.ToInt32(model.Price); context.Add(prd); context.SaveChanges(); } model.ProductId = prd.ProductId; return(model); }
public IActionResult Index() { List <ProductsViewModel> productList = new List <ProductsViewModel>(); using (var context = new Trainee1334Context()) { productList = context.Products.Select(x => new ProductsViewModel { ProductId = x.ProductId, ProductCode = x.ProductCode, ProdcuctName = x.ProdcuctName, ProductDesc = x.ProductDesc, ProductPrice = x.ProductPrice }).ToList(); } return(View(productList)); }
public List <ProductsViewModel> Disable(ProductsViewModel model) { List <ProductsViewModel> ProductList = new List <ProductsViewModel>(); using (var context = new Trainee1334Context()) { Products product = new Products(); var row = context.Products.Where(x => x.ProductCode == model.ProductCode).FirstOrDefault(); if (row != null) { row.ActiveFlag = "0"; context.Products.Update(row); context.SaveChanges(); ProductList.Add(model); } } return(ProductList); }
public IActionResult Edit(int?id) { ProductsViewModel productList = new ProductsViewModel(); using (var context = new Trainee1334Context()) { var pro = context.Products.Find(id); if (pro == null) { return(RedirectToAction("Index")); } productList.ProductId = pro.ProductId; productList.ProdcuctName = pro.ProdcuctName; productList.ProductDesc = pro.ProductDesc; productList.ProductCode = pro.ProductCode; productList.ProductPrice = pro.ProductPrice; } return(View("AddnEdit", productList)); }
public List <ProductsViewModel> Search(string searchString, int pageNum, int pageSize) { List <ProductsViewModel> ProductList = new List <ProductsViewModel>(); using (var context = new Trainee1334Context()) { ProductList = context.Products.Where(x => x.ProdcuctName.Contains(searchString)) .Select(x => new ProductsViewModel() { ProductName = x.ProdcuctName, ProductCode = x.ProductCode, ProductDes = x.ProductDesc, Price = Convert.ToInt32(x.ProductPrice), Flag = Convert.ToChar(x.ActiveFlag) }) .ToList(); } return(ProductList); }
public List <ProductsViewModel> GetProduct(int pageNum, int pageSize) { List <ProductsViewModel> ProductList = new List <ProductsViewModel>(); using (var context = new Trainee1334Context()) { var products = context.Products; foreach (var product in products) { ProductsViewModel newentry = new ProductsViewModel(); newentry.Price = Convert.ToInt32(product.ProductPrice); newentry.ProductCode = product.ProductCode; newentry.ProductDes = product.ProductDesc; newentry.ProductName = product.ProdcuctName; newentry.Flag = Convert.ToChar(product.ActiveFlag); ProductList.Add(newentry); } } return(ProductList); }
public ProductsViewModel Edit(ProductsViewModel model) { List <ProductsViewModel> ProductList = new List <ProductsViewModel>(); using (var context = new Trainee1334Context()) { Products product = new Products(); var row = context.Products.Where(x => x.ProductCode == model.ProductCode).FirstOrDefault(); if (row != null) { row.ProdcuctName = model.ProductName; row.ProductCode = model.ProductCode; row.ProductDesc = model.ProductDes; row.ProductPrice = Convert.ToInt32(model.Price); context.Products.Update(row); context.SaveChanges(); ProductList.Add(model); } } return(model); }
public List <ProductsViewModel> Delete(ProductsViewModel model) { List <ProductsViewModel> ProductList = new List <ProductsViewModel>(); using (var context = new Trainee1334Context()) { Products product = new Products(); var temp_var = model.ProductCode; bool i = context.Products.Any(x => x.ProductCode == temp_var); var entity = context.Products.FirstOrDefault(x => x.ProductCode == temp_var); if (entity == null) { } else { context.Products.Remove(entity); context.SaveChanges(); } } return(ProductList); }
public List <ProductsViewModel> Add(ProductsViewModel model) { List <ProductsViewModel> ProductList = new List <ProductsViewModel>(); using (var context = new Trainee1334Context()) { bool codeExists = context.Products.Any(x => x.ProductCode == model.ProductCode); if (!codeExists) { Products product = new Products(); product.ProdcuctName = model.ProductName; product.ProductCode = model.ProductCode; product.ProductDesc = model.ProductDes; product.ProductPrice = Convert.ToInt32(model.Price); product.ActiveFlag = Convert.ToString(model.Flag); context.Products.Add(product); context.SaveChanges(); ProductList.Add(model); } } return(ProductList); }
public IActionResult EditValue(Products model) { try { Trainee1334Context context = new Trainee1334Context(); Products pro = context.Products.Where(p => p.ProductCode == model.ProductCode).FirstOrDefault(); if (pro != null) { if (!string.IsNullOrEmpty(model.ProdcuctName) && model.ProductPrice != null && !string.IsNullOrEmpty(model.ProductDesc)) { pro.ProdcuctName = model.ProdcuctName; pro.ProductDesc = model.ProductDesc; pro.ProductPrice = model.ProductPrice; context.SaveChanges(); } } } catch (Exception ex) { throw ex; } return(RedirectToAction("Index")); }