protected void Button1_Click(object sender, EventArgs e)
{
var ID = Request.QueryString["identifier"];
int id = Convert.ToInt32(ID);
var context = new MOMEntities();
MOMDETAILS USER = new MOMDETAILS();
USER = context.MOMDETAILS.Single(x => x.KEY == id);
var meeting = USER.MOMDETAILS1;
MEETINGTABLE Meeting = new MEETINGTABLE();
Meeting = context.MEETINGTABLE.Single(x => x.MEETINGID == USER.MOMDETAILS1);
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 = "REMINDER";
//var link = Request.Url.AbsoluteUri.Replace(Request.Url.PathAndQuery, verifyUrl);
//mm.Body = USER.ACTIONABLE+" "+ USER.ITEM+" "+ USER.STATUS+" "+ USER.EXPECTEDCLOSURE;
mm.Body = USER.ACTIONPOINT + USER.TASKDESCRIPTION + USER.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);
}
}
private void BindGrid()
{
var token = Session["TOKEN"] as string;
var user = TokenManager.Identifytoken(token);
var context = new MOMEntities();
// var list = from u in MEETINGTABLE sel List<MEETINGTABLE> list = new List<MEETINGTABLE>();
var dep = user.DEPARTMENT;
var DepMeet = (List <MEETDEP>)context.MEETDEP.Where(x => x.DEPID == dep).ToList();
List <MEETINGTABLE> list = new List <MEETINGTABLE>();
foreach (var item in DepMeet)
{
MEETINGTABLE x = new MEETINGTABLE();
x = context.MEETINGTABLE.Single(p => p.MEETINGID == item.MEETID);
list.Add(x);
}
Meetlist.DataSource = list;
Meetlist.DataBind();
}
protected void btn_Click(object sender, EventArgs e)
{
try
{
var agenda = txtTinyMCE.Text;
var title = TextBox3.Text;
var chairperson = ChairpersonList.SelectedValue;
var date = Convert.ToDateTime(TextBox.Text);
var time = TextBox1.Text;
var NewMeeting = new MEETINGTABLE();
NewMeeting.CHAIRPERSON = Convert.ToDecimal(chairperson);
NewMeeting.TIME = time;
NewMeeting.TITLE = title;
NewMeeting.MEETINGDATE = date;
//NewMeeting.CHAIRPERSON = chairperson;
var context = new MOMEntities();
context.MEETINGTABLE.Add(NewMeeting);
context.SaveChanges();
var ID = NewMeeting.MEETINGID;
var Meetagenda = new AGENDATABLE();
Meetagenda.MEETINGID = ID;
Meetagenda.AGENDA = agenda;
context.AGENDATABLE.Add(Meetagenda);
context.SaveChanges();
foreach (ListItem listItem in InviteeList.Items)
{
if (listItem.Selected)
{
var val = listItem.Value;
var txt = listItem.Text;
INVITEESTABLE invite = new INVITEESTABLE();
invite.MEETINGID = ID;
invite.INVITEEID = Convert.ToDecimal(val);
context.INVITEESTABLE.Add(invite);
context.SaveChanges();
}
}
foreach (ListItem LISTITEM in ListBox1.Items)
{
if (LISTITEM.Selected)
{
var val = LISTITEM.Value;
MEETDEP obj = new MEETDEP();
obj.MEETID = ID;
obj.DEPID = Convert.ToInt32(val);
context.MEETDEP.Add(obj);
context.SaveChanges();
}
}
Response.Redirect("/Home.aspx");
// var list = InviteeList.SelectedValue;
// var ID= context.MEETINGTABLE.
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}