public List <TimecardDetail> GetTimecardDetailsByTimecardId(int tcId)
{
SqlParameter parm;
List <TimecardDetail> listTcd = new List <TimecardDetail>();
try
{
using (SqlCommand cmd = new SqlCommand("Gsp_GetTimecardDetailByTimecardId", _dbConn))
{
cmd.CommandType = CommandType.StoredProcedure;
parm = new SqlParameter("@timecardId", SqlDbType.Int);
cmd.Parameters.Add(parm);
parm.Value = tcId;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
TimecardDetail tcd = new TimecardDetail();
tcd.DetailId = Convert.ToInt32(reader["TcDetailId"]);
tcd.TaskId = Convert.ToInt32(reader["TaskId"]);
tcd.TimecardId = Convert.ToInt32(reader["TimecardId"]);
tcd.PutValueForDay(Timecard.DetailFields.Monday_Hrs, Convert.ToDecimal(reader["MondayHrs"]));
tcd.PutValueForDay(Timecard.DetailFields.Tuesday_Hrs, Convert.ToDecimal(reader["TuesdayHrs"]));
tcd.PutValueForDay(Timecard.DetailFields.Wednesday_Hrs, Convert.ToDecimal(reader["WednesdayHrs"]));
tcd.PutValueForDay(Timecard.DetailFields.Thursday_Hrs, Convert.ToDecimal(reader["ThursdayHrs"]));
tcd.PutValueForDay(Timecard.DetailFields.Friday_Hrs, Convert.ToDecimal(reader["FridayHrs"]));
tcd.PutValueForDay(Timecard.DetailFields.Saturday_Hrs, Convert.ToDecimal(reader["SaturdayHrs"]));
tcd.PutValueForDay(Timecard.DetailFields.Sunday_Hrs, Convert.ToDecimal(reader["SundayHrs"]));
tcd.Task_Name = (string)reader["TaskName"];
listTcd.Add(tcd);
}
reader.Close();
}
return(listTcd);
}
catch (Exception ex)
{
string errTitle = this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name;
LogHardErrorMessage(errTitle, ex.Source, ex.Message);
throw;
}
}
