public int CreateTask(Entity.Task tsk)
{
int retVal = 0;
SqlParameter parm;
try {
using (SqlCommand cmd = new SqlCommand("Isp_CreateTask", _dbConn)) {
cmd.CommandType = CommandType.StoredProcedure;
parm = new SqlParameter("@TaskCategoryId", SqlDbType.Int);
cmd.Parameters.Add(parm);
parm.Value = tsk.CategoryId;
parm = new SqlParameter("@TaskName", SqlDbType.VarChar);
cmd.Parameters.Add(parm);
parm.Value = tsk.TaskName;
parm = new SqlParameter("@BudgetHours", SqlDbType.Int);
cmd.Parameters.Add(parm);
parm.Value = tsk.BudgetHours;
parm = new SqlParameter("@ActualHours", SqlDbType.Int);
cmd.Parameters.Add(parm);
parm.Value = tsk.ActualHours;
parm = new SqlParameter("@StartDate", SqlDbType.NChar);
cmd.Parameters.Add(parm);
parm.Value = tsk.StartDate;
parm = new SqlParameter("@EndDate", SqlDbType.NChar);
cmd.Parameters.Add(parm);
if (String.IsNullOrEmpty(tsk.EndDate))
{
parm.Value = DBNull.Value;
}
else
{
parm.Value = tsk.EndDate;
}
parm = new SqlParameter("@NewIdentity", SqlDbType.Int);
cmd.Parameters.Add(parm);
parm.Value = 0;
retVal = (Int32)cmd.ExecuteScalar();
}
}
catch (Exception ex) {
string errTitle = System.Reflection.MethodBase.GetCurrentMethod().Name;
LogHardErrorMessage(errTitle, ex.Source, ex.Message);
throw;
}
return(retVal);
}
public List <Entity.Task> GetAllTasks()
{
//SqlParameter parm;
List <Entity.Task> tasks = new List <Entity.Task>();
try
{
using (SqlCommand cmd = new SqlCommand("Gsp_GetAllTasks", _dbConn))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Entity.Task et = new Entity.Task();
et.CategoryId = Convert.ToInt32(reader["CategoryId"]);
et.CategoryName = Convert.ToString(reader["CategoryName"]);
et.TaskId = Convert.ToInt32(reader["TaskId"]);
et.TaskName = (string)reader["TaskName"];
et.BudgetHours = Convert.ToString(reader["BudgetHours"]);
et.ActualHours = Convert.ToString(reader["ActualHours"]);
et.StartDate = Convert.ToString(reader["StartDate"]);
et.EndDate = Convert.ToString(reader["EndDate"]);
if (!et.BudgetHours.Contains("."))
{
et.BudgetHours += ".0";
}
if (!et.ActualHours.Contains("."))
{
et.ActualHours += ".0";
}
tasks.Add(et);
}
reader.Close();
}
return(tasks);
}
catch (Exception ex)
{
string errTitle = this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name;
LogHardErrorMessage(errTitle, ex.Source, ex.Message);
throw;
}
}
public List <Task> GetActiveTasksBudgetSummary()
{
List <Task> tcrList = new List <Task>();
try
{
using (SqlCommand cmd = new SqlCommand("Gsp_ActiveTasksBudgetSummary", _dbConn))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Entity.Task et = new Entity.Task();
et.TaskName = (string)reader["TaskName"];
et.BudgetHours = Convert.ToString(reader["BudgetHours"]);
et.StartDate = Convert.ToString(reader["StartDate"]);
et.ActualHours = Convert.ToString(reader["TotalToDate"]);
if (!et.BudgetHours.Contains("."))
{
et.BudgetHours += ".0";
}
if (!et.ActualHours.Contains("."))
{
et.ActualHours += ".0";
}
tcrList.Add(et);
}
reader.Close();
}
return(tcrList);
}
catch (Exception ex)
{
string errTitle = this.GetType().Name + "." + System.Reflection.MethodBase.GetCurrentMethod().Name;
LogHardErrorMessage(errTitle, ex.Source, ex.Message);
throw;
}
}