protected void default_searchbox_button_Click(object sender, EventArgs e)
{
string itms = default_searchbox_textbox.Text;
using (SaPEEntitiesRemote itmsearch = new SaPEEntitiesRemote())
{
/*var query = (from x in itmsearch.item_table where x.ItemName.Contains("x") select x);*/
/*var query = (from x in itmsearch.item_table where x.ItemName.IndexOf("x", StringComparison.InvariantCultureIgnoreCase) >= 0 select x);*/
var query = (from x in itmsearch.item_table where x.ItemName == itms select x);
default_repeater1.DataSource = query.ToList();
default_repeater1.DataBind();
}
}
/*begin adding item pushcart code similar to merchandise types*/
public string add_item(item_pushcart itempushcart)
{
try
{
SaPEEntitiesRemote db = new SaPEEntitiesRemote();
db.item_pushcart.Add(itempushcart);
db.SaveChanges();
return(itempushcart.BuyDate + " Added Sucessfull");
}
catch (Exception e)
{
return("Something When Wrong" + e);
}
}
/*begin adding item versions code*/
public string add_item(item_versions itemversions)
{
try
{
SaPEEntitiesRemote db = new SaPEEntitiesRemote();
db.item_versions.Add(itemversions);
db.SaveChanges();
return(itemversions.ItemName + " Added Sucessfull");
}
catch (Exception e)
{
return("Something When Wrong" + e);
}
}
/*end array list of item from table*/
/*begin array list of item versions from table*/
public List <item_table> retrieve_item_versions(int Versions)
{
try
{
using (SaPEEntitiesRemote db = new SaPEEntitiesRemote())
{
List <item_table> itemtable = (from x in db.item_table where x.Versions == Versions select x).ToList();
return(itemtable);
}
}
catch
{
return(null);
}
}
/*end updating item pushcart code similar to item versions*/
/*begin array list of item from table*/
public List <item_table> retrieve_all_item()
{
try
{
using (SaPEEntitiesRemote db = new SaPEEntitiesRemote())
{
List <item_table> itemtable = (from x in db.item_table select x).ToList();
return(itemtable);
}
}
catch (Exception)
{
return(null);
}
}
/*begin getting item from table*/
public item_table retrieve_item(int Code)
{
try
{
using (SaPEEntitiesRemote db = new SaPEEntitiesRemote())
{
item_table itemtable = db.item_table.Find(Code);
return(itemtable);
}
}
catch (Exception)
{
return(null);
}
}
/*end adding item pushcart code similar to merchandise types*/
/*begin deleting item pushcart code similar to merchandise types*/
public string delete_item(int Code)
{
try
{
SaPEEntitiesRemote db = new SaPEEntitiesRemote();
item_pushcart itempushcart = db.item_pushcart.Find(Code);
db.item_pushcart.Attach(itempushcart);
db.item_pushcart.Remove(itempushcart);
db.SaveChanges();
return(itempushcart.BuyDate + " Deleted Sucessfull");
}
catch (Exception e)
{
return("Something When Wrong" + e);
}
}
/*end deleting item versions code*/
/*begin updating item versions code*/
public string update_item(int Code, item_versions itemversions)
{
try
{
SaPEEntitiesRemote db = new SaPEEntitiesRemote();
item_versions i = db.item_versions.Find(Code);
i.ItemName = itemversions.ItemName;
db.SaveChanges();
return("Updated Successfull");
}
catch (Exception e)
{
return("Something When Wrong" + e);
}
}
/*end adding item versions code*/
/*begin deleting item versions code*/
public string delete_item(int Code)
{
try
{
SaPEEntitiesRemote db = new SaPEEntitiesRemote();
item_versions itemversions = db.item_versions.Find(Code);
db.item_versions.Attach(itemversions);
db.item_versions.Remove(itemversions);
db.SaveChanges();
return(itemversions.ItemName + " Deleted Sucessfull");
}
catch (Exception e)
{
return("Something When Wrong" + e);
}
}
/*end deleting item pushcart code similar to merchandise types*/
/*begin updating item pushcart code similar to merchandise types*/
public string update_item(int Code, item_pushcart itempushcart)
{
try
{
SaPEEntitiesRemote db = new SaPEEntitiesRemote();
item_pushcart i = db.item_pushcart.Find(Code);
i.UserCode = itempushcart.UserCode;
i.PushCart = itempushcart.PushCart;
i.ItemCode = itempushcart.ItemCode;
i.BuyDate = itempushcart.BuyDate;
i.Total = itempushcart.Total;
db.SaveChanges();
return("Updated Successfull");
}
catch (Exception e)
{
return("Something When Wrong" + e);
}
}
/*end deleting item to table*/
/*begin updating item to table*/
public string update_item(int Code, item_table itemtable)
{
try
{
SaPEEntitiesRemote db = new SaPEEntitiesRemote();
item_table i = db.item_table.Find(Code);
i.ItemName = itemtable.ItemName;
i.Versions = itemtable.Versions;
i.ItemDetails = itemtable.ItemDetails;
i.ItemCostBND = itemtable.ItemCostBND;
i.ItemDisplay = itemtable.ItemDisplay;
db.SaveChanges();
return("Updated Successfull");
}
catch (Exception e)
{
return("Something When Wrong" + e);
}
}
