public ActionResult Register(Register model) { OKhachHang khachHang = new OKhachHang { TenKhach = model.FullName, DienThoai = model.Phone, Email = model.Email, }; khService.Add(khachHang); int idKhach = khService.GetLastId(); OAccount account = new OAccount { Email = khachHang.Email, MaKhach = idKhach, MatKhau = model.Password, TenDN = model.UserName, MaQuyen = 3, }; if (accountService.Register(account)) { Session["Account"] = account; //Random rd = new Random(); //string strRandom; //strRandom = rd.Next(1, 1000).ToString(); //Session["RandomText"] = strRandom; //SendMailActive(account.Email, strRandom); return(RedirectToAction("Index", "Home")); } return(View("Login")); }
public void Add(OKhachHang item) { conn.connect(); var comm = new SqlCommand("KhachHang_Add", conn.db); comm.CommandType = CommandType.StoredProcedure; if (comm == null) { return; } comm.Parameters.Add("@ten", SqlDbType.NVarChar).Value = item.TenKhach; comm.Parameters.Add(new SqlParameter("@diachi", item.DiaChi ?? (object)DBNull.Value)); comm.Parameters.Add("@dienthoai", SqlDbType.NVarChar).Value = item.DienThoai; comm.Parameters.Add("@email", SqlDbType.NVarChar).Value = item.Email; comm.ExecuteNonQuery(); }
public OKhachHang GetById(int id) { conn.connect(); var comm = new SqlCommand("KhachHang_GetById", conn.db); comm.CommandType = CommandType.StoredProcedure; if (comm == null) { return(null); } comm.Parameters.Add("@MaKhach", SqlDbType.Int).Value = id; DataTable dt = new DataTable(); dt.Load(comm.ExecuteReader()); OKhachHang item = new OKhachHang(); item = Help.DAL.ConvertDataTable <OKhachHang>(dt).FirstOrDefault(); return(item); }
public bool Update(OKhachHang item) { conn.connect(); var comm = new SqlCommand("KhachHang_Edit", conn.db); comm.CommandType = CommandType.StoredProcedure; if (comm == null) { return(false); } comm.Parameters.Add("@ma", SqlDbType.Int).Value = item.MaKhach; comm.Parameters.Add("@ten", SqlDbType.NVarChar).Value = item.TenKhach; comm.Parameters.Add(new SqlParameter("@diachi", item.DiaChi ?? (object)DBNull.Value)); comm.Parameters.Add("@dienthoai", SqlDbType.NVarChar).Value = item.DienThoai; comm.Parameters.Add("@email", SqlDbType.NVarChar).Value = item.Email; if (comm.ExecuteNonQuery() != 0) { return(true); } return(false); }