/// <summary>
/// CreatedBy:kasun
/// CreatedDate:2016/4/22
///
/// Get all titles for a loan
/// </summary>
/// <param name="loanId"></param>
/// <returns></returns>
public List<TitleUpload> GetUploadTitlesByLoanId(string unitId)
{
DataHandler dataHandler = new DataHandler();
List<object[]> parameterList = new List<object[]>();
List<TitleUpload> titleList = new List<TitleUpload>();
parameterList.Add(new object[] { "@unit_id", unitId });
try
{
DataSet dataSet = dataHandler.GetDataSet("spGetUploadTitlesByUnitId", parameterList);
if (dataSet != null && dataSet.Tables.Count != 0 && dataSet.Tables[0].Rows.Count != 0)
{
foreach (DataRow reader in dataSet.Tables[0].Rows)
{
TitleUpload title = new TitleUpload();
title.FilePath = reader["file_path"].ToString();
title.UnitId = reader["unit_id"].ToString();
title.OriginalFileName = reader["original_file_name"].ToString();
titleList.Add(title);
}
return titleList;
}
else {
return null;
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult AddUnitPost(Models.Unit unit, List<HttpPostedFileBase> fileUpload)
{
int userId = userData.UserId;
// check this is an advance or add unit
switch (unit.AdvanceNow)
{
case "No":
unit.IsAdvanced = false;
unit.AddAndAdvance = false;
break;
case "Yes":
unit.IsAdvanced = true;
unit.AddAndAdvance = true;
break;
}
if (Session["loanCode"] == null) {
return RedirectToAction("UserLogin", "Login", null);
}
string loanCode = Session["loanCode"].ToString();
//check this posted vin unique in database
int num = 0;
// vehile ID number
if (unit.UnitTypeId == 1)
{
num = (new UnitAccess()).IsUniqueVinForaLoan(unit.vehicle.IdentificationNumber, unit.LoanId);
}
// rv ID number
else if (unit.UnitTypeId == 2)
{
num = (new UnitAccess()).IsUniqueVinForaLoan(unit.rv.IdentificationNumber , unit.LoanId);
}
// camper ID number
else if (unit.UnitTypeId == 3)
{
num = (new UnitAccess()).IsUniqueVinForaLoan(unit.camper.IdentificationNumber, unit.LoanId);
}
// atv ID number
else if (unit.UnitTypeId == 4)
{
num = (new UnitAccess()).IsUniqueVinForaLoan(unit.atv.IdentificationNumber, unit.LoanId);
}
// boat ID number
else if (unit.UnitTypeId == 5)
{
num = (new UnitAccess()).IsUniqueVinForaLoan(unit.boat.IdentificationNumber, unit.LoanId);
}
// motorcycle ID number
else if (unit.UnitTypeId == 6)
{
num = (new UnitAccess()).IsUniqueVinForaLoan(unit.motorcycle.IdentificationNumber, unit.LoanId);
}
// snowmobile ID number
else if (unit.UnitTypeId == 7)
{
num = (new UnitAccess()).IsUniqueVinForaLoan(unit.snowmobile.IdentificationNumber, unit.LoanId);
}
// heavyequipment ID number
else if (unit.UnitTypeId == 8)
{
num = (new UnitAccess()).IsUniqueVinForaLoan(unit.heavyequipment.SerialNumber, unit.LoanId);
}
//only allow to add if and only if vin already not existing in this loan
if (num != 0 && num != 1)
{
string IDNumber;
UnitAccess ua = new UnitAccess();
//inserting the unit to the database
string res = ua.InsertUnit(unit, userId, loanCode, out IDNumber);
//if mention advance fee, then insert in to fee table
if (!string.IsNullOrEmpty(res) && unit.AddAndAdvance)
{
if ((Session["loanDashboard"] != null) || (Session["oneLoanDashboard"] != null))
{
Loan loanObj = new Loan();
if (Session["loanDashboard"] != null)
{
loanObj = (Loan)Session["loanDashboard"];
}
else
{
loanObj = (Loan)Session["oneLoanDashboard"];
}
if (loanObj.AdvanceFee == 1)
{
//check advance amount and other details
ua.insertFreeDetails(unit);
}
}
}
if (!string.IsNullOrEmpty(res))
{
if (Session["addUnitloan"] == null)
{
return RedirectToAction("UserLogin", "Login", new { lbl = "Failed find loan" });
}
LoanSetupStep1 loan = (LoanSetupStep1)Session["addUnitloan"];
//insert to log
Log log = new Log(userData.UserId, userData.Company_Id, userData.BranchId, unit.LoanId, "Add Unit", (unit.AddAndAdvance ? "Added and advanced" : "Added") + " unit : " + IDNumber + ", Cost Amount : " + unit.Cost + (unit.Cost * loan.advancePercentage / 100 != unit.AdvanceAmount ? ", Edited Advance amount " + unit.AdvanceAmount : ", Advance amount : " + unit.AdvanceAmount), DateTime.Now);
int islog = (new LogAccess()).InsertLog(log);
//Handling file attachments
//Check directory is already exists, if not create new
string mapPath = "~/Uploads/" + loan.RegisteredCompanyCode + "/" + loan.RegisteredBranchCode + "/";
if (!Directory.Exists(Server.MapPath(mapPath)))
{
Directory.CreateDirectory(Server.MapPath(mapPath));
}
List<TitleUpload> titleList = new List<TitleUpload>();
int imageNo = 1;
// if unit successfully updated then upload files
if (unit.FileName != null && fileUpload != null)
{
foreach (var file in fileUpload)
{
if (file != null && Array.Exists(unit.FileName.Split(','), s => s.Equals(file.FileName)))
{
if (file.ContentLength > 3 * 1024 * 1024)
{
break;
}
unit.UnitId = res;
string extension = Path.GetExtension(file.FileName);
string filename = unit.UnitId + "_" + imageNo.ToString("00") + extension;
file.SaveAs(Server.MapPath(mapPath + filename));
string filepathtosave = mapPath + filename;
//add file information to list
TitleUpload title = new TitleUpload();
title.UploadId = imageNo;
title.FilePath = filepathtosave;
title.UnitId = unit.UnitId;
title.OriginalFileName = file.FileName;
titleList.Add(title);
imageNo++;
}
}
try
{
XElement xEle = new XElement("Titles",
from title in titleList
select new XElement("Title",
new XElement("FilePath", title.FilePath),
new XElement("UnitId", title.UnitId),
new XElement("OriginalFileName", title.OriginalFileName)
));
string xmlDoc = xEle.ToString();
bool res1 = ua.InsertTitleDocumentUploadInfo(xmlDoc, unit.UnitId);
}
catch (Exception ex)
{
throw ex;
}
}
TempData["Msg"] = 1;
return RedirectToAction("AddUnit");
}
}
TempData["Msg"] = 2;
return RedirectToAction("AddUnit", unit);
}