public string Post([FromBody] LoanApprover loanApprover)
{
loanApprover.newApplication.status = "success";
hle.Entry(loanApprover.newApplication).State = System.Data.Entity.EntityState.Modified;
hle.SaveChanges();
loan newLoan = new loan();
loanDetail newloandet = new loanDetail();
newloandet = hle.loanDetails.ToList().Find(item => item.appId == loanApprover.newApplication.appId);
newLoan.adminId = loanApprover.adminId;
newLoan.remarks = loanApprover.remarks;
newLoan.loanId = loanApprover.newApplication.appId;
newLoan.status = "current";
newLoan.loanDateStart = System.DateTime.Now;
newLoan.amountApproved = newloandet.loanAsked;
newLoan.noOfEmiTotal = hle.loanDetails.ToList().Find(item => item.appId == newLoan.loanId).tenure * 12;
newLoan.noOfEmiLeft = newLoan.noOfEmiTotal;
hle.loans.Add(newLoan);
hle.SaveChanges();
return("loan has been approved");
}
public static void loanToUser(loanDetail l)
{
using (var context = new STOK_TAKIPEntities())
{
//get sql parameters for addLoan procedure
var userID = new SqlParameter("@userID", l.userID);
var loanByID = new SqlParameter("@loanByID", l.loanByID);
var productID = new SqlParameter("@productID", l.productID);
var loanDate = new SqlParameter("@loanDate", l.loanDate);
var pieces = new SqlParameter("@loanPieces", l.loanPieces);
try
{
//execute addLoan stored procedure
context.Database.ExecuteSqlCommand("exec addLoan @userID , @loanByID , @productID , @loanDate, @loanPieces",
userID, loanByID, productID, loanDate, pieces);
MessageBox.Show("The transaction (Loan) was successful!");
ucLoans.Instance = null;
ucProduct.Instance = null;
ucRemoveProduct.Instance = null;
ucUndoProduct.Instance = null;
ucDepartmentChief.Instance = null;
}
catch
{
MessageBox.Show("The transaction (Loan) was failed!");
}
}
}
private void btnAddLoan_Click(object sender, EventArgs e)
{
if (txtPiece.Text == "" || cbUser.SelectedIndex == -1 || string.IsNullOrWhiteSpace(cbProducts.Text.ToString()))
{
MessageBox.Show("You must fill in the required fields");
}
else
{
if (int.Parse(lblAvailable.Text) >= int.Parse(txtPiece.Text))
{
// Zimmetleme işlemleri burada gerçekleştiriliyor
string[] user = cbUser.SelectedItem.ToString().Split('-');
string[] product = cbProducts.SelectedItem.ToString().Split('-');
var result = productList.Find(x => x.productName == cbProducts.SelectedItem.ToString());
loanDetail l = new loanDetail();
product p = new product();
l.productID = result.productID;
l.loanDate = DateTime.Now.ToString();
l.userID = int.Parse(user[0]);
l.loanPieces = int.Parse(txtPiece.Text);
l.loanByID = 1;
//Send Loan Controller
Controller.LoanController.loanToUser(l);
txtPiece.Text = "";
cbUser.SelectedIndex = -1;
}
else
{
MessageBox.Show("You can't write more than the maximum number of products!");
}
}
}
public void loanToUser()
{
loanDetail loanDetail = new loanDetail
{
loanByID = 1,
loanDate = DateTime.Now.ToString(),
loanPieces = 5,
productID = 2,
userID = 44,
};
LoanController.loanToUser(loanDetail);
}
