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