private void btnThem_Click(object sender, EventArgs e) { if (txtIDGiay.Text == "" || txtChietKhau.Text == "") { MessageBox.Show("Mã giày không tồn tại hoặc không có chiết khấu", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { foreach (DataGridViewRow row in dgvDSKM.Rows) { if (dgvDSKM.Rows.Count > 1 && row.Cells["MaGiay"].Value != null && txtIDGiay.Text.Equals(row.Cells["MaGiay"].Value.ToString())) { MessageBox.Show("Mã giày đã có trong danh sách khuyến mãi", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } int check; if (Int32.TryParse(txtChietKhau.Text, out check)) { CTKhuyenMai_DTO ChiTietKM = new CTKhuyenMai_DTO(); ChiTietKM.MaGiay = Convert.ToInt32(txtIDGiay.Text); ChiTietKM.ChietKhau = Convert.ToInt32(txtChietKhau.Text); listCTKhuyenMai.Add(ChiTietKM); listCTKM.Add(ChiTietKM); dgvDSKM.DataSource = listCTKhuyenMai; dgvDSKM.Columns["MAKM"].Visible = false; } else { MessageBox.Show("Nhập sai chiết khấu.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } //DataTable data = CTKhuyenMaiDAO.Instance.InsertCTKM(Convert.ToInt32(txtIDGiay.Text), Convert.ToInt32(txtChietKhau.Text), Convert.ToInt32(lblMaKM.Text)); } }
private void btnXoaCT_Click(object sender, EventArgs e) { if (txtMaGiay.Text == null || txtCK.Text == null) { MessageBox.Show("Chọn ít nhất 1 chi tiết khuyến mãi.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { var confirm = MessageBox.Show("Bạn có chắc chắn muốn xóa chi tiết khuyến mãi ", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (confirm == DialogResult.Yes) { int maKM = Convert.ToInt32(txtIDKM.Text); int maGiay = Convert.ToInt32(txtMaGiay.Text); float CK = float.Parse(txtCK.Text); CTKhuyenMai_DTO ctkm = new CTKhuyenMai_DTO(maKM, maGiay, CK); CTKhuyenMai_DTO CTKM = new CTKhuyenMai_DTO(maKM, maGiay); List <CTKhuyenMai_DTO> list = null; using (var client = new HttpClient()) { client.BaseAddress = new Uri(baseAddress); var url = baseAddress + "CTKhuyenMai?idkm=" + maKM + "&idgiay=" + maGiay; //HTTP PUT api / CTKhuyenMai?idkm ={idkm}&idgiay ={ idgiay} var postTask = client.DeleteAsync(url); postTask.Wait(); var result = postTask.Result; if (result.IsSuccessStatusCode) { MessageBox.Show("Xóa thành công"); } var responseTask = client.GetAsync($"CTKhuyenMai?idkm={maKM}"); responseTask.Wait(); var result1 = responseTask.Result; if (result1.IsSuccessStatusCode) { var readTask = result1.Content.ReadAsAsync <List <CTKhuyenMai_DTO> >(); readTask.Wait(); list = readTask.Result; } } listCTKM = list; dgvDSKM.DataSource = listCTKM; AddBinding(); } else { return; } } }
public List <CTKhuyenMai_DTO> SearchKM(string str) { List <CTKhuyenMai_DTO> KMList = new List <CTKhuyenMai_DTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("EXEC USP_SearchKM @str ", new object[] { str }); foreach (DataRow item in data.Rows) { CTKhuyenMai_DTO tenKM = new CTKhuyenMai_DTO(item); KMList.Add(tenKM); } return(KMList); }
public List <CTKhuyenMai_DTO> ListCTKM(int ID) { List <CTKhuyenMai_DTO> ListCTKM = new List <CTKhuyenMai_DTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("EXEC USP_ListCTKM @ID ", new object[] { ID }); foreach (DataRow item in data.Rows) { CTKhuyenMai_DTO MaKM = new CTKhuyenMai_DTO(item); ListCTKM.Add(MaKM); } return(ListCTKM); }
public List <CTKhuyenMai_DTO> GetListCTKM() { List <CTKhuyenMai_DTO> ListCTKM = new List <CTKhuyenMai_DTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("SELECT IDGIAY,CHIETKHAU FROM CTKHUYENMAI"); foreach (DataRow item in data.Rows) { CTKhuyenMai_DTO MaGiay = new CTKhuyenMai_DTO(item); ListCTKM.Add(MaGiay); } return(ListCTKM); }
public List <CTKhuyenMai_DTO> ListCTKM(int ID) { List <CTKhuyenMai_DTO> ListCTKM = new List <CTKhuyenMai_DTO>(); //DataTable data = DataProvider.Instance.ExecuteQuery("EXEC USP_ListCTKM @ma ", new object[] { ID }); string query = "select * from CTKHUYENMAI where IDKhuyenMai = " + ID; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { CTKhuyenMai_DTO MaKM = new CTKhuyenMai_DTO(item); ListCTKM.Add(MaKM); } return(ListCTKM); }
public IHttpActionResult Post(CTKhuyenMai_DTO x) { try { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } CTKhuyenMaiDAO.Instance.InsertCTKM(x.MaKM, x.MaGiay, x.CK); } catch (Exception) { } return(Ok()); }