public ActionResult Value(int value)
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
DSRCManagementSystem.Models.Email obj = new DSRCManagementSystem.Models.Email();
var Path = objdb.EmailTemplates.Where(x => x.EmailTemplateID == value).Select(o => o.TemplatePath).FirstOrDefault();
return(Json(new { Name = Path }, JsonRequestBehavior.AllowGet));
}
public ActionResult AddNewEdit(int Id)
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
DSRCManagementSystem.Models.Email obj = new DSRCManagementSystem.Models.Email();
var EmailList = (from p in objdb.Users.Where(x => x.IsActive == true)
select new
{
UserId = p.UserID,
UserName = p.UserName
}).ToList();
var EmailList1 = (from p in objdb.Users.Where(x => x.IsActive == true)
select new
{
Id1 = p.UserID,
UserName1 = p.UserName
}).ToList();
var EmailList2 = (from p in objdb.Users.Where(x => x.IsActive == true)
select new
{
Id2 = p.UserID,
UserName2 = p.UserName
}).ToList();
obj = (from p in objdb.EmailPurposes.Where(x => x.EmailPurposeID == Id)
join t in objdb.EmailTemplates on p.EmailTemplateID equals t.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
PurposeId = t.EmailTemplateID,
Purpose = p.EmailPurposeName,
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = t.TemplatePath
}).FirstOrDefault();
List <int> selectedEmail = new List <int>();
if (obj.To != null)
{
string[] tokens = obj.To.Split(new string[] { "," }, StringSplitOptions.None);
foreach (var i in tokens)
{
int val;
int.TryParse(i, out val);
selectedEmail.Add(val);
}
}
List <int> selectedEmail1 = new List <int>();
if (obj.CC != null)
{
string[] tokens1 = obj.CC.Split(new string[] { "," }, StringSplitOptions.None);
foreach (var i in tokens1)
{
int val;
int.TryParse(i, out val);
selectedEmail1.Add(val);
}
}
List <int> selectedEmail2 = new List <int>();
if (obj.BCC != null)
{
string[] tokens2 = obj.BCC.Split(new string[] { "," }, StringSplitOptions.None);
foreach (var i in tokens2)
{
int val;
int.TryParse(i, out val);
selectedEmail2.Add(val);
}
}
var value = (from pi in objdb.EmailTemplates.Where(x => x.IsActive == true)
select new
{
Id3 = pi.EmailTemplateID,
Template = pi.TemplatePurpose
}).ToList();
return(View(obj));
}