private void khoiTao() { List <int> listLoaiKhachHang = new List <int>(); for (int i = 0; i < bindingSource.Count; i++) { LoaiKhachHang loaiKhachHang = (LoaiKhachHang)bindingSource[i]; listLoaiKhachHang.Add(loaiKhachHang.MaLoaiKH); } if (maKhuyenMai != -1) { cmbLoaiKH.DataSource = BUS.KhuyenMaiBUS.XemChiTiet(maKhuyenMai, listLoaiKhachHang); cmbLoaiKH.DisplayMember = "TENLOAIKH"; } else { if (bindingSource.Count > 0) { cmbLoaiKH.DataSource = BUS.LoaiKhachHangBUS.XemLoaiKhachHang(listLoaiKhachHang); cmbLoaiKH.DisplayMember = "TENLOAIKH"; } else { cmbLoaiKH.DataSource = BUS.LoaiKhachHangBUS.LoadLoaiKH(); cmbLoaiKH.DisplayMember = "TENLOAIKH"; } } cmbLoaiKH.DisplayMember = "TENLOAIKH"; }
public static bool CapNhatLoaiKH(LoaiKhachHang loaiKhach) { int rowNum = 0; int maLoaiKH = loaiKhach.MaLoaiKH; string tenLoaiKH = loaiKhach.TenLoaiKH; float mucKM = loaiKhach.MucKM; string query = "EXEC usp_CapNhatLoaiKH @maLoaiKH,@tenLoaiKH,@mucKM"; List <SqlParameter> parameters = new List <SqlParameter> { new SqlParameter("@maLoaiKH", SqlDbType.Int) { Value = maLoaiKH }, new SqlParameter("@tenLoaiKH", SqlDbType.VarChar) { Value = tenLoaiKH }, new SqlParameter("@mucKM", SqlDbType.Float) { Value = mucKM }, }; try { rowNum = Dataprovider.ExcuteNonQuery(query, parameters.ToArray()); } catch (Exception ex) { Utility.Log(ex); } return(rowNum > 0 ? true : false); }
public JsonResult Create(int id, string TenLoai) { //Khai báo 1 đối tượng LoaiKhachHang obj = new LoaiKhachHang(); //Gán giá trị obj.Id = id; obj.TenLoai = TenLoai; if (id > 0)//TH sửa { obj.Id = id; //Lấy đối tượng cũ LoaiKhachHang objid = DataProvider.ShopEntities.LoaiKhachHangs.Where(p => p.Id == id).First(); DataProvider.ShopEntities.Entry(objid).CurrentValues.SetValues(obj); } else { //Thực hiện thêm và lưu sự thay đổi DataProvider.ShopEntities.LoaiKhachHangs.Add(obj); } DataProvider.ShopEntities.SaveChanges(); return(Json(obj, JsonRequestBehavior.AllowGet)); }
public List <LoaiKhachHang> HienThiDanhSachLKHTheoMa(string MaLoaiKhachHang) { OpenDataBase(); List <LoaiKhachHang> DanhSachLoaiKhachHang = new List <LoaiKhachHang>(); SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.CommandText = "HienThiDanhSachLKHTheoMa"; sqlCommand.Connection = sqlConnection; sqlCommand.Parameters.Add("@MaLoaiKhachHang", SqlDbType.Char).Value = MaLoaiKhachHang; SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); while (sqlDataReader.Read()) { LoaiKhachHang loaiKhachHang = new LoaiKhachHang() { MaLoaiKhachHang = sqlDataReader[0].ToString(), TenLoaiKhachHang = sqlDataReader[1].ToString(), KhuyenMai = sqlDataReader[2].ToString(), }; DanhSachLoaiKhachHang.Add(loaiKhachHang); } sqlDataReader.Close(); return(DanhSachLoaiKhachHang); }
/// <summary> /// hàm lấy thông tin để đưa lên modal sửa /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult GetObjToEdit(int id) { try { if (id > 0) { LoaiKhachHang obj = DataProvider.Entities.LoaiKhachHangs.Where(p => p.Id == id).First(); //Tạo đối tượng trả về LoaiKhachHang objReturn = new LoaiKhachHang { Id = obj.Id, TenLoai = obj.TenLoai }; return(Json(new JsonResponse { Message = ResponseMessage.SuccessGet, Success = true, Data = objReturn }, JsonRequestBehavior.AllowGet)); } return(Json(new VaiTro(), JsonRequestBehavior.AllowGet)); } catch (Exception ex) { //return Json(new JsonPostBack("Có lỗi xảy ra", false), JsonRequestBehavior.AllowGet); return(Json(new JsonResponse { Message = ResponseMessage.Error, Success = false }, JsonRequestBehavior.AllowGet)); } }
public ActionResult DeleteConfirmed(int id) { LoaiKhachHang loaiKhachHang = db.LoaiKhachHangs.Find(id); db.LoaiKhachHangs.Remove(loaiKhachHang); db.SaveChanges(); return(RedirectToAction("Index")); }
public IHttpActionResult Update(LoaiKhachHang input) { _loaiKHServices.Update(input); return(Ok(new { obj = input, message = "success" })); }
private int GetLoaiKH(string tenLoai) { using (CSDLQuanLyQuanAoDataContext db = new CSDLQuanLyQuanAoDataContext()) { LoaiKhachHang lkh = db.LoaiKhachHangs.Where(p => p.TenLoaiKhachHang.Equals(tenLoai)).SingleOrDefault(); // MessageBox.Show(lsp.MaLoaiSanPham + ""); return(lkh.MaLoaiKhachHang); } }
public string GetLastMaLoaiKhachHangs() { LoaiKhachHang lkh = qlhh.LoaiKhachHangs.Where(t => t.MaLoaiKhachHang == "LKH001").FirstOrDefault(); if (lkh == null) { return("LKH001"); } return(qlhh.LoaiKhachHangs.OrderByDescending(t => t.MaLoaiKhachHang).FirstOrDefault().MaLoaiKhachHang); }
public ActionResult Edit([Bind(Include = "MaLoaiKH,TenLoaiKH,GhiChu")] LoaiKhachHang loaiKhachHang) { if (ModelState.IsValid) { db.Entry(loaiKhachHang).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(loaiKhachHang)); }
public void xoaLoaiKhachHang(LoaiKhachHang lkh) { string sql = "delete from LoaiKhachHang where maLoaiKhachHang=@maLoaiKhachHang"; Connect.openConnect(); SqlCommand cmd = new SqlCommand(sql, Connect.connect); cmd.Parameters.AddWithValue("maLoaiKhachHang", lkh.MaLoaiKhachHang); cmd.ExecuteNonQuery(); Connect.closeConnect(); }
public ActionResult Create([Bind(Include = "MaLoaiKH,TenLoaiKH,GhiChu")] LoaiKhachHang loaiKhachHang) { if (ModelState.IsValid) { db.LoaiKhachHangs.Add(loaiKhachHang); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(loaiKhachHang)); }
public int Insert(LoaiKhachHang obj) { SqlParameter[] para = { new SqlParameter("TenLKH", obj.tenLKH), new SqlParameter("ChuanLKH", obj.chuanLKH), new SqlParameter("GhiChuLKH", obj.ghiChu) }; return(base.ExcuteSQL("LOAIKHACHHANG_Insert", para)); }
public void them1loaikhachhang(string maloaikh, string tenloaikh) { LoaiKhachHang iLoaiKhachHangs = new LoaiKhachHang(); iLoaiKhachHangs.Maloaikh = maloaikh; iLoaiKhachHangs.Tenloaikh = tenloaikh; iLoaiKhachHangs.soluongkh = 0; db.LoaiKhachHangs.InsertOnSubmit(iLoaiKhachHangs); db.SubmitChanges(); }
public void themLoaiKhachHang(LoaiKhachHang lkh) { string sql = "insert into LoaiKhachHang values(@tenLoaiKhachHang)"; Connect.openConnect(); SqlCommand cmd = new SqlCommand(sql, Connect.connect); cmd.Parameters.AddWithValue("tenLoaiKhachHang", lkh.TenLoaiKhachHang); cmd.ExecuteNonQuery(); Connect.closeConnect(); }
public int Update(LoaiKhachHang obj) { SqlParameter[] para = { // new SqlParameter("MaLKH", obj.maLKH), new SqlParameter("TenLKH", obj.tenLKH), new SqlParameter("ChuanLKH", obj.chuanLKH), new SqlParameter("GhiChuLKH", obj.ghiChu) }; return(base.ExcuteSQL("LOAIKHACHHANG_Update", para)); }
public bool Insert(LoaiKhachHang entity) { try { db.LoaiKhachHangs.Add(entity); db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool SuaLoaiKhachHang(LoaiKhachHang loaiKhachHang) { if (loaiKhachHang.TenLoaiKhachHang == "" || loaiKhachHang.TenLoaiKhachHang == null) { loaiKhachHang.TenLoaiKhachHang = "-"; } if (loaiKhachHang.KhuyenMai == "" || loaiKhachHang.KhuyenMai == null) { loaiKhachHang.KhuyenMai = "-"; } return(HienThiLoaiKhachHangDAL.SuaLoaiKhachHang(loaiKhachHang)); }
// GET: LoaiKhachHangs/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } LoaiKhachHang loaiKhachHang = db.LoaiKhachHangs.Find(id); if (loaiKhachHang == null) { return(HttpNotFound()); } return(View(loaiKhachHang)); }
public int UpdateLoaiKhachHangs(string qMaLoaiKH, string qTenLoaiKH) { LoaiKhachHang loaiKhachHangs = qlhh.LoaiKhachHangs.Where(t => t.MaLoaiKhachHang == qMaLoaiKH).FirstOrDefault(); if (loaiKhachHangs != null) { loaiKhachHangs.TenLoaiKhachHang = qTenLoaiKH; qlhh.SubmitChanges(); return(1); } else { return(0); } }
public bool SuaLoaiKhachHang(LoaiKhachHang loaiKhachHang) { OpenDataBase(); SqlCommand sqlCommand = new SqlCommand(); sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.CommandText = "SuaLoaiKhachHang"; sqlCommand.Connection = sqlConnection; sqlCommand.Parameters.Add("@MaLoaiKhachHang", SqlDbType.Char).Value = loaiKhachHang.MaLoaiKhachHang; sqlCommand.Parameters.Add("@TenLoaiKhachHang", SqlDbType.Char).Value = loaiKhachHang.TenLoaiKhachHang; sqlCommand.Parameters.Add("@KhuyenMai", SqlDbType.Char).Value = loaiKhachHang.KhuyenMai; int k = sqlCommand.ExecuteNonQuery(); return(k > 0); }
public ActionResult Create(LoaiKhachHang entity) { if (ModelState.IsValid) { db.LoaiKhachHangs.Add(entity); db.SaveChanges(); return(RedirectToAction("Index")); // return View(); } else { return(View(entity)); } // return View(); }
public int DeleteLoaiKhachHangs(string qMaLoaiKH) { LoaiKhachHang loaiKhachHangs = qlhh.LoaiKhachHangs.Where(t => t.MaLoaiKhachHang == qMaLoaiKH).FirstOrDefault(); if (loaiKhachHangs != null) { qlhh.LoaiKhachHangs.DeleteOnSubmit(loaiKhachHangs); qlhh.SubmitChanges(); return(1); } else { return(0); } }
public JsonResult GetById(int id) { var data = DataProvider.ShopEntities.LoaiKhachHangs.Find(id); if (data == null) { return(Json(new { success = false, msg = "Không tìm thấy loại khách hàng" }, JsonRequestBehavior.AllowGet)); } var obj = new LoaiKhachHang { Id = data.Id, TenLoai = data.TenLoai }; return(Json(new { success = true, data = obj }, JsonRequestBehavior.AllowGet)); }
private void btnLuu_Click(object sender, EventArgs e) { if (bThem) { List <int> listMaLoaiKhachHang = new List <int>(); List <float> listMucKhuyenMai = new List <float>(); List <LoaiKhachHang> list = new List <LoaiKhachHang>(); for (int i = 0; i < bindingSource.Count; i++) { LoaiKhachHang loaiKhachHang = (LoaiKhachHang)bindingSource[i]; listMaLoaiKhachHang.Add(loaiKhachHang.MaLoaiKH); listMucKhuyenMai.Add(loaiKhachHang.MucKM); } if (BUS.KhuyenMaiBUS.ThemkhuyenMai(new DTO.KhuyenMai() { NgayBatDau = dTPNgayBatDau.Value, NgayKetThuc = dTPNgayKetThuc.Value, TenKhuyenMai = txtTenKM.Text, }, listMaLoaiKhachHang, listMucKhuyenMai)) { MessageBox.Show("Thêm nguyên liệu thành công"); } bThem = false; enableControls(false); enableButton(true); resetDanhSach(); } else if (bSua) { List <LoaiKhachHang> list = (List <LoaiKhachHang>)bindingSource.DataSource; List <int> listMaLoaiKhachHang = list.Select(l => l.MaLoaiKH).ToList(); List <float> listMucKhuyenMai = list.Select(l => l.MucKM).ToList(); if (BUS.KhuyenMaiBUS.CapNhatkhuyenMai(new DTO.KhuyenMai() { TenKhuyenMai = txtTenKM.Text, }, listMaLoaiKhachHang, listMucKhuyenMai)) { MessageBox.Show("Sửa nguyên liệu thành công"); } bSua = false; enableControls(false); enableButton(true); resetDanhSach(); } }
public List <LoaiKhachHang> layLoaiKhachHang() { List <LoaiKhachHang> arr = new List <LoaiKhachHang>(); Connect.openConnect(); string query = "select * from LoaiKhachHang"; SqlCommand cmd = new SqlCommand(query, Connect.connect); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { LoaiKhachHang x = new LoaiKhachHang(int.Parse(dr["maLoaiKhachHang"] + ""), dr["tenLoaiKhachHang"] + ""); arr.Add(x); } Connect.closeConnect(); return(arr); }
private void btnChinhSua_Click(object sender, EventArgs e) { if (texMaLoaiKH.Text == "" || texTenLoaiKH.Text == null) { MessageBox.Show("Bạn Cần Phải Có Mã Loại Khách Hàng"); return; } HienThiLoaiKhachHangBLL hienThiLoaiKhachHangBLL = new HienThiLoaiKhachHangBLL(); LoaiKhachHang loaiKhachHang = new LoaiKhachHang() { MaLoaiKhachHang = texMaLoaiKH.Text, TenLoaiKhachHang = texTenLoaiKH.Text, KhuyenMai = TexKhuyenMai.Text }; hienThiLoaiKhachHangBLL.SuaLoaiKhachHang(loaiKhachHang); HienThiDanhSachLKH(); }
public int AddLoaiKhachHangs(string qMaLoaiKH, string qTenLoai) { LoaiKhachHang loaiKhachHangs = qlhh.LoaiKhachHangs.Where(t => t.MaLoaiKhachHang == qMaLoaiKH).FirstOrDefault(); if (loaiKhachHangs == null) { LoaiKhachHang lkh = new LoaiKhachHang(); lkh.MaLoaiKhachHang = qMaLoaiKH; lkh.TenLoaiKhachHang = qTenLoai; qlhh.LoaiKhachHangs.InsertOnSubmit(lkh); qlhh.SubmitChanges(); return(1); } else { return(0); } }
//thêm mới loại khách hàng public static Boolean ThemLoaiKH(LoaiKhachHangViewModel loaikh) { var entity = new QuanLyThueXeEntities(); try { var lkh = new LoaiKhachHang(); lkh.MaLoaiKH = TuTangMaLKH(); lkh.TenLoaiKH = loaikh.TenLoaiKH; entity.LoaiKhachHangs.Add(lkh); entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
public ActionResult Edit(LoaiKhachHang entity) { if (ModelState.IsValid) { var dao = new LoaiKhachHangDao(); if (dao.Update(entity)) { return(RedirectToAction("Index")); } else { return(View(entity)); } } else { return(View(entity)); } }
public ActionResult SuaLoaiKhachHang(LoaiKhachHang loaikhachhang) { if (!Models.User.CurrentUser.Quyen.CoChucNang("sua_loai_khach_hang")) { return RedirectToAction("Error", "Admin"); } if (ModelState.IsValid) { db.Entry(loaikhachhang).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("LoaiKhachHang"); } return View(loaikhachhang); }
public ActionResult ThemLoaiKhachHang(LoaiKhachHang loaikhachhang) { if (ModelState.IsValid) { db.LoaiKhachHangs.Add(loaikhachhang); db.SaveChanges(); return RedirectToAction("LoaiKhachHang"); } return View(loaikhachhang); }