private static string GetSysWhereClause(InterimStatus status, OnApproveAction action, int requestId)
{
string whereClause = String.Format("[Sys_Status] = {0} AND [Sys_OnApprove] = {1} AND [Sys_RequestId] = {2}",
((int)status), ((int)action), requestId);
return(whereClause);
}
private static string GetSysWhereClause(InterimStatus status, int requestId)
{
string whereClause = String.Format("[Sys_Status] = {0} AND [Sys_RequestId] = {1}",
((int)status), requestId);
return(whereClause);
}
private static string GetSysWhereClause(InterimStatus status, OnApproveAction action, int requestId, string alias)
{
string prefix = (String.IsNullOrWhiteSpace(alias) ? "" : alias + ".");
string whereClause = String.Format("{3}[Sys_Status] = {0} AND {3}[Sys_OnApprove] = {1} AND {3}[Sys_RequestId] = {2}",
((int)status), ((int)action), requestId, prefix);
return(whereClause);
}
public MarkAsInterimViewModel(InterimStatus interimStatus)
{
NotificationId = interimStatus.NotificationId;
NotificationStatus = interimStatus.NotificationStatus;
IsInterim = interimStatus.IsInterim;
}
public void Add(InterimStatus interimStatus)
{
context.InterimStatuses.Add(interimStatus);
}
private static string GetSysSetValues(InterimStatus status)
{
string setStatements = String.Format("[Sys_Status] = {0}", ((int)status));
return(setStatements);
}
private static string GetSysSetValues(InterimStatus status, OnApproveAction action)
{
string setStatements = String.Format("[Sys_Status] = {0}, [Sys_OnApprove] = {1}", ((int)status), ((int)action));
return(setStatements);
}
public void Add(InterimStatus interimStatus)
{
context.InterimStatuses.Add(interimStatus);
}
public MarkAsInterimViewModel(InterimStatus interimStatus)
{
NotificationId = interimStatus.NotificationId;
NotificationStatus = interimStatus.NotificationStatus;
IsInterim = interimStatus.IsInterim;
}
