protected void Button2_Click(object sender, EventArgs e)
{
string s_add, r_add, message, heading,muid;
s_add = Session["us_name"].ToString();
r_add = TextBox1.Text;
heading = TextBox3.Text;
message = TextBox2.Text;
rec_mail te = new rec_mail();
conn = new OleDbConnection("Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password=db_mail;User ID=db_mail");
conn.Open();
cmd = new OleDbCommand("insert into messages values(m_id.nextval,'" + heading + "','" + message + "'," + file_name + "',sysdate,sysdate,'Draft')", conn);
dr = cmd.ExecuteReader();
cmd = new OleDbCommand("insert into mail_exchange values('" + s_add + "',m_id.currval,sysdate,sysdate,'" + r_add + "')", conn);
dr = cmd.ExecuteReader();
cmd = new OleDbCommand("insert into draft values(m_id.currval)", conn);
dr = cmd.ExecuteReader();
dr.Close();
cmd = new OleDbCommand("select m_id.currval from dual", conn);
dr = cmd.ExecuteReader();
dr.Read();
muid = dr[0].ToString();
dr.Close();
conn.Close();
Label1.Text = "Message Saved. Your message id is " + muid;
Label1.Visible = true;
dr.Close();
conn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
conn = new OleDbConnection("Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password=db_mail;User ID=db_mail");
string u_name, password;
u_name = TextBox1.Text;
password = TextBox2.Text;
rec_mail rr = new rec_mail();
string comp=rr.un_enc(u_name, password);
//u_name = raw_u_name + password[2];
//Response.Write(u_name);
conn.Open();
cmd=new OleDbCommand ("select enc_fun(user_id,password) from username where user_id='"+ u_name +"'",conn);
dr = cmd.ExecuteReader();
//dr.Read();
//Response.Write(raw_u_name + dr["password"].ToString()[2]);
if (dr.HasRows == false)
Label2.Visible = true;
else
{
dr.Read();
if (dr[0].ToString() == comp)
{
Session["us_name"] = u_name;
Response.Redirect("Mail_box.aspx");
}
else
Label2.Visible = true;
}
dr.Close();
conn.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
string raw,s_add, message, heading,muid;
string[] r_add = new string[100];
int i;
s_add = Session["us_name"].ToString();
raw = TextBox1.Text;
heading = TextBox3.Text;
message = TextBox2.Text;
r_add=raw.Split(',');
rec_mail te = new rec_mail();
conn = new OleDbConnection("Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password=db_mail;User ID=db_mail");
conn.Open();
if (file_name == null)
file_name = "NA";
cmd = new OleDbCommand("insert into messages values(m_id.nextval,'" + heading + "','" + message + "','" + file_name + "',sysdate,sysdate,'delivered')", conn);
dr = cmd.ExecuteReader();
dr.Close();
for (i = 0; i < r_add.Length; i++)
{
cmd = new OleDbCommand("insert into mail_exchange values('" + s_add + "',m_id.currval,sysdate,sysdate,'" + r_add[i].ToString() + "')", conn);
dr = cmd.ExecuteReader();
}
dr.Close();
cmd = new OleDbCommand("select m_id.currval from dual", conn);
dr = cmd.ExecuteReader();
dr.Read();
muid=dr[0].ToString();
dr.Close();
conn.Close();
Label1.Text = "Message Sent. Your message id is " +muid;
Label1.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
rec_mail tt = new rec_mail();
Response.Write("vedsar");
string x = "vedsar";
Response.Write(x);
}
protected void Button1_Click(object sender, EventArgs e)
{
String mid = Request.QueryString["val"].ToString();
rec_mail td = new rec_mail();
conn = new OleDbConnection("Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password=db_mail;User ID=db_mail");
conn.Open();
cmd = new OleDbCommand("select senders_address from mail_exchange where m_uid='" + mid + "'", conn);
dr = cmd.ExecuteReader();
dr.Read();
Response.Redirect("Compose_mail.aspx?val=" + dr[0].ToString());
dr.Close();
conn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
String mid = Request.QueryString["val"].ToString();
conn = new OleDbConnection("Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password=db_mail;User ID=db_mail");
conn.Open();
rec_mail td = new rec_mail();
cmd = new OleDbCommand("select m_heading,m_body,attachment from messages where m_uid='" + mid + "'", conn);
dr = cmd.ExecuteReader();
if (dr.HasRows == true)
{
dr.Read();
if (dr[2].ToString() != "NA")
{
LinkButton1.Visible = true;
LinkButton1.Text = dr[2].ToString();
}
Label1.Text = dr[0].ToString();
TextBox1.Text = dr[1].ToString();
}
else
{
Label1.Text = "No Heading and No Body";
}
dr.Close();
conn.Close();
}
private DataTable getdatatable()
{
page_type = Request.QueryString["val"].ToString();
e_name = Session["us_name"].ToString();
conn = new OleDbConnection("Provider=MSDAORA;Data Source=orcl;Persist Security Info=True;Password=db_mail;User ID=db_mail");
conn.Open();
DataTable test = new DataTable("test");
DataColumn c2 = new DataColumn("Date");
DataColumn c3 = new DataColumn();
DataColumn c4 = new DataColumn("Heading");
DataColumn c5 = new DataColumn("Status");
DataColumn c1 = new DataColumn("M_UID");
//HyperLinkColumn c6 = new HyperLinkColumn();
test.Columns.Add(c1);
test.Columns.Add(c2);
test.Columns.Add(c3);
test.Columns.Add(c4);
rec_mail td = new rec_mail();
if (page_type == "inb")
{
cmd = new OleDbCommand("select receiving_date,senders_address,m_heading,b.m_uid from mail_exchange a,messages b where a.m_uid=b.m_uid and (a.m_uid NOT IN (select m_uid from draft)) and receivers_address='" +e_name + "'", conn);
c3.ColumnName = "Sender";
}
else if (page_type == "sen")
{
cmd = new OleDbCommand("select sending_date,receivers_address,m_heading,b.m_uid,status from mail_exchange a,messages b where a.m_uid=b.m_uid and (a.m_uid NOT IN (select m_uid from draft)) and senders_address='" + e_name+ "'", conn);
c3.ColumnName = "Receiver";
test.Columns.Add(c5);
}
else if (page_type == "dra")
{
cmd = new OleDbCommand("select m_modified_date,receivers_address,m_heading,b.m_uid from mail_exchange a,messages b, draft c where a.m_uid=b.m_uid and b.m_uid=c.m_uid and senders_address='" + e_name + "'", conn);
c3.ColumnName = "Receiver";
}
GridView1.DataSource = test;
GridView1.DataBind();
dr = cmd.ExecuteReader();
if (dr.HasRows == true)
{
while (dr.Read())
{
DataRow r1 = test.NewRow();
r1[1] = dr[0].ToString();
r1[2] = dr[1].ToString();
r1[3] = dr[2].ToString();
r1[0] = dr[3].ToString();
if (page_type == "sen")
{
r1[4] = dr[4].ToString();
//r1[5] = dr[5].ToString();
//HyperLinkColumn(r1[5]);
}
//else
// r1[4] = td.enc(dr[4].ToString());`
test.Rows.Add(r1);
}
}
return test;
}
