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);
}
public int DeleteFromSSApprovalTable(string CompCode, object intGlobReqestID)
{
Query = "DELETE H_TRNG_NMNTN WHERE COMP_AID='" + CompCode + "' AND RQST_ID=" + intGlobReqestID;
return(DataCreator.ExecuteSQL(Query));
}
