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, 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 static string GetUpdateQueryForInterim(DataRow row, OnApproveAction action)
{
string tableName = Shared.GetTableName(row) + "_INTERIM";
string setValues = Shared.GetSetValuesCSV(row) + ", [Sys_Status] = " + ((int)InterimStatus.Pending) + ", [Sys_RequestId] = @requestId";
string setValues2 = Shared.GetSetValuesCSV(row) + ", [Sys_OnApprove] = " + ((int)action) + ", [Sys_Status] = " + ((int)InterimStatus.Pending) + ", [Sys_RequestId] = @requestId";
string whereClause = Shared.GetWhereClause(row);
string withAction = String.Format(Templates.UPDATE, tableName, setValues2, whereClause);
string withoutAction = String.Format(Templates.UPDATE, tableName, setValues, whereClause);
return(String.Format(Templates.UPDATE_CONDITIONAL, tableName, whereClause, withoutAction, withAction));
}
private static string GetSysSetValues(InterimStatus status, OnApproveAction action)
{
string setStatements = String.Format("[Sys_Status] = {0}, [Sys_OnApprove] = {1}", ((int)status), ((int)action));
return(setStatements);
}
