internal string updateCurtailmets(SelectedCurtailmentList curtailmentScheduleModel, int loanId, string dealerEmail)
{
try
{
int i = 1;
XElement xEle = new XElement("Curtailments",
from curtailmentShedule in curtailmentScheduleModel.SelectedCurtailmentSchedules
select new XElement("CurtailmentShedule",
new XElement("CurtNo", curtailmentShedule.CurtNumber),
new XElement("UnitId", curtailmentShedule.UnitId),
new XElement("CurtAmount", curtailmentShedule.CurtAmount),
new XElement("PayDate", curtailmentShedule.PayDate),
new XElement("id", i++)
));
string xmlDoc = xEle.ToString();
DataHandler dataHandler = new DataHandler();
List <object[]> paramertList2 = new List <object[]>();
paramertList2.Add(new object[] { "@loan_id", loanId });
paramertList2.Add(new object[] { "@dealer_email", dealerEmail ?? "" });
paramertList2.Add(new object[] { "@Input", xmlDoc });
return(dataHandler.ExecuteSQLWithStringReturnVal("spUpdateCurtailmentSchedule", paramertList2));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Insert unit to database
///
/// CreatedBy: Kanishka
/// CreatedDate:02/24/2016
///
/// EditedBy: Kasun
/// EditedDate: 03/09/2016
/// Add seperate code for units for passing as object list
///
/// EditedBy: Piyumi
/// EditedDate: 03/16/2016
/// add isActive field to parameter list
///
/// EditedBy: Irfan
/// EditedDate: 4/25/2016
/// adding output value IDNumber for logging purpose
///
/// EditedBy: Kasun
/// EditedDate: 6/15/2016
/// Roleback SP for add unit
/// </summary>
/// <param name="unit"></param>
/// <param name="userId"></param>
/// <returns></returns>
public string InsertUnit(Unit unit, int userId ,string loanCode,out string IDNumber)
{
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
paramertList.Add(new object[] { "@loan_id", unit.LoanId });
paramertList.Add(new object[] { "@user_id", userId });
paramertList.Add(new object[] { "@loan_code", loanCode });
paramertList.Add(new object[] { "@created_date", DateTime.Now });
paramertList.Add(new object[] { "@unit_type_id", unit.UnitTypeId });
if (unit.UnitTypeId == 1)
{
paramertList.Add(new object[] { "@identification_number", unit.vehicle.IdentificationNumber });
paramertList.Add(new object[] { "@year", unit.vehicle.Year });
paramertList.Add(new object[] { "@make", unit.vehicle.Make });
paramertList.Add(new object[] { "@model", unit.vehicle.Model });
paramertList.Add(new object[] { "@color", unit.vehicle.Color });
paramertList.Add(new object[] { "@trim", unit.vehicle.Trim });
paramertList.Add(new object[] { "@miles", unit.vehicle.Miles });
paramertList.Add(new object[] { "@new_or_used", unit.vehicle.NewOrUsed });
paramertList.Add(new object[] { "@length", unit.Length });
paramertList.Add(new object[] { "@hitch_style", unit.HitchStyle });
paramertList.Add(new object[] { "@speed", unit.Speed });
paramertList.Add(new object[] { "@trailer_id", unit.TrailerId });
paramertList.Add(new object[] { "@engine_serial", unit.EngineSerial });
IDNumber = unit.vehicle.IdentificationNumber;
}
else if (unit.UnitTypeId == 2)
{
paramertList.Add(new object[] { "@identification_number", unit.rv.IdentificationNumber });
paramertList.Add(new object[] { "@year", unit.rv.Year });
paramertList.Add(new object[] { "@make", unit.rv.Make });
paramertList.Add(new object[] { "@model", unit.rv.Model });
paramertList.Add(new object[] { "@color", unit.Color });
paramertList.Add(new object[] { "@trim", unit.Trim });
paramertList.Add(new object[] { "@miles", unit.rv.Miles });
paramertList.Add(new object[] { "@new_or_used", unit.rv.NewOrUsed });
paramertList.Add(new object[] { "@length", unit.rv.Length });
paramertList.Add(new object[] { "@hitch_style", unit.HitchStyle });
paramertList.Add(new object[] { "@speed", unit.Speed });
paramertList.Add(new object[] { "@trailer_id", unit.TrailerId });
paramertList.Add(new object[] { "@engine_serial", unit.EngineSerial });
IDNumber = unit.rv.IdentificationNumber;
}
else if (unit.UnitTypeId == 3)
{
paramertList.Add(new object[] { "@identification_number", unit.camper.IdentificationNumber });
paramertList.Add(new object[] { "@year", unit.camper.Year });
paramertList.Add(new object[] { "@make", unit.camper.Make });
paramertList.Add(new object[] { "@model", unit.camper.Model });
paramertList.Add(new object[] { "@color", unit.Color });
paramertList.Add(new object[] { "@trim", unit.Trim });
paramertList.Add(new object[] { "@miles", unit.Miles });
paramertList.Add(new object[] { "@new_or_used", unit.camper.NewOrUsed });
paramertList.Add(new object[] { "@length", unit.camper.Length });
paramertList.Add(new object[] { "@hitch_style", unit.camper.HitchStyle });
paramertList.Add(new object[] { "@speed", unit.Speed });
paramertList.Add(new object[] { "@trailer_id", unit.TrailerId });
paramertList.Add(new object[] { "@engine_serial", unit.EngineSerial });
IDNumber = unit.camper.IdentificationNumber;
}
else if (unit.UnitTypeId == 4)
{
paramertList.Add(new object[] { "@identification_number", unit.atv.IdentificationNumber });
paramertList.Add(new object[] { "@year", unit.atv.Year });
paramertList.Add(new object[] { "@make", unit.atv.Make });
paramertList.Add(new object[] { "@model", unit.atv.Model });
paramertList.Add(new object[] { "@color", unit.Color });
paramertList.Add(new object[] { "@trim", unit.Trim });
paramertList.Add(new object[] { "@miles", unit.atv.Miles });
paramertList.Add(new object[] { "@new_or_used", unit.atv.NewOrUsed });
paramertList.Add(new object[] { "@length", unit.Length });
paramertList.Add(new object[] { "@hitch_style", unit.HitchStyle });
paramertList.Add(new object[] { "@speed", unit.Speed });
paramertList.Add(new object[] { "@trailer_id", unit.TrailerId });
paramertList.Add(new object[] { "@engine_serial", unit.EngineSerial });
IDNumber = unit.atv.IdentificationNumber;
}
else if (unit.UnitTypeId == 5)
{
paramertList.Add(new object[] { "@identification_number", unit.boat.IdentificationNumber });
paramertList.Add(new object[] { "@year", unit.boat.Year });
paramertList.Add(new object[] { "@make", unit.boat.Make });
paramertList.Add(new object[] { "@model", "" });
paramertList.Add(new object[] { "@color", unit.Color });
paramertList.Add(new object[] { "@trim", unit.Trim });
paramertList.Add(new object[] { "@miles", unit.Miles });
paramertList.Add(new object[] { "@new_or_used", unit.boat.NewOrUsed });
paramertList.Add(new object[] { "@length", unit.Length });
paramertList.Add(new object[] { "@hitch_style", unit.HitchStyle });
paramertList.Add(new object[] { "@speed", unit.Speed });
paramertList.Add(new object[] { "@trailer_id", unit.boat.TrailerId });
paramertList.Add(new object[] { "@engine_serial", unit.boat.EngineSerial });
IDNumber = unit.boat.IdentificationNumber;
}
else if (unit.UnitTypeId == 6)
{
paramertList.Add(new object[] { "@identification_number", unit.motorcycle.IdentificationNumber });
paramertList.Add(new object[] { "@year", unit.motorcycle.Year });
paramertList.Add(new object[] { "@make", unit.motorcycle.Make });
paramertList.Add(new object[] { "@model", unit.motorcycle.Model });
paramertList.Add(new object[] { "@color", unit.motorcycle.Color });
paramertList.Add(new object[] { "@trim", unit.Trim });
paramertList.Add(new object[] { "@miles", unit.motorcycle.Miles });
paramertList.Add(new object[] { "@new_or_used", unit.motorcycle.NewOrUsed });
paramertList.Add(new object[] { "@length", unit.Length });
paramertList.Add(new object[] { "@hitch_style", unit.HitchStyle });
paramertList.Add(new object[] { "@speed", unit.Speed });
paramertList.Add(new object[] { "@trailer_id", unit.TrailerId });
paramertList.Add(new object[] { "@engine_serial", unit.EngineSerial });
IDNumber = unit.motorcycle.IdentificationNumber;
}
else if (unit.UnitTypeId == 7)
{
paramertList.Add(new object[] { "@identification_number", unit.snowmobile.IdentificationNumber });
paramertList.Add(new object[] { "@year", unit.snowmobile.Year });
paramertList.Add(new object[] { "@make", unit.snowmobile.Make });
paramertList.Add(new object[] { "@model", unit.snowmobile.Model });
paramertList.Add(new object[] { "@color", unit.Color });
paramertList.Add(new object[] { "@trim", unit.Trim });
paramertList.Add(new object[] { "@miles", unit.Miles });
paramertList.Add(new object[] { "@new_or_used", unit.snowmobile.NewOrUsed });
paramertList.Add(new object[] { "@length", unit.Length });
paramertList.Add(new object[] { "@hitch_style", unit.HitchStyle });
paramertList.Add(new object[] { "@speed", unit.Speed });
paramertList.Add(new object[] { "@trailer_id", unit.TrailerId });
paramertList.Add(new object[] { "@engine_serial", unit.EngineSerial });
IDNumber = unit.snowmobile.IdentificationNumber;
}
else if (unit.UnitTypeId == 8)
{
paramertList.Add(new object[] { "@identification_number", unit.heavyequipment.SerialNumber });
paramertList.Add(new object[] { "@year", unit.heavyequipment.Year });
paramertList.Add(new object[] { "@make", unit.heavyequipment.Make });
paramertList.Add(new object[] { "@model", "" });
paramertList.Add(new object[] { "@color", unit.Color });
paramertList.Add(new object[] { "@trim", unit.Trim });
paramertList.Add(new object[] { "@miles", unit.Miles });
paramertList.Add(new object[] { "@new_or_used", unit.NewOrUsed });
paramertList.Add(new object[] { "@length", unit.Length });
paramertList.Add(new object[] { "@hitch_style", unit.HitchStyle });
paramertList.Add(new object[] { "@speed", unit.Speed });
paramertList.Add(new object[] { "@trailer_id", unit.TrailerId });
paramertList.Add(new object[] { "@engine_serial", unit.EngineSerial });
IDNumber = unit.heavyequipment.SerialNumber;
}
else
{
paramertList.Add(new object[] { "@identification_number", unit.IdentificationNumber });
paramertList.Add(new object[] { "@year", unit.Year });
paramertList.Add(new object[] { "@make", unit.Make });
paramertList.Add(new object[] { "@model", unit.Model });
paramertList.Add(new object[] { "@color", unit.Color });
paramertList.Add(new object[] { "@trim", unit.Trim });
paramertList.Add(new object[] { "@miles", unit.Miles });
paramertList.Add(new object[] { "@new_or_used", unit.NewOrUsed });
paramertList.Add(new object[] { "@length", unit.Length });
paramertList.Add(new object[] { "@hitch_style", unit.HitchStyle });
paramertList.Add(new object[] { "@speed", unit.Speed });
paramertList.Add(new object[] { "@trailer_id", unit.TrailerId });
paramertList.Add(new object[] { "@engine_serial", unit.EngineSerial });
IDNumber = unit.IdentificationNumber;
}
paramertList.Add(new object[] { "@cost", unit.Cost });
paramertList.Add(new object[] { "@advance_amount", unit.AdvanceAmount });
if (unit.TitleReceived == "Yes")
{
unit.TitleStatus = 1;
}
else
{
unit.TitleStatus = 0;
}
paramertList.Add(new object[] { "@title_status", unit.TitleStatus });
paramertList.Add(new object[] { "@note", unit.Note });
paramertList.Add(new object[] { "@add_or_advance", unit.AddAndAdvance });
paramertList.Add(new object[] { "@is_advanced", unit.IsAdvanced });
if (unit.IsAdvanced == true)
{
unit.UnitStatus = 1;
paramertList.Add(new object[] { "@advance_date", unit.AdvanceDate });
}
else {
unit.UnitStatus = 0;
paramertList.Add(new object[] { "@advance_date", null });
}
paramertList.Add(new object[] { "@unit_status", unit.UnitStatus });
paramertList.Add(new object[] { "@is_approved", unit.IsApproved });
paramertList.Add(new object[] { "@status", unit.Status });
try
{
string val = dataHandler.ExecuteSQLWithStringReturnVal("spInsertUnitDetailsRoleBack", paramertList);
if (!string.IsNullOrEmpty(val) && unit.AddAndAdvance)
{
unit.UnitId = val;
if (this.GetLoanCurtailmentDetails(unit.LoanId, unit.UnitId, unit.AdvanceDate, unit.AdvanceAmount, unit.Cost))
{
return val;
}
else
{
return "";
}
}
else if (!string.IsNullOrEmpty(val)) {
return val;
}
else {
return "";
}
}
catch (Exception ex)
{
throw ex;
}
}
internal string updateCurtailmets(SelectedCurtailmentList curtailmentScheduleModel, int loanId, string dealerEmail)
{
try
{
int i = 1;
XElement xEle = new XElement("Curtailments",
from curtailmentShedule in curtailmentScheduleModel.SelectedCurtailmentSchedules
select new XElement("CurtailmentShedule",
new XElement("CurtNo", curtailmentShedule.CurtNumber),
new XElement("UnitId", curtailmentShedule.UnitId),
new XElement("CurtAmount", curtailmentShedule.CurtAmount),
new XElement("PayDate", curtailmentShedule.PayDate),
new XElement("id", i++)
));
string xmlDoc = xEle.ToString();
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList2 = new List<object[]>();
paramertList2.Add(new object[] { "@loan_id", loanId });
paramertList2.Add(new object[] { "@dealer_email", dealerEmail ?? ""});
paramertList2.Add(new object[] { "@Input", xmlDoc });
return dataHandler.ExecuteSQLWithStringReturnVal("spUpdateCurtailmentSchedule", paramertList2);
}
catch (Exception ex)
{
throw ex;
}
}
