public int DelEmployeeProjectHours(int EmployeeID, int ProjectID, DateTime Date)
{
int intRC = 0;
IParameterFactory objParams = new EmployeeProjectHoursParameterFactory(EmployeeID: EmployeeID, ProjectID: ProjectID, Date: Date);
System.Data.SqlClient.SqlCommand objCmd = new SqlCommand("pDelEmployeeProjectHours", new ADOConnectionFactory().Connection);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add(objParams.Parmeters["RC"]);
objCmd.Parameters.Add(objParams.Parmeters["ProjectID"]);
objCmd.Parameters.Add(objParams.Parmeters["EmployeeID"]);
objCmd.Parameters.Add(objParams.Parmeters["Date"]);
try
{
objCmd.Connection.Open();
objCmd.ExecuteNonQuery();
intRC = (int)objParams.Parmeters["RC"].Value;
if (intRC < 0)
{
throw new Exception("Error reported in Stored Procedure: " + objParams.Parmeters["RC"].Value.ToString());
}
objCmd.Connection.Close();
}
catch (Exception) { throw; }
return(intRC);
}
public IEnumerable <EmployeeProjectHour> SelEmployeeProjectHours(int EmployeeID = -1, int ProjectID = -1)
{
int intRC = 0;
objEmployeeProjectHours = new List <EmployeeProjectHour>();
IParameterFactory objParams = new EmployeeProjectHoursParameterFactory(EmployeeID: EmployeeID, ProjectID: ProjectID);
System.Data.SqlClient.SqlCommand objCmd = new SqlCommand("pSelEmployeeProjectHours", new ADOConnectionFactory().Connection);
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add(objParams.Parmeters["RC"]);
objCmd.Parameters.Add(objParams.Parmeters["EmployeeID"]);
objCmd.Parameters.Add(objParams.Parmeters["ProjectID"]);
//objCmd.CommandType = CommandType.StoredProcedure;
try
{
objCmd.Connection.Open();
System.Data.SqlClient.SqlDataReader objDR = objCmd.ExecuteReader();
while (objDR.Read())
{
EmployeeProjectHour objEPH = new EmployeeProjectHour();
objEPH.objProjectID = (int)objDR["ProjectID"];
objEPH.objEmployeeID = (int)objDR["EmployeeID"];
objEPH.objProjectName = (string)objDR["ProjectName"];
objEPH.objEmployeeName = (string)objDR["EmployeeName"];
objEPH.objDate = (System.DateTime)objDR["Date"];
objEPH.objHours = (decimal)objDR["Hours"];
((List <EmployeeProjectHour>)objEmployeeProjectHours).Add(objEPH);
}
objDR.Close();
intRC = (int)objParams.Parmeters["RC"].Value;
if (intRC < 0)
{
throw new Exception("Error reported in Stored Procedure: " + objParams.Parmeters["RC"].Value.ToString());
}
objCmd.Connection.Close();
}
catch (Exception) { throw; }
return(objEmployeeProjectHours);
}
