public List <MucDichTietKiem> GetMucDichTietKiem(string matv)
{
const string proc = "SP_XemMucDichTietKiem";
List <SqlParameter> para = new List <SqlParameter>()
{
new SqlParameter("thanhvien", matv)
};
IDataReader reader = DataProvider.ExecuteReader(proc, para);
List <MucDichTietKiem> result = new List <MucDichTietKiem>();
MucDichTietKiem md;
while (reader.Read())
{
md = new MucDichTietKiem();
md.maMD = Convert.ToString(reader["MaMD"]);
md.tenmucdich = Convert.ToString(reader["TenMucDich"]);
md.sotiendukien = Convert.ToDouble(reader["SoTienDuKien"]);
md.sotiendatietkiem = Convert.ToDouble(reader["SoTienDaTietKiem"]);
md.ngaybatdau = Convert.ToDateTime(reader["NgayBatDau"]);
md.ngayketthuc = Convert.ToDateTime(reader["NgayKetThuc"]);
md.trangthai = Convert.ToString(reader["TrangThai"]);
result.Add(md);
}
return(result);
}
public ActionResult ThemMucDichTietKiem(string maMD, string tenmucdich, int sotiendukien, DateTime ngaybatdau, DateTime ngayketthuc)
{
MucDichTietKiem md = new MucDichTietKiem();
md.matv = (string)Session[Ses_Admin.Admin];
md.maMD = maMD;
md.tenmucdich = tenmucdich;
md.sotiendukien = sotiendukien;
md.ngaybatdau = ngaybatdau;
md.ngayketthuc = ngayketthuc;
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseAddress);
//HTTP POST
var postTask = client.PostAsJsonAsync <MucDichTietKiem>("MucDichTietKiem", md);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
return(RedirectToAction("Index"));
}
}
return(Redirect("~/Error/Error"));
}
public ActionResult SuaMucDichTietKiem(string maMD)
{
MucDichTietKiem res = new MucDichTietKiem();
res = LayMucDichTKTheoMa(maMD);
return(View(res));
}
private void btnThem_Click(object sender, EventArgs e)
{
if (MucDichTietKiem_Session.themhoacsua == 2)
{
MucDichTietKiem md = new MucDichTietKiem();
md.maMD = MucDichTietKiem_Session.maMD;
md.tenmucdich = txttenmucdich.Text.Trim();
md.ngaybatdau = dtpNgaybd.Value;
md.ngayketthuc = dtpNgaykt.Value;
md.matv = MySession.tendangnhap;
md.sotiendukien = Convert.ToInt32(txtSotiendukien.Text.Trim());
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseAddress);
var postTask = client.PutAsJsonAsync <MucDichTietKiem>("MucDichTietKiem", md);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
MessageBox.Show("Đã sửa!");
}
else
{
MessageBox.Show("404 Error");
}
}
}
else
{
MucDichTietKiem md = new MucDichTietKiem();
md.maMD = MucDichTietKiem_Session.maMD;
md.tenmucdich = txttenmucdich.Text.Trim();
md.ngaybatdau = dtpNgaybd.Value;
md.ngayketthuc = dtpNgaykt.Value;
md.matv = MySession.tendangnhap;
md.sotiendukien = Convert.ToInt32(txtSotiendukien.Text.Trim());
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseAddress);
var postTask = client.PostAsJsonAsync <MucDichTietKiem>("MucDichTietKiem", md);
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
MessageBox.Show("Đã thêm!");
}
else
{
MessageBox.Show("404 Error");
}
}
}
}
//Tìm kiếm theo mã
public IHttpActionResult Get_TimKiem(string MaMD)
{
MucDichTietKiem res = dao.SearchMucDichTK(MaMD);
if (res == null)
{
return(NotFound());
}
return(Ok(res));
}
public IHttpActionResult PutMD([FromBody] MucDichTietKiem md)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
if (!dao.PutMucDichTietKiem(md))
{
return(BadRequest("Not a valid model"));
}
return(Ok());
}
private void frmThemHoacSuaMDTK_Load(object sender, EventArgs e)
{
if (MucDichTietKiem_Session.themhoacsua == 2)
{
btnThem.Text = "Sửa";
string maMD = MucDichTietKiem_Session.maMD;
MucDichTietKiem md = LayMucDichTKTheoMa(maMD);
txttenmucdich.Text = md.tenmucdich;
txtSotiendukien.Text = md.sotiendukien.ToString();
dtpNgaybd.Value = md.ngaybatdau;
dtpNgaykt.Value = md.ngayketthuc;
}
else
{
btnThem.Text = "Thêm";
}
}
public List <MucDichTietKiem> LoadDataForMucDich(string thanhvien)
{
const string proc = "LoadDataForMucDich";
List <SqlParameter> para = new List <SqlParameter>()
{
new SqlParameter("matv", thanhvien)
};
IDataReader reader = DataProvider.ExecuteReader(proc, para);
List <MucDichTietKiem> result = new List <MucDichTietKiem>();
MucDichTietKiem md;
while (reader.Read())
{
md = new MucDichTietKiem();
md.maMD = Convert.ToString(reader["MaMD"]);
md.tenmucdich = Convert.ToString(reader["TenMucDich"]);
result.Add(md);
}
return(result);
}
public MucDichTietKiem LayMucDichTKTheoMa(string maMD)
{
MucDichTietKiem md = new MucDichTietKiem();
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(baseAddress);
//HTTP GET
var responseTask = client.GetAsync($"MucDichTietKiem?MaMD={maMD}");
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
var readTask = result.Content.ReadAsAsync <MucDichTietKiem>();
readTask.Wait();
md = readTask.Result;
return(md);
}
}
return(md);
}
public bool PutMucDichTietKiem(MucDichTietKiem md)
{
const string proc = "SP_SuaMucDichTK";
List <SqlParameter> para = new List <SqlParameter>()
{
new SqlParameter("MaMD", md.maMD),
new SqlParameter("TenMucDich", md.tenmucdich),
new SqlParameter("SoTienDuKien", md.sotiendukien),
new SqlParameter("NgayBatDau", md.ngaybatdau),
new SqlParameter("NgayKetThuc", md.ngayketthuc)
};
int res = DataProvider.ExecuteNonQuery(proc, para);
if (res != 0)
{
return(true);
}
else
{
return(false);
}
}
public MucDichTietKiem SearchMucDichTK(string MaMD)
{
const string proc = "SP_TimKiemMucDichTK";
List <SqlParameter> para = new List <SqlParameter>()
{
new SqlParameter("maMD", MaMD)
};
IDataReader reader = DataProvider.ExecuteReader(proc, para);
MucDichTietKiem res = new MucDichTietKiem();
MucDichTietKiem md;
while (reader.Read())
{
md = new MucDichTietKiem();
md.maMD = Convert.ToString(reader["MaMD"]);
md.tenmucdich = Convert.ToString(reader["TenMucDich"]);
md.sotiendukien = Convert.ToInt32(reader["SoTienDuKien"]);
md.ngaybatdau = Convert.ToDateTime(reader["NgayBatDau"]);
md.ngayketthuc = Convert.ToDateTime(reader["NgayKetThuc"]);
res = md;
}
return(res);
}
