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;
}
}
private void LoadData()
{
List <usergroup> data_usergr = Businesses.usergroup.GetAll();
List <usergroup> usergroups = new List <usergroup>();
usergroup all_usergr = new usergroup();
all_usergr.name = "Tất cả";
all_usergr.idgroup = "";
all_usergr.users = null;
usergroups.Add(all_usergr);
usergroups.AddRange(data_usergr);
var bindingSource1 = new BindingSource();
bindingSource1.DataSource = usergroups;
cboRole.DataSource = bindingSource1.DataSource;
cboRole.DisplayMember = "name";
cboRole.ValueMember = "idgroup";
guna2DataGridView1.Columns[1].DefaultCellStyle.Format = "dd/MM/yyyy";
guna2DataGridView1.AutoGenerateColumns = false;
guna2DataGridView1.DataSource = users;
thread.Join();
}
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 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;
}
}
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;
}
}
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);
}
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));
}
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;
}
}
