public List <PartnerInfo> GetList(int pageIndex, int pageSize, out int total) { List <PartnerInfo> 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_Partner_GetList", param, out comx); if (r != null) { list = new List <PartnerInfo>(); while (r.Read()) { var info = new PartnerInfo(); if (r["Id"] != null && !r["Id"].ToString().Equals("")) { info.Id = Int32.Parse(r["Id"].ToString()); } if (r["Name"] != null && !r["Name"].ToString().Equals("")) { info.Name = r["Name"].ToString(); } if (r["Link"] != null && !r["Link"].ToString().Equals("")) { info.Link = r["Link"].ToString(); } if (r["Description"] != null && !r["Description"].ToString().Equals("")) { info.Description = r["Description"].ToString(); } if (r["Image"] != null && !r["Image"].ToString().Equals("")) { info.Image = r["Image"].ToString(); } if (r["Alt"] != null && !r["Alt"].ToString().Equals("")) { info.Alt = r["Alt"].ToString(); } list.Add(info); } r.Close(); r.Dispose(); t = int.Parse(comx.Parameters[2].Value.ToString()); } total = t; return(list); }
public List <UserInfo> GetList(int pageIndex, int pageSize, out int total) { List <UserInfo> list = null; int t = 0; SqlParameter[] param = { new SqlParameter("@pageIndex", pageIndex), new SqlParameter("@pageSize", pageSize), new SqlParameter("@totalrow", DbType.Int32) { Direction = ParameterDirection.Output } }; SqlCommand comx; IDataReader r = DataHelper.ExecuteReader(Config.ConnectString, "usp_tblUser_GetList", param, out comx); if (r != null) { list = new List <UserInfo>(); while (r.Read()) { var info = new UserInfo(); if (r["Id"] != null && !r["Id"].ToString().Equals("")) { info.Id = Int32.Parse(r["Id"].ToString()); } if (r["Username"] != null && !r["Username"].ToString().Equals("")) { info.Username = r["Username"].ToString(); } if (r["Password"] != null && !r["Password"].ToString().Equals("")) { info.Password = r["Password"].ToString(); } if (r["Fullname"] != null && !r["Fullname"].ToString().Equals("")) { info.Fullname = r["Fullname"].ToString(); } if (r["Status"] != null && !r["Status"].ToString().Equals("")) { info.Status = Convert.ToInt16(r["Status"].ToString()); } list.Add(info); } r.Close(); r.Dispose(); t = int.Parse(comx.Parameters[2].Value.ToString()); } total = t; return(list); }
public PartnerInfo GetInfo(int id) { PartnerInfo info = null; SqlParameter[] param = { new SqlParameter("@Id", id) }; var r = DataHelper.ExecuteReader(Config.ConnectString, "new_Partner_GetById", param); if (r != null) { info = new PartnerInfo(); while (r.Read()) { if (r["Id"] != null && !r["Id"].ToString().Equals("")) { info.Id = Int32.Parse(r["Id"].ToString()); } if (r["Name"] != null && !r["Name"].ToString().Equals("")) { info.Name = r["Name"].ToString(); } if (r["Link"] != null && !r["Link"].ToString().Equals("")) { info.Link = r["Link"].ToString(); } if (r["Description"] != null && !r["Description"].ToString().Equals("")) { info.Description = r["Description"].ToString(); } if (r["Image"] != null && !r["Image"].ToString().Equals("")) { info.Image = r["Image"].ToString(); } if (r["Alt"] != null && !r["Alt"].ToString().Equals("")) { info.Alt = r["Alt"].ToString(); } } r.Close(); r.Dispose(); } return(info); }
public List <PartnerInfo> GetList() { List <PartnerInfo> list = null; var r = DataHelper.ExecuteReader(Config.ConnectString, "new_Partner_GetList_All"); if (r != null) { list = new List <PartnerInfo>(); while (r.Read()) { var info = new PartnerInfo(); if (r["Id"] != null && !r["Id"].ToString().Equals("")) { info.Id = Int32.Parse(r["Id"].ToString()); } if (r["Name"] != null && !r["Name"].ToString().Equals("")) { info.Name = r["Name"].ToString(); } if (r["Link"] != null && !r["Link"].ToString().Equals("")) { info.Link = r["Link"].ToString(); } if (r["Description"] != null && !r["Description"].ToString().Equals("")) { info.Description = r["Description"].ToString(); } if (r["Image"] != null && !r["Image"].ToString().Equals("")) { info.Image = r["Image"].ToString(); } if (r["Alt"] != null && !r["Alt"].ToString().Equals("")) { info.Alt = r["Alt"].ToString(); } list.Add(info); } r.Close(); r.Dispose(); } return(list); }
public UserInfo UpdateProfile(UserInfo infos) { UserInfo info = null; SqlParameter[] param = { new SqlParameter("@Id", infos.Id), new SqlParameter("@Username", infos.Username), new SqlParameter("@Password", infos.Password), new SqlParameter("@Fullname", infos.Fullname) }; var r = DataHelper.ExecuteReader(Config.ConnectString, "tuan_user_UpdateProfile", param); if (r != null) { info = new UserInfo(); while (r.Read()) { if (r["Id"] != null && !r["Id"].ToString().Equals("")) { info.Id = int.Parse(r["Id"].ToString()); } if (r["Username"] != null && !r["Username"].ToString().Equals("")) { info.Username = r["Username"].ToString(); } if (r["Password"] != null && !r["Password"].ToString().Equals("")) { info.Password = r["Password"].ToString(); } if (r["Fullname"] != null && !r["Fullname"].ToString().Equals("")) { info.Fullname = r["Fullname"].ToString(); } if (r["Status"] != null && !r["Status"].ToString().Equals("")) { info.Status = Convert.ToInt16(r["Status"].ToString()); } } } return(info); }
public UserInfo GetInfo(int id) { UserInfo info = null; SqlParameter[] param = { new SqlParameter("@id", id) }; IDataReader r = DataHelper.ExecuteReader(Config.ConnectString, "tuan_User_GetById", param); if (r != null) { info = new UserInfo(); while (r.Read()) { if (r["Id"] != null && !r["Id"].ToString().Equals("")) { info.Id = int.Parse(r["Id"].ToString()); } if (r["Username"] != null && !r["Username"].ToString().Equals("")) { info.Username = r["Username"].ToString(); } if (r["Password"] != null && !r["Password"].ToString().Equals("")) { info.Password = r["Password"].ToString(); } if (r["Fullname"] != null && !r["Fullname"].ToString().Equals("")) { info.Fullname = r["Fullname"].ToString(); } if (r["Status"] != null && !r["Status"].ToString().Equals("")) { info.Status = Convert.ToInt16(r["Status"].ToString()); } } r.Close(); r.Dispose(); } return(info); }
public List <UserInfo> GetList() { List <UserInfo> list = null; IDataReader r = DataHelper.ExecuteReader(Config.ConnectString, "tuan_tblUser_GetList_All", null); if (r != null) { list = new List <UserInfo>(); while (r.Read()) { var info = new UserInfo(); if (r["Id"] != null && !r["Id"].ToString().Equals("")) { info.Id = Int32.Parse(r["Id"].ToString()); } if (r["Username"] != null && !r["Username"].ToString().Equals("")) { info.Username = r["Username"].ToString(); } if (r["Password"] != null && !r["Password"].ToString().Equals("")) { info.Password = r["Password"].ToString(); } if (r["Fullname"] != null && !r["Fullname"].ToString().Equals("")) { info.Fullname = r["Fullname"].ToString(); } if (r["Status"] != null && !r["Status"].ToString().Equals("")) { info.Status = Convert.ToInt16(r["Status"].ToString()); } list.Add(info); } r.Close(); r.Dispose(); } return(list); }