public static void Delete(int id) { DBExecutor <int> dbExecutor = new DBExecutor <int>(); dbExecutor.Execute(delegate(SqlCommand myCommand) { int updatedRows; myCommand.CommandText = string.Format("DELETE FROM Stock WHERE ItemId={0}", id); updatedRows = myCommand.ExecuteNonQuery(); return(updatedRows); } ); }
public void Save(int itemid, string batch, int opStock) { DBExecutor <int> dbExecutor = new DBExecutor <int>(); dbExecutor.Execute(delegate(SqlCommand myCommand) { int updatedRows; myCommand.CommandText = string.Format("INSERT INTO Stock VALUES({0},'{1}',0,0,{2},'2018-01-01')", itemid, batch, opStock); updatedRows = myCommand.ExecuteNonQuery(); return(updatedRows); } ); }
public static string Read(int id) { string itemName = string.Empty; DBExecutor <string> dbExecutor = new DBExecutor <string>(); dbExecutor.Execute(delegate(SqlCommand myCommand) { SqlDataReader tableData; myCommand.CommandText = string.Format("SELECT * FROM Items WHERE id={0}", id); tableData = myCommand.ExecuteReader(); while (tableData.Read()) { itemName = Convert.ToString(tableData["Name"]); } return(itemName); } ); return(itemName); }
public int Save(string name) { int newId = 0; DBExecutor <int> dbExecutor = new DBExecutor <int>(); dbExecutor.Execute(delegate(SqlCommand myCommand) { SqlDataReader tableData; myCommand.CommandText = string.Format("INSERT INTO Items VALUES('{0}')", name); newId = myCommand.ExecuteNonQuery(); myCommand.CommandText = string.Format("SELECT ID FROM Items WHERE Name='{0}'", name); tableData = myCommand.ExecuteReader(); while (tableData.Read()) { newId = Convert.ToInt32(tableData["ID"]); } return(newId); } ); return(newId); }
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 <Item> ReadAll() { List <Item> items = new List <Item>(); DBExecutor <List <Item> > dbExecutor = new DBExecutor <List <Item> >(); dbExecutor.Execute(delegate(SqlCommand myCommand) { SqlDataReader tableData; myCommand.CommandText = string.Format("SELECT * FROM Items"); tableData = myCommand.ExecuteReader(); while (tableData.Read()) { Item item = new Item(); item.id = Convert.ToInt32(tableData["ID"]); item.Name = Convert.ToString(tableData["Name"]); items.Add(item); } return(items); } ); return(items); }
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; })); }