public static void GetWorkDayDetails(
int pkWorkDay
, out int fkBuildProject
, out DateTime WorkDate
, out string WorkDescription
, out string Comments
, out int LunchfkOrganization)
{
SQLStoredProc sp = new SQLStoredProc(config.ConnectionString, "haah.GetWorkDayDetails");
sp.AddInputParameter("@pkWorkDay", pkWorkDay);
sp.AddOutputParameter("@fkBuildProject", SqlDbType.Int);
sp.AddOutputParameter("@WorkDate", SqlDbType.DateTime);
sp.AddOutputParameter("@WorkDescription", SqlDbType.VarChar, 500);
sp.AddOutputParameter("@Comments", SqlDbType.VarChar, 500);
sp.AddOutputParameter("@LunchfkOrganization", SqlDbType.Int);
sp.ExecNonQuery();
fkBuildProject = sp.OutputParameterValueInt("@fkBuildProject", -1);
WorkDate = sp.OutputParameterValueDateTime("@WorkDate", DateTime.MinValue);
WorkDescription = sp.OutputParameterValueString("@WorkDescription", "");
Comments = sp.OutputParameterValueString("@Comments", "");
LunchfkOrganization = sp.OutputParameterValueInt("@LunchfkOrganization", -1);
}
public static void GetVolunteerWorkDay(
int pkVolunteer
, int pkWorkDay
, out DateTime ActualStartTime
, out DateTime ActualEndTime
, out DateTime ProjectedStartTime
, out DateTime ProjectedEndTime
, out string Comments
, out bool NoShow
, out DateTime BaseDate
, out string VolunteerName
, out string OrganizationName)
{
SQLStoredProc sp = new SQLStoredProc(config.ConnectionString, "haah.GetVolunteerWorkDay");
sp.AddInputParameter("@pkVolunteer", pkVolunteer);
sp.AddInputParameter("@pkWorkDay", pkWorkDay);
sp.AddOutputParameter("@ActualStartTime", SqlDbType.DateTime);
sp.AddOutputParameter("@ActualEndTime", SqlDbType.DateTime);
sp.AddOutputParameter("@ProjectedStartTime", SqlDbType.DateTime);
sp.AddOutputParameter("@ProjectedEndTime", SqlDbType.DateTime);
sp.AddOutputParameter("@Comments", SqlDbType.VarChar, 500);
sp.AddOutputParameter("@NoShow", SqlDbType.Bit);
sp.AddOutputParameter("@BaseDate", SqlDbType.DateTime);
sp.AddOutputParameter("@VolunteerName", SqlDbType.VarChar, 100);
sp.AddOutputParameter("@OrganizationName", SqlDbType.VarChar, 100);
sp.ExecNonQuery();
ActualStartTime = sp.OutputParameterValueDateTime("@ActualStartTime", DateTime.MinValue);
ActualEndTime = sp.OutputParameterValueDateTime("@ActualEndTime", DateTime.MinValue);
ProjectedStartTime = sp.OutputParameterValueDateTime("@ProjectedStartTime", DateTime.MinValue);
ProjectedEndTime = sp.OutputParameterValueDateTime("@ProjectedEndTime", DateTime.MinValue);
Comments = sp.OutputParameterValueString("@Comments", "");
NoShow = (sp.OutputParameterValueString("@NoShow", "") == "True");
BaseDate = sp.OutputParameterValueDateTime("@BaseDate", DateTime.MinValue);
VolunteerName = sp.OutputParameterValueString("@VolunteerName", "");
OrganizationName = sp.OutputParameterValueString("@OrganizationName", "");
}
