public bool Xoa(KhuyenMaiDTO kmDTO) { string query = " delete from KHUYENMAI where MAKM='" + kmDTO.Makm + "'"; bool kq = xl.Command(query); return(kq); }
public IHttpActionResult Put([FromBody] KhuyenMaiDTO x) { if (!ModelState.IsValid) { return(BadRequest("Not a valid data")); } KhuyenMaiDAO.Instance.UpdateKM(x.TenCT, x.MoTa, x.NgayBD, x.NgayKT, x.ChietKhau); return(Ok()); }
public bool Them(KhuyenMaiDTO kmDTO) { String query = String.Empty; query += "insert into KHUYENMAI(TENKM, TGBD, TGKT, MUCGIAMGIA)"; query += "values('" + kmDTO.Tenkm + "', '" + kmDTO.TgBD + "', '" + kmDTO.TgKT + "', '" + kmDTO.Mucgiamgia + "')"; bool kq = xl.Command(query); return(kq); }
public KhuyenMaiDTO GetDTOKM(string tenKM) { DataTable data = DataProvider.Instance.ExecuteQuery("Select * From KhuyenMai WHERE TenKM = N'" + tenKM + "'"); if (data.Rows.Count > 0) { KhuyenMaiDTO km = new KhuyenMaiDTO(data.Rows[0]); return(km); } return(null); }
public List <KhuyenMaiDTO> TimKiemKMChuaHetHan() { List <KhuyenMaiDTO> list = new List <KhuyenMaiDTO>(); DataTable table = DataProvider.Instance.executeQuery("select * from KHUYENMAI where NGAYKETTHUC >= GETDATE()"); foreach (DataRow row in table.Rows) { KhuyenMaiDTO km = new KhuyenMaiDTO(row); list.Add(km); } return(list); }
public int GetIDByTenKM(string tenKM) { string query = "SELECT * FROM KhuyenMai WHERE TenKM = N'" + tenKM + "'"; DataTable table = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in table.Rows) { KhuyenMaiDTO lkm = new KhuyenMaiDTO(item); return(lkm.Id); } return(-1); }
public List <KhuyenMaiDTO> LoadDsKMAll() { List <KhuyenMaiDTO> dsKM = new List <KhuyenMaiDTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM KhuyenMai Where idLoaiKm = 1"); foreach (DataRow item in data.Rows) { KhuyenMaiDTO km = new KhuyenMaiDTO(item); dsKM.Add(km); } return(dsKM); }
public List <KhuyenMaiDTO> GetKhuyenMai() { List <KhuyenMaiDTO> list = new List <KhuyenMaiDTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("select * from KhuyenMai "); foreach (DataRow item in data.Rows) { KhuyenMaiDTO KM = new KhuyenMaiDTO(item); list.Add(KM); } return(list); }
public List <KhuyenMaiDTO> SearchKM(string str) { List <KhuyenMaiDTO> KMList = new List <KhuyenMaiDTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("EXEC USP_SearchKM @str ", new object[] { str }); foreach (DataRow item in data.Rows) { KhuyenMaiDTO tenKM = new KhuyenMaiDTO(item); KMList.Add(tenKM); } return(KMList); }
public List <KhuyenMaiDTO> GetKhuyenMai() { List <KhuyenMaiDTO> ListKhuyenMai = new List <KhuyenMaiDTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("select * from KhuyenMai"); foreach (DataRow item in data.Rows) { KhuyenMaiDTO khuyenMai = new KhuyenMaiDTO(item); ListKhuyenMai.Add(khuyenMai); } return(ListKhuyenMai); }
public List <KhuyenMaiDTO> LoadDsKM() { List <KhuyenMaiDTO> dsKM = new List <KhuyenMaiDTO>(); DataTable data = DataProvider.Instance.ExecuteQuery("USP_GetDSKM"); foreach (DataRow item in data.Rows) { KhuyenMaiDTO km = new KhuyenMaiDTO(item); dsKM.Add(km); } return(dsKM); }
private void cbxTenKM_SelectedIndexChanged(object sender, EventArgs e) { string tenKM = cbxTenKM.Text; string tenLKM = cbxLoaiKM.Text; KhuyenMaiDTO km = KhuyenMaiDAO.Instance.GetDTOKM(tenKM); txbDieuKien.Text = km.DieuKien.ToString(); txbGiamGiaPT.Text = km.GiamGia.ToString(); txbGiamGiaTM.Text = km.GiamTien.ToString(); txbToiDa.Text = km.ToiDa.ToString(); txbNDKM.Text = km.TenKM; cbxLoaiKM.Text = LoaiKhuyenMaiDAO.Instance.GetTenLoaiKMByID(km.IdLoaiKM); }
private void fillList() { DataTable table = new DataTable(); table.Columns.Add("Stt", typeof(int)); table.Columns.Add("MaKM", typeof(string)); table.Columns.Add("TenKM", typeof(string)); table.Columns.Add("MaApDung", typeof(string)); table.Columns.Add("GiaTri", typeof(string)); BangVocher.DataSource = table; int soluong; try { soluong = Int32.Parse(TxtSoLuong.Text); } catch { soluong = 0; } list = new List <KhuyenMaiDTO>(); for (int i = 0; i < soluong; i++) { KhuyenMaiDTO km = new KhuyenMaiDTO(); km.MaKM = getnewcodeKM(i); km.TenKM = txtTenVocher.Text; try { km.GiaTri = Decimal.Parse(TxtGiaTri.Text); } catch { km.GiaTri = 0; } km.MaApDung = "VOCHER-" + km.MaKM; km.LoaiKM = "Vocher"; km.BatDau = DateTime.Today; km.KetThuc = DateTime.Today; km.TuXoa = false; km.TrangThai = true; list.Add(km); table.Rows.Add(i + 1, km.MaKM, km.TenKM, km.MaApDung, ConvertDTO.Instance.CurrencyFromDecimal(km.GiaTri)); } BangVocher.DataSource = table; }
public IHttpActionResult HoanThanh(KhuyenMaiDTO x) { try { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } KhuyenMaiDAO.Instance.HoanThanh(x.List, x.TenCT, x.MoTa, x.NgayBD, x.NgayKT); } catch (Exception) { } return(Ok()); }
public IHttpActionResult Put(KhuyenMaiDTO x) { try { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } //int idkm, string tenct, string mota, DateTime ngaybd, DateTime ngaykt, float chietkhau KhuyenMaiDAO.Instance.UpdateKM(x.MaKM, x.TenCT, x.MoTa, x.NgayBD, x.NgayKT, x.ChietKhau); } catch (Exception) { } return(Ok()); }
public IHttpActionResult Post(KhuyenMaiDTO x) { try { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } KhuyenMaiDAO.Instance.InsertKM(x.TenCT, x.MoTa, x.NgayBD, x.NgayKT, x.ChietKhau); } catch (Exception) { } return(Ok()); }
public List <KhuyenMaiDTO> select() { Fxuly xuLy = new Fxuly(); List <KhuyenMaiDTO> listKM = new List <KhuyenMaiDTO>(); string query = String.Empty; query += "select [MAKM], [TENKM], [TGBD], [TGKT], [MUCGIAMGIA] from [KHUYENMAI]"; using (SqlConnection con = new SqlConnection(xuLy.ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = query; try { con.Open(); SqlDataReader reader = null; reader = cmd.ExecuteReader(); if (reader.HasRows == true) { while (reader.Read()) { KhuyenMaiDTO db = new KhuyenMaiDTO(); db.Makm = int.Parse(reader["MAKM"].ToString()); db.Tenkm = reader["TENKM"].ToString(); db.TgBD = DateTime.Parse(reader["TGBD"].ToString()); db.TgKT = DateTime.Parse(reader["TGKT"].ToString()); db.Mucgiamgia = int.Parse(reader["MUCGIAMGIA"].ToString()); listKM.Add(db); } } con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); con.Dispose(); } } return(listKM); } }
public List <KhuyenMaiDTO> selectLoadCB() { string query = String.Empty; Fxuly xuLy = new Fxuly(); query += "select [MAKM], [TENKM], [MUCGIAMGIA] FROM [KHUYENMAI] "; List <KhuyenMaiDTO> list = new List <KhuyenMaiDTO>(); using (SqlConnection con = new SqlConnection(xuLy.ConnectionString)) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; try { con.Open(); SqlDataReader reader = null; reader = cmd.ExecuteReader(); if (reader.HasRows == true) { while (reader.Read()) { KhuyenMaiDTO kn = new KhuyenMaiDTO(); kn.maKhuyenMai = int.Parse(reader["MAKM"].ToString()); kn.tenKhuyenMai = reader["TENKM"].ToString(); kn.mucKhuyenMai = int.Parse(reader["MUCGIAMGIA"].ToString()); list.Add(kn); } } con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(null); } } return(list); } }
private void btn_Xoa_Click(object sender, EventArgs e) { int currentRowIndex = dgv_KM.CurrentCellAddress.Y; if (-1 < currentRowIndex && currentRowIndex < dgv_KM.RowCount) { kmDTO = (KhuyenMaiDTO)dgv_KM.Rows[currentRowIndex].DataBoundItem; if (kmDTO != null) { bool kq = kmBUS.Xoa(kmDTO); if (kq == true) { loadKM(); MessageBox.Show("Xóa khuyến mãi thành công"); } else { MessageBox.Show("Xóa khuyến mãi thất bại"); } } } }
private void btnCapNhat_Click(object sender, EventArgs e) { if (txtTenCT.Text == null || dtpTuNgay.Text == null || dtpDenNgay == null || txtChietKhau.Text == null) { MessageBox.Show("Thêm đầy đủ thông tin khuyến mại.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } int id = Convert.ToInt32(txtIDKM.Text); string tenct = txtTenCT.Text; string mota = txtMoTa.Text; float chietkhau = float.Parse(txtChietKhau.Text); DateTime ngaybd = Convert.ToDateTime(dtpTuNgay.Text); DateTime ngaykt = Convert.ToDateTime(dtpDenNgay.Text); KhuyenMaiDTO KM = new KhuyenMaiDTO(id, tenct, mota, ngaybd, ngaykt, chietkhau); using (var client = new HttpClient()) { client.BaseAddress = new Uri(baseAddress); //HTTP PUT var postTask = client.PutAsJsonAsync <KhuyenMaiDTO>("KhuyenMai", KM); postTask.Wait(); var result = postTask.Result; if (result.IsSuccessStatusCode) { MessageBox.Show("Sửa thành công!", "Thông báo", MessageBoxButtons.OK); } else { MessageBox.Show("Sửa không thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } Load(); } }
private void btnHoanThanh_Click(object sender, EventArgs e) { if (txtTenCT.Text == "" || dtpTuNgay == null || dtpDenNgay == null) { MessageBox.Show("Nhập đầy đủ thông tin chương trình khuyến mãi!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (radKMDH.Checked == true) { string tenct = txtTenCT.Text; string mota = txtMoTa.Text; DateTime ngaybd = Convert.ToDateTime(dtpTuNgay.Text); DateTime ngaykt = Convert.ToDateTime(dtpDenNgay.Text); float chietkhau = float.Parse(txtCK.Text); KhuyenMaiDTO CTKM = new KhuyenMaiDTO(tenct, mota, ngaybd, ngaykt, chietkhau); using (var client = new HttpClient()) { client.BaseAddress = new Uri(baseAddress); //HTTP POST var postTask = client.PostAsJsonAsync <KhuyenMaiDTO>("KhuyenMai", CTKM); postTask.Wait(); var result = postTask.Result; if (result.IsSuccessStatusCode) { MessageBox.Show("thêm thành công 1 phiếu đổi!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } } else { //KhuyenMaiDAO.Instance.HoanThanh(listCTKM, txtTenCT.Text, txtMoTa.Text, Convert.ToDateTime(dtpTuNgay.Text), Convert.ToDateTime(dtpDenNgay.Text)); string tenct = txtTenCT.Text; string mota = txtMoTa.Text; DateTime ngaybd = Convert.ToDateTime(dtpTuNgay.Text); DateTime ngaykt = Convert.ToDateTime(dtpDenNgay.Text); KhuyenMaiDTO CTKM = new KhuyenMaiDTO(listCT, tenct, mota, ngaybd, ngaykt); using (var client = new HttpClient()) { client.BaseAddress = new Uri(baseAddress); //HTTP POST var postTask = client.PostAsJsonAsync <KhuyenMaiDTO>("HoanThanh", CTKM); postTask.Wait(); var result = postTask.Result; if (result.IsSuccessStatusCode) { MessageBox.Show("thêm thành công 1 phiếu đổi!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } } } fKhuyenMai KM = new fKhuyenMai(); this.Hide(); KM.ShowDialog(); this.Show(); }
private void BtnThemKM_Click(object sender, EventArgs e) { if (TimeNgayKetThuc.Value >= TimeNgayBatDau.Value && TimeNgayKetThuc.Value >= DateTime.Today && TimeNgayBatDau.Value >= DateTime.Today) { if (SelectLoaiKM.selectedIndex == 1) { KhuyenMaiDTO km = new KhuyenMaiDTO(); km.MaKM = getnewcodeKM(0); km.TenKM = fmCT.GetTenCT(); km.GiaTri = fmCT.getGiaTri(); km.LoaiKM = "Chương Trình"; km.MaApDung = getnewcodeKM(0); km.BatDau = TimeNgayBatDau.Value; km.KetThuc = TimeNgayKetThuc.Value; km.TuXoa = SwitchTuXoa.Value; km.TrangThai = (km.BatDau <= DateTime.Today && km.KetThuc >= DateTime.Today)?true:false; if (KhuyenMaiDAO.Instance.Insert(km)) { this.Close(); } else { MessageBox.Show("Không thể thêm Chương Trình Khuyến Mãi"); } } if (SelectLoaiKM.selectedIndex == 0) { int soluong; try { soluong = Int32.Parse(fmVC.getSoLuong()); } catch { soluong = 0; } try { for (int i = 0; i < soluong; i++) { KhuyenMaiDTO km = new KhuyenMaiDTO(); km.MaKM = getnewcodeKM(i); km.TenKM = fmVC.getTenVoCher(); try { km.GiaTri = Decimal.Parse(fmVC.getGiaTri()); } catch { km.GiaTri = 0; } km.MaApDung = "VOCHER-" + km.MaKM; km.LoaiKM = "Vocher"; km.BatDau = TimeNgayBatDau.Value; km.KetThuc = TimeNgayKetThuc.Value; km.TuXoa = SwitchTuXoa.Value; km.TrangThai = (km.BatDau <= DateTime.Today && km.KetThuc >= DateTime.Today) ? true : false; KhuyenMaiDAO.Instance.Insert(km); } this.Close(); } catch { MessageBox.Show("Không thể thêm Vocher"); } } } else { MessageBox.Show("Khuyến Mãi Không Hợp lệ"); } }