public void AddCustomer(Models.KhachHang a) { Database db = new Database(); DataTable dtlkh = db.Query("select MaLoaiKH from LoaiKhachHang where LoaiKH = N'" + a.LoaiKH + "';"); db.Insert("insert into KhachHang(HoTen, DiaChi,SDT, Email, MaLoaiKH) values (N'" + a.HoTenKhachHang + "',N'" + a.DiaChi + "', '" + a.SDT + "','" + a.Email + "', " + dtlkh.Rows[0]["MaLoaiKH"].ToString() + ");"); }
private void ModernButton_Click_3(object sender, RoutedEventArgs e) { Models.KhachHang kh = dg_Customer.SelectedItem as Models.KhachHang; Expand ex = new Expand(kh); ex.Show(); }
public Models.KhachHang convertKHService(ServiceReference1.KhachHang kh) { Models.KhachHang khang = new Models.KhachHang(); khang.MaKH = kh.MaKH; khang.SoTienTK = kh.SoTienTK; khang.MaPin = kh.MaPin; return(khang); }
public ActionResult createKH(Models.KhachHang tk) { if (ModelState.IsValid) { var tks = convertKHClient(tk); client.dangkyKH(tks); return(RedirectToAction("ViewKH")); } return(View()); }
public ActionResult dang_ky(Models.KhachHang KhachHangData) { bool temp = ivivuDB.themKhachHang(KhachHangData); if (temp) { return(RedirectToAction("dang_nhap", "KhachHang")); } return(RedirectToAction("dang_ky", "KhachHang")); }
public IHttpActionResult deleteKhachHang(string id) { Models.KhachHang ncc = dc.KhachHangs.Find(id); if (ncc == null) { return(BadRequest()); } ncc.status = false; dc.SaveChanges(); return(Ok()); }
public MakeCallViewModel(Models.KhachHang kh) { System.Threading.ThreadPool.QueueUserWorkItem(((o) => { try { Customer = kh; LoaiCuocGois = db.LoaiCuocGois; } catch (Exception ex) { FireHandledExeptionAndLogErorrAsync(ErrorTemplates.GetDBInteractionError(ex)); } })); }
public JsonResult GetListCustomer() { List <Models.KhachHang> CustomerList = new List <Models.KhachHang>(); Database db = new Database(); DataTable dt = db.Query("select MaKH, HoTen from KhachHang; "); for (int i = 0; i < dt.Rows.Count; i++) { Models.KhachHang Customer = new Models.KhachHang(); Customer.MaKhachHang = dt.Rows[i]["MaKH"].ToString(); Customer.HoTenKhachHang = dt.Rows[i]["HoTen"].ToString(); CustomerList.Add(Customer); } return(Json(CustomerList)); }
public IHttpActionResult putKhachHang(Models.CKhachHang kh) { Models.KhachHang k = dc.KhachHangs.Find(kh.MaKh); if (k == null) { return(BadRequest()); } k.MaKH = kh.MaKh; k.TenKh = kh.TenKH; k.GioiTinh = kh.GioiTinh; k.Tuoi = kh.Tuoi; k.DiaChi = kh.DiaChi; k.SoDT = kh.SoDT; k.status = kh.status; dc.SaveChanges(); return(Ok()); }
public ExpandViewModel(Models.KhachHang kh) { Customer = kh; try { LoaiQuanHes = dbcg.LoaiQuanHes; WindowTitle = Customer.ConNguoi.HoTen; CbbLQHData = dbcg.LoaiQuanHes; CbbLoaiCuocGoiData = dbcg.LoaiCuocGois; } catch (Exception ex) { FireHandledExeptionAndLogErorrAsync(ErrorTemplates.GetDBInteractionError(ex)); } RefreshNTAsync(); RefreshCGAsync(); }
public IHttpActionResult getKhachHang(string id) { Models.KhachHang kh = dc.KhachHangs.Find(id); if (kh == null) { return(BadRequest()); } Models.CKhachHang l = new Models.CKhachHang() { MaKh = kh.MaKH, TenKH = kh.TenKh, GioiTinh = kh.GioiTinh, Tuoi = kh.Tuoi, DiaChi = kh.DiaChi, SoDT = kh.SoDT, status = kh.status }; return(Ok(l)); }
public ActionResult Index(Models.KhachHang model) { using (var context = new CT25Team24Entities()) { var account = context.KhachHangs.Where(acc => acc.Email == model.Email && acc.MatKhau == model.MatKhau).FirstOrDefault(); bool isValid = context.KhachHangs.Any(x => x.Email == model.Email && x.MatKhau == model.MatKhau); if (isValid) { Session["HoTen"] = account.HoTen; Session["Email"] = account.Email; FormsAuthentication.SetAuthCookie(model.Email, false); return(RedirectToAction("Index", "TrangChu")); } } ModelState.AddModelError("", "Invalid email and password!!"); Session["Message"] = "Sai Email hoặc mật khẩu!!"; return(View()); }
public void AddCustomer(string name, string address, bool?gioitinh, DateTime?ngaysinh, string phone1, string phone2, string CMND, string email) { KhachHang.ConNguoi = new Models.ConNguoi { HoTen = name, DiaChi = address, GioiTinh = gioitinh, NgaySinh = ngaysinh, Phone = phone1, Phone2 = phone2, CMND = CMND, Email = email }; db.KhachHangs.InsertOnSubmit(KhachHang); try { db.SubmitChanges(); KhachHang = new Models.KhachHang(); NguoiThans = new ObservableCollection <Models.NguoiThan>(); } catch (Exception ex) { FireHandledExeptionAndLogErorrAsync(ErrorTemplates.GetDBInteractionError(ex)); } }
public void saveOrder(BaseController context, string emailReceiver, string nameReceiver, string phoneReceiver, string addressReceiver, string note, string curency) { //Get member account by session email string emailSender = AccountHelper.getInstance().getLoggingInMemberEmail(context.HttpContext); Models.KhachHang member = AccountHelper.getInstance().getMemberAccountByEmail(context.db, emailSender); //Get shoppingCard in Sesion List <Models.ChiTietDonDatHang> listShoppingCard = getShoppingCardInSession(context); long totalPrice = 0; foreach (Models.ChiTietDonDatHang record in listShoppingCard.ToList()) { totalPrice += record.SoLuong.Value; } //Save order Models.DonDatHang order = new Models.DonDatHang(); order.IdKH = member.IdKH; order.NgayDat = DateTime.Now; order.NguoiNhan = emailReceiver; order.SdtNguoiNhan = phoneReceiver; order.DiaChiNguoiNhan = addressReceiver; order.TongTien = totalPrice; order.DaHuy = false; order.DaThanhToan = false; order.TinhTrangGiaoHang = false; context.db.DonDatHangs.Add(order); context.db.SaveChanges(); //Submit change here to get the id of inserted record. //Save order_details foreach (Models.ChiTietDonDatHang record in listShoppingCard.ToList()) { record.IdDDH = order.IdDDH; context.db.ChiTietDonDatHangs.Add(record); } context.db.SaveChanges(); }
public IHttpActionResult postKhachHang(Models.CKhachHang kh) { if (ModelState.IsValid == false) { return(BadRequest()); } Models.KhachHang k = new Models.KhachHang() { MaKH = kh.MaKh, TenKh = kh.TenKH, GioiTinh = kh.GioiTinh, Tuoi = kh.Tuoi, DiaChi = kh.DiaChi, SoDT = kh.SoDT, status = true }; dc.KhachHangs.Add(k); dc.SaveChanges(); return(Ok()); }
public JsonResult CustomerList() { List <Models.KhachHang> listCus = new List <Models.KhachHang>(); Database db = new Database(); DataTable dt = db.Query("select MaKH, HoTen, SDT, DiaChi, Email, LoaiKH, DiemTichLuy from KhachHang as kh, LoaiKhachHang as lkh where kh.MaLoaiKH = lkh.MaLoaiKH"); for (int i = 0; i < dt.Rows.Count; i++) { Models.KhachHang cus = new Models.KhachHang(); cus.MaKhachHang = dt.Rows[i]["MaKH"].ToString(); cus.HoTenKhachHang = dt.Rows[i]["HoTen"].ToString(); cus.SDT = dt.Rows[i]["SDT"].ToString(); cus.DiaChi = dt.Rows[i]["DiaChi"].ToString(); cus.Email = dt.Rows[i]["Email"].ToString(); cus.LoaiKH = dt.Rows[i]["LoaiKH"].ToString(); cus.DiemTichLuy = dt.Rows[i]["DiemTichLuy"].ToString(); listCus.Add(cus); } return(Json(listCus)); }
public Models.KhachHang getMemberAccountByEmail(Models.QLShopOnlineEntities data, string email) { Models.KhachHang result = data.KhachHangs.Where(n => n.Email.Equals(email)).Single(); return(result); }