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());
}
}
