/// <summary>
/// CreatedBy : Nadeeka
/// CreatedDate: 2016/03/30
///
/// Insert Dealser User details
///
/// argument : dealer user (DealerUserModel)
///
///
/// </summary>
/// <returns>1</returns>
public int InsertDealerUser(DealerUserModel dealerUser)
{
// if (this.InsertUser(dealerUser) == 1)
//{
DataHandler dataHandler = new DataHandler();
List <object[]> paramertList = new List <object[]>();
paramertList.Add(new object[] { "@user_Id", dealerUser.UserId });
paramertList.Add(new object[] { "@user_name", dealerUser.UserName });
paramertList.Add(new object[] { "@password", dealerUser.Password });
paramertList.Add(new object[] { "@first_name", dealerUser.FirstName });
paramertList.Add(new object[] { "@last_name", dealerUser.LastName });
paramertList.Add(new object[] { "@email", dealerUser.Email });
paramertList.Add(new object[] { "@phone_no", dealerUser.PhoneNumber });
paramertList.Add(new object[] { "@status", dealerUser.Status });
paramertList.Add(new object[] { "@is_delete", dealerUser.IsDelete });
paramertList.Add(new object[] { "@created_by", dealerUser.CreatedBy });
paramertList.Add(new object[] { "@create_Date", DateTime.Now });
//paramertList.Add(new object[] { "@branch_id", dealerUser.BranchId });
paramertList.Add(new object[] { "@role_id", dealerUser.RoleId });
paramertList.Add(new object[] { "@Company_id", dealerUser.Company_Id });
paramertList.Add(new object[] { "@request_user_id", dealerUser.UserIdForSendReq });
paramertList.Add(new object[] { "@request_email", dealerUser.UserEmailForSendReq });
//paramertList.Add(new object[] { "@dealer_company_id ", dealerUser.NonRegCompanyId });
paramertList.Add(new object[] { "@dealer_branch_id", dealerUser.NonRegBranchId });
paramertList.Add(new object[] { "@loan_id", dealerUser.LoanId });
paramertList.Add(new object[] { "@activation_code", dealerUser.ActivationCode });
paramertList.Add(new object[] { "@report_rights", dealerUser.ReportRights });
try
{
return(dataHandler.ExecuteSQLWithIntOutPutParam("spInsertDealerUser", paramertList));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// CreatedBy : Nadeeka
/// CreatedDate: 2016/03/30
///
/// Insert Dealser User details
///
/// argument : dealer user (DealerUserModel)
///
///
/// </summary>
/// <returns>1</returns>
public int InsertDealerUser(DealerUserModel dealerUser)
{
// if (this.InsertUser(dealerUser) == 1)
//{
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
paramertList.Add(new object[] { "@user_Id", dealerUser.UserId });
paramertList.Add(new object[] { "@user_name", dealerUser.UserName });
paramertList.Add(new object[] { "@password", dealerUser.Password });
paramertList.Add(new object[] { "@first_name", dealerUser.FirstName });
paramertList.Add(new object[] { "@last_name", dealerUser.LastName });
paramertList.Add(new object[] { "@email", dealerUser.Email });
paramertList.Add(new object[] { "@phone_no", dealerUser.PhoneNumber });
paramertList.Add(new object[] { "@status", dealerUser.Status });
paramertList.Add(new object[] { "@is_delete", dealerUser.IsDelete });
paramertList.Add(new object[] { "@created_by", dealerUser.CreatedBy });
paramertList.Add(new object[] { "@create_Date", DateTime.Now });
//paramertList.Add(new object[] { "@branch_id", dealerUser.BranchId });
paramertList.Add(new object[] { "@role_id", dealerUser.RoleId });
paramertList.Add(new object[] { "@Company_id", dealerUser.Company_Id });
paramertList.Add(new object[] { "@request_user_id", dealerUser.UserIdForSendReq });
paramertList.Add(new object[] { "@request_email", dealerUser.UserEmailForSendReq });
//paramertList.Add(new object[] { "@dealer_company_id ", dealerUser.NonRegCompanyId });
paramertList.Add(new object[] { "@dealer_branch_id", dealerUser.NonRegBranchId });
paramertList.Add(new object[] { "@loan_id", dealerUser.LoanId });
paramertList.Add(new object[] { "@activation_code", dealerUser.ActivationCode });
paramertList.Add(new object[] { "@report_rights", dealerUser.ReportRights });
try
{
return dataHandler.ExecuteSQLWithIntOutPutParam("spInsertDealerUser", paramertList);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// CreatedBy:Piyumi
/// CreatedDate:2016/2/24
///
/// Advance a selected item
///
///
/// </summary>
/// <param name="advanceDate"></param>
/// <param name="loanId"></param>
/// <param name="unitObj"></param>
/// <param name="userId"></param>
/// <returns>countVal</returns>
public int AdvanceItem(Unit unitObj, int loanId, int userId, DateTime advanceDate)
{
int countVal = 0;
DataHandler dataHandler = new DataHandler();
List<object[]> parameterList = new List<object[]>();
try
{
parameterList.Add(new object[] { "@loan_id", loanId });
parameterList.Add(new object[] { "@user_id", userId });
parameterList.Add(new object[] { "@advance_date", advanceDate });
parameterList.Add(new object[] { "@unit_id", unitObj.UnitId });
parameterList.Add(new object[] { "@advance_amount", unitObj.AdvanceAmount });
this.GetLoanCurtailmentDetails(loanId, unitObj.UnitId, advanceDate, unitObj.AdvanceAmount, unitObj.Cost);
countVal = dataHandler.ExecuteSQLWithIntOutPutParam("spAdvanceAllSelectedItems", parameterList);
parameterList.Clear();
return countVal;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// CreatedBy : Kasun
/// CreatedDate: 2016/04/20
///
/// vin existing check
/// <param name="vin"></param>
/// <param name="loanId"></param>
/// <returns>
/// 0 - exist in loan advanced
/// 1 - exist in loan pending
/// 2 - exist in loan but another loan
/// 3 - not exist or payoff
/// </returns>
public int IsUniqueVinForaLoan(string vin, int loanId)
{
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
paramertList.Add(new object[] { "@vin", vin });
paramertList.Add(new object[] { "@loan_id", loanId });
return dataHandler.ExecuteSQLWithIntOutPutParam("spIsUniqueVinForaLoan", paramertList);
}
