public List<Stationary_Catalogue> getItemName(String statCat)
{
Stationary_Catalogue sCat = new Stationary_Catalogue();
sCat.Category = statCat;
List<Stationary_Catalogue> itemName = statCatEnt.getStatCat(sCat);
return itemName;
}
protected void btnGenereatePO_Click(object sender, EventArgs e)
{
List<Stationary_Catalogue> lstItems = new List<Stationary_Catalogue>();
int count = 0;
foreach (GridViewRow r in GridView1.Rows)
{
CheckBox chk = (CheckBox)r.FindControl("selChkBox");
if (chk.Checked)
{
//lblCheck.Text += r.Cells[1].Text + "<br>";
Stationary_Catalogue item = new Stationary_Catalogue();
item.Item_Code = r.Cells[1].Text;
lstItems.Add(item);
count++;
}
}
if (lstItems.Count > 0)
{
Session["itemCode"] = lstItems;
Response.BufferOutput = true;
Response.Redirect("PurchaseOrder.aspx");
}
else
lblStatus2.Text = "No record selected";
}
public List<view_Check_Existing_Stock> getBalanceByItemCode(string itCode)
{
Stationary_Catalogue stCat = new Stationary_Catalogue();
stCat.Item_Code = itCode;
List<view_Check_Existing_Stock> balance = statCatEnt.getExistingStock(stCat);
return balance;
}
public List<Stationary_Catalogue> getItemDescription(string category)
{
StationaryCatalogueEnt ent = new StationaryCatalogueEnt();
Stationary_Catalogue searchCat = new Stationary_Catalogue();
searchCat.Category = category;
List<Stationary_Catalogue> desc = ent.getStatCat(searchCat);
return desc;
}
public List<Stationary_Catalogue> getItemCode(string description)
{
StationaryCatalogueEnt ent = new StationaryCatalogueEnt();
Stationary_Catalogue searchCat = new Stationary_Catalogue();
searchCat.Description = description;
List<Stationary_Catalogue> code = ent.getStatCat(searchCat);
return code;
}
public List<view_Check_Existing_Stock> getUnitQtyByName(String desc, String Cat)
{
Stationary_Catalogue stCt=new Stationary_Catalogue();
stCt.Description= desc;
stCt.Category= Cat;
List<view_Check_Existing_Stock> qtyUnit= statCatEnt.getExistingStock(stCt);
return qtyUnit;
}
public List<view_Check_Existing_Stock> getExistingStock(Stationary_Catalogue scatalogue)
{
var q = from vs in ContextDB.view_Check_Existing_Stock
where (vs.Category == scatalogue.Category || scatalogue.Description == null)
&& (vs.Description == scatalogue.Description || scatalogue.Description == null)
select vs;
return q.ToList<view_Check_Existing_Stock>();
}
public List<Stationary_Catalogue> getStatCat(Stationary_Catalogue sc)
{
var q = from s in ContextDB.Stationary_Catalogue
where (s.Item_Code == sc.Item_Code || sc.Item_Code == null)
&& (s.Category == sc.Category || sc.Category == null)
&& (s.Description == sc.Description || sc.Description == null)
&& (s.Reorder_Level == sc.Reorder_Level || sc.Reorder_Level == null)
&& (s.Reorder_Qty == sc.Reorder_Qty || sc.Reorder_Qty == null)
&& (s.UOM == sc.UOM || sc.UOM == null)
select s;
return q.ToList<Stationary_Catalogue>();
}
public void createStatCat(Stationary_Catalogue sc)
{
ContextDB.Stationary_Catalogue.AddObject(sc);
ContextDB.SaveChanges();
}
/// <summary>
/// Deprecated Method for adding a new object to the Stationary_Catalogue EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToStationary_Catalogue(Stationary_Catalogue stationary_Catalogue)
{
base.AddObject("Stationary_Catalogue", stationary_Catalogue);
}
/// <summary>
/// Create a new Stationary_Catalogue object.
/// </summary>
/// <param name="item_Code">Initial value of the Item_Code property.</param>
public static Stationary_Catalogue CreateStationary_Catalogue(global::System.String item_Code)
{
Stationary_Catalogue stationary_Catalogue = new Stationary_Catalogue();
stationary_Catalogue.Item_Code = item_Code;
return stationary_Catalogue;
}