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 Change_Click(object sender, EventArgs e) { Database1Entities22 db = new Database1Entities22(); string pass = TextBox1.Text; // s.Name = TextBox1.Text; // s.sem = Int32.Parse(TextBox2.Text); LoginDb s1 = db.LoginDbs.Where(s => s.password == pass).FirstOrDefault <LoginDb>(); if (s1 == null) { Label4.Text = "Your Old Password is Incorrect"; Label4.ForeColor = System.Drawing.Color.Firebrick; } else { LoginDb s2 = db.LoginDbs.Where(s => (s.password).Equals(pass)).FirstOrDefault <LoginDb>(); s2.password = TextBox2.Text; // db.LoginDbs.Add(s2); db.SaveChanges(); Label4.Text = "Password successfully changed"; Label4.ForeColor = System.Drawing.Color.ForestGreen; } TextBox1.Text = " "; TextBox2.Text = " "; TextBox3.Text = " "; }
protected void Button2_Click(object sender, EventArgs e) { Database1Entities22 db = new Database1Entities22(); int bid = Int32.Parse(TextBox3.Text); string uid = TextBox4.Text; Take tk = db.Takes.Where(s => (s.user_id).Equals(uid) && s.book_id == bid).FirstOrDefault <Take>(); if (tk == null) { Label5.Text = "No such Book issued"; Label5.ForeColor = System.Drawing.Color.ForestGreen; return; } DateTime dt = DateTime.Now; if (tk.due_date < dt) { double days = (dt - tk.due_date).TotalDays; Label6.Text = "You are" + days + "days late penalty will be charged"; } Library lb = db.Libraries.Where(s => s.book_id == bid).FirstOrDefault <Library>(); lb.units_available++; db.Takes.Remove(tk); db.SaveChanges(); Label5.Text = "Book Successfully returned"; Label5.ForeColor = System.Drawing.Color.ForestGreen; GridView1.DataBind(); GridView3.DataBind(); TextBox3.Text = ""; TextBox4.Text = ""; }
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) { int abc = Int32.Parse(DropDownList1.SelectedItem.Text); Database1Entities22 db = new Database1Entities22(); var rm = from s in db.Rooms where s.room_capacity == abc select s; foreach (var room in rm) { room.room_price = Int32.Parse(TextBox1.Text); } db.SaveChanges(); Label3.Text = "Price Updated"; }
protected void Button1_Click(object sender, EventArgs e) { Database1Entities22 db = new Database1Entities22(); Notice not = new Notice(); not.notice_sub = TextBox1.Text; not.notice_descrip = TextBox2.Text; not.notice_date = DateTime.Now; Label3.Text = "Notice Successsfully Added"; db.Notices.Add(not); db.SaveChanges(); GridView1.DataBind(); }
protected void Button4_Click(object sender, EventArgs e) { Database1Entities22 db = new Database1Entities22(); int bid = Int32.Parse(TextBox3.Text); string uid = TextBox4.Text; Take tk = db.Takes.Where(s => (s.user_id).Equals(uid) && s.book_id == bid).FirstOrDefault <Take>(); if (tk == null) { Label5.Text = "No such Book issued"; Label5.ForeColor = System.Drawing.Color.ForestGreen; return; } DateTime dt = DateTime.Now; if (tk.due_date < dt) { int days = (int)(dt - tk.due_date).TotalDays; Label6.Text = "You are" + days + "days late penalty will be charged"; Label6.ForeColor = System.Drawing.Color.ForestGreen; Penalty p = new Penalty(); p.penalty_subject = "Book Submission"; p.penalty_descrip = "You are" + days + "days late for book submission"; p.penalty_money = 10 * days; p.user_id = uid; p.penalty_date = DateTime.Now; db.Penalties.Add(p); db.SaveChanges(); } tk.issue_date = DateTime.Now; tk.due_date = DateTime.Now.AddDays(21); db.SaveChanges(); Label5.Text = "Book successfully Renewed"; GridView1.DataBind(); GridView3.DataBind(); TextBox3.Text = ""; TextBox4.Text = ""; }
protected void Button7_Click(object sender, EventArgs e) { Database1Entities22 db = new Database1Entities22(); int mon3 = Int32.Parse(DropDownList4.SelectedItem.Value); var exp = from x in db.Expenses where x.expense_date.Month == mon3 select x; foreach (var x in exp) { x.expense_status = "paid"; } db.SaveChanges(); GridView3.DataBind(); Label16.Text = "Payed Succssfully"; }
protected void Button4_Click(object sender, EventArgs e) { Database1Entities22 db = new Database1Entities22(); int mon = Int32.Parse(DropDownList1.SelectedItem.Value); var can = from x in db.User_Canteen where x.canteen_date.Month == mon select x; foreach (var x in can) { x.canteen_status = "paid"; } db.SaveChanges(); GridView2.DataBind(); Label11.Text = "Payed Succssfully"; }
protected void Button6_Click(object sender, EventArgs e) { Database1Entities22 db = new Database1Entities22(); int mon2 = Int32.Parse(DropDownList3.SelectedItem.Value); var pen = from x in db.Penalties where x.penalty_date.Month == mon2 select x; foreach (var x in pen) { x.penalty_status = "paid"; } db.SaveChanges(); GridView2.DataBind(); Label16.Text = "Payed Succssfully"; }
protected void Button5_Click(object sender, EventArgs e) { Database1Entities22 db = new Database1Entities22(); int mon1 = Int32.Parse(DropDownList2.SelectedItem.Value); var lau = from x in db.Laundries where x.laundry_date.Month == mon1 select x; foreach (var x in lau) { x.laundry_status = "paid"; } db.SaveChanges(); GridView1.DataBind(); Label16.Text = "Payed Succssfully"; }
protected void Button3_Click(object sender, EventArgs e) { Database1Entities22 db = new Database1Entities22(); Canteen c = new Canteen(); c.item_id = Int32.Parse(TextBox5.Text); c.item_name = TextBox6.Text; c.item_money = Decimal.Parse(TextBox7.Text); db.Canteens.Add(c); db.SaveChanges(); // Label11.Text = " New Item Insert Successfully "; TextBox5.Text = " "; TextBox6.Text = " "; TextBox7.Text = " "; GridView1.DataBind(); }
protected void Button2_Click(object sender, EventArgs e) { Database1Entities22 db = new Database1Entities22(); string uid = (GridView1.SelectedRow.Cells[1].Text); var abc = from s in db.Allocateds from t in db.Rooms where s.user_id.Equals(uid) && s.room_no == t.room_no select t; foreach (var x in abc) { x.slots_available = x.slots_available + 1; } // Room rm = db.Rooms.Where(s => s.user_id.Equals(uid) && s.room_no == t.room_no).FirstOrDefault<UserDb>(); UserDb user = db.UserDbs.Where(s => (s.user_id).Equals(uid)).FirstOrDefault <UserDb>(); db.UserDbs.Remove(user); db.SaveChanges(); Label31.Text = "User checked Out and Room slot is available"; GridView1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { Database1Entities22 db = new Database1Entities22(); User_Canteen uc = new User_Canteen(); uc.item_id = Int32.Parse(TextBox1.Text); uc.user_id = TextBox2.Text; uc.quantity = Int32.Parse(TextBox3.Text); uc.canteen_date = DateTime.Today; uc.canteen_status = "unpaid"; db.User_Canteen.Add(uc); db.SaveChanges(); Label5.Text = "Order added"; Label5.ForeColor = System.Drawing.Color.ForestGreen; TextBox1.Text = " "; TextBox2.Text = " "; TextBox3.Text = " "; }
protected void Button1_Click(object sender, EventArgs e) { Database1Entities22 db = new Database1Entities22(); Complaint c = new Complaint(); c.complaint_date = DateTime.Today; c.complaint_subject = TextBox1.Text; c.complaint_descrip = TextBox2.Text; c.user_id = (string)Session["user"]; c.complaint_status = "pending"; db.Complaints.Add(c); db.SaveChanges(); Label3.Text = "Your Complaint is Successfully Registerer to Admin and granted within 3 days"; GridView1.DataBind(); Label3.ForeColor = System.Drawing.Color.ForestGreen; TextBox1.Text = " "; TextBox2.Text = " "; }
/* protected void SqlDatasoruce1_selecting1(object sender, SqlDataSourceSelectingEventArgs e) * { * String x = TextBox1.Text; * if (TextBox1.Text.Length != 0) * { * e.Command.Parameters["@UserId"].Value = x; * * } * else * { * e.Command.Parameters["@UserId"].Value = "default"; * } * } * * protected void SqlDatasoruce2_selecting1(object sender, SqlDataSourceSelectingEventArgs e) * { * String x = TextBox1.Text; * if (TextBox1.Text.Length != 0) * { * e.Command.Parameters["@UserId1"].Value = x; * * } * else * { * e.Command.Parameters["@UserId1"].Value = "default"; * } * } * * protected void SqlDatasoruce3_selecting1(object sender, SqlDataSourceSelectingEventArgs e) * { * String x = TextBox1.Text; * if (TextBox1.Text.Length != 0) * { * e.Command.Parameters["@UserId2"].Value = x; * * } * else * { * e.Command.Parameters["@UserId2"].Value = "default"; * } * } */ protected void Button2_Click(object sender, EventArgs e) { DropDownList2.Visible = true; Button5.Visible = true; Database1Entities22 db = new Database1Entities22(); Laundry ly = new Laundry(); ly.user_id = Label4.Text; ly.total_items = Int32.Parse(TextBox2.Text); ly.laundry_money = Int32.Parse(TextBox3.Text); ly.laundry_date = DateTime.Today; ly.laundry_status = "unpaid"; db.Laundries.Add(ly); db.SaveChanges(); Label9.Text = "Successfully Inserted"; Label9.ForeColor = System.Drawing.Color.ForestGreen; GridView1.DataBind(); }
protected void Button3_Click(object sender, EventArgs e) { DropDownList3.Visible = true; Button6.Visible = true; Database1Entities22 db = new Database1Entities22(); Penalty p = new Penalty(); p.user_id = Label4.Text; p.penalty_subject = TextBox4.Text; p.penalty_descrip = TextBox5.Text; p.penalty_money = Int32.Parse(TextBox6.Text); p.penalty_date = DateTime.Today; p.penalty_status = "unpaid"; db.Penalties.Add(p); db.SaveChanges(); Label9.Text = "Successfully Inserted"; Label9.ForeColor = System.Drawing.Color.ForestGreen; GridView2.DataBind(); }
protected void Button4_Click(object sender, EventArgs e) { DropDownList4.Visible = true; Button7.Visible = true; Database1Entities22 db = new Database1Entities22(); Expense ex = new Expense(); ex.user_id = Label4.Text; ex.expense_descrip = TextBox7.Text; ex.expense_money = Int32.Parse(TextBox8.Text); ex.expense_date = DateTime.Today; ex.expense_status = "unpaid"; db.Expenses.Add(ex); db.SaveChanges(); Label9.Text = "Successfully Inserted"; Label9.ForeColor = System.Drawing.Color.ForestGreen; GridView3.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { DateTime dt = DateTime.Now.AddDays(-1); DateTime dt1 = Calendar2.SelectedDate; if (dt1 >= dt) { Database1Entities22 db = new Database1Entities22(); String s = DropDownList1.SelectedItem.Text; MessMenu mm1 = new MessMenu(); var st = from x in db.MessMenus where x.date == dt1 && x.menu_type == s select x; if (st.Count() == 0) { MessMenu mm = new MessMenu(); mm.menu = TextBox1.Text; mm.menu_type = DropDownList1.SelectedItem.Text; mm.date = Calendar2.SelectedDate; db.MessMenus.Add(mm); db.SaveChanges(); Label6.Text = "Menu is successfully added"; Label6.ForeColor = System.Drawing.Color.ForestGreen; TextBox1.Text = " "; // TextBox4.Text = " "; Calendar2.SelectedDates.Clear(); } else { Label8.Text = "Menu already added on this date"; TextBox1.Text = " "; Calendar2.SelectedDates.Clear(); } } else { Label6.Text = "Date must be greater than or equal to today"; Label6.ForeColor = System.Drawing.Color.Firebrick; } GridView1.Visible = false; Calendar1.SelectedDates.Clear(); }
protected void Button1_Click(object sender, EventArgs e) { Database1Entities22 db = new Database1Entities22(); int bid = Int32.Parse(TextBox3.Text); string uid = TextBox4.Text; Library lb = db.Libraries.Where(s => s.book_id == bid).FirstOrDefault <Library>(); int books = db.Takes.Count(s => (s.user_id).Equals(uid)); int same = db.Takes.Count(s => (s.user_id).Equals(uid) && s.book_id == bid); if (same != 0) { Label5.Text = "Book already issued"; } else if (lb.units_available > 0 && books < 3) { Take tk = new Take(); tk.book_id = Int32.Parse(TextBox3.Text); tk.user_id = TextBox4.Text; tk.issue_date = DateTime.Now; tk.due_date = DateTime.Now.AddDays(21); db.Takes.Add(tk); lb.units_available--; db.SaveChanges(); Label5.Text = "Book Successfully Issued"; Label5.ForeColor = System.Drawing.Color.ForestGreen; GridView1.DataBind(); GridView3.DataBind(); } else if (books == 3) { Label5.Text = "Maximum number of books issued"; Label5.ForeColor = System.Drawing.Color.ForestGreen; } else { Label5.Text = "All books issued"; Label5.ForeColor = System.Drawing.Color.ForestGreen; } TextBox3.Text = ""; TextBox4.Text = ""; }
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"; } //} }
protected void Wizard1_FinishButtonClick(object sender, WizardNavigationEventArgs e) { HttpCookie cookie1 = new HttpCookie("extension"); // int f = 0; int slots = 0; if (f == 0) { SqlConnection conn; SqlDataReader sr; SqlCommand cmd = new SqlCommand(); String str; str = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; conn = new SqlConnection(str); /* Database1Entities22 db1 = new Database1Entities22(); * UserDb u1 = new UserDb(); * // String imgname; * u1.user_id = TextBox1.Text; * u1.name = TextBox2.Text + " " + TextBox3.Text; * u1.dob = DropDownList8.SelectedItem.Text.ToString() + " " + DropDownList9.SelectedItem.Text.ToString() + " " + DropDownList10.SelectedItem.Text.ToString(); * u1.mobileno = Decimal.Parse(TextBox9.Text); * u1.email = TextBox5.Text; * u1.address = TextBox15.Text; * u1.city = TextBox6.Text; * u1.state = TextBox7.Text; * u1.pcode = Decimal.Parse(TextBox8.Text); * u1.sem = Int32.Parse(TextBox4.Text); * u1.branch = TextBox17.Text; * * * * db1.UserDbs.Add(u1); * * * db1.SaveChanges(); * * Database1Entities22 db2 = new Database1Entities22(); * Allocated a = new Allocated(); * a.user_id = TextBox1.Text; //userid into Allocate table * * * conn.Open(); * cmd.Connection = conn; * cmd.CommandText = "select * from Room where room_no=@number;"; * // String s = ListBox1.SelectedItem.Value; * cmd.Parameters.AddWithValue("@number", Int32.Parse(ListBox1.SelectedItem.Text.Substring(6))); * sr = cmd.ExecuteReader(); * while (sr.Read()) * { * a.room_no = (int)sr["room_no"]; * }//room no into Allocate table * db2.Allocateds.Add(a); * db2.SaveChanges(); * * sr.Close(); * conn.Close(); * * Database1Entities22 db3 = new Database1Entities22(); * LoginDb l = new LoginDb(); * l.user_id = TextBox1.Text; * l.password = TextBox11.Text; * int x = 1; * l.roleid = x; * // l.secque = TextBox13.Text; * * //l.secans = TextBox14.Text; * db3.LoginDbs.Add(l); * db3.SaveChanges(); * * * conn.Open(); * cmd.Connection = conn; * cmd.CommandText = "select * from Room where room_no=@room;"; * cmd.Parameters.AddWithValue("@room", ListBox1.SelectedItem.Text.Substring(6)); * * sr = cmd.ExecuteReader(); * sr.Read(); * * slots = (int)sr["slots_available"]; * slots = slots - 1; * sr.Close(); * cmd.CommandText = "update Room set slots_available=@slot where room_no=@room1"; * * cmd.Parameters.AddWithValue("@room1", ListBox1.SelectedItem.Text.Substring(6)); * cmd.Parameters.AddWithValue("@slot", slots); * cmd.ExecuteNonQuery(); * conn.Close();*/ if (FileUpload1.HasFile) { string ext = System.IO.Path.GetExtension(FileUpload1.FileName); cookie1["exte"] = ext; Response.Cookies.Add(cookie1); if (ext == ".jpg") { if (FileUpload1.PostedFile.ContentLength > 2000000) { Label39.Text = "Image size is greater than 2 MB......"; Label39.ForeColor = System.Drawing.Color.Firebrick; } else { FileUpload1.PostedFile.SaveAs(Server.MapPath("Upload\\" + TextBox1.Text + ext)); Database1Entities22 db1 = new Database1Entities22(); UserDb u1 = new UserDb(); // String imgname; u1.user_id = TextBox1.Text; u1.name = TextBox2.Text + " " + TextBox3.Text; u1.dob = DropDownList8.SelectedItem.Text.ToString() + " " + DropDownList9.SelectedItem.Text.ToString() + " " + DropDownList10.SelectedItem.Text.ToString(); u1.mobileno = Decimal.Parse(TextBox9.Text); u1.email = TextBox5.Text; u1.address = TextBox15.Text; u1.city = TextBox6.Text; u1.state = TextBox7.Text; u1.pcode = Decimal.Parse(TextBox8.Text); u1.sem = Int32.Parse(TextBox4.Text); u1.branch = TextBox17.Text; db1.UserDbs.Add(u1); db1.SaveChanges(); Database1Entities22 db2 = new Database1Entities22(); Allocated a = new Allocated(); a.user_id = TextBox1.Text; //userid into Allocate table conn.Open(); cmd.Connection = conn; cmd.CommandText = "select * from Room where room_no=@number;"; // String s = ListBox1.SelectedItem.Value; cmd.Parameters.AddWithValue("@number", Int32.Parse(ListBox1.SelectedItem.Text.Substring(6))); sr = cmd.ExecuteReader(); while (sr.Read()) { a.room_no = (int)sr["room_no"]; }//room no into Allocate table db2.Allocateds.Add(a); db2.SaveChanges(); sr.Close(); conn.Close(); Database1Entities22 db3 = new Database1Entities22(); LoginDb l = new LoginDb(); l.user_id = TextBox1.Text; l.password = TextBox11.Text; int x = 1; l.roleid = x; // l.secque = TextBox13.Text; //l.secans = TextBox14.Text; db3.LoginDbs.Add(l); db3.SaveChanges(); conn.Open(); cmd.Connection = conn; cmd.CommandText = "select * from Room where room_no=@room;"; cmd.Parameters.AddWithValue("@room", ListBox1.SelectedItem.Text.Substring(6)); sr = cmd.ExecuteReader(); sr.Read(); slots = (int)sr["slots_available"]; slots = slots - 1; sr.Close(); cmd.CommandText = "update Room set slots_available=@slot where room_no=@room1"; cmd.Parameters.AddWithValue("@room1", ListBox1.SelectedItem.Text.Substring(6)); cmd.Parameters.AddWithValue("@slot", slots); cmd.ExecuteNonQuery(); conn.Close(); Response.Redirect("Register2.aspx"); } } else { Label39.Text = "Please Select JPG Image file"; Label39.ForeColor = System.Drawing.Color.Firebrick; } } else { Label39.Text = "Select Image"; Label39.ForeColor = System.Drawing.Color.Firebrick; } } else { string message = "Already Registered."; System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("<script type = 'text/javascript'>"); sb.Append("window.onload=function(){"); sb.Append("alert('"); sb.Append(message); sb.Append("')};"); sb.Append("</script>"); ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", sb.ToString()); //Label46.Text = "Already Registered"; //Label46.ForeColor = System.Drawing.Color.ForestGreen; } }