public void Update(Roles obj) { _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = UPDATERoles; #region [Parameters] SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int); parameterID.Value = obj.ID; parameterID.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterID); SqlParameter parameterName = new SqlParameter(PN_NAME, SqlDbType.NVarChar); parameterName.Value = obj.Name; parameterName.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterName); #endregion; _connection.Open(); _command.ExecuteNonQuery(); _connection.Close(); }
public int Add(Roles obj) { _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = INSERTRoles; #region [Parameters] SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int); parameterID.Value = obj.ID; parameterID.Direction = ParameterDirection.Output; _command.Parameters.Add(parameterID); SqlParameter parameterName = new SqlParameter(PN_NAME, SqlDbType.NVarChar); parameterName.Value = obj.Name; parameterName.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterName); #endregion; _connection.Open(); _command.ExecuteNonQuery(); _connection.Close(); obj.ID = Convert.ToInt32(parameterID.Value); return obj.ID; }
public void PopulateRoles(SqlDataReader _dtr, Roles obj) { int columnIndex = 0; columnIndex = _dtr.GetOrdinal(RolesDataMapper.CN_ID); if (!_dtr.IsDBNull(columnIndex)) { obj.ID = _dtr.GetInt32((columnIndex)); } columnIndex = _dtr.GetOrdinal(RolesDataMapper.CN_NAME); if (!_dtr.IsDBNull(columnIndex)) { obj.Name = _dtr.GetString((columnIndex)); } }
private void EditMode() { if (ObjectID > 0) { Roles cat = new Roles(); cat = RolesManager.GetByID(ObjectID); if (null == cat) return; txtName.Text = cat.Name; plcControls.Visible = true; } }
void btnSaveUpdate_Click(object sender, EventArgs e) { Roles role = new Roles(); if (ObjectID <= 0) { try { role.Name = txtName.Text; RolesManager.Add(role); AddMode(); dvProblems.InnerText = "Saved Successfully"; } catch (Exception ex) { dvProblems.InnerText = ex.ToString(); } } else { try { role = RolesManager.GetByID(ObjectID); if (null == role) { dvProblems.InnerText = Resources.ExpressCMS.ResourceManager.GetString(ConstantsManager.UnknowErronOccures); return; } role.Name = txtName.Text; RolesManager.Update(role); EditMode(); dvProblems.InnerText = "Saved Successfully"; } catch (Exception ex) { dvProblems.InnerText = ex.ToString(); } } BindGrid(); }
public Roles GetRoles(SqlDataReader _dtr, IList<Roles> colobj) { Roles obj = colobj.Where(t => t.ID == Convert.ToInt32(_dtr[CN_ID].ToString())).SingleOrDefault(); if (null == obj) { obj = new Roles(); colobj.Add(obj); } return obj; }
public IList<Roles> GetRolesByUserID(int userID) { Roles obj = null; IList<Roles> colobj = new List<Roles>(); _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = "[usp_SelectRoleforUser]"; #region [Parameters] SqlParameter parameteruserID = new SqlParameter("UserID", SqlDbType.Int); parameteruserID.Value = userID; parameteruserID.Direction = ParameterDirection.Input; _command.Parameters.Add(parameteruserID); #endregion; _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new Roles(); colobj = new List<Roles>(); while (_dtreader.Read()) { obj = GetRoles(_dtreader, colobj); GetEntityFromReader(_dtreader, obj); } } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return colobj; }
public IList<Roles> GetAll() { Roles obj = null; IList<Roles> colobj = null; _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = SELECTALLRoles; _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new Roles(); colobj = new List<Roles>(); while (_dtreader.Read()) { obj = GetRoles(_dtreader, colobj); GetEntityFromReader(_dtreader, obj); } } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return colobj; }
private void GetEntityFromReader(SqlDataReader _dtr, Roles obj) { PopulateRoles(_dtr, obj); }
public Roles GetByID(int ID) { Roles obj = null; _connection.ConnectionString = _ConnectionString; _command.Connection = _connection; _command.CommandType = CommandType.StoredProcedure; _command.CommandText = SELECTRoles; #region [Parameters] SqlParameter parameterID = new SqlParameter(PN_ID, SqlDbType.Int); parameterID.Value = ID; parameterID.Direction = ParameterDirection.Input; _command.Parameters.Add(parameterID); #endregion; _connection.Open(); try { using (_dtreader = _command.ExecuteReader()) { if (_dtreader != null && _dtreader.HasRows) { obj = new Roles(); if (_dtreader.Read()) GetEntityFromReader(_dtreader, obj); } } } catch (Exception ex) { throw ex; } finally { _dtreader.Close(); _connection.Close(); } return obj; }
public static void Update(Roles obj) { RolesDataMapper objCaller = new RolesDataMapper(); objCaller.Update(obj); }
public static int Add(Roles obj) { RolesDataMapper objCaller = new RolesDataMapper(); return objCaller.Add(obj); }