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