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 int Delete(int id)
{
SqlParameter[] param =
{
new SqlParameter("@Id", id)
};
return(DataHelper.ExecuteNonQuery(Config.ConnectString, "new_Partner_Delete", param));
}
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 int Add(UserInfo info)
{
SqlParameter[] param =
{
new SqlParameter("@Username", info.Username),
new SqlParameter("@Password", info.Password),
new SqlParameter("@Fullname", info.Fullname),
new SqlParameter("@Status", info.Status)
};
return(int.Parse(DataHelper.ExecuteScalar(Config.ConnectString, "tuan_User_Add", param).ToString()));
}
public int Add(PartnerInfo info)
{
SqlParameter[] param =
{
new SqlParameter("@Name", info.Name),
new SqlParameter("@Link", info.Link),
new SqlParameter("@Description", info.Description),
new SqlParameter("@Image", info.Image),
new SqlParameter("@Alt", info.Alt)
};
return(int.Parse(DataHelper.ExecuteScalar(Config.ConnectString, "new_Partner_Add", param).ToString()));
}
public int Update(UserInfo info)
{
SqlParameter[] param =
{
new SqlParameter("@Id", info.Id),
new SqlParameter("@Username", info.Username),
new SqlParameter("@Password", info.Password),
new SqlParameter("@Fullname", info.Fullname),
new SqlParameter("@Status", info.Status)
};
return(DataHelper.ExecuteNonQuery(Config.ConnectString, "tuan_tblUser_Update", param));
}
public int Update(PartnerInfo info)
{
SqlParameter[] param =
{
new SqlParameter("@Id", info.Id)
, new SqlParameter("@Name",info.Name),
new SqlParameter("@Link", info.Link),
new SqlParameter("@Description", info.Description),
new SqlParameter("@Image", info.Image),
new SqlParameter("@Alt", info.Alt)
};
return(DataHelper.ExecuteNonQuery(Config.ConnectString, "new_Partner_Update", param));
}
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);
}
