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