public void ShouldbeAbleToCallUDF()
{
using (var db = new SNAPDatabaseDataContext())
{
var newDate = db.udf_get_next_business_day(DateTime.Now, 10);
Assert.IsTrue(newDate != null);
}
}
public void ShouldOk()
{
using(var db = new SNAPDatabaseDataContext())
{
DateTime current = DateTime.Parse("3/31/2010 1:00:00 PM");
for (int i = 1; i < 20; i++)
{
Console.WriteLine(db.udf_get_next_business_day(current, i));
}
}
}
private static DateTime getDueDate(ActorApprovalType approvalType, WorkflowState fr, WorkflowState to)
{
int day = 1;
DateTime due;
SLAConfiguration slaCfg = new SLAConfiguration((NameValueCollection)ConfigurationManager.GetSection(
"Apollo.AIM.SNAP/Workflow.SLA"));
switch (approvalType)
{
case ActorApprovalType.Manager:
day = System.Convert.ToInt16(slaCfg.ManagerApprovalInDays);
break;
case ActorApprovalType.Team_Approver:
day = System.Convert.ToInt16(slaCfg.TeamApprovalInDays);
break;
case ActorApprovalType.Technical_Approver:
day = System.Convert.ToInt16(slaCfg.TechnicalApprovalInDays);
break;
case ActorApprovalType.Workflow_Admin:
if (to == WorkflowState.Workflow_Created) // same as the due day for technical approval since workflow admin depend on it
day = System.Convert.ToInt16(slaCfg.TechnicalApprovalInDays);
break;
}
using (var db = new SNAPDatabaseDataContext())
{
due = db.udf_get_next_business_day(DateTime.Now, day) ?? DateTime.Now.AddDays(-1);
}
return due;
}