protected void Page_Load(object sender, EventArgs e)
{
if ((string)Session["user"] != null)
{
} // Label1.Text = "Welcome " + (string)Session["user"];
else
{
Response.Redirect("Index2.aspx");
}
Label2.Text = " ";
int rows = GridView2.Rows.Count;
if (rows == 0)
{
Label2.Text = "No records";
}
Label1.Text = " ";
DateTime dt1 = DateTime.Now.AddDays(-1);
Database1Entities22 db = new Database1Entities22();
var gt = from x in db.GatePasses where x.gate_date < dt1 select x;
GatePass gate = new GatePass();
foreach (var s in gt)
{
gate = s;
db.GatePasses.Remove(gate);
}
db.SaveChanges();
}
protected void Button1_Click(object sender, EventArgs e)
{
Database1Entities22 db = new Database1Entities22();
GatePass gt = new GatePass();
gt.user_id = (String)Session["User"];
gt.gate_reason = TextBox1.Text;
gt.gate_date = Calendar1.SelectedDate;
db.GatePasses.Add(gt);
db.SaveChanges();
Label3.Text = "Request Submitted";
}
protected void Button1_Click(object sender, EventArgs e)
{
String email1 = " ";
Database1Entities22 db = new Database1Entities22();
int gid = (int)GridView2.SelectedValue;
var x = from a in db.GatePasses from b in db.UserDbs where a.gate_id == gid && a.user_id == b.user_id select b;
foreach (var s in x)
{
email1 = s.email;
}
GatePass gt = db.GatePasses.Where(s => s.gate_id == gid).FirstOrDefault <GatePass>();
db.GatePasses.Remove(gt);
db.SaveChanges();
GridView2.DataBind();
int f = 0;
SqlConnection conn;
SqlDataReader sr;
SqlCommand cmd = new SqlCommand();
String str;
str = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
conn = new SqlConnection(str);
/* conn.Open();
* cmd.Connection = conn;
* cmd.CommandText = "select email from UserDb where user_id=@user1;";
* cmd.Parameters.AddWithValue("@user1", GridView2.SelectedRow.Cells[0]);
* sr = cmd.ExecuteReader();
* sr.Read();
*
* email1 = sr["email"].ToString();
* gate1 = (int)sr["gate_id"];
*
* sr.Close();*/
// if (!string.IsNullOrEmpty(pwd))
//{
MailMessage msg = new MailMessage();
msg.From = new MailAddress("*****@*****.**");
msg.To.Add(email1);
msg.Subject = "GatePass ";
msg.Body = ("Your GatePass Id is: " + gid.ToString());
msg.IsBodyHtml = true;
SmtpClient smt = new SmtpClient();
smt.Host = "smtp.gmail.com";
System.Net.NetworkCredential ntwd = new NetworkCredential();
ntwd.UserName = "******"; //Your Email ID
ntwd.Password = "******"; // Your Password
smt.UseDefaultCredentials = true;
smt.Credentials = ntwd;
smt.Port = 587;
smt.EnableSsl = true;
smt.Send(msg);
Label1.Text = "Mail sent";
// Label2.Text = "Username and Password Sent Successfully";
//Label2.ForeColor = System.Drawing.Color.ForestGreen;
// }
//else
//{
// Label2.Text = "Invalid Email";
// Label2.ForeColor = System.Drawing.Color.ForestGreen;
int rows = GridView2.Rows.Count;
if (rows == 0)
{
Label2.Text = "No records";
}
//}
}
