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