// -----------------------------------------------------
// Add Task Button -- Click Event Handler
private void buttonAddTask_Click(object sender, EventArgs e)
{
// Putup a modal dialog where the user can pick a task
// Don't show tasks that are already on the time card
SsOpsDatabaseLibrary.Entity.Task[] theSelectedTasks;
// Filtered tasks are the ones that are not already on the timecard
if (_tcDetailsUnderGlass.Count != 0)
{
foreach (TimecardDetail tcd in _tcDetailsUnderGlass)
{
foreach (Task task in _activeTasks)
{
if (task.TaskName == tcd.Task_Name)
{
_filteredTasks.Remove(task);
}
}
}
}
using (SelectTaskForm stf = new SelectTaskForm(_filteredTasks))
{
Point targetPoint = this.Location;
targetPoint.X = this.Location.X + 170;
targetPoint.Y = this.Location.Y + 25;
stf.Width = 272;
stf.Height = 458;
stf.Location = targetPoint;
stf.ShowDialog(this);
theSelectedTasks = stf.GetSelectedTasks();
stf.Dispose();
}
if (theSelectedTasks != null)
{
//Add the selected task to the timecard
TimecardDetail tcDetail;
foreach (SsOpsDatabaseLibrary.Entity.Task tsk in theSelectedTasks)
{
tcDetail = new TimecardDetail();
tcDetail.Task_Name = tsk.TaskName;
tcDetail.TaskId = Convert.ToInt32(tsk.TaskId);
_bindingSource1.Add(tcDetail);
}
//tcDetail.Task_Name= theSelectedTask.TaskName;
//tcDetail.TaskId = Convert.ToInt32(theSelectedTask.TaskId);
//adding a row to the binding source will in-turn add the row to our _timecardDetailsUnderGlass list
//_bindingSource1.Add(tcDetail);
//There are now changes made to this timecard that have not yet been committed to the DB
_currentFormState = FormState.ViewingPotentialChanges;
AssertFormState();
}
}
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;
}
}
public List <TimecardDetail> GetTimecardDetailsByTimecardId(string tcId)
{
SqlParameter parm;
List <TimecardDetail> listTcd = new List <TimecardDetail>();
try
{
using (SqlCommand cmd = new SqlCommand("Gsp_GetTimecardDetailByTimecardId", _dbConn))
{
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.Detail_ID = (string)reader["TcDetailId"];
tcd.Task_ID = (string)reader["TaskId"];
tcd.Timecard_ID = (string)reader["TimecardId"];
tcd.Monday_Hrs = (string)reader["MondayHrs"];
tcd.Tuesday_Hrs = (string)reader["TuesdayHrs"];
tcd.Wednesday_Hrs = (string)reader["WednesdayHrs"];
tcd.Thursday_Hrs = (string)reader["ThursdayHrs"];
tcd.Friday_Hrs = (string)reader["FridayHrs"];
tcd.Saturday_Hrs = (string)reader["SaturdayHrs"];
tcd.Sunday_Hrs = (string)reader["SundayHrs"];
listTcd.Add(tcd);
}
}
return(listTcd);
}
catch (Exception ex)
{
string errTitle = this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name;
LogHardErrorMessage(errTitle, ex.Source, ex.Message);
throw;
}
}
