public PartialViewResult AddProductPVAJAX(string pName, string pDesc, string pStock)
{
demo_appEntities1 DB = new demo_appEntities1();
List <SImpleWebApp.Models.T_products> plist = new List <SImpleWebApp.Models.T_products>();
var query = from st in DB.T_products
where st.P_name.Contains("")
select st;
plist = query.ToList();
if (pName == "" || pDesc == "" || pStock == null)
{
Response.Write("Fields cannot be empty, please fill in all detils");
return(PartialView(plist));
}
T_products newProduct = new T_products();
newProduct.P_name = pName;
newProduct.P_description = pDesc;
try
{
newProduct.P_stock = int.Parse(pStock);
}
catch (Exception e)
{
throw e;
}
if (DB.T_products.Find(newProduct.P_id) != null)
{
return(PartialView(plist));
}
DB.T_products.Add(newProduct);
int res;
try
{
res = DB.SaveChanges();
}
catch (Exception e)
{
throw e;
}
if (res > 0)
{
Response.Write("new product was added successfuly");
}
else
{
Response.Write("Operation Failed");
}
return(PartialView("SearchProductAJAX", plist));
}
public PartialViewResult SearchProductPVAJAX(string searchText)
{
ViewBag.Message = "Product Search Result Page.";
demo_appEntities1 DB = new demo_appEntities1();
List <SImpleWebApp.Models.T_products> plist = new List <SImpleWebApp.Models.T_products>();
var query = from st in DB.T_products
where st.P_name.Contains(searchText)
select st;
plist = query.ToList();
//check if search value did not match in the P_name table
//and check the P_description table
if (plist.Count == 0)
{
query = from st in DB.T_products
where st.P_description.Contains(searchText)
select st;
}
plist = query.ToList();
if (plist.Count == 0)
{
plist = DB.T_products.ToList();
}
return(PartialView(plist));
}
public ActionResult SearchProductAJAX(string searchText)
{
demo_appEntities1 DB = new demo_appEntities1();
ViewBag.Message = "AJAX Search.";
List <SImpleWebApp.Models.T_products> plist = new List <SImpleWebApp.Models.T_products>();
var query = from st in DB.T_products
where st.P_name.Contains(searchText)
select st;
plist = query.ToList();
if (plist.Count == 0)
{
query = from st in DB.T_products
where st.P_description.Contains(searchText)
select st;
}
plist = query.ToList();
if (plist.Count == 0)
{
plist = DB.T_products.ToList();
}
return(View(plist));
}
public PartialViewResult EditProductPVAJAX(int pid, string altName, string altDesc, int altStock)
{
demo_appEntities1 DB = new demo_appEntities1();
List <SImpleWebApp.Models.T_products> plist = new List <SImpleWebApp.Models.T_products>();
T_products tp = DB.T_products.Find(pid);
if (altName != "")
{
tp.P_name = altName;
}
if (altDesc != "")
{
tp.P_description = altDesc;
}
if (altStock != -1)
{
tp.P_stock = altStock;
}
DB.T_products.AddOrUpdate(tp);
int res;
try
{
res = DB.SaveChanges();
}
catch (Exception e)
{
throw e;
}
if (res > 0)
{
Response.Write("Selected Product was edited successfuly");
}
else
{
Response.Write("Operation Failed");
}
var query = from st in DB.T_products
where st.P_name.Contains("")
select st;
plist = query.ToList();
return(PartialView("SearchProductPVAJAX", plist));
}
public PartialViewResult RemoveProductPVAJAX(int [] pids)
{
demo_appEntities1 DB = new demo_appEntities1();
List <SImpleWebApp.Models.T_products> plist = new List <SImpleWebApp.Models.T_products>();
List <SImpleWebApp.Models.T_products> plistToRem = new List <SImpleWebApp.Models.T_products>();
//remove duplicates that arrive from the view jquery method
//TODO: (need to check why duplicates arrive to controller)
int[] pidDistinct = pids.Distinct().ToArray();
for (int i = 0; i < pidDistinct.Length; i++)
{
T_products tp = DB.T_products.Find(pidDistinct[i]);
plistToRem.Add(tp);
}
DB.T_products.RemoveRange(plistToRem);
int res;
try
{
res = DB.SaveChanges();
}
catch (Exception e)
{
throw e;
}
if (res > 0)
{
Response.Write("new product was removed successfuly");
}
else
{
Response.Write("Operation Failed");
}
var query = from st in DB.T_products
where st.P_name.Contains("")
select st;
plist = query.ToList();
return(PartialView("SearchProductPVAJAX", plist));
}