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")); } }