protected void btn_Click(object sender, EventArgs e)
{
try
{
var FirstName = TextBox.Text;
var LastName = TextBox1.Text;
var Dep = DepList.SelectedValue;
var Email = TextBox2.Text;
var mobno = txtTinyMCE.Text;
var phoneno = TextBox3.Text;
var role = Rolelist.SelectedValue;
var context = new MOMEntities();
DETAILSTABLE NEWMEMBER = new DETAILSTABLE();
NEWMEMBER.FIRSTNAME = FirstName;
NEWMEMBER.LASTNAME = LastName;
NEWMEMBER.DEPARTMENT = Convert.ToDecimal(Dep);
NEWMEMBER.EMAIL = Email;
if (mobno != "")
{
NEWMEMBER.MOBILE = mobno;
}
if (phoneno != "")
{
NEWMEMBER.TELEPHONE = phoneno;
}
NEWMEMBER.ROLE = Convert.ToDecimal(role);
context.DETAILSTABLE.Add(NEWMEMBER);
context.SaveChanges();
}
catch (Exception ex)
{
Response.Write(ex);
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{
var ID = Request.QueryString["identifier"];
int id = Convert.ToInt32(ID);
var context = new MOMEntities();
List <MOMDETAILS> USER = new List <MOMDETAILS>();
USER = context.MOMDETAILS.Where(x => x.MOMDETAILS1 == id).ToList();
//var meeting = USER.MOMDETAILS1;
List <INVITEESTABLE> INV = context.INVITEESTABLE.Where(x => x.MEETINGID == id).ToList();
DETAILSTABLE detail = new DETAILSTABLE();
foreach (var item in INV)
{
var uid = item.INVITEEID;
detail = context.DETAILSTABLE.SingleOrDefault(x => x.UNIQUEID == uid);
var email = detail.EMAIL;
using (MailMessage mm = new MailMessage("*****@*****.**", email))
{
mm.Subject = "MOM DETAILS";
foreach (var item2 in USER)
{
mm.Body = mm.Body + " " + item2.ACTIONPOINT + item2.TASKDESCRIPTION + item2.TARGET;
}
//var link = Request.Url.AbsoluteUri.Replace(Request.Url.PathAndQuery, verifyUrl);
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
System.Net.NetworkCredential credentials = new System.Net.NetworkCredential();
credentials.UserName = "******";
credentials.Password = "******";
smtp.UseDefaultCredentials = true;
smtp.Credentials = credentials;
smtp.Port = 587;
smtp.Send(mm);
}
}
PopUp("Mail sent to all Invitees");
}
catch (Exception ex)
{
PopUp("Some error occured");
//Response.Write(ex.Message);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
var ID = Request.QueryString["identifier"];
int id = Convert.ToInt32(ID);
var context = new MOMEntities();
List <MOMDETAILS> USER = new List <MOMDETAILS>();
USER = context.MOMDETAILS.Where(x => x.MOMDETAILS1 == id).ToList();
//var meeting = USER.MOMDETAILS1;
//MEETINGTABLE Meeting = new MEETINGTABLE();
var Meeting = context.MEETINGTABLE.Single(x => x.MEETINGID == id);
var CPID = Meeting.CHAIRPERSON;
DETAILSTABLE cp = new DETAILSTABLE();
cp = context.DETAILSTABLE.Single(x => x.UNIQUEID == CPID);
var email = cp.EMAIL;
using (MailMessage mm = new MailMessage("*****@*****.**", email))
{
mm.Subject = "Chairperson Meeting Update";
//var link = Request.Url.AbsoluteUri.Replace(Request.Url.PathAndQuery, verifyUrl);
//mm.Body = USER.ACTIONABLE+" "+ USER.ITEM+" "+ USER.STATUS+" "+ USER.EXPECTEDCLOSURE;
foreach (var item in USER)
{
mm.Body = mm.Body + " " + item.ACTIONPOINT + item.TASKDESCRIPTION + item.TARGET;
}
mm.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.EnableSsl = true;
System.Net.NetworkCredential credentials = new System.Net.NetworkCredential();
credentials.UserName = "******";
credentials.Password = "******";
smtp.UseDefaultCredentials = true;
smtp.Credentials = credentials;
smtp.Port = 587;
smtp.Send(mm);
}
PopUp("Mail sent to Chairperson");
}
