public List<usergroup> usergroupGetAll()
{
List<usergroup> lstusergroup = new List<usergroup>();
try
{
DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "usergroupGetAll").Tables[0];
if (dt.Rows.Count > 0)
{
int colUserGroupId = dt.Columns["UserGroupId"].Ordinal;
int colUserGroupDescription = dt.Columns["UserGroupDescription"].Ordinal;
for (int i = 0; dt.Rows.Count > i; i++)
{
usergroup NewEnt = new usergroup();
NewEnt.UserGroupId = Int32.Parse(dt.Rows[i].ItemArray[colUserGroupId].ToString());
NewEnt.UserGroupDescription = dt.Rows[i].ItemArray[colUserGroupDescription].ToString();
lstusergroup.Add(NewEnt);
}
}
return lstusergroup;
}
catch(Exception ex)
{
throw ex;
}
}
public int usergroupAdd( usergroup usergroup)
{
try
{
return (int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "usergroupAdd",
usergroup.UserGroupDescription);
}
catch(Exception ex)
{
throw ex;
}
}
public usergroup usergroupGetById(int UserGroupId)
{
try
{
DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "usergroupGetById",
UserGroupId).Tables[0];
usergroup NewEnt = new usergroup();
if(dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
NewEnt.UserGroupId = Int32.Parse(dr["UserGroupId"].ToString());
NewEnt.UserGroupDescription = dr["UserGroupDescription"].ToString();
}
return NewEnt;
}
catch(Exception ex)
{
throw ex;
}
}
public bool usergroupUpdate( usergroup usergroup)
{
try
{
int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "usergroupUpdate",
usergroup.UserGroupId,
usergroup.UserGroupDescription);
if (update > 0)
{
return true;
}
else
{
return false;
}
}
catch(Exception ex)
{
throw ex;
}
}
protected void getUsersData()
{
DataTable dttUsers = new DataTable();
dttUsers.Columns.Add(new DataColumn("userId", System.Type.GetType("System.Int32")));
dttUsers.Columns.Add(new DataColumn("userName", System.Type.GetType("System.String")));
dttUsers.Columns.Add(new DataColumn("userLastName", System.Type.GetType("System.String")));
dttUsers.Columns.Add(new DataColumn("userFirstName", System.Type.GetType("System.String")));
dttUsers.Columns.Add(new DataColumn("userGroupId", System.Type.GetType("System.Int32")));
dttUsers.Columns.Add(new DataColumn("userGroupDescription", System.Type.GetType("System.String")));
dttUsers.Columns.Add(new DataColumn("userActive", System.Type.GetType("System.Boolean")));
List<users> lstUsers = new List<users>();
usersBus oUsers = new usersBus();
usergroup auxGroup = new usergroup();
usergroupBus oGroup = new usergroupBus();
lstUsers = oUsers.usersGetAll();
if (lstUsers.Count > 0)
{
foreach (users row in lstUsers)
{
auxGroup = oGroup.usergroupGetById(row.UserGroupId);
dttUsers.Rows.Add(row.UserId,
row.UserName,
row.UserLastName,
row.UserFirstName,
row.UserGroupId,
auxGroup.UserGroupDescription,
row.UserActive);
}
gvUsers.DataSource = dttUsers;
gvUsers.DataBind();
}
}
public bool usergroupUpdate(usergroup usergroup)
{
usergroupImpl ousergroupImpl = new usergroupImpl();
return ousergroupImpl.usergroupUpdate( usergroup);
}
public int usergroupAdd(usergroup usergroup)
{
usergroupImpl ousergroupImpl = new usergroupImpl();
return ousergroupImpl.usergroupAdd( usergroup);
}