private void btn_ThemMoi_Click(object sender, EventArgs e) { try { KhuyenMaiBLL _KMBLL = new KhuyenMaiBLL(); KHUYENMAI _km = new KHUYENMAI(); _km.Chuong_Trinh_KM = txt_CTKM.Text; if (check_PT.Checked == true) { _km.Loai_KM = "phần trăm"; } if (check_VND.Checked == true) { _km.Loai_KM = "voucher"; } _km.Gia_Tri = int.Parse(spin_GiaTri.Text); if (DateTime.Compare(dt_NgayKetThuc.DateTime, dt_NgayBatDau.DateTime) < 0) { Notification.Error("Có lỗi xảy ra khi Thêm dữ liệu."); return; } _km.Ngay_Bat_Dau = dt_NgayBatDau.DateTime; _km.Ngay_Het_Han = dt_NgayKetThuc.DateTime; _km.So_Luong = int.Parse(spin_SoLuong.Text); _KMBLL.ThemKMMoi(_km); Notification.Success("Thêm dữ liệu thành công."); } catch (Exception er) { Notification.Error("Có lỗi xảy ra khi Thêm dữ liệu: (" + er.Message + ")."); } }
private void button1_Click(object sender, EventArgs e) { try { KHUYENMAI km = new KHUYENMAI(); km.ID = int.Parse(txt_MaKM.Text); km.NGAYBATDAU = dtp_NgBatDauKM.Value; km.NGAYKETTHUC = dtp_NgKetThucKM.Value; km.ISDELETE = false; km.TENKM = txt_TenKM.Text; KhuyenMaiBLL newKM = new KhuyenMaiBLL(); newKM.add(km); ChiTietKMBLL newCtkm = new ChiTietKMBLL(); newCtkm.add(listCTKM); MessageBox.Show("Cập nhật thành công"); txt_TenKM.ResetText(); dtp_NgBatDauKM.ResetText(); dtp_NgKetThucKM.ResetText(); dgv_AllKM.DataSource = null; loadKM(); } catch (Exception) { MessageBox.Show("Không thêm được"); } }
public async Task <IHttpActionResult> Delete(string id) { var result = new TransferObj <bool>(); KHUYENMAI instance = await _service.Repository.FindAsync(id); if (instance == null) { return(NotFound()); } try { var refund = _service.DeleteKhuyenMai(instance.ID); int del = await _service.UnitOfWork.SaveAsync(); if (del > 1) { result.Data = true; result.Status = true; result.Message = "Xóa thành công bản ghi"; } else { result.Data = false; result.Status = false; result.Message = "Thao tác không thành công"; } } catch (Exception e) { result.Data = false; result.Status = false; result.Message = e.Message; } return(Ok(result)); }
private void cboKhuyenMai_SelectedIndexChanged(object sender, EventArgs e) { KHUYENMAI km = new KHUYENMAI(); String makm = cboKhuyenMai.SelectedValue.ToString(); km = kmai.getPhanTramKMByMa(cboKhuyenMai.SelectedValue.ToString()); if (km == null) { lbPhanTramGiam.Text = "0"; } else { TimeSpan difference_NGAYBD = getDateDifference(DateTime.Now, km.NGAYBD.Value); TimeSpan difference_NGAYKT = getDateDifference(km.NGAYKT.Value, DateTime.Now); int ngaybd_ht = difference_NGAYBD.Days; int ngaykt_ht = difference_NGAYKT.Days; if (ngaybd_ht >= 0) { lbPhanTramGiam.Text = km.PHANTRAMKM.ToString(); } else { lbPhanTramGiam.Text = "0"; } } }
public bool addTTKM(string masp, float giakm, DateTime tgbd, DateTime tgkt, string noidung, string hinhanh) { db = new CMART8Entities(); KHUYENMAI TTKM = new KHUYENMAI(); try { TTKM.MAKM = DateTime.Now.ToString(); TTKM.MASP = masp; TTKM.GIAKM = giakm; TTKM.HINHANH = hinhanh; //TTKM.THOIGIANBD = DateTime.Parse(tgbd); //TTKM.THOIGIANKT = DateTime.Parse(tgkt); TTKM.THOIGIANBD = tgbd; TTKM.THOIGIANKT = tgkt; TTKM.NOIDUNG = noidung; db.KHUYENMAIs.AddObject(TTKM); db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
private void btnsua_Click(object sender, EventArgs e) { KHUYENMAI km = new KHUYENMAI(); km.MAKM = txt_mkm.Text.ToString(); km.TENKM = txt_tkm.Text.ToString(); km.MUCGIAM = Convert.ToDouble(txt_mg.Text.ToString()); if (radioButton1.Checked == true) { km.APDUNG = true; } else { km.APDUNG = false; } if (km_bll.ktkc_km(km) == false) { if (km_bll.suakm(km) == true) { MessageBox.Show("thành công"); dataGridView1.DataSource = km_bll.loaddlkm(); } else { MessageBox.Show("thất bại"); } } else { MessageBox.Show("dữ liệu chưa tồn tại"); } }
public ActionResult Create(PromotionViewModel km) { ViewBag.message = ""; if (ModelState.IsValid) { KHUYENMAI khuyenmai = new KHUYENMAI(); khuyenmai.MAKM = km.MAKM; khuyenmai.TENKM = km.TENKM; khuyenmai.NGAYBD = km.NGAYBD; khuyenmai.NGAYKT = km.NGAYKT; if (promotionService.addPromotion(khuyenmai)) { ViewBag.message = "Thêm mới khuyến mãi thành công"; km = new PromotionViewModel(); km.MAKM = newMAKM(promotionService.getLastRecord()); return(View(km)); } else { ViewBag.message = "Thêm mới khuyến mãi thất bại"; } } return(View(km)); }
private void btn_Luu_Lai_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { foreach (int id in _listUpdate) { KHUYENMAI _km = new KHUYENMAI(); _km.ID_KM = int.Parse(gridView1.GetRowCellValue(id, "ID_KM").ToString()); _km.Chuong_Trinh_KM = gridView1.GetRowCellValue(id, "Chuong_Trinh_KM").ToString(); _km.Loai_KM = gridView1.GetRowCellValue(id, "Loai_KM").ToString(); _km.Gia_Tri = int.Parse(gridView1.GetRowCellValue(id, "Gia_Tri").ToString()); _km.Ngay_Bat_Dau = DateTime.Parse(gridView1.GetRowCellValue(id, "Ngay_Bat_Dau").ToString()); _km.Ngay_Het_Han = DateTime.Parse(gridView1.GetRowCellValue(id, "Ngay_Het_Han").ToString()); _km.So_Luong = int.Parse(gridView1.GetRowCellValue(id, "So_Luong").ToString()); _KMBLL.CapNhatKM(_km); } LoadDataSource(); Notification.Success("Cập dữ liệu thành công."); } catch (Exception er) { Notification.Error("Có lỗi xảy ra khi cập nhật dữ liệu: (" + er.Message + ")."); } }
private void buttonX1_Click(object sender, EventArgs e) { if (txtmakm.Text == "" || txtnd.Text == "" || txtphantram.Text == "") { MessageBox.Show("không thể xóa"); return; } KHUYENMAI ct = new KHUYENMAI(); var kt = from s in db.KHUYENMAIs where s.MAKM == txtmakm.Text select s; if (kt.Count() > 0) { MessageBox.Show("Trùng khóa chính"); return; } ct.MAKM = txtmakm.Text; ct.NOIDUNG = txtnd.Text; ct.PHANTRAM = Convert.ToDouble(txtphantram.Text); ct.APDUNG = aPDUNGCheckEdit.Checked; db.KHUYENMAIs.InsertOnSubmit(ct); db.SubmitChanges(); frm_KhuyenMai_Load(sender, e); MessageBox.Show("thành công"); }
public void Add(KhuyenMaiViewModel model) { var khuyenMai = new KHUYENMAI() { TenKhuyenMai = model.TenKhuyenMai, GiaTriKhuyenMai = model.GiaTriKhuyenMai, NgayBatDau = model.NgayBatDau, NgayKetThuc = model.NgayKetThuc, }; context.KHUYENMAIs.Add(khuyenMai); context.SaveChanges(); if (model.SanPhams?.Count > 0) { //foreach (var item in model.SanPhams) //{ // var sanPham = context.SANPHAMs.FirstOrDefault(t => t.Id_SanPham == item && t.TrangThai != false); // if (sanPham == null) continue; // sanPham.Id_KhuyenMai = khuyenMai.Id_KhuyenMai; //} UpdateKhuyenMaiForSanPham(model.SanPhams, khuyenMai.Id_KhuyenMai, true); } context.SaveChanges(); }
public IHttpActionResult DeleteTypeProduct([FromUri] int Ma) { KHUYENMAI khuyenmai = db.KHUYENMAIs.Where(sp => sp.DAXOA == false && sp.MA == Ma).SingleOrDefault(); db.KHUYENMAIs.Remove(khuyenmai); db.SaveChanges(); return(Ok()); }
public void add(KHUYENMAIModel km) { Mapper.CreateMap <KHUYENMAIModel, KHUYENMAI>(); KHUYENMAI _km = Mapper.Map <KHUYENMAIModel, KHUYENMAI>(km); db.KHUYENMAIs.Add(_km); db.SaveChanges(); }
public ActionResult DeleteConfirmed(string id) { KHUYENMAI kHUYENMAI = db.KHUYENMAIs.Find(id); db.KHUYENMAIs.Remove(kHUYENMAI); db.SaveChanges(); return(RedirectToAction("Index")); }
public bool deleteTTKM(String id) { db = new CMART8Entities(); KHUYENMAI TTKM = db.KHUYENMAIs.Single(st => st.MAKM.Contains(id)); db.KHUYENMAIs.DeleteObject(TTKM); db.SaveChanges(); return(true); }
public void xoaKhuyenMai(string makm) { KHUYENMAI delete = db.KHUYENMAIs.Where(t => t.MAKM == makm).FirstOrDefault(); if (delete != null) { db.KHUYENMAIs.DeleteOnSubmit(delete); } db.SubmitChanges(); }
public ActionResult Edit([Bind(Include = "KM_ID,KM_TEN,KM_NGAYBATDAU,KM_GIATRI,KM_NGAYKETTHUC,KM_MOTA")] KHUYENMAI kHUYENMAI) { if (ModelState.IsValid) { db.Entry(kHUYENMAI).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(kHUYENMAI)); }
public ActionResult KhuyenMai(string id) { KHUYENMAI km = db.KHUYENMAIs.Find(id); if (km == null || km.NgayBD > DateTime.Now || km.NgayKT < DateTime.Now || km.SoLanConLai <= 0) { return(Json(new { tb = "Lỗi!", id = "", gt = "" })); } return(Json(new { tb = "Mã khuyến mãi có hiệu lực: ", id = id, gt = km.GiaTriKM + "%" })); }
public bool Delete(int maKM) { KHUYENMAI khuyenMaiExist = context.KHUYENMAIs.Find(maKM); if (khuyenMaiExist == null) { return(false); } context.KHUYENMAIs.Remove(khuyenMaiExist); context.SaveChanges(); return(true); }
public void themKhuyenMai(string makm, string tenkm, int phantramkm, string ngaybd, string ngaykt) { KHUYENMAI insert = new KHUYENMAI(); insert.MAKM = makm; insert.TENKM = tenkm; insert.PHANTRAMKM = phantramkm; insert.NGAYBD = DateTime.Parse(ngaybd); insert.NGAYKT = DateTime.Parse(ngaykt); db.KHUYENMAIs.InsertOnSubmit(insert); db.SubmitChanges(); }
public IHttpActionResult UpdateProduct([FromUri] int Ma, [FromBody] KHUYENMAI s) { KHUYENMAI khuyenmai = db.KHUYENMAIs.Where(sp => sp.DAXOA == false && sp.MA == Ma).SingleOrDefault(); khuyenmai.MA = s.MA; khuyenmai.NGAYBATDAU = s.NGAYBATDAU; khuyenmai.NGAYKETTHUC = s.NGAYKETTHUC; khuyenmai.NOIDUNG = s.NOIDUNG; khuyenmai.DAXOA = s.DAXOA; db.SaveChanges(); return(Ok()); }
public bool them(KHUYENMAI pmh) { try { data.KHUYENMAIs.InsertOnSubmit(pmh); data.SubmitChanges(); return(true); } catch { return(false); } }
public ActionResult Edit(string VoucherCode) { //Lấy ra đối tượng sách theo mã KHUYENMAI voucher = db.KHUYENMAIs.SingleOrDefault(n => n.MaKM == VoucherCode); if (voucher == null) { Response.StatusCode = 404; return(null); } ViewBag.SoLanConLai = voucher.SoLanConLai.ToString(); return(View(voucher)); }
public bool addPromotion(KHUYENMAI km) { try { db.KHUYENMAIs.Add(km); db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public void suaKhuyenMai(string makm, string tenkm, int phantramkm, string ngaybd, string ngaykt) { KHUYENMAI update = db.KHUYENMAIs.Where(t => t.MAKM == makm).FirstOrDefault(); if (update != null) { update.TENKM = tenkm; update.PHANTRAMKM = phantramkm; update.NGAYBD = DateTime.Parse(ngaybd); update.NGAYKT = DateTime.Parse(ngaykt); } db.SubmitChanges(); }
public JsonResult Remove(string id) { KHUYENMAI km = db.KHUYENMAIs.SingleOrDefault(n => n.MaKM == id); if (km == null) { Response.StatusCode = 404; return(null); } db.KHUYENMAIs.Remove(km); db.SaveChanges(); return(Json(new { Url = Url.Action("IndexPartial") })); }
public List <KHUYENMAI> LoadPromotionList() { List <KHUYENMAI> promotionList = new List <KHUYENMAI>(); string query = "Select MaKM, TenKM, NgayBD, NgayKT, PhanTramKM from dbo.KHUYENMAI where TinhTrang = 'true'"; DataTable data = provider.ExecuteQuery(query); foreach (DataRow item in data.Rows) { KHUYENMAI km = new KHUYENMAI(item); promotionList.Add(km); } return(promotionList); }
public bool xoa(KHUYENMAI pmh) { try { KHUYENMAI mh = data.KHUYENMAIs.Where(t => t.MAKM == pmh.MAKM.ToString()).FirstOrDefault(); data.KHUYENMAIs.DeleteOnSubmit(mh); data.SubmitChanges(); return(true); } catch { return(false); } }
// GET: KHUYENMAIs/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } KHUYENMAI kHUYENMAI = db.KHUYENMAIs.Find(id); if (kHUYENMAI == null) { return(HttpNotFound()); } return(View(kHUYENMAI)); }
public void update(KHUYENMAIModel news_km) { Mapper.CreateMap <KHUYENMAIModel, KHUYENMAI>(); KHUYENMAI _news_km = Mapper.Map <KHUYENMAIModel, KHUYENMAI>(news_km); KHUYENMAI km = (from s in db.KHUYENMAIs where s.MA == _news_km.MA select s).First(); km.NGAYBATDAU = news_km.NGAYBATDAU; km.NGAYKETTHUC = news_km.NGAYKETTHUC; km.NOIDUNG = news_km.NOIDUNG; km.DAXOA = news_km.DAXOA; db.SaveChanges(); }
public ActionResult Create(KHUYENMAI khuyenmai) { try { // TODO: Add insert logic here database.KHUYENMAIs.Add(khuyenmai); database.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }