public static List <POHistoryobj> GetReceivedItems(int PONumber)
{
try
{
SqlCommand cmd = new SqlCommand("SELECT Type,PONumber,ItemNumber,EnteredBy,Quantity,Cost,LocalSKU,SuppliersSKU FROM POHistory Where Type = 'R' AND PONumber =" + PONumber.ToString(), cn);
SqlDataReader dr = cmd.ExecuteReader();
List <POHistoryobj> polist = new List <POHistoryobj>();
while (dr.Read())
{
POHistoryobj poh = new POHistoryobj();
poh.Type = dr["Type"] == DBNull.Value ? "" : Convert.ToString(dr["Type"]);
poh.PONumber = dr["PONumber"] == DBNull.Value ? 0 : Convert.ToInt32(dr["PONumber"]);
poh.ItemNumber = dr["ItemNumber"] == DBNull.Value ? 0 : Convert.ToInt32(dr["ItemNumber"]);
poh.EnteredBy = dr["EnteredBy"] == DBNull.Value ? "" : Convert.ToString(dr["EnteredBy"]);
poh.Quantity = dr["Quantity"] == DBNull.Value ? 0 : Convert.ToInt32(dr["Quantity"]);
poh.Cost = dr["Cost"] == DBNull.Value ? 0 : Convert.ToDecimal(dr["Cost"]);
poh.LocalSKU = dr["LocalSKU"] == DBNull.Value ? "" : Convert.ToString(dr["LocalSKU"]);
poh.SuppliersSKU = dr["SuppliersSKU"] == DBNull.Value ? "" : Convert.ToString(dr["SuppliersSKU"]);
polist.Add(poh);
}
dr.Close();
dr.Dispose();
dr = null;
foreach (POHistoryobj item in polist)
{
item.ItemName = Inventory.GetItemName(item.LocalSKU);
}
return(polist);
}
catch (Exception)
{
return(new List <POHistoryobj>());
}
}
public static bool Insert(POHistoryobj poh)
{
cn = Connection.GetConnection();
SqlCommand cmd = new SqlCommand("INSERT INTO POHistory(Type,PONumber,ItemNumber,Date,EnteredBy,Quantity,Cost,LocalSKU,SuppliersSKU,Lot) VALUES(@Type,@PONumber,@ItemNumber,@Date,@EnteredBy,@Quantity,@Cost,@LocalSKU,@SuppliersSKU,'Pieces')", cn);
cmd.Parameters.AddWithValue("@Type", "R");
cmd.Parameters.AddWithValue("@PONumber", poh.PONumber);
cmd.Parameters.AddWithValue("@ItemNumber", poh.ItemNumber);
cmd.Parameters.AddWithValue("@Date", DateTime.Now.Date);
cmd.Parameters.AddWithValue("@EnteredBy", poh.EnteredBy);
cmd.Parameters.AddWithValue("@Quantity", poh.Quantity);
cmd.Parameters.AddWithValue("@Cost", poh.Cost);
cmd.Parameters.AddWithValue("@LocalSKU", poh.LocalSKU);
cmd.Parameters.AddWithValue("@SuppliersSKU", poh.SuppliersSKU);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
