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); } }