protected void GridViewLoans_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Extend")
{
if (dl.hasPenalty(user.UserName))
{
Response.Write("<script> alert('You have a penalty.You can not extend the book.') </script>");
}
else
{
int rowIndex = Convert.ToInt32(e.CommandArgument.ToString());
GridViewRow row = GridViewLoans.Rows[rowIndex];
if (!dl.increaseExtend(row.Cells[0].Text.ToString()))
{
Response.Write("<script> alert('You can not extend.Extend limit is done.') </script>");
}
else
{
Response.Redirect("~/pages/member/default.aspx");
}
}
}
else if (e.CommandName == "Return")
{
int rowIndex = Convert.ToInt32(e.CommandArgument.ToString());
GridViewRow row = GridViewLoans.Rows[rowIndex];
if (dl.hasPenalty(user.UserName))
{
Response.Write("<script> alert('You have a penalty.You can not return the book.') </script>");
}
else
{
String loanDB2ID = row.Cells[0].Text.ToString();
loan_DB2 loanDB2 = db.loan_DB2.SingleOrDefault(x => x.loanID == loanDB2ID);
int matIDD = (int)loanDB2.matID;
db.loan_DB2.Remove(loanDB2);
db.SaveChanges();
loanhistory2 loanH = new loanhistory2();
loanH.memberID = Convert.ToInt32(user.UserName);
loanH.matID = matIDD;
DateTime d = DateTime.Now;
string s = d.ToString("yyyyMMdd");
string loanIDS = string.Concat(s, user.UserName);
loanIDS = String.Concat(loanIDS, matIDD.ToString());
loanH.historyID = loanIDS;
db.loanhistory2.Add(loanH);
db.SaveChanges();
dl.setAvaibleOne(matIDD);
Response.Redirect("~/pages/member/default.aspx");
}
}
}
public Boolean increaseExtend(String loanID)
{
String[] role = Roles.GetRolesForUser(user.UserName);
loan_DB2 loanDB2 = db.loan_DB2.SingleOrDefault(x => x.loanID == loanID);
if (role.Contains("student"))
{
if (loanDB2.extends > 1)
{
return(false);
}
else
{
DateTime datetime = (DateTime)loanDB2.duedate;
loanDB2.extends = loanDB2.extends + 1;
loanDB2.duedate = datetime.AddMonths(1);
db.SaveChanges();
return(true);
}
}
else if (role.Contains("teacher"))
{
if (loanDB2.extends > 3)
{
return(false);
}
else
{
DateTime datetime = (DateTime)loanDB2.duedate;
loanDB2.extends = loanDB2.extends + 1;
loanDB2.duedate = datetime.AddMonths(1);
db.SaveChanges();
return(true);
}
}
else//undergrade
{
if (loanDB2.extends > 2)
{
return(false);
}
else
{
DateTime datetime = (DateTime)loanDB2.duedate;
loanDB2.extends = loanDB2.extends + 1;
loanDB2.duedate = datetime.AddMonths(1);
db.SaveChanges();
return(true);
}
}
//return false;
}
protected void LinkButtonTake_Click(object sender, EventArgs e)
{
String memID = Session["usN"].ToString();
int id = Convert.ToInt32(memID);
penaltyDB3 penalty = db.penaltyDB3.FirstOrDefault(x => x.memID == id);
db.penaltyDB3.Remove(penalty);
db.SaveChanges();
int matID = (int)penalty.matID;
loan_DB2 loanDB2 = db.loan_DB2.FirstOrDefault(x => x.matID == matID);
db.loan_DB2.Remove(loanDB2);
db.SaveChanges();
dl.setAvaibleZero(matID);
db.SaveChanges();
}