protected void Submit_Click(object sender, EventArgs e)
{
ItemBatch itemBatch = new ItemBatch();
itemBatch.Save(Convert.ToInt32(Request.QueryString["itemId"]), Batch.Text, Convert.ToInt32(Quantity.Text));
Response.Redirect("Default.aspx");
}
protected void DelBtn_Click(object sender, EventArgs e)
{
GridViewRow grdrow = (GridViewRow)((LinkButton)sender).NamingContainer;
int del_id = Convert.ToInt32(grdrow.Cells[0].Text);
Item.Delete(del_id);
ItemBatch.Delete(del_id);
Response.Redirect("Default.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
var dr = ItemBatch.ReadAll();
//DBConnectExecute con = new DBConnectExecute();
//SqlDataReader dr = con.FetchItems();
GridView1.DataSource = dr;
GridView1.DataBind();
}
protected void Submit_Click(object sender, EventArgs e)
{
if (validate(Name.Text))
{
int itemID;
Item item = new Item();
itemID = item.Save(Name.Text);
ItemBatch itemBatch = new ItemBatch();
itemBatch.Save(itemID, Batch.Text, Convert.ToInt32(Quantity.Text));
Response.Redirect("Default.aspx");
}
}
public static ItemBatch Read(int id)
{
DBExecutor <ItemBatch> db = new DBExecutor <ItemBatch>();
return(db.Execute(delegate(SqlCommand cmd)
{
cmd.CommandText = "SELECT * FROM STOCK WHERE ID=" + id;
var dr = cmd.ExecuteReader();
ItemBatch ib = new ItemBatch();
while (dr.Read())
{
ib.Id = Convert.ToInt32(dr["ID"]);
ib.item.id = Convert.ToInt32(dr["ItemID"]);
ib.item.Name = Item.Read(ib.item.id);
ib.Batch = Convert.ToString(dr["BatchNo"]);
ib.CP = Convert.ToDouble(dr["CostPrice"]);
ib.SP = Convert.ToDouble(dr["SellingPrice"]);
ib.OpStock = Convert.ToInt32(dr["NoOfItems"]);
}
return ib;
}));
}
public static List <ItemBatch> ReadAll()
{
DBExecutor <List <ItemBatch> > db = new DBExecutor <List <ItemBatch> >();
return(db.Execute(delegate(SqlCommand cmd)
{
List <ItemBatch> ret = new List <ItemBatch>();
cmd.CommandText = "SELECT * FROM STOCK ORDER BY ItemID";
var dr = cmd.ExecuteReader();
while (dr.Read())
{
ItemBatch ib = new ItemBatch();
ib.Id = Convert.ToInt32(dr["ID"]);
ib.item.id = Convert.ToInt32(dr["ItemID"]);
ib.item.Name = Item.Read(ib.item.id);
ib.Batch = Convert.ToString(dr["BatchNo"]);
ib.CP = Convert.ToDouble(dr["CostPrice"]);
ib.SP = Convert.ToDouble(dr["SellingPrice"]);
ib.OpStock = Convert.ToInt32(dr["NoOfItems"]);
ret.Add(ib);
}
return ret;
}));
}
