public async Task <IActionResult> Edit(Guid id, LoanData loanData)
{
if (id != loanData.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
CalculateLoanData(loanData);
await LoanDataRepo.Update(loanData).ConfigureAwait(false);
}
catch (DbUpdateConcurrencyException)
{
if (!LoanDataExists(loanData.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(loanData));
}
} // AddLoanData
public void AddRepayment(SafeReader sr, SortedSet <int> oLateLoans)
{
LoanData ld = sr.Fill <LoanData>();
ld.IsLate = oLateLoans.Contains(ld.ID);
if (m_oLoans.ContainsKey(ld.ID))
{
m_oLoans[ld.ID] += ld;
}
else
{
m_oLoans[ld.ID] = ld;
if (m_oCashRequests.ContainsKey(ld.CashRequestID))
{
m_oCashRequests[ld.CashRequestID].AmountTaken += ld.Amount;
}
else
{
m_oCashRequests[ld.CashRequestID] = new CashRequestData {
ApprovedAmount = sr["ManagerApprovedSum"],
AmountTaken = ld.Amount,
};
} // if
} // if
} // AddRepayment
public static HttpResponseMessage Run([HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)] HttpRequestMessage req, TraceWriter log)
{
log.Info("C# HTTP trigger function processed a request.");
// parse query parameter
int p = Convert.ToInt32(req.GetQueryNameValuePairs()
.FirstOrDefault(q => string.Compare(q.Key, "p", true) == 0)
.Value);
int t = Convert.ToInt32(req.GetQueryNameValuePairs()
.FirstOrDefault(q => string.Compare(q.Key, "t", true) == 0)
.Value);
decimal r = Convert.ToDecimal(req.GetQueryNameValuePairs()
.FirstOrDefault(q => string.Compare(q.Key, "r", true) == 0)
.Value);
CobList cList = new CobList();
LoanData PaymentInfo = cList.AmortInfo(p, t, r);
//if (name == null)
//{
// // Get request body
// dynamic data = await req.Content.ReadAsAsync<object>();
// name = data?.name;
//}
return(req.CreateResponse(HttpStatusCode.OK, PaymentInfo));
}
public List <LoanData> GetOutgoingGames(int userId, out string error)
{
var games = new List <LoanData>();
string sqlString = @"SELECT Us_Username, Bg_Name, Bgc_Id
FROM Tbl_BoardGameCopys, Tbl_Users, Tbl_BoardGames
WHERE Us_Id = Bgc_BorrowedToUserId AND Bgc_CopyOfBoardGameId = Bg_Id AND Bgc_OwnerUserId = @userid";
try
{
_sqlHandler.SetCommand(sqlString);
_sqlHandler.AddIntParamter("userid", userId);
using (SqlDataReader reader = _sqlHandler.ExecuteReader(out error))
{
while (reader.Read())
{
var game = new LoanData(reader["Bg_Name"].ToString(), reader["Us_Username"].ToString(), "You!", (int)reader["Bgc_Id"]);
games.Add(game);
}
}
}
catch (Exception e)
{
error = e.Message;
}
finally
{
_sqlHandler.EndReader();
}
return(games);
}
private void ApplyLoan_Load(object sender, EventArgs e)
{
ld = API.Controllers.LoansData.GetLoanData();
API.filter(txtPrincipal, txtRate);
txtRate.Text = Convert.ToString(ld.InterestRate);
lblStandingCharge.Text = "Standing Charge " + ld.StandingCharge + "%";
}
public ApplyLoan()
{
InitializeComponent();
si.DataChanged += Si_DataChanged;
ld = API.Controllers.LoansData.GetLoanData();
si.Rate = (decimal)ld.InterestRate;
numericUpDown1.Value = 1;
}
private void initComp()
{
datagridSupportDocs.Rows.Clear();
ld = Moshi_Bank.API.Controllers.LoansData.GetLoanData();
datagridSupportDocs.Rows.Add("Interest Rate", ld.InterestRate);
txtLIR.Text = ld.InterestRate.ToString();
txtLSC.Text = ld.StandingCharge.ToString();
datagridSupportDocs.Rows.Add("Standing Charge", ld.StandingCharge);
}
private LoanData ConvertDataReaderIntoModelForLoan(MySqlDataReader dr)
{
LoanData obj = new LoanData();
obj.loanId = Convert.ToInt32(dr["Id"]);
obj.loanName = Convert.ToString(dr["LoanName"]);
obj.loanDisplayName = Convert.ToString(dr["LoanDescription"]);
return(obj);
}
public ActionResult Edit(LoanData obj)
{
var list = new List <SelectListItem>
{
new SelectListItem {
Text = "--Select--", Value = "", Selected = true
},
new SelectListItem {
Text = "New", Value = "New"
},
new SelectListItem {
Text = "Resale", Value = "Resale"
},
new SelectListItem {
Text = "Take Over", Value = "Take Over"
},
};
var list1 = new List <SelectListItem>
{
new SelectListItem {
Text = "--Select--", Value = "", Selected = true
},
new SelectListItem {
Text = "Yes", Value = "Yes"
},
new SelectListItem {
Text = "No", Value = "No"
},
};
ViewData["LoanType"] = list;
ViewData["RinnRaksha"] = list1;
try
{
var data = _db.LoanDatas.Where(m => m.ID == obj.ID).FirstOrDefault();
data.Loan_Amount = obj.Loan_Amount;
data.Loan_No = obj.Loan_No;
data.Loan_Type = obj.Loan_Type;
data.Login_Date = obj.Login_Date;
data.Mobile_No = obj.Mobile_No;
data.Name = obj.Name;
data.Rinn_Raksha = obj.Rinn_Raksha;
data.Sourcing_Person = obj.Sourcing_Person;
data.Sourcing_Branch = obj.Sourcing_Branch;
_db.SaveChanges();
return(RedirectToAction("Listing"));
}
catch
{
return(RedirectToAction("Edit", obj.ID));
}
}
public ActionResult Create(LoanData obj)
{
var list = new List <SelectListItem>
{
new SelectListItem {
Text = "--Select--", Value = "", Selected = true
},
new SelectListItem {
Text = "New", Value = "New"
},
new SelectListItem {
Text = "Resale", Value = "Resale"
},
new SelectListItem {
Text = "Take Over", Value = "Take Over"
},
};
var list1 = new List <SelectListItem>
{
new SelectListItem {
Text = "--Select--", Value = "", Selected = true
},
new SelectListItem {
Text = "Yes", Value = "Yes"
},
new SelectListItem {
Text = "No", Value = "No"
},
};
ViewData["LoanType"] = list;
ViewData["RinnRaksha"] = list1;
try
{
if (ModelState.IsValid)
{
obj.createdby = Convert.ToString(Session["UserName"]);
_db.LoanDatas.Add(obj);
_db.SaveChanges();
return(RedirectToAction("Listing"));
}
else
{
return(RedirectToAction("Create"));
}
}
catch (Exception ex)
{
return(RedirectToAction("Create"));
}
}
public void OnLoanCommit()
{
LoanData data = MarketManager.GetLoanData(toloan);
GameManager.AdjustCash(data.amount);
loanButton.interactable = false;
MarketManager.TakeLoan(toloan);
//Add expense
AddExpense(ExpenseType.Loan, Departments.Start, data.amount * (1 + data.interest / 100) / data.term);
instance.moneyText.text = string.Format("${0:N0}", GameManager.Cash);
PopulateLoans();
}
public Loan(LoanData loanData, Customer customer = null) //When loading from database
{
data = loanData;
if (customer == null)
{
this.customer = new Customer(data.Customer);
}
else
{
this.customer = customer;
}
}
protected override void Seed(Bibliothek.DataAccess.LibraryDbContext context)
{
#region Instantiating
Book book = new BookData()
{
ID = 1,
Condition = "Mint", IsRented = true, Loans = new List <LoanData>()
};
Author author = new Author()
{
ID = 1,
BooksWritten = new List <BookInformationData>(), HasNobelPrize = true,
IsAlive = false, Name = "John Doe", Nation = "se"
};
BookInformationData bookInformation = new BookInformationData()
{
ID = 1,
Title = "Sample Title",
Description = "Sample Description", Category = Category.Horses, Position = "A1",
PublishingYear = 1111, ISBN = "123-456-789", Authors = new List <Author>(), Books = new List <Book>()
};
LoanData loan = new LoanData()
{
ID = 1,
Start = DateTime.Now, End = DateTime.Now.AddMonths(3), IsReturned = false, Books = new List <Book>()
};
CustomerData loanTaker = new CustomerData()
{
ID = 1,
Name = "Some Loner", MembershipNumber = "12", Contact = "*****@*****.**", Loans = new List <LoanData>()
};
#endregion
#region Mapping
book.BookInformation = bookInformation;
bookInformation.Books.Add(book);
bookInformation.Authors.Add(author);
author.BooksWritten.Add(bookInformation);
book.Loans.Add(loan);
loan.Books.Add(book);
loan.Customer = loanTaker;
loanTaker.Loans.Add(loan);
#endregion
#region Add to database
context.LoanTakers.AddOrUpdate(loanTaker);
/* context.Database.ExecuteSqlCommand("Book_Insert @condition, @isrented, @BookInformationId",
* new SqlParameter {ParameterName = "@condition", Value = book.Condition},
* new SqlParameter { ParameterName = "@isrented", Value = book.IsRented },
* new SqlParameter { ParameterName = "@BookInformationId", Value = book.BookInformation.ID });*/
#endregion
}
public async Task <IActionResult> Create(LoanData loanData)
{
if (ModelState.IsValid)
{
if (loanData.Id == null)
{
loanData.Id = Guid.NewGuid();
}
CalculateLoanData(loanData);
await LoanDataRepo.Add(loanData).ConfigureAwait(false);
return(RedirectToAction(nameof(Index)));
}
return(View(loanData));
}
public List <LoanData> getAllLoanData()
{
string response = JsonConvert.SerializeObject(null);
MySqlDataReader dr = CallLoanDetail_USP(response, OperationType.GET_All);
List <LoanData> LoanDataList = new List <LoanData>();
while (dr.Read())
{
LoanData LoanData = ConvertDataReaderIntoModelForLoan(dr);
LoanDataList.Add(LoanData);
}
dr.Close();
return(LoanDataList);
}
public void TestCalculateLoanData()
{
var testLoanData = new LoanData()
{
Id = Guid.NewGuid(),
LoanAmount = 100000.00,
InterestRates = 5.0,
LoanTerm = 12
};
testLoanData.SetTotalCost();
testLoanData.SetMonthlyBill();
double testDouble = 8333.75;
Assert.Equal(testDouble, testLoanData.MonthlyBill);
}
void PayExpenses()
{
for (int i = 0; i < expenses.Count; i++)
{
GameManager.AdjustCash(-(expenses[i].amount + expenses[i].amountMod));
}
LoanData data = MarketManager.GetLoanData(toloan);
if (data.taken)
{
MarketManager.PayLoanDaily();
data = MarketManager.GetLoanData(toloan);
AddExpense(ExpenseType.Loan, Departments.Start, data.amount / data.term);
}
PopulateExpense();
}
public CreateLoanResult CreateLoan(LoanData data)
{
Logger.LogLine($"Processing loan request for user {data.PhoneNumber}");
if (validatorManager.ValidateLoan(data.PhoneNumber, data.Amount, data.Days))
{
Logger.LogLine($"Cannot create loan, validation failed.");
return(CreateLoanResult.Failed());
}
saveUserManager.SaveUser(new User(data.PhoneNumber));
if (riskManager.CheckForBadPhones(data.PhoneNumber))
{
Logger.LogLine($"Cannot create loan, user phone is in BadPhone Collection");
return(CreateLoanResult.Failed());
}
return(CreateLoanResult.Success(calculatorManager.CalculateLoan(data.Amount, data.Days)));
}
} // AddSectionItem
private void SaveLoanServicingSection(ExcelPackage oReport)
{
ExcelWorksheet oSheet = oReport.FindOrCreateSheet(
"LoanServicing",
true,
"OrderNo",
"BuyerRepayDate",
"BuyerRepayAmount",
"TotalInterestAmount",
"Overdue",
"UnusedCreditAmount"
);
int nLoanRow = 2;
while (oSheet.Cells[nLoanRow, 1].Value != null)
{
nLoanRow++;
}
foreach (KeyValuePair <int, LoanData> pair in m_oLoans)
{
LoanData oLoan = pair.Value;
oSheet.SetRowValues(nLoanRow, true,
CustomerRefNum,
AlibabaID,
oLoan.RefNum,
oLoan.DateClosed,
oLoan.TotalRepaid,
oLoan.InterestRepaid,
oLoan.IsLate ? "yes" : "no",
m_oCashRequests[oLoan.CashRequestID].UnusedAmount
);
nLoanRow++;
} // for each loan
} // SaveLoanServicingSection
public Loan()
{
data = new LoanData();
customer = new Customer(data.Customer);
}
private static void CalculateLoanData(LoanData loanData)
{
loanData.SetTotalCost();
loanData.SetMonthlyBill();
}
