/// <summary>
/// Show pending request's to admin
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Index(string id)
{
try
{
Request obj = new Request();
int Id = Int32.Parse(id);
string userid = User.Identity.GetUserName();
var person = db.Employees.Where(y => y.Email == userid).First();
obj.EmployeeId = person.Id;
obj.LoanId = Id;
string cmd = "SELECT * FROM Lookup";
SqlDataReader reader = Database_Connection.get_instance().Getdata(cmd);
while (reader.Read())
{
if (reader.GetString(1) == "Pending")
{
obj.Status = reader.GetInt32(0);
}
}
db.Requests.Add(obj);
db.SaveChanges();
return(RedirectToAction("Index", "Account"));
}
catch (Exception ex)
{
throw (ex);
}
}
public ActionResult AddDocuments(int id, DocumentViewModel model, IEnumerable <HttpPostedFileBase> ImageFile)
{
model.temp = temp2.Count();
string userid = User.Identity.GetUserName();
var person = db.Employees.Where(y => y.Email == userid).First();
int i = 0;
foreach (var files in ImageFile)
{
Document obj = new Document();
obj.Title = temp2[i];
obj.EmployeeId = person.Id;
obj.LoanId = id;
string cmd = "SELECT * FROM Lookup";
SqlDataReader reader = Database_Connection.get_instance().Getdata(cmd);
while (reader.Read())
{
if (reader.GetString(1) == "NotVerified")
{
obj.Status = reader.GetInt32(0);
}
}
string fileName = Path.GetFileName(files.FileName);
string extension = Path.GetExtension(files.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
model.Document = "~/Image/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
model.ImageFile.SaveAs(fileName);
obj.RequiredDocuments = model.Document;
db.Documents.Add(obj);
db.SaveChanges();
i++;
}
//foreach (EmployeeLoan e in db.EmployeeLoans)
//{
// if (e.EmployeeId != person.Id && e.LoanId != id && e.InstallementId != tem)
// {
// }
// else {
DateTime date = DateTime.Now.Date;
string cmd2 = string.Format("INSERT INTO EmployeeLoan(EmployeeId,LoanId,InstallementId,Status,AssignDate) VALUES('{0}','{1}','{2}','{3}','{4}')", person.Id, id, tem, 2, date);
int rows = Database_Connection.get_instance().Executequery(cmd2);
temp2 = null;
return(RedirectToAction("Index", "Account"));
}
/// <summary>
/// Delete Loan
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult DeleteLoan(int id)
{
try
{
DB64Entities db = new DB64Entities();
var item = db.Loans.Where(x => x.Id == id).SingleOrDefault();
db.Loans.Remove(item);
db.SaveChanges();
return(RedirectToAction("Loanlist", "Admin"));
}
catch (Exception ex)
{
throw(ex);
}
}
/// <summary>
/// Delete installment from database
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult DeleteInstallment(int id)
{
try
{
DB64Entities db = new DB64Entities();
var item2 = db.Installements.Where(x => x.Id == id).SingleOrDefault();
int temp = item2.LoanId;
var item = db.Installements.Where(x => x.Id == id).SingleOrDefault();
db.Installements.Remove(item);
db.SaveChanges();
return(RedirectToAction("ViewInstallment", "Admin", new { id = temp }));
}
catch (Exception ex)
{
throw (ex);
}
}
