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); }