public CustormerInfo Login(string email, string password)
{
CustormerInfo info = null;
SqlParameter[] param =
{
new SqlParameter("@Email", email),
new SqlParameter("@password", password)
};
var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_tblCustormer_Login", param);
if (r != null)
{
info = new CustormerInfo();
while (r.Read())
{
info.id = Int32.Parse(r["id"].ToString());
info.Email = r["Email"].ToString();
info.FirstName = r["FirstName"].ToString();
info.Lastname = r["Lastname"].ToString();
info.Phone = r["Phone"].ToString();
info.Address = r["Address"].ToString();
info.Active = Convert.ToBoolean(r["Active"]);
info.CreateDate = Convert.ToDateTime(r["CreateDate"]);
}
r.Close();
r.Dispose();
}
return(info);
}
public int Add(CustormerInfo info)
{
SqlParameter[] param =
{
new SqlParameter("@Email", info.Email),
new SqlParameter("@FirstName", info.FirstName),
new SqlParameter("@Lastname", info.Lastname),
new SqlParameter("@Password", info.Password),
new SqlParameter("@Phone", info.Phone),
new SqlParameter("@Address", info.Address),
new SqlParameter("@Active", info.Active)
};
return(int.Parse(DataHelper.ExecuteScalar(Config.ConnectString, "usp_tblCustormer_Add", param).ToString()));
}
public int Update(CustormerInfo info)
{
SqlParameter[] param =
{
new SqlParameter("@id", info.id),
//new SqlParameter("@Email", info.Email),
new SqlParameter("@FirstName", info.FirstName),
new SqlParameter("@Lastname", info.Lastname),
//new SqlParameter("@Password", info.Password),
new SqlParameter("@Phone", info.Phone),
new SqlParameter("@Address", info.Address),
new SqlParameter("@Active", info.Active)
};
return(DataHelper.ExecuteNonQuery(Config.ConnectString, "usp_tblCustormer_Update", param));
}
public List <CustormerInfo> GetList(int pageIndex, int pageSize, out int total)
{
List <CustormerInfo> list = null;
var t = 0;
SqlParameter[] param =
{
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@totalrow", DbType.Int32)
{
Direction = ParameterDirection.Output
}
};
SqlCommand comx;
var r = DataHelper.ExecuteReader(Config.ConnectString, "usp_tblCustormer_GetList", param, out comx);
if (r != null)
{
list = new List <CustormerInfo>();
while (r.Read())
{
var info = new CustormerInfo();
info.id = Int32.Parse(r["id"].ToString());
info.Email = r["Email"].ToString();
info.FirstName = r["FirstName"].ToString();
info.Lastname = r["Lastname"].ToString();
//info.Password = r["Password"].ToString();
info.Phone = r["Phone"].ToString();
info.Address = r["Address"].ToString();
info.Active = Convert.ToBoolean(r["Active"]);
info.CreateDate = Convert.ToDateTime(r["CreateDate"]);
list.Add(info);
}
r.Close();
r.Dispose();
t = int.Parse(comx.Parameters[2].Value.ToString());
}
total = t;
return(list);
}
protected void Unnamed1_Click(object sender, EventArgs e)
{
int id = (int)Session["id"];
CustormerInfo info = new CustormerInfo
{
id = id,
FirstName = TB_FirstName.Text.Trim(),
Lastname = TB_LastName.Text.Trim(),
Phone = TB_Phone.Text.Trim(),
Address = TB_Address.Text.Trim(),
Active = true
};
CustormerImpl.Instance.Update(info);
if (TB_Password.Text.Trim().Length > 0)
{
CustormerImpl.Instance.UpdatePassword(id, TB_Password.Text.Trim());
}
}
