public T FindbyId(int id)
{
var productionPackaging = new ProductionPackaging();
using (DBClass = new MSSQLDatabase())
{
SqlCommand cmd = DBClass.GetStoredProcedureCommand("APP_GET_PRODUCTION_PACKAGING_BY_ID");
cmd.Parameters.AddWithValue("@ProductionPackagingId", id);
var reader = DBClass.ExecuteReader(cmd);
while (reader.Read())
{
productionPackaging.ProductionPackagingID = int.Parse(reader[0].ToString());
productionPackaging.VoucherCode = reader[1].ToString();
productionPackaging.DepartementID = int.Parse(reader[2].ToString());
productionPackaging.DestinationProduct = int.Parse(reader[3].ToString());
productionPackaging.DestinationQty = decimal.Parse(reader[4].ToString());
productionPackaging.Note = reader[6].ToString();
productionPackaging.ProductionPackagingDate = DateTime.Parse(reader[7].ToString());
}
}
return(productionPackaging as T);
}
public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam)
{
var result = new List <ProductionPackaging>();
using (DBClass = new MSSQLDatabase())
{
SqlCommand cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_PRODUCTION_PACKAGING");
RoutinesParameterSetter.Set(ref cmd, keyValueParam);
var reader = DBClass.ExecuteReader(cmd);
while (reader.Read())
{
var productionPackaging = new ProductionPackaging();
productionPackaging.ProductionPackagingID = int.Parse(reader[0].ToString());
productionPackaging.VoucherCode = reader[1].ToString();
productionPackaging.ProductionPackagingDate = DateTime.Parse(reader[2].ToString());
productionPackaging.DestinationCode = reader[3].ToString();
productionPackaging.DestinationName = reader[4].ToString();
productionPackaging.DestinationQty = decimal.Parse(reader[5].ToString());
productionPackaging.Note = reader[7].ToString();
result.Add(productionPackaging);
}
}
return(result as List <T>);
}
