using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Net.Mail;
using System.Data.OleDb;
public partial class _Default : System.Web.UI.Page
{
OleDbConnection gridcon = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0; Data Source =" + System.Web.HttpContext.Current.Server.MapPath("App_Data/MCAfinal.mdb"));
String uname, upwd, username, proguide, rollno, name, email1, txt, acc, rol, Accept, valid;
int flag = 0, flag1 = 0, count = 0, count1 = 0;
protected void Page_Load(object sender, EventArgs e)
{
uname = Request.QueryString["username"].ToString();
upwd = Request.QueryString["password"].ToString();
editgriddd();
//}
gridcon.Open();
//editgriddd();
//showgrid();
OleDbCommand gcmd = gridcon.CreateCommand();
gcmd.CommandText = "SELECT *FROM ONLINE WHERE guser='" + uname + "' AND gpwd='" + upwd + "'";
// OleDbDataAdapter oda = new OleDbDataAdapter("SELECT *FROM ONLINE WHERE guser='" + uname + "' AND gpwd='" + upwd + "'", gridcon);
//DataTable dat = new DataTable();
// oda.Fill(dat);
OleDbDataReader gdr = gcmd.ExecuteReader();
if (gdr.Read())
//if (dat.Rows.Count > 0)
{
//username = dat.Rows[0]["guser"].ToString();
//proguide = dat.Rows[0]["guname"].ToString();
username = gdr["guser"].ToString();
proguide = gdr["guidename"].ToString();
rol = gdr["roll"].ToString();
//rol = dat.Rows[0]["roll"].ToString();
// ViewState["proguide"] = proguide;
flag = 1;
}
gdr.Close();
gridcon.Close();
if (flag == 1)
{
// showgrid();
gridcon.Open();
OleDbCommand cmd = gridcon.CreateCommand();
//cmd.CommandText = "SELECT roll,name,guidename,empaddress,ptitle,pdes,comments,department FROM ONLINE WHERE guidename='" + proguide + "'";
cmd.CommandText = "SELECT *FROM ONLINE WHERE guidename='" + proguide +"'";
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
gridcon.Close();
}
//if (!IsPostBack)
//{
//uname = Request.QueryString["username"].ToString();
//upwd = Request.QueryString["password"].ToString();
//gridcon.Open();
//showgrid();
//OleDbCommand gcmd = gridcon.CreateCommand();
//gcmd.CommandText = "SELECT *FROM ONLINE WHERE guser='" + uname + "' AND gpwd='" + upwd + "'";
//OleDbDataReader gdr = gcmd.ExecuteReader();
//OleDbCommand gdatcmd = gridcon.CreateCommand();
//gdatcmd.CommandText = "SELECT *FROM gnamelistdaid WHERE guser='" + uname + "' AND gpwd='" + upwd + "'";
//OleDbDataReader gadr = gdatcmd.ExecuteReader();
//if (gdr.Read())
//{
// username = gdr["guser"].ToString();
// proguide = gdr["guidename"].ToString();
// flag = 1;
//}
//if (gadr.Read())
//{
// username = gadr["guser"].ToString();
// proguide = gadr["guidename"].ToString();
// flag = 1;
//}
//gdr.Close();
//gadr.Close();
//gridcon.Close();
//}
//showgrid();
}
protected void searchRedirect(object sender, EventArgs e)
{
uname = Request.QueryString["username"].ToString();
upwd = Request.QueryString["password"].ToString();
gridcon.Open();
OleDbCommand secmd = gridcon.CreateCommand ();
secmd.CommandText = "SELECT *FROM gnamelist WHERE guser='" + uname + "'AND gpwd='" + upwd + "'";
OleDbDataReader sedr = secmd.ExecuteReader();
//OleDbCommand searchcmd = accon.CreateCommand();
//searchcmd.CommandText = "SELECT *FROM gnamelistdaid WHERE guser='" + uname + "' AND gpwd='" + upwd + "'";
//OleDbDataReader sedaitdr = searchcmd.ExecuteReader();
if (sedr.Read())
//while (sedr.Read())
{
username = sedr["guser"].ToString();
proguide = sedr["guidename"].ToString();
//proguide = sedr["guname"].ToString();
}
//else if (sedaitdr.Read())
// {
// username = sedaitdr["guser"].ToString();
// proguide = sedaitdr["gpwd"].ToString();
// }
sedr.Close();
// sedaitdr.Close();
gridcon.Close();
rol = GridView1.SelectedRow.Cells[1].Text;
// Response.Redirect("Validationlogin.aspx?rollno=" + rol + "'" + "&guidename='" + proguide + "'");
// Response.Redirect("Default10.aspx?rollno=" + rol + "'" + "&guidename='" + proguide + "'");
Response.Redirect("Default7.aspx?roll=" + rol + "'" + "&guidename='" + proguide + "'");
//accon.Open();
}
protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
rol = GridView1.SelectedRow.Cells[1].Text;
Accept = GridView1.SelectedRow.Cells[8].Text;
}
protected void Populate_Grid2(object sender, EventArgs e)
{
uname = Request.QueryString["username"].ToString();
upwd = Request.QueryString["password"].ToString();
gridcon.Open();
OleDbCommand sqlcmd = gridcon.CreateCommand();
sqlcmd.CommandText = "SELECT *FROM ONLINE WHERE guser='" + uname + "'AND gpwd='" + upwd + "'";
//sqlcmd.CommandText ="SELECT *FROM gnamelist WHERE guser='" + uname+ "'AND gpwd='" + upwd +"'";
OleDbDataReader sqldr = sqlcmd.ExecuteReader();
if(sqldr.Read())
//while (sqldr.Read())
{
username =sqldr["guser"].ToString();
//proguide = sqldr["guname"].ToString();
proguide = sqldr["guidename"].ToString();
flag = 1;
}
sqldr.Close();
// gdaitdr.Close();
gridcon.Close();
DropDownList ddl = sender as DropDownList;
foreach (GridViewRow row in GridView1.Rows)
{
Control ctrl = row.FindControl("DropDownList1") as DropDownList;
if (ctrl != null)
{
DropDownList ddl1 = (DropDownList)ctrl;
if (ddl.ClientID == ddl1.ClientID)
{
txt = ddl1.SelectedValue;
rol = GridView1.SelectedRow.Cells[1].Text;
break;
}
}
}
if (flag == 1)
{
gridcon.Open();
//sqlcon.Open ();
OleDbCommand sqlcmddd = gridcon.CreateCommand();
sqlcmddd.CommandText = "SELECT * FROM online WHERE guidename='" + proguide + "' and roll='" + rol + "'";
//OleDbCommand sqlcmddd = new OleDbCommand("SELECT accept FROM online WHERE guidename='" + proguide + "' and roll='" + rol + "'", accon);
OleDbDataReader sqldrr = sqlcmddd.ExecuteReader();
while (sqldrr.Read())
{
acc = sqldrr["department"].ToString();
rollno = sqldrr["roll"].ToString();
name = sqldrr["name"].ToString();
email1 = sqldrr["empaddress"].ToString();
valid = sqldrr["comments"].ToString();
if (acc == "")
{
flag1 = 1;
}
}
sqldrr.Close();
gridcon.Close();
if (flag1 == 1)
{
gridcon.Open();
//sqlcon.Open ();
OleDbCommand upcmd = new OleDbCommand();
upcmd.Connection = gridcon;
upcmd.CommandText = "UPDATE online SET [department]='" + txt + "'WHERE roll='" + rollno + "'";
upcmd.ExecuteNonQuery();
gridcon.Close();
gridcon.Open();
OleDbCommand gcmd = gridcon.CreateCommand();
gcmd.CommandText = "SELECT *FROM online WHERE guidename='" + proguide + "'and roll='" + rol + "'";
//gcmd.CommandText = "SELECT * FROM online guidename='" + proguide + "'";
OleDbDataReader gdr1 = gcmd.ExecuteReader();
while (gdr1.Read())
{
if (gdr1["department"].ToString() == "ACCEPTED")
{
count = count + 1;
}
else
{
count1 = count1 + 1;
}
}
gdr1.Close();
gridcon.Close();
if (count <= 10)
{
if(ddl.Text == "ACCEPTED")
{
//if (ddl.Text == "ACCEPTED")
//{
String from = "mca_cde@annauniv.edu";
String to = email1;
String subjectt = "Acceptance from the Guide (YES / NO):";
String body = "<STRONG>Dear Student (" + rollno + ")Name(" + name + "),<BR><FONT COLOR=Maroon><STRONG>The Guide has accepted you as a Project Student</FONT> <br> For Further Process, kindly, Contact Your Guide. <br><br> Best Wishes<br><br><br> CDE, ANNA UNIVERSITY<br><br> You have Received Mail from Selected Guide: <a href=http://cde.annauniv.edu/mcaonline/acknowlegement.aspx target\"blank\"> Acknowledgement Mail</a><br>" + proguide;
//String body = "<STRONG>Dear Student (" + rollno + ")Name(" + name + "),<BR><FONT COLOR=Maroon><STRONG>The Guide has accepted you as a Project Student</FONT> <br> For Further Process, kindly, Contact Your Guide. <br><br> Best Wishes<br><br><br> CDE, ANNA UNIVERSITY<br><br>" + proguide;
MailMessage message = new MailMessage();
message.From = new MailAddress(from);
message.To.Add(new MailAddress(to));
message.Subject = subjectt;
AlternateView hrmvw = AlternateView.CreateAlternateViewFromString(body, null, "text/html");
message.AlternateViews.Add(hrmvw);
message.IsBodyHtml = true;
message.Priority = MailPriority.Normal;
SmtpClient nsmtpe = new SmtpClient();
nsmtpe.Send(message);
Response.Redirect("Default10.aspx?username=" + uname + "&password=" + upwd + "&roll=" + rol);
// //Response.Write("Your Email Has been Successfully Send- Thanking You");
}
else if (ddl.Text == "ACCEPTED AFTER REVISION ONLY")
{
String from = "mca_cde@annauniv.edu";
String to = email1;
String subject = "<font size=15pt>Project Proposal - <font color=blue>Guide's Comments.</font></font>";
String body = "<STRONG>Dear Student, (" + rollno + ")name(" + name + ")comments("+valid+") ,<BR><FONT COLOR=Maroon><STRONG>The Guide has accepted you as a Project Student</FONT> <br> For Further Process, kindly, Contact Your Guide. <br><br> Best Wishes<br><br><br> CDE, ANNA UNIVERSITY<br><br> You have Received Mail from Selected Guide: <a href=http://cde.annauniv.edu/mcaonline/acknowlegement.aspx target\"blank\"> Acknowledgement Mail</a><br>" + proguide;
//String body = "<STRONG>Dear Student</STRONG><br><br> " + "<table border=2 cellpadding=2 cellspcaing=2 align=center><tr><td>Roll Number:</td><br>" + rol + "<tr><td><STRONG>Name of the Student</STRONG></td>" + tx1.Text + "<br><br></tr>" + "<tr><td style=width:180px;><STRONG>Guide's Comments:</STRONG></td>" + tx3.Text + "<br>" + "<tr><td style=width:180px;><STRONG>Guide's Accepted:</STRONG></td></table>" + ddl.Text + "<br><br></tr>" + "Carry out the comments suggested by the Guide and re-register the Project Proposal. <br><br><a href=http://cde.annauniv.edu/mcaonline/reregister.aspx target\"blank\"><br><br>Thanking you<br><br>CDE, ANNA UNIVERSITY";
MailMessage mMailmessage = new MailMessage();
mMailmessage.From = new MailAddress(from);
mMailmessage.To.Add(new MailAddress(to));
AlternateView htmlvw = AlternateView.CreateAlternateViewFromString(body, null, "text/html");
mMailmessage.AlternateViews.Add(htmlvw);
mMailmessage.Subject = subject;
mMailmessage.IsBodyHtml = true;
mMailmessage.Priority = MailPriority.Normal;
SmtpClient client = new SmtpClient();
client.Send(mMailmessage);
Response.Redirect("updatesuccess.aspx");
}
else if (ddl.Text == "REJECTED")
{
gridcon.Open();
//sqlcon.Open ();
OleDbCommand ncmd = new OleDbCommand();
ncmd.Connection = gridcon;
ncmd.CommandText = "INSERT INTO [delete] SELECT *FROM online WHERE roll='" + rollno + "'";
//ncmd.CommandText = "DELETE *FROM online where roll='" + rollno + "'";
//OleDbCommand ncmd = new OleDbCommand("INSERT INTO [delete] SELECT *FROM online WHERE roll='" + rollno + "'", accon);
//ncmd.Connection = accon;
ncmd.ExecuteNonQuery();
gridcon.Close();
//sqlcon.Close();
String from = "mca_cde@annauniv.edu";
String to = email1;
String subjectt = "Acceptance from the Guide (YES / NO):";
String body = "<STRONG>Dear Student (" + rollno + ")Name(" + name + "),<STRONG><BR><BR><TABLE BORDER=2><TR><TD><FONT COLOR=BLUE>The Guide has not accepted you as Project Student.</FONT><br></TD><TD>Kindly, Choose Alternate Guide</TR></TABLE><br><br> Thanking You<br><br>" + "<FONT COLOR=BLUE>CDE, Anna University, Chennai:</FONT>";
MailMessage message = new MailMessage();
message.From = new MailAddress(from);
message.To.Add(new MailAddress(to));
message.Subject = subjectt;
AlternateView hrmvw = AlternateView.CreateAlternateViewFromString(body, null, "text/html");
message.AlternateViews.Add(hrmvw);
message.IsBodyHtml = true;
message.Priority = MailPriority.Normal;
SmtpClient nsmtpe = new SmtpClient();
nsmtpe.Send(message);
Response.Redirect("updatesuccess.aspx");
Response.Write("Your Mail has been Sent Successfully");
gridcon.Open();
//sqlcon.Open();
OleDbCommand dcmd = new OleDbCommand();
dcmd.Connection = gridcon;
dcmd.CommandText = "DELETE *FROM online WHERE roll='" + rollno + "'";
// OleDbCommand dcmd = new OleDbCommand("DELETE FROM online WHERE roll='" + rollno + "'", accon);
// dcmd.Connection = accon;
dcmd.ExecuteNonQuery();
gridcon.Close();
// sqlcon.Close();
}
// else
// {
// Response.Write("<script>alert('You have to Select the Acceptance to the Student')</script>", this.Page);
// // MessageBox.ShowMessage("You have to Select the Acceptance to the Student", this.Page);
//}
}
}
// else
//{
// Response.Write("<script>alert('You have Given the Acceptance the Student')</script>",this.Page);
// //MessageBox.ShowMessage("You have Given the Acceptance to the Student", this.Page);
//}
if ((count1 > 0) && (count == 10)) ;
{
gridcon.Open();
OleDbCommand sccmd = gridcon.CreateCommand();
// sccmd.CommandText = "SELECT *FROM online WHERE ((guidename='" + proguide + "')and (IsNull(accept)=True))";
sccmd.CommandText = "SELECT *FROM online WHERE ((guname='" + proguide + "')and (IsNull(department)=True))";
OleDbDataReader dr11 = sccmd.ExecuteReader();
while (dr11.Read())
{
email1 = dr11["empaddress"].ToString();
String rollno1 = dr11["roll"].ToString();
String name1 = dr11["name"].ToString();
//gridcon.Open();
String acc = dr11["department"].ToString();
#region yes and no
//String from = "mca_cde@annauniv.edu";
//String to = email1;
//String subjectt = "Acceptance from the Guide (YES / NO):";
//String body = "<STRONG>Dear Student (" + rollno1 + ")Name(" + name1 + "),<STRONG><BR><BR> The Guide has accepted you has a Project Student <br> Please proceed further with this Guide, <br><br>Thanking You<br><br>" + proguide;
//MailMessage message = new MailMessage();
//message.From = new MailAddress(from);
//message.To.Add(new MailAddress(to));
//message.Subject = subjectt;
//AlternateView hrmvw = AlternateView.CreateAlternateViewFromString(body, null, "text/html");
//message.AlternateViews.Add(hrmvw);
//message.IsBodyHtml = true;
//message.Priority = MailPriority.Normal;
//SmtpClient nsmtpe = new SmtpClient();
//nsmtpe.Send(message);
//Response.Write("Your Mail has been Successfully");
//OleDbCommand dlcmd = new OleDbCommand();
//dlcmd.Connection = accon;
//dlcmd.CommandText = "DELETE *FROM online WHERE roll='" + rollno1 + "'";
////OleDbCommand dlcmd = new OleDbCommand("DELETE FROM online WHERE rollno='" + rollno1 + "'", accon);
////dlcmd.Connection = accon;
//dlcmd.ExecuteNonQuery();
#endregion
}
// Response.Redirect("Default7.aspx");
dr11.Close();
gridcon.Close();
}
}
Response.Redirect("Default7.aspx?rollno=" + rol + "'" + "&guidename='" + proguide + "'");
//Response.Redirect("Default10.aspx?rollno=" + rol + "'" +"&guidename='" + proguide);
}
public void showgrid()
{
OleDbConnection mcon = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0; Data Source =" + System.Web.HttpContext.Current.Server.MapPath("App_Data/MCAfinal.mdb"));
mcon.Open();
OleDbCommand cmd = mcon.CreateCommand();
cmd.CommandText = "SELECT *FROM ONLINE WHERE guname='" + proguide + "'";
//OleDbCommand cmd = new OleDbCommand ("SELECT *FROM ONLINE",mcon);
cmd.ExecuteNonQuery();
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
mcon.Close();
}
//public void showgrid()
//{
// OleDbConnection mcon = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0; Data Source =" + System.Web.HttpContext.Current.Server.MapPath("App_Data/MCAfinal.mdb"));
// mcon.Open();
// OleDbCommand cmd = new OleDbCommand("SELECT *FROM online",mcon);
// //OleDbCommand cmd = new OleDbCommand ("SELECT *FROM employee",mcon);
// cmd.ExecuteNonQuery();
// OleDbDataAdapter da = new OleDbDataAdapter(cmd);
// DataSet ds = new DataSet();
// da.Fill(ds);
// GridView1.DataSource = ds;
// GridView1.DataBind();
// mcon.Close();
//}
public void editgriddd()
{
OleDbConnection edicon = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0; Data Source =" + System.Web.HttpContext.Current.Server.MapPath("App_Data/MCAfinal.mdb"));
edicon.Open();
OleDbCommand edcmd = new OleDbCommand("SELECT *FROM ONLINE WHERE guname='" + proguide + "'", edicon);
edcmd.ExecuteNonQuery();
OleDbDataAdapter eda = new OleDbDataAdapter(edcmd);
DataSet eds = new DataSet();
eda.Fill(eds);
GridView1.DataSource = eds;
GridView1.DataBind();
edicon.Close();
}
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GridView1.EditIndex = -1;
editgriddd();
//showgrid();
}
protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView1.EditIndex = e.NewEditIndex;
gridcon.Open();
GridView1.EditIndex = e.NewEditIndex;
editgriddd();
// proguide = ViewState["proguide"].ToString();
//OleDbCommand cmd1 = gridcon.CreateCommand();
//cmd1.CommandText = "SELECT *FROM ONLINE WHERE guidename='" + proguide +"'and roll='" + rol +"'";
OleDbCommand cmd = new OleDbCommand("SELECT roll,name,guidename,empaddress,ptitle,pdes,comments,department FROM ONLINE WHERE guidename='" + proguide + "'", gridcon);
//OleDbCommand cmd = new OleDbCommand ("SELECT *FROM employee",mcon);
OleDbDataAdapter da1 = new OleDbDataAdapter(cmd);
DataSet ds1 = new DataSet();
da1.Fill(ds1);
GridView1.DataSource = ds1;
GridView1.DataBind();
//editgriddd();
showgrid();
gridcon.Close();
// showgrid();
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lb = (Label)GridView1.Rows[e.RowIndex].FindControl("Label6");
Label lbguide = (Label)GridView1.Rows[e.RowIndex].FindControl("Label9");
DropDownList ddl = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("DropDownList1");
//RadioButtonList rbl = (RadioButtonList)GridView1.Rows[e.RowIndex].FindControl("RadioButtonList1");
//CheckBoxList chb = (CheckBoxList)GridView1.Rows[e.RowIndex].FindControl("CheckBoxList2");
TextBox tx1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1");
TextBox tx2 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2");
TextBox tx3 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox3");
TextBox tx4 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox4");
TextBox tx6 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox6");
gridcon.Open();
string sql = "UPDATE ONLINE SET name='" + tx1.Text + "',empaddress='" + tx2.Text + "',department='" + ddl.SelectedValue + "',comments='" +
tx3.Text + "',guidename='" + lbguide.Text + "',pdes='" + tx4.Text + "' WHERE roll='" + rol + "'";
//string sql = "UPDATE ONLINE SET name='" + tx1.Text + "',department='" + ddl.SelectedValue.ToString() + "',comments='" +
// tx3.Text + "',pdes='" + tx4.Text + "' WHERE roll='" + lb.Text + "'";
OleDbCommand cmd = new OleDbCommand(sql,gridcon);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery ();
gridcon.Close();
GridView1.EditIndex = -1;
showgrid ();
//gridcon.Close();
//rol = GridView1.SelectedRow.Cells[1].Text;
//Accept = GridView1.SelectedRow.Cells[8].Text;
rol = lb.Text;
gridcon.Open();
//OleDbCommand accomd = gridcon.CreateCommand();
//accomd.CommandText = "SELECT *FROM ONLINE WHERE guidename='" + proguide + "' and roll='" + rol + "'";
//OleDbDataReader acdr = accomd.ExecuteReader();
//while (acdr.Read())
//{
// if (acdr["department"].ToString() == "ACCEPTED")
// {
// // proguide = ViewState["proguide"].ToString();
// count = count + 1;
// }
// else
// {
// count1 = count1 + 1;
// }
//}
//gridcon.Close();
////if (count <= 10)
////{
if (ddl.Text == "ACCEPTED")
{
//Response.Redirect("Default10.aspx");
Response.Redirect("Default10.aspx?username=" + uname + "&password=" + upwd + "&roll=" + rol);
}
else if (ddl.Text == "ACCEPTED AFTER REVISION ONLY")
{
String from = "mca_cde@annauniv.edu";
String to = tx2.Text;
String subject = "<font size=15pt>Project Proposal - <font color=blue>Guide's Comments.</font></font>";
String body = "<STRONG>Dear Student,</STRONG><br><br> " + "<table border=2 cellpadding=2 cellspcaing=2 align=center><tr><td>Roll Number:</td><br>" + lb.Text + "<tr><td><STRONG>Name of the Student</STRONG></td>" + tx1.Text + "<br><br></tr>" + "<tr><td style=width:180px;><STRONG>Guide's Comments:</STRONG></td>" + tx3.Text + "<br>" + "<tr><td style=width:180px;><STRONG>Guide's Accepted:</STRONG></td></table>" + ddl.SelectedValue.ToString() + "<br><br></tr>" + "Carry out the comments suggested by the Guide and re-register the Project Proposal. <br><br><a href=http://cde.annauniv.edu/mcaonline/reregister.aspx target\"blank\"><br><br>Thanking you<br><br>CDE, ANNA UNIVERSITY";
MailMessage mMailmessage = new MailMessage();
mMailmessage.From = new MailAddress(from);
mMailmessage.To.Add(new MailAddress(to));
AlternateView htmlvw = AlternateView.CreateAlternateViewFromString(body, null, "text/html");
mMailmessage.AlternateViews.Add(htmlvw);
mMailmessage.Subject = subject;
mMailmessage.IsBodyHtml = true;
mMailmessage.Priority = MailPriority.Normal;
SmtpClient client = new SmtpClient();
client.Send(mMailmessage);
//Response.Redirect("updatesuccess.aspx");
}
else if(ddl.Text == "REJECTED")
{
String from = "mca_cde@annauniv.edu";
String to = tx2.Text;
// String to = tx2.Text ;
String subjectt = "Guide's ACCEPTANCE :";
String body = "<STRONG>Dear Student (" + rol + ")Name(" + name + "),<STRONG><BR><BR><TABLE BORDER=2><TR><TD><FONT COLOR=BLUE>The Guide has not accepted you as Project Student.</FONT><br></TD><TD>Kindly, Choose Alternate Guide</TR></TABLE><br><br> Thanking You<br><br>" + "<FONT COLOR=BLUE>CDE, Anna University, Chennai:</FONT>";
MailMessage message = new MailMessage();
message.From = new MailAddress(from);
message.To.Add(new MailAddress(to));
message.Subject = subjectt;
AlternateView hrmvw = AlternateView.CreateAlternateViewFromString(body, null, "text/html");
message.AlternateViews.Add(hrmvw);
message.IsBodyHtml = true;
message.Priority = MailPriority.Normal;
SmtpClient nsmtpe = new SmtpClient();
nsmtpe.Send(message);
// // Response.Write("updatesuccess.aspx");
// //Response.Write("Your Mail has been Sent Successfully");
// gridcon.Open();
// //sqlcon.Open();
// OleDbCommand dcmd = new OleDbCommand();
// dcmd.Connection = gridcon;
// dcmd.CommandText = "DELETE *FROM ONLINE WHERE roll='" + rol + "'";
// //dcmd.CommandText = "DELETE *FROM ONLINE WHERE roll='" + rollno + "'";
// // dcmd.Connection = accon;
// dcmd.ExecuteNonQuery();
// gridcon.Close();
string sql2 = "DELETE *FROM ONLINE WHERE roll='" + rol + "'";
OleDbCommand cmd1 = new OleDbCommand(sql2,gridcon);
cmd1.CommandType = CommandType.Text;
cmd1.ExecuteNonQuery();
gridcon.Close();
}
//}
}
//private DataTable GetData(OleDbCommand cmd5)
//{
// gridcon.Open();
// OleDbDataAdapter sda = new OleDbDataAdapter();
// cmd5.Connection = gridcon;
// sda.SelectCommand = cmd5;
// DataTable dt = new DataTable();
// sda.Fill(dt);
// return dt;
//}
//public DataTable load_department()
//{
// OleDbConnection deptcon = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0; Data Source =" + System.Web.HttpContext.Current.Server.MapPath("App_Data/MCAfinal.mdb"));
// DataTable dt = new DataTable();
// deptcon.Open();
// string sql = "SELECT * from department";
// OleDbCommand cmd = new OleDbCommand(sql, deptcon);
// cmd.CommandType = CommandType.Text;
// OleDbDataAdapter sd = new OleDbDataAdapter(cmd);
// sd.Fill(dt);
// return dt;
// deptcon.Close();
//}
//protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
//{
// if (GridView1.EditIndex == e.Row.RowIndex && e.Row.RowType == DataControlRowType.DataRow)
// {
// DropDownList dp = (DropDownList)e.Row.Cells[2].FindControl("DropDownList1");
// }
// //if (e.Row.RowType == DataControlRowType.DataRow)
// //{
// // DataSet row = ((DataRowView)e.Row.DataItem).Row;
// // DropDownList dp = (DropDownList)e.Row.FindControl("DropDownList1");
// // DataTable dt = load_department();
// // ListItem lt = new ListItem();
// // lt.Text = dt.Rows[0].ToString();
// // dp.Items.Add(lt);
// // if (dp.Text == "REJECTED")
// // {
// // gridcon.Open();
// // //sqlcon.Open ();
// // OleDbCommand ncmd = new OleDbCommand();
// // ncmd.Connection = gridcon;
// // ncmd.CommandText = "INSERT INTO [delete] SELECT *FROM online where roll='" + rollno + "'";
// // //ncmd.CommandText = "DELETE *FROM online where roll='" + rollno + "'";
// // //OleDbCommand ncmd = new OleDbCommand("INSERT INTO [delete] SELECT *FROM online WHERE roll='" + rollno + "'", accon);
// // //ncmd.Connection = accon;
// // ncmd.ExecuteNonQuery();
// // gridcon.Close();
// // //sqlcon.Close();
// // String from = "mca_cde@annauniv.edu";
// // String to = email1;
// // // String to = tx2.Text ;
// // String subjectt = "Acceptance from the Guide (YES / NO):";
// // String body = "<STRONG>Dear Student (" + rollno + ")Name(" + name + "),<STRONG><BR><BR><TABLE BORDER=2><TR><TD><FONT COLOR=BLUE>The Guide has not accepted you as Project Student.</FONT><br></TD><TD>Kindly, Choose Alternate Guide</TR></TABLE><br><br> Thanking You<br><br>" + "<FONT COLOR=BLUE>CDE, Anna University, Chennai:</FONT>";
// // MailMessage message = new MailMessage();
// // message.From = new MailAddress(from);
// // message.To.Add(new MailAddress(to));
// // message.Subject = subjectt;
// // AlternateView hrmvw = AlternateView.CreateAlternateViewFromString(body, null, "text/html");
// // message.AlternateViews.Add(hrmvw);
// // message.IsBodyHtml = true;
// // message.Priority = MailPriority.Normal;
// // SmtpClient nsmtpe = new SmtpClient();
// // nsmtpe.Send(message);
// // // Response.Write("updatesuccess.aspx");
// // //Response.Write("Your Mail has been Sent Successfully");
// // gridcon.Open();
// // //sqlcon.Open();
// // OleDbCommand dcmd = new OleDbCommand();
// // dcmd.Connection = gridcon;
// // dcmd.CommandText = "DELETE *FROM ONLINE WHERE roll=@roll";
// // dcmd.Parameters.AddWithValue("@roll", rollno);
// // //dcmd.CommandText = "DELETE *FROM ONLINE WHERE roll='" + rol + "'";
// // // dcmd.Connection = accon;
// // dcmd.ExecuteNonQuery();
// // gridcon.Close();
// // showgrid();
// // }
// //}
//}
//protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
//{
// DataRowView drv = e.Row.DataItem as DataRowView;
// if (e.Row.RowType == DataControlRowType.DataRow)
// {
// if ((e.Row.RowState & DataControlRowState.Edit) > 0)
// {
// DropDownList dp = (DropDownList)e.Row.FindControl("DropDownList1");
// DataBind dt = new DataTable();
// //DataTable dt = load_department();
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// ListItem lt = new ListItem();
// lt.Text = dt.Rows[i][0].ToString();
// dp.Items.Add(lt);
// }
// dp.SelectedValue = drv[3].ToString();
// //RadioButtonList rbtnl = (RadioButtonList)e.Row.FindControl("RadioButtonList1");
// //rbtnl.SelectedValue = drv[5].ToString();
// //CheckBoxList chkb = (CheckBoxList)e.Row.FindControl("CheckBoxList2");
// //chkb.SelectedValue = drv[6].ToString();
// }
// }
// // //rrp.SelectedValue = drv[1].ToString();
// // dp.SelectedValue = drv[3].ToString();
// // //RadioButtonList rbtnl = (RadioButtonList)e.Row.FindControl("RadioButtonList1");
// // //rbtnl.SelectedValue = drv[5].ToString();
// // //CheckBoxList chkb = (CheckBoxList)e.Row.FindControl("CheckBoxList2");
// // //chkb.SelectedValue = drv[6].ToString();
// // }
// //}
//}
//}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if(e.CommandName.Equals ("REJECTED"))
{
Label lbdep = (Label)GridView1.FindControl ("Label2");
DropDownList dp= (DropDownList)GridView1.FindControl ("DropDownList1");
gridcon.Open();
OleDbCommand ocmd = new OleDbCommand();
ocmd.CommandText = "DELECT *FROM ONLINE WHERE roll='" + rol +"'";
ocmd.Connection = gridcon;
ocmd.ExecuteNonQuery();
showgrid();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Label lb = (Label)GridView1.Rows[e.RowIndex].FindControl("Label6");
DropDownList ddl = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("DropDownList1");
//RadioButtonList rbl = (RadioButtonList)GridView1.Rows[e.RowIndex].FindControl("RadioButtonList1");
//CheckBoxList chb = (CheckBoxList)GridView1.Rows[e.RowIndex].FindControl("CheckBoxList2");
TextBox tx1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1");
TextBox tx2 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2");
TextBox tx3 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox3");
TextBox tx4 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox4");
TextBox tx6 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox6");
//email1 = tx2.Text;
gridcon.Open();
OleDbCommand ncmdd = new OleDbCommand();
ncmdd.Connection = gridcon;
ncmdd.CommandText = "INSERT INTO [delete] SELECT *FROM ONLINE WHERE roll='" + rol + "'";
ncmdd.ExecuteNonQuery();
gridcon.Close();
String from = "mca_cde@annauniv.edu";
String to = tx2.Text;
// String to = tx2.Text ;
String subjectt = "Guide's ACCEPTANCE :";
String body = "<STRONG>Dear Student (" + rol + ")Name(" + name + "),<STRONG><BR><BR><TABLE BORDER=2><TR><TD><FONT COLOR=BLUE>The Guide has not accepted you as Project Student.</FONT><br></TD><TD>Kindly, Choose Alternate Guide</TR></TABLE><br><br> Thanking You<br><br>" + "<FONT COLOR=BLUE>CDE, Anna University, Chennai:</FONT>";
MailMessage message = new MailMessage();
message.From = new MailAddress(from);
message.To.Add(new MailAddress(to));
message.Subject = subjectt;
AlternateView hrmvw = AlternateView.CreateAlternateViewFromString(body, null, "text/html");
message.AlternateViews.Add(hrmvw);
message.IsBodyHtml = true;
message.Priority = MailPriority.Normal;
SmtpClient nsmtpe = new SmtpClient();
nsmtpe.Send(message);
// // Response.Write("updatesuccess.aspx");
// //Response.Write("Your Mail has been Sent Successfully");
// gridcon.Open();
// //sqlcon.Open();
// OleDbCommand dcmd = new OleDbCommand();
// dcmd.Connection = gridcon;
// dcmd.CommandText = "DELETE *FROM ONLINE WHERE roll='" + rol + "'";
// //dcmd.CommandText = "DELETE *FROM ONLINE WHERE roll='" + rollno + "'";
// // dcmd.Connection = accon;
// dcmd.ExecuteNonQuery();
// gridcon.Close();
string sql2 = "DELETE *FROM ONLINE WHERE roll='" + rol + "'";
OleDbCommand cmd1 = new OleDbCommand(sql2,gridcon);
cmd1.CommandType = CommandType.Text;
cmd1.ExecuteNonQuery();
gridcon.Close();
showgrid();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.EditIndex =-1;
editgriddd();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
}
I choose Grid view Template Field DropDownList Item selected values Accepted, Accepted after revision only and rejected. I id choose Accepted and redirect to the another page. And, Accepted after revision. it also only send to the email. how to solve
}