public JsonResult SaveEmail(string emailMarketing)
{
try
{
using (var db = new MyDbDataContext())
{
var checkEmail = db.EmailMarketings.FirstOrDefault(a => a.Email == emailMarketing);
if (checkEmail != null)
{
return(Json(new { result = "Error", message = "Email is exist" }));
}
EmailMarketing marketing = new EmailMarketing
{
Email = emailMarketing,
Tel = "",
Note = "",
};
db.EmailMarketings.InsertOnSubmit(marketing);
db.SubmitChanges();
return(Json(new { result = "ok" }));
}
}
catch (Exception)
{
return(Json(new { result = "Error", message = "Error!" }));
}
}
public JsonResult Edit(EmailMarketing model)
{
//End check
using (var db = new MyDbDataContext())
{
if (ModelState.IsValid)
{
try
{
var edit = db.EmailMarketings.FirstOrDefault(b => b.Id == model.Id);
if (edit != null)
{
edit.Email = model.Email;
//edit.Tel = model.Tel;
edit.Note = model.Note;
db.SubmitChanges();
string message = "Update successful";
return(Json(new { Result = "OK", Message = message }));
}
else
{
return(Json(new { Result = "ERROR", Message = "Video is not exist" }));
}
}
catch (Exception exception)
{
return(Json(new { Result = "Error", Message = "Error: " + exception.Message }));
}
}
return(Json(new { Result = " Error", Errors = ModelState.Errors(), Message = "Input data are not correct in form" }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult Create(EmailMarketing model)
{
//End check
using (var db = new MyDbDataContext())
{
if (ModelState.IsValid)
{
try
{
var emailmarketing = new EmailMarketing
{
Email = model.Email,
//Tel = model.Tel,
Note = model.Note,
};
db.EmailMarketings.InsertOnSubmit(emailmarketing);
db.SubmitChanges();
string message = "Insert successful";
return(Json(new { Result = "OK", Message = message, Record = model }));
}
catch (Exception exception)
{
return(Json(new { Result = "Error", Message = "Error: " + exception.Message }));
}
}
return(Json(new { Result = " Error", Errors = ModelState.Errors(), Message = "Input data are not correct in form" }, JsonRequestBehavior.AllowGet));
}
}
private void btnAddDetails_Click(object sender, EventArgs e)
{
if ((txtUserName.Text.Length > 0 && !string.IsNullOrWhiteSpace(txtUserName.Text)) && (txtPassword.Text.Length > 0 && !string.IsNullOrWhiteSpace(txtPassword.Text)) && (txtAcceptType.Text.Length > 0 && !string.IsNullOrWhiteSpace(txtAcceptType.Text)) && (txtContentType.Text.Length > 0 && !string.IsNullOrWhiteSpace(txtContentType.Text)) && (txtVersion.Text.Length > 0 && !string.IsNullOrWhiteSpace(txtVersion.Text)) && (txtEmail.Text.Length > 0 && !string.IsNullOrWhiteSpace(txtEmail.Text)))
{
EmailMarketing objEMarketing = new EmailMarketing();
objEMarketing.EUserName = txtUserName.Text.Trim();
objEMarketing.EPassword = txtPassword.Text.Trim();
objEMarketing.EAcceptType = txtAcceptType.Text.Trim();
objEMarketing.EContentType = txtContentType.Text.Trim();
objEMarketing.EEmail = txtEmail.Text.Trim();
objEMarketing.EAPIKEY = txtApiKey.Text.Trim();
objEMarketing.EAPIVersion = txtVersion.Text.Trim();
_objNewsLetter = new NewsLetterBLL();
int result = -1;
string type = string.Empty;
if (btnAddDetails.Text.Contains("Add"))
{
result = _objNewsLetter.CreateEmailNewsLetter(objEMarketing);
type = "Insert";
}
else
{
if (ENid != -1)
{
objEMarketing.ENID = ENid;
result = _objNewsLetter.UpdateEmailNewsLetter(objEMarketing);
type = "Update";
}
else
{
MessageBox.Show("Email NewsLetter details are something wrong.");
return;
}
}
if (result.Equals(1) && type.Equals("Insert"))
{
lblMessage.Text = "Email Marketing Details are added successfully.";
btnAddDetails.Text = "Update Details";
}
else
{
lblMessage.Text = "Email Marketing Details are updated successfully.";
}
lblMessage.ForeColor = Color.Green;
LoadMarketingDetails();
}
else
{
MessageBox.Show("Please Enter the missed fields before adding.");
}
}
public async Task <int> Transaction(EmailMarketing data, char action)
{
return(await _adapterPattern.SingleTransaction <EmailMarketing, int>(data, "usp_EmailMarketing_Transaction", action, DataConfiguration.instanceCore));
}
public async Task <int> Transaction(EmailMarketing data, char action)
{
return(await _emailMarketing.Transaction(data, action));
}
