public int SendAlerts(string strComp, string strSender, int?intRecipientId, string strMessage, string apprReqType, int formID, int requestId, bool isDefault = true) { int status; string strAc; switch (apprReqType.ToLower()) { case "approvals": strAc = "APR"; break; case "birthdays": strAc = "BIR"; break; case "holidays": strAc = "HOL"; break; default: strAc = apprReqType; break; } object[] insertPara = new object[11]; insertPara[0] = strComp; insertPara[1] = strAc; insertPara[2] = strMessage; insertPara[3] = intRecipientId == 0 ? null : intRecipientId; insertPara[4] = strAc == "BIR" || strAc == "HOL" ? "A" : "R"; insertPara[5] = strSender; insertPara[6] = 1; insertPara[7] = ""; insertPara[8] = 1; insertPara[9] = DateTime.Now.ToString("dd/MMM/yyyy"); insertPara[10] = requestId; if (isDefault) { status = DataCreator.ExecuteProcedure("INSERT_GM_ALERTS", insertPara); if (status == 0) { object[] insertMapPara = new object[2]; insertMapPara[0] = formID; insertMapPara[1] = strSender; status = DataCreator.ExecuteProcedure("INSERT_SS_ALERTID_MAP", insertMapPara); } } else { status = DataCreator.ExecuteProcedure("INSERT_GM_ALERTSME", insertPara); } return(status); }
public int DismissAlert(string compId, string userId, int alertId, int requestId) { object[] updatePara = new object[6]; updatePara[0] = compId; updatePara[1] = alertId; updatePara[2] = 0; updatePara[3] = "D"; updatePara[4] = userId; updatePara[5] = requestId; int status = DataCreator.ExecuteProcedure("UPDATE_GM_ALERTS", updatePara); return(status); }