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"); }