public List <UsersInfo> UsersInfo_Paging(string CurentPage, string PageSize)
{
List <DataAccess.UsersInfo> list = new List <DataAccess.UsersInfo>();
DataAccess.UsersInfo obj = new DataAccess.UsersInfo();
DbCommand cmd = db.GetStoredProcCommand("Users_SelectPage", CurentPage, PageSize);
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.UsersInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public List <UsersInfo> UsersInfo_GetByAll()
{
List <DataAccess.UsersInfo> list = new List <DataAccess.UsersInfo>();
DataAccess.UsersInfo obj = new DataAccess.UsersInfo();
DbCommand cmd = db.GetStoredProcCommand("Users_SelectAll");
using (IDataReader dr = db.ExecuteReader(cmd))
{
while (dr.Read())
{
list.Add(obj.UsersInfoIDataReader(dr));
}
dr.Close();
dr.Dispose();
}
return(list);
}
public UsersInfo UsersInfoIDataReader(IDataReader dr)
{
DataAccess.UsersInfo obj = new DataAccess.UsersInfo();
obj.UserID = (dr["UserID"] is DBNull) ? string.Empty : dr["UserID"].ToString();
obj.UserName = (dr["UserName"] is DBNull) ? string.Empty : dr["UserName"].ToString();
obj.Password = (dr["Password"] is DBNull) ? string.Empty : dr["Password"].ToString();
obj.FullName = (dr["FullName"] is DBNull) ? string.Empty : dr["FullName"].ToString();
obj.Gender = (dr["Gender"] is DBNull) ? string.Empty : dr["Gender"].ToString();
obj.Avatar = (dr["Avatar"] is DBNull) ? string.Empty : dr["Avatar"].ToString();
obj.Birthday = (dr["Birthday"] is DBNull) ? string.Empty : dr["Birthday"].ToString();
obj.Email = (dr["Email"] is DBNull) ? string.Empty : dr["Email"].ToString();
obj.Address = (dr["Address"] is DBNull) ? string.Empty : dr["Address"].ToString();
obj.MobilePhone = (dr["MobilePhone"] is DBNull) ? string.Empty : dr["MobilePhone"].ToString();
obj.IdentityCard = (dr["IdentityCard"] is DBNull) ? string.Empty : dr["IdentityCard"].ToString();
obj.LastLoggedOn = (dr["LastLoggedOn"] is DBNull) ? string.Empty : dr["LastLoggedOn"].ToString();
obj.CreatedDate = (dr["CreatedDate"] is DBNull) ? string.Empty : dr["CreatedDate"].ToString();
obj.GroupID = (dr["GroupID"] is DBNull) ? string.Empty : dr["GroupID"].ToString();
obj.Level = (dr["Level"] is DBNull) ? string.Empty : dr["Level"].ToString();
obj.Active = (dr["Active"] is DBNull) ? string.Empty : dr["Active"].ToString();
obj.Ord = (dr["Ord"] is DBNull) ? string.Empty : dr["Ord"].ToString();
obj.Admin = (dr["Admin"] is DBNull) ? string.Empty : dr["Admin"].ToString();
return(obj);
}
protected void Update_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
DataAccess.UsersInfo obj = new DataAccess.UsersInfo();
obj.UserID = Id;
obj.FullName = txtName.Text;
obj.UserName = txtUsername.Text;
obj.Gender = rdGender.SelectedValue;
obj.Avatar = txtAvatar.Text;
obj.Birthday = cldBirthday.SelectedDate.ToString().Trim();
//obj.Birthday = cldBirthday.SelectedDate;
obj.Email = txtEmail.Text;
obj.Address = txtAddress.Text;
obj.MobilePhone = txtPhoneNumber.Text;
obj.GroupID = ddlGroupUser.SelectedValue;
obj.Level = ddlGroupUser.SelectedValue;
obj.Admin = txtAdmin.Text != "" ? txtAdmin.Text : "1";
obj.Ord = txtOrd.Text != "" ? txtOrd.Text : "1";
obj.Active = chkActive.Checked ? "1" : "0";
if (Insert == true)
{
obj.Password = md5(txtPassword.Text);
//UsersService.UsersInfo_Insert(obj);
}
else
{
obj.Password = md5(txtPassword.Text != "" ? StringClass.Encrypt(txtPassword.Text) : Password);
UsersService.UsersInfo_Update(obj);
}
BindGrid();
pnView.Visible = true;
pnUpdate.Visible = false;
Level = "";
Insert = false;
}
}
