public ActionResult SuaKhoanVay(int id, DateTime ngayvay, int sotien, string nguoivay, string taikhoanchitieu)
{
KhoanVay_ChoVay kt = new KhoanVay_ChoVay();
kt.id = id;
kt.ngayvay = ngayvay;
kt.sotien = sotien;
kt.thanhvien = (string)Session[Ses_Admin.Admin];
kt.loai = "1";
kt.nguoivay = nguoivay;
kt.taikhoanchitieu = taikhoanchitieu;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseAddress);
//HTTP POST
var postTask = client.PutAsJsonAsync <KhoanVay_ChoVay>("KhoanVay", kt);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
return(RedirectToAction("Index"));
}
else
{
return(View(kt));
}
}
}
private KhoanVay_ChoVay LaykhoanVayTheoMa()
{
int manv = KhoanVay_Session.ma;
KhoanVay_ChoVay kt = new KhoanVay_ChoVay();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseAddress);
//HTTP GET
var responseTask = client.GetAsync($"KhoanVay/{manv}");
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var readTask = result.Content.ReadAsAsync <KhoanVay_ChoVay>();
readTask.Wait();
kt = readTask.Result;
return(kt);
}
else
{
return(null);
}
}
}
public ActionResult ThemKhoanChoVay(DateTime ngayvay, int sotien, string nguoivay, string taikhoanchitieu)
{
KhoanVay_ChoVay kt = new KhoanVay_ChoVay();
kt.ngayvay = ngayvay;
kt.sotien = sotien;
kt.thanhvien = (string)Session[Ses_Admin.Admin];
kt.loai = "2";
kt.nguoivay = nguoivay;
kt.taikhoanchitieu = taikhoanchitieu;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseAddress);
//HTTP POST
var postTask = client.PostAsJsonAsync <KhoanVay_ChoVay>("KhoanChoVay", kt);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Không thêm được!");
}
}
return(RedirectToAction("ThemKhoanChoVay"));
}
public KhoanVay_ChoVay SearchKhoanChoVay(int id)
{
const string proc = "SP_TimKiemKhoanChoVay";
List <SqlParameter> para = new List <SqlParameter>()
{
new SqlParameter("id", id)
};
IDataReader reader = DataProvider.ExecuteReader(proc, para);
KhoanVay_ChoVay res = new KhoanVay_ChoVay();
KhoanVay_ChoVay kthu;
while (reader.Read())
{
kthu = new KhoanVay_ChoVay();
kthu.id = Convert.ToInt32(reader["id"]);
kthu.ngayvay = Convert.ToDateTime(reader["NgayVay"]);
kthu.sotien = Convert.ToInt32(reader["SoTien"]);
kthu.thanhvien = Convert.ToString(reader["ThanhVien"]);
kthu.loai = Convert.ToString(reader["Loai"]);
kthu.nguoivay = Convert.ToString(reader["NguoiVay"]);
kthu.taikhoanchitieu = Convert.ToString(reader["TaiKhoanChiTieu"]);
res = kthu;
}
return(res);
}
public IHttpActionResult Get_TimKiem(int id)
{
KhoanVay_ChoVay res = dao.SearchKhoanChoVay(id);
if (res == null)
{
return(NotFound());
}
return(Ok(res));
}
public ActionResult SuaKhoanVay(int id)
{
LoadDataForComboLoaiTaiKhoan();
LoadDataForComboNguoiVay();
KhoanVay_ChoVay res = new KhoanVay_ChoVay();
res = LayKhoanVayTheoMa(id);
return(View(res));
}
public IHttpActionResult PutKCV([FromBody] KhoanVay_ChoVay kt)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
if (!dao.PutKhoanChoVay(kt))
{
return(BadRequest("Not a valid model"));
}
return(Ok());
}
private void frmThemHoacSuaKhoanVay_Load(object sender, EventArgs e)
{
LoadDataForComboLoaiTaiKhoan();
LoadDataForComboNguoivay();
if (KhoanVay_Session.themhoacsua == 1)//vua click them
{
btnThem.Text = "Thêm";
}
else//vua click sua
{
btnThem.Text = "Sửa";
KhoanVay_ChoVay nv = LaykhoanVayTheoMa();
dtpNgay.Value = nv.ngayvay;
txtSoTien.Text = Convert.ToString(nv.sotien);
cboNguoiVay.SelectedValue = nv.nguoivay;
cboTaiKhoan.SelectedValue = nv.taikhoanchitieu;
//txtTen.Text = nv.ten;
//txtSDT.Text = Convert.ToString(nv.sdt);
}
}
public KhoanVay_ChoVay LayKhoanVayTheoMa(int id)
{
KhoanVay_ChoVay kt = new KhoanVay_ChoVay();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseAddress);
//HTTP GET
var responseTask = client.GetAsync($"KhoanVay?id={id}");
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var readTask = result.Content.ReadAsAsync <KhoanVay_ChoVay>();
readTask.Wait();
kt = readTask.Result;
return(kt);
}
}
return(kt);
}
public bool PostKhoanChoVay(KhoanVay_ChoVay kt)
{
const string proc = "SP_ThemKhoanVay_ChoVay";
List <SqlParameter> para = new List <SqlParameter>()
{
new SqlParameter("ngayvay", kt.ngayvay),
new SqlParameter("sotien", kt.sotien),
new SqlParameter("thanhvien", kt.thanhvien),
new SqlParameter("loai", kt.loai),
new SqlParameter("nguoivay", kt.nguoivay),
new SqlParameter("taikhoanchitieu", kt.taikhoanchitieu),
};
int res = DataProvider.ExecuteNonQuery(proc, para);
if (res > 0)
{
return(true);
}
else
{
return(false);
}
}
private void btnThem_Click(object sender, EventArgs e)
{
if (themhoacsua == 1)
{
KhoanVay_ChoVay kt = new KhoanVay_ChoVay();
kt.ngayvay = dtpNgay.Value;
kt.sotien = Convert.ToInt32(txtSoTien.Text.Trim());
kt.thanhvien = MySession.tendangnhap;
kt.loai = "1";
kt.nguoivay = Convert.ToString(cboNguoiVay.SelectedValue);
kt.taikhoanchitieu = Convert.ToString(cboTaiKhoan.SelectedValue);
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseAddress);
//HTTP POST
var postTask = client.PostAsJsonAsync <KhoanVay_ChoVay>("KhoanVay", kt);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
MessageBox.Show("Thêm thành công");
}
else
{
MessageBox.Show("Lỗi");
}
}
}
else
{
KhoanVay_ChoVay kt = new KhoanVay_ChoVay();
kt.id = KhoanVay_Session.ma;
kt.ngayvay = dtpNgay.Value;
kt.sotien = Convert.ToInt32(txtSoTien.Text.Trim());
kt.thanhvien = MySession.tendangnhap;
kt.loai = "1";
kt.nguoivay = Convert.ToString(cboNguoiVay.SelectedValue);
kt.taikhoanchitieu = Convert.ToString(cboTaiKhoan.SelectedValue);
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseAddress);
//HTTP POST
var postTask = client.PutAsJsonAsync <KhoanVay_ChoVay>("KhoanVay", kt);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
MessageBox.Show("Sửa thành công");
}
else
{
MessageBox.Show("Lỗi");
}
}
}
}
