public TaiKhoanConvert Convert(TaiKhoan a)
{
TaiKhoanConvert temp = new TaiKhoanConvert();
temp.IdUser = a.IdUser;
temp.LastName = a.LastName;
temp.Address = a.Address;
temp.Birth = a.Birth.ToString("dd/MM/yyyy");
temp.Email = a.Email;
temp.FirtName = a.FirtName;
temp.PassWord = a.PassWord;
temp.Phone = a.Phone;
temp.Picture = a.Picture;
temp.Provider = a.Provider;
temp.Role = a.Role;
temp.Sex = a.Sex;
return(temp);
}
public TaiKhoanConvert getTaiKhoan(string email, string provider)
{
connect();
string query = "SELECT * FROM TAIKHOAN WHERE Email = '" + email + "' AND NhaCungCap = '" + provider + "'";
adapter = new SqlDataAdapter(query, connection);
DataSet dataset = new DataSet();
adapter.Fill(dataset);
ArrayList ls = ConvertDataSetToArrayList(dataset);
TaiKhoan arr = new TaiKhoan();
foreach (Object o in ls)
{
arr = (TaiKhoan)o;
break;
}
disconnect();
TaiKhoanConvert temp = new TaiKhoanConvert();
temp = Convert(arr);
return(temp);
}
public TaiKhoanConvert getTaiKhoan(int id)
{
connect();
string query = "SELECT * FROM TAIKHOAN WHERE IdUser = " + id;
adapter = new SqlDataAdapter(query, connection);
DataSet dataset = new DataSet();
adapter.Fill(dataset);
ArrayList ls = ConvertDataSetToArrayList(dataset);
TaiKhoan arr = new TaiKhoan();
foreach (Object o in ls)
{
arr = (TaiKhoan)o;
break;
}
disconnect();
TaiKhoanConvert temp = new TaiKhoanConvert();
temp = Convert(arr);
return(temp);
}
public TaiKhoanConvert getTaiKhoan(string email, string password, string provider)
{
string result = "Null";
if (string.IsNullOrEmpty(email) && string.IsNullOrEmpty(password) &&
(HttpContext.Current.Session.Count == 0 || HttpContext.Current.Session["UserOnline"] == null))
{
return(null);
}
if (HttpContext.Current.Session.Count > 0 && HttpContext.Current.Session["UserOnline"] != null && HttpContext.Current.Session["UserOnline"].ToString() == "On")
{
string type = "";
if (HttpContext.Current.Session["Auth"].ToString() == "Admin")
{
type = "Admin";
}
else
{
type = "Customer";
}
result = type;
}
connect();
string query = "SELECT * FROM TAIKHOAN WHERE Email = '" + email + "' AND MatKhau = '" + password + "' AND NhaCungCap = '" + provider + "'";
adapter = new SqlDataAdapter(query, connection);
DataSet dataset = new DataSet();
adapter.Fill(dataset);
ArrayList ls = ConvertDataSetToArrayList(dataset);
TaiKhoan arr = new TaiKhoan();
foreach (Object o in ls)
{
arr = (TaiKhoan)o;
break;
}
try
{
if (arr.Email != null)
{
HttpContext.Current.Session["AccountId"] = arr.Email;
HttpContext.Current.Session["UserOnline"] = "On";
if (arr.Role == "Admin")
{
HttpContext.Current.Session["Auth"] = "Admin";
}
else
{
HttpContext.Current.Session["Auth"] = "Customer";
}
}
}
catch (NotImplementedException implementedException)
{
}
disconnect();
TaiKhoanConvert temp = new TaiKhoanConvert();
temp = Convert(arr);
return(temp);
}