public ActionResult AddNew(Email objmail) { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); DSRCManagementSystem.EmailPurpose objpurpose = new DSRCManagementSystem.EmailPurpose(); var already = db.EmailPurposes.Where(x => x.EmailPurposeName == objmail.Purpose && x.IsActive == true).Select(x => x).FirstOrDefault(); if (already != null) { return(Json(new { Result = "Already", JsonRequestBehavior.AllowGet })); } else { var val = db.EmailTemplates.Where(x => x.TemplatePurpose == objmail.Purpose).Select(o => o.EmailTemplateID).FirstOrDefault(); var val1 = db.EmailTemplates.Where(x => x.TemplatePurpose == objmail.Purpose).Select(o => o.TemplatePath).FirstOrDefault(); objmail.Template = val1; //string temp = ""; //int count = objmail.To.Count(); //foreach (var num in objmail.To) //{ // temp += num + ","; //} //string temp1 = ""; //foreach (var num in objmail.CC) //{ // temp1 += num + ","; //} //string temp2 = ""; //foreach (var num in objmail.BCC) //{ // temp2 += num + ","; //} objpurpose.EmailPurposeName = objmail.Purpose; objpurpose.EmailTemplateID = val; objpurpose.To = objmail.To != null ? objmail.To : ""; objpurpose.CC = objmail.CC != null ? objmail.CC : ""; objpurpose.BCC = objmail.BCC != null ? objmail.BCC : ""; objpurpose.Subject = objmail.Subject; objpurpose.IsActive = true; db.AddToEmailPurposes(objpurpose); db.SaveChanges(); return(Json(new { Result = "Success", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet)); } }