public ActionResult Return_DVD(int id)
{
string sql_member = @"select * from dbo.Loan where Loan_ID = " + id + ";";
string today = DateTime.Today.ToString("yyyy-MM-dd");
string issue_date = "";
LoanIssueModel lm = new LoanIssueModel();
List <LoanIssueModel> lst = SqlDataAccess.LoadData <LoanIssueModel>(sql_member);
foreach (LoanIssueModel row in lst)
{
lm = row;
break;
}
// updating the member database
int mem_id = lm.Member_ID;
string sql_member2 = @"select * from dbo.Member where Member_ID = " + mem_id + ";";
List <MemberModel> memlist = SqlDataAccess.LoadData <MemberModel>(sql_member2);
MemberModel mem = new MemberModel();
foreach (MemberModel row in memlist)
{
mem = row;
break;
}
mem.DVD_On_Loan = mem.DVD_On_Loan - 1;
string sql_mem_update = @"UPDATE dbo.Member SET DVD_On_Loan = @DVD_On_Loan WHERE Member_ID = @Member_ID;";
int result2 = SqlDataAccess.SaveData(sql_mem_update, mem);
/*
* if (lm.Date_returned != null)
* {
* today = lm.Date_returned;
* }
*/
issue_date = lm.Date_out;
int penalty = Convert.ToInt32((DateTime.Parse(today) - DateTime.Parse(issue_date)).TotalDays);
if (penalty > 30)
{
penalty = penalty - 30;
}
else
{
penalty = 0;
}
string sql_update = @"UPDATE dbo.Loan SET Date_returned = '" + today + "', Penalty_Charge = " + penalty + " WHERE Loan_ID = " + id + ";";
int result = SqlDataAccess.SaveData(sql_update, lm);
return(RedirectToAction("Loan", "Users"));
}
public ActionResult Issue_DVD(LoanViewModel ld, int id)
{
Console.WriteLine("Hello there!!");
int mem_id = 0;
string sql_member = @"select Member_ID from dbo.Member where FirstName = '" + ld.FirstName + "' AND LastName = '" + ld.LastName + "';";
List <int> lst = SqlDataAccess.LoadData <int>(sql_member);
foreach (int row in lst)
{
mem_id = row;
break;
}
string sql_check = @"select Loan_ID from dbo.Loan where Member_ID = " + mem_id + ";";
List <int> num = SqlDataAccess.LoadData <int>(sql_check);
if (num.Count > 5)
{
return(RedirectToAction("Limit_Exceeded", "Users"));
}
else
{
string today = DateTime.Today.ToString("yyyy-MM-dd");
LoanIssueModel iss = new LoanIssueModel();
iss.Date_out = today;
iss.Amount_paid = 100;
iss.Date_returned = null;
iss.Penalty_Charge = 0;
iss.Dvd_ID = id;
iss.Member_ID = mem_id;
string sql_member2 = @"select * from dbo.Member where Member_ID = " + mem_id + ";";
List <MemberModel> memlist = SqlDataAccess.LoadData <MemberModel>(sql_member2);
MemberModel mem = new MemberModel();
foreach (MemberModel row in memlist)
{
mem = row;
break;
}
mem.DVD_On_Loan = mem.DVD_On_Loan + 1;
string sql_member3 = @"UPDATE dbo.Member SET DVD_On_Loan = @DVD_On_Loan WHERE Member_ID = @Member_ID;";
int result1 = SqlDataAccess.SaveData(sql_member3, mem);
string sql_loan = @"insert into dbo.Loan(Date_out, Amount_paid, Date_returned, Penalty_Charge, Dvd_ID, Member_ID)
values (@Date_out, @Amount_paid, @Date_returned, @Penalty_Charge, @Dvd_ID, @Member_ID);";
int result = SqlDataAccess.SaveData(sql_loan, iss);
return(RedirectToAction("Main", "Users"));
}
}
