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