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