public List <KhoanChoVay> GetKhoanChoVay(string matv)
{
const string proc = "SP_XemKhoanChoVay";
List <SqlParameter> para = new List <SqlParameter>()
{
new SqlParameter("matv", matv)
};
IDataReader reader = DataProvider.ExecuteReader(proc, para);
List <KhoanChoVay> result = new List <KhoanChoVay>();
KhoanChoVay vt;
while (reader.Read())
{
vt = new KhoanChoVay();
vt.id = Convert.ToInt32(reader["id"]);
vt.ngayvay = Convert.ToDateTime(reader["NgayVay"]);
vt.nguoivay = Convert.ToString(reader["NguoiVay"]);
vt.sotien = Convert.ToInt32(reader["SoTien"]);
vt.sotiendatra = Convert.ToInt32(reader["SoTienDaTra"]);
vt.sotienchuatra = Convert.ToInt32(reader["SoTienChuaTra"]);
vt.trangthai = Convert.ToString(reader["TrangThai"]);
result.Add(vt);
}
return(result);
}
public KhoanChoVay XemKhoanChoVayTheoId(int id)
{
const string proc = "SP_XemKhoanVayTheoId";
List <SqlParameter> para = new List <SqlParameter>()
{
new SqlParameter("id", id)
};
IDataReader reader = DataProvider.ExecuteReader(proc, para);
KhoanChoVay kcv = new KhoanChoVay();
while (reader.Read())
{
kcv.id = Convert.ToInt32(reader["id"]);
kcv.ngayvay = Convert.ToDateTime(reader["NgayVay"]);
kcv.sotien = Convert.ToInt32(reader["SoTienVay"]);
kcv.sotiendatra = Convert.ToInt32(reader["SoTienDaTra"]);
kcv.sotienchuatra = Convert.ToInt32(reader["SoTienConNo"]);
kcv.nguoivay = Convert.ToString(reader["NguoiVay"]);
}
return(kcv);
}
public ActionResult ToiTraNo(int id)
{
Session["IdKhoanNo"] = id;
KhoanChoVay kt = new KhoanChoVay();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseAddress);
//HTTP GET
var responseTask = client.GetAsync($"TraNo/{id}");
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var readTask = result.Content.ReadAsAsync <KhoanChoVay>();
readTask.Wait();
kt = readTask.Result;
return(View(kt));
}
}
return(View());
}
public IHttpActionResult Get_KhoanChoVay(int id)
{
KhoanChoVay res = dao.XemKhoanChoVayTheoId(id);
return(Ok(res));
}
