public object GetMailAlertById(int id)
{
object result = null;
MailAlert objMailAlert = new MailAlert();
try
{
using (_context)
{
objMailAlert = _context.MailAlert.FirstOrDefault(x => x.Id == id);
result = new
{
objMailAlert,
error = "0",
msg = "Success"
};
}
}
catch (Exception ex)
{
ex.ToString();
result = new
{
objMailAlert,
error = "1",
msg = "Error"
};
}
return(result);
}
public static void SendAlertMessage(MailAlertType type, string message, Exception exception)
{
MailAlert mailAlert = new MailAlert(AlertMessageHost, AlertMessagePort)
{
Username = AlertMessageUsername,
Password = AlertMessagePassword,
Recipient = AlertMessageTo
};
mailAlert.Send(type, message, exception);
}
public object CreateMailAlert([FromBody] MailAlert model)
{
object result = null;
string message = "";
string errorcode = "";
string excp = "";
if (model == null)
{
return(BadRequest());
}
using (_context)
{
using (var _ctxTransaction = _context.Database.BeginTransaction())
{
try
{
_context.MailAlert.Add(model);
//await _ctx.SaveChangesAsync();
_context.SaveChanges();
_ctxTransaction.Commit();
message = "Saved Successfully";
errorcode = "0";
}
catch (Exception e)
{
_ctxTransaction.Rollback();
e.ToString();
message = "Saved Error";
errorcode = "1";
excp = e.ToString();
}
result = new
{
error = errorcode,
msg = message,
excp = excp
};
}
}
return(result);
}
public object CreateUpdateMailAlert(int id, [FromBody] MailAlert model)
{
object result = null;
string message = "";
string errorcode = "";
string excp = "";
if (model == null)
{
return(BadRequest());
}
using (_context)
{
using (var _ctxTransaction = _context.Database.BeginTransaction())
{
try
{
if (id != 0)
{
var entityUpdate = _context.MailAlert.FirstOrDefault(x => x.Id == id);
if (entityUpdate != null)
{
entityUpdate.FormName = model.FormName;
entityUpdate.MailAlertName = model.MailAlertName;
entityUpdate.TemplateId = model.TemplateId;
entityUpdate.FromAddress = model.FromAddress;
entityUpdate.ToAddress = model.ToAddress;
entityUpdate.Ccaddress = model.Ccaddress;
entityUpdate.Bccaddress = model.Bccaddress;
entityUpdate.ReplyToAddress = model.ReplyToAddress;
entityUpdate.EmailSubject = model.EmailSubject;
entityUpdate.Attachment = model.Attachment;
entityUpdate.Message = model.Message;
_context.SaveChanges();
}
_ctxTransaction.Commit();
message = "Entry Updated";
errorcode = "0";
}
else
{
_context.MailAlert.Add(model);
//await _ctx.SaveChangesAsync();
_context.SaveChanges();
_ctxTransaction.Commit();
message = "Saved Successfully";
errorcode = "0";
}
}
catch (Exception e)
{
_ctxTransaction.Rollback();
e.ToString();
message = "Saved Error";
errorcode = "1";
excp = e.ToString();
}
result = new
{
error = errorcode,
msg = message,
excp = excp
};
}
}
return(result);
}
