public List<userroles> userrolesGetAll() { List<userroles> lstuserroles = new List<userroles>(); try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "userrolesGetAll").Tables[0]; if (dt.Rows.Count > 0) { int colUserRoleId = dt.Columns["UserRoleId"].Ordinal; int colUserRoleDescription = dt.Columns["UserRoleDescription"].Ordinal; for (int i = 0; dt.Rows.Count > i; i++) { userroles NewEnt = new userroles(); NewEnt.UserRoleId = Int32.Parse(dt.Rows[i].ItemArray[colUserRoleId].ToString()); NewEnt.UserRoleDescription = dt.Rows[i].ItemArray[colUserRoleDescription].ToString(); lstuserroles.Add(NewEnt); } } return lstuserroles; } catch(Exception ex) { throw ex; } }
public int userrolesAdd( userroles userroles) { try { return (int)SqlHelper.ExecuteScalar(SqlImplHelper.getConnectionString(), "userrolesAdd", userroles.UserRoleDescription); } catch(Exception ex) { throw ex; } }
public userroles userrolesGetById(int UserRoleId) { try { DataTable dt = SqlHelper.ExecuteDataset(SqlImplHelper.getConnectionString(), "userrolesGetById", UserRoleId).Tables[0]; userroles NewEnt = new userroles(); if(dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; NewEnt.UserRoleId = Int32.Parse(dr["UserRoleId"].ToString()); NewEnt.UserRoleDescription = dr["UserRoleDescription"].ToString(); } return NewEnt; } catch(Exception ex) { throw ex; } }
public bool userrolesUpdate( userroles userroles) { try { int update = SqlHelper.ExecuteNonQuery(SqlImplHelper.getConnectionString(), "userrolesUpdate", userroles.UserRoleId, userroles.UserRoleDescription); if (update > 0) { return true; } else { return false; } } catch(Exception ex) { throw ex; } }
protected void gvUsers_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = gvUsers.SelectedRow; users auxUser = new users(); usersBus oUser = new usersBus(); List<userrolesmapping> lstGroupRolesMapping = new List<userrolesmapping>(); userrolesmappingBus oRolesMapping = new userrolesmappingBus(); userroles auxRol = new userroles(); userrolesBus oRoles = new userrolesBus(); try { ddlUserGroup.SelectedValue = ((Label)row.FindControl("userGroupId")).Text; } catch { } if ((Label)row.FindControl("userId") != null) { userId.Value = ((Label)row.FindControl("userId")).Text; } else { userId.Value = ""; } if ((Label)row.FindControl("userName") != null) { txtUserName.Text = ((Label)row.FindControl("userName")).Text; } else { txtUserName.Text = ""; } if ((Label)row.FindControl("userLastName") != null) { txtUserLastName.Text = ((Label)row.FindControl("userLastName")).Text; } else { txtUserLastName.Text = ""; } if ((Label)row.FindControl("userFirstName") != null) { txtUserFirstName.Text = ((Label)row.FindControl("userFirstName")).Text; } else { txtUserFirstName.Text = ""; } if ((CheckBox)row.FindControl("userActive") != null) { chkActive.Checked = ((CheckBox)row.FindControl("userActive")).Checked; } else { chkActive.Checked = false; } auxUser = oUser.usersGetById(Convert.ToInt32(userId.Value)); txtMail.Text = auxUser.UserMail; txtPassword.Text = auxUser.UserPassword; txtSMS.Text = auxUser.UserSMSNumber; cblRolesRoles.Items.Clear(); lstGroupRolesMapping = oRolesMapping.userrolesmappingGetByUserGroupId(Convert.ToInt32(ddlUserGroup.SelectedValue)); if (lstGroupRolesMapping.Count > 0) { int index = 0; foreach (userrolesmapping rowRolMapping in lstGroupRolesMapping) { auxRol = oRoles.userrolesGetById(rowRolMapping.UserRoleId); cblRolesRoles.Items.Add(auxRol.UserRoleDescription); cblRolesRoles.Items[index].Selected = true; index++; } } activateFields(true, false); btnSave.Enabled = true; }
protected void ddlUserGroup_SelectedIndexChanged(object sender, EventArgs e) { List<userrolesmapping> lstGroupRolesMapping = new List<userrolesmapping>(); userrolesmappingBus oRolesMapping = new userrolesmappingBus(); userroles auxRol = new userroles(); userrolesBus oRoles = new userrolesBus(); cblRolesRoles.Items.Clear(); if (lstGroupRolesMapping.Count > 0) { int index = 0; foreach (userrolesmapping rowRolMapping in lstGroupRolesMapping) { auxRol = oRoles.userrolesGetById(rowRolMapping.UserRoleId); cblRolesRoles.Items.Add(auxRol.UserRoleDescription); cblRolesRoles.Items[index].Selected = true; index++; } } }
public bool userrolesUpdate(userroles userroles) { userrolesImpl ouserrolesImpl = new userrolesImpl(); return ouserrolesImpl.userrolesUpdate( userroles); }
public int userrolesAdd(userroles userroles) { userrolesImpl ouserrolesImpl = new userrolesImpl(); return ouserrolesImpl.userrolesAdd( userroles); }