protected void Button1_Click(object sender, EventArgs e)
{
if (DropDownList1.Text.Equals("Student"))
{
string qury = "select username from student where username='******' And password='******'";
SqlDataReader dr;
dr = db.RetriveData(qury);
if (dr.Read())
{
Session["uname"] = TextBox1.Text;
Response.Redirect("stu_issue.aspx");
}
else
{
Label7.Visible = true;
Label7.Text = "Not Valid Credential.";
}
}
else if (DropDownList1.Text.Equals("Faculty"))
{
string qury_fac = "select username from faculty where username='******' And password='******'";
SqlDataReader dr;
dr = db.RetriveData(qury_fac);
if (dr.Read())
{
Session["uname"] = TextBox1.Text;
Response.Redirect("fac_issue.aspx");
}
else
{
Label7.Visible = true;
Label7.Text = "Not Valid Credential.";
}
}
else
{
string qury_adm = "select username from admin where username='******' And password='******'";
SqlDataReader dr;
dr = db.RetriveData(qury_adm);
if (dr.Read())
{
Session["uname"] = TextBox1.Text;
Response.Redirect("admDefault.aspx");
}
else
{
Label7.Visible = true;
Label7.Text = "Not Valid Credential.";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string cmd = "select general_Loan_Fine from changeSetting";
dr = db.RetriveData(cmd);
if (dr.Read())
{
temp = dr[0].ToString();
LoanFine = temp.Split(':');
Label1.Text = LoanFine[0];
Label2.Text = LoanFine[1];
}
}
catch (Exception eo)
{
Label3.Visible = true;
Label3.Text = "Error==" + eo;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (DropDownList1.SelectedValue.Equals("Student"))
{
try
{
string cmd = "select issuelimit_stu from changeSetting";
dr = db.RetriveData(cmd);
if (dr.Read())
{
isslimitstu = dr[0].ToString();
}
}
catch (Exception eo)
{
Label3.Visible = true;
Label3.Text = "Error==" + eo;
}
}
else
{
try
{
string cmd = "select issuelimit_fac from changeSetting";
dr = db.RetriveData(cmd);
if (dr.Read())
{
isslimitfac = dr[0].ToString();
}
}
catch (Exception eo)
{
Label3.Visible = true;
Label3.Text = "Error==" + eo;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["uname"] == null)
{
Response.Redirect("login.aspx?info=0");
}
string name = "";
string qury = " select enrollid,name from student where username='******'";
dr = con.RetriveData(qury);
if (dr.Read())
{
id = Convert.ToInt64(dr[0].ToString());
name = dr[1].ToString();
}
else
{
Response.Redirect("suggestion.aspx?info=0");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
db.CheckStatus();
SqlCommand cmd = new SqlCommand("select name,dept,email,contact from student where enrollid=@Name", db.sqcon);
cmd.Parameters.AddWithValue("@Name", TextBox1.Text);
dr = cmd.ExecuteReader();
if (dr.Read())
{
Label1.Text = dr[0].ToString();
Label2.Text = dr[1].ToString();
Label3.Text = dr[2].ToString();
Label4.Text = dr[3].ToString();
}
else
{
Label1.Text = "Invalid ID/No such data existing in database";
}
string issue = "select bname from book where stuid='" + TextBox1.Text + "'";
dr = db.RetriveData(issue);
int i = 0;
while (dr.Read())
{
i++;
Label5.Text = dr[0].ToString();
}
Label5.Text = i + "";
//else
//{
// Label2.Text = "No book issued by this student";
//}
rmvstu.Style.Add("display", "block");
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
string email = null, pass = null;
string tempmail = null;
string[] emailPass = null;
string cmd = "select emailPass from changeSetting";
dr = db.RetriveData(cmd);
if (dr.Read())
{
tempmail = dr[0].ToString();
emailPass = tempmail.Split(':');
email = emailPass[0];
pass = emailPass[1];
}
else
{
Label1.Visible = true;
Label1.Text = "No EmailID exist in database....";
}
int Days = Convert.ToInt32(TextBox1.Text);
DateTime ti = DateTime.Now;
string format = "MM-dd-yyyy";
List <string> temp = new List <string>();
cmd = "select email,name,bname,issuedate,duedate from book,student where book.stuid=student.enrollid AND book.duedate=('" + ti.AddDays(Convert.ToDouble(Days)).ToString(format) + "')";
dr = db.RetriveData(cmd);
while (dr.Read())
{
Count++;
senderAddress = email;
receiveraddress = dr[0].ToString();
emailSubject = " Book Duedate Reminder";
emailMessageText = "Dear, " + dr[1].ToString() + " as per the <b>rule</b> and regulation established by A.D.Patel Institute of Technology for library division, owing period for book <strong>" + dr[2].ToString() + "</strong> issued on " + dr[3].ToString() + " expires on " + dr[4].ToString() + ". We request you to submit the book at library. If however you need to continue the usage please extend the lease interval. If by any means or reasons you are not able to submit book on above mentioned date, you will be subjected to rules and regulation and a predefined amount will be charged per day.'<br />'Regards,'<br />'ADIT Library.";
mail = new MailMessage();
mail.From = new MailAddress(senderAddress, "LibraryAdmin", System.Text.Encoding.UTF8);
mail.To.Add(new MailAddress(receiveraddress));
mail.Subject = emailSubject;
mail.Body = emailMessageText;
client.UseDefaultCredentials = false;
client.Credentials = new NetworkCredential(email, pass);
client.EnableSsl = true;
client.Send(mail);
}
Label1.Visible = true;
Label1.Text = "\nMail Sent=" + Count;
}
catch (Exception err)
{
Label1.Visible = true;
Label1.Text = "Error ==" + err;
}
}
protected void Page_Load(object sender, EventArgs e)
{
//getting fine from db
string cmd = "select general_Loan_Fine from changeSetting";
dr = db.RetriveData(cmd);
if (dr.Read())
{
temp = dr[0].ToString();
LoanFine = temp.Split(':');
Get_Loan_Fine = Convert.ToInt32(LoanFine[1]);
}
// updating fine for student
cmd = "select bid, book.dept, bname, duedate,email,name from book,student where book.stuid=student.enrollid and book.ret='n' and book.stuid!='0' ";
dr = db.RetriveData(cmd);
string duedate = "";
while (dr.Read())
{
dt = ((DateTime)dr[3]);
duedate = dt.ToShortDateString();
if (DateTime.Now > dt && DateTime.Now.ToShortDateString() != dt.ToShortDateString())
{
t = DateTime.Now.Date - dt.Date;
fine = t.TotalDays * Get_Loan_Fine;
stuDetail.Add(dr[0].ToString());
stuDetail.Add(dr[4].ToString());
stuDetail.Add(dr[5].ToString());
stuDetail.Add(dr[2].ToString());
stuDetail.Add(fine.ToString());
}
}
for (int i = 0; i < stuDetail.Count; i += 5)
{
cmd = "update book set fine='" + stuDetail[i + 4] + "' where bid='" + stuDetail[i] + "'";
db.DbTrcn(cmd);
}
//updating fine for faculty
cmd = "select bid, book.dept, bname, duedate,email,name from book,faculty where book.facusername=faculty.username and book.ret='n' and book.facusername!='0' ";
dr = db.RetriveData(cmd);
while (dr.Read())
{
dt = ((DateTime)dr[3]);
duedate = dt.ToShortDateString();
if (DateTime.Now > dt && DateTime.Now.ToShortDateString() != dt.ToShortDateString())
{
t = DateTime.Now.Date - dt.Date;
fine = t.TotalDays * Get_Loan_Fine;
facDetail.Add(dr[0].ToString());
facDetail.Add(dr[4].ToString());
facDetail.Add(dr[5].ToString());
facDetail.Add(dr[2].ToString());
facDetail.Add(fine.ToString());
}
}
for (int i = 0; i < facDetail.Count; i += 5)
{
cmd = "update book set fine='" + facDetail[i + 4] + "' where bid='" + facDetail[i] + "'";
db.DbTrcn(cmd);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string cmd = "select bname,name from book,student";
dr = db.RetriveData(cmd);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["uname"] == null)
{
Response.Redirect("login.aspx?info=0");
}
try
{
string qury = " select enrollid,name from student where username='******'";
dr = db.RetriveData(qury);
if (dr.Read())
{
uid = dr[0].ToString();
name = dr[1].ToString();
((General)Page.Master).MyText = name;
}
else
{
Response.Redirect("login.aspx?info=0");
}
cmd = "select general_Loan_Fine from changeSetting";
dr = db.RetriveData(cmd);
if (dr.Read())
{
temp = dr[0].ToString();
LoanFine = temp.Split(':');
fine = Convert.ToInt32(LoanFine[1]);
}
cmd = "select bid, duedate from book where ret='n' and stuid='" + uid + "' ";
dr = db.RetriveData(cmd);
while (dr.Read())
{
dt = ((DateTime)dr[1]);
duedate = dt.ToShortDateString();
if (DateTime.Now > dt && DateTime.Now.ToShortDateString() != dt.ToShortDateString())
{
t = DateTime.Now.Date - dt.Date;
tfine = t.TotalDays * fine;
stuDetail.Add(dr[0].ToString());
stuDetail.Add(tfine.ToString());
}
}
for (int i = 0; i < stuDetail.Count; i += 2)
{
cmd = "update book set fine='" + stuDetail[i + 1] + "' where bid='" + stuDetail[i] + "'";
db.DbTrcn(cmd);
}
stu_Fine();
}
catch (Exception er)
{
Label1.Visible = true;
Label1.Text = "Error:" + er;
}
}