public void ExecuteScheduledJob(string ProcedureName, int refreshType = 0)
{
var emailStatusUtility = new EmailUtilities();
var dbs = new DataBaseServices();
var wslog = new Log();
var sqlParametersList = new List <SqlParameter>
{
new SqlParameter("@refreshtype", refreshType)
{
SqlDbType = SqlDbType.NVarChar
}
};
try
{
if (refreshType == 0)
{
emailStatusUtility = dbs.ExecuteNonQuery(ProcedureName);
}
else
{
emailStatusUtility = dbs.ExecuteNonQuery(ProcedureName, sqlParametersList.ToArray());
}
if (emailStatusUtility.OperationStatus != "Success")
{
wslog.WriteLog("ERR", emailStatusUtility.Description);
throw new ArgumentException(emailStatusUtility.Description, "Error");
}
}
catch (Exception exp)
{
wslog.WriteLog("ERR", exp.Message.ToString());
}
}
public EmailUtilities SaveData(string procedureName, List <SqlParameter> sqlparameterList)
{
var emailStatusUtility = new EmailUtilities();
var dbs = new DataBaseServices();
var wslog = new Log();
try
{
emailStatusUtility = dbs.ExecuteNonQuery(procedureName, sqlparameterList.ToArray());
if (emailStatusUtility.OperationStatus != "Success")
{
wslog.WriteLog("ERR", emailStatusUtility.Description);
throw new ArgumentException(emailStatusUtility.Description, "Error");
}
}
catch (Exception exp)
{
wslog.WriteLog("ERR", exp.Message.ToString());
}
return(emailStatusUtility);
}