public IEnumerable <T> FindAll(List <Dictionary <string, object> > keyValueParam)
{
var result = new List <Repackage>();
using (DBClass = new MSSQLDatabase())
{
var cmd = DBClass.GetStoredProcedureCommand("APP_GET_ALL_STOCK_REPACKAGE") as SqlCommand;
RoutinesParameterSetter.Set(ref cmd, keyValueParam);
var reader = DBClass.ExecuteReader(cmd);
while (reader.Read())
{
var repackage = new Repackage();
repackage.RepackageID = int.Parse(reader[0].ToString());
repackage.VoucherCode = reader[1].ToString();
repackage.RepackageDate = DateTime.Parse(reader[2].ToString());
repackage.SourceName = reader[3].ToString();
repackage.SourceQty = decimal.Parse(reader[4].ToString());
repackage.DestinationName = reader[5].ToString();
repackage.DestinationQty = decimal.Parse(reader[6].ToString());
repackage.Note = reader[7].ToString();
result.Add(repackage);
}
}
return(result as List <T>);
}
public T FindbyId(int id)
{
var repackage = new Repackage();
using (DBClass = new MSSQLDatabase())
{
var cmd = DBClass.GetStoredProcedureCommand("APP_GET_STOCK_REPACKAGE_BY_ID") as SqlCommand;
DBClass.AddSimpleParameter(cmd, "@RepackageId", id);
var reader = DBClass.ExecuteReader(cmd);
while (reader.Read())
{
repackage.RepackageID = int.Parse(reader[0].ToString());
repackage.VoucherCode = reader[1].ToString();
repackage.RepackageDate = DateTime.Parse(reader[2].ToString());
repackage.DepartementId = int.Parse(reader[3].ToString());
repackage.SourceProduct = int.Parse(reader[4].ToString());
repackage.SourceQty = decimal.Parse(reader[5].ToString());
repackage.DestinationProduct = int.Parse(reader[6].ToString());
repackage.DestinationQty = decimal.Parse(reader[7].ToString());
repackage.Note = reader[8].ToString();
}
}
return(repackage as T);
}
