How to call a storedprocedure in mvc using entity framework and triggermail to "velidiraviram@gmail
hi alli have written code to cal a storedprocedure in mvc using entity framework and to triggermail to me so where i am wrong helpme
in my common files poaperakaleter.cs
public void MailSchedule()
{
log4net.ILog logger = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
logger.Info("Begin of job - MailSchedule");
eProEntities db = new eProEntities();
try
{
ObjectParameter result = new ObjectParameter("outflag", typeof(Int32));
var outputSP = db.process_porespone();
outputSP = db.process_porespone();
foreach (var email in outputSP)
{
EMailHelper.SendMail(email);
}
}
catch (Exception ex)
{
logger.Error("Error in job - MailSchedule", ex);
}
db.Dispose();
logger.Info("End of job - MailSchedule");
}
in global.aspx in application start
JobManager.AddJob(new Common.eBPJobScheduler().MailSchedule, s => s.ToRunEvery(1).Days().At(06,30));