public bool EditGroup(UserGroupBO obj) { bool isUpdate = false; DBEgine dbEgine = new DBEgine(); dbEgine.DBOpen(); SqlParameter[] parms = new SqlParameter[3]; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "in_groupId"; p1.SqlDbType = SqlDbType.Int; p1.Direction = ParameterDirection.Input; p1.Value = obj.GroupId; parms[0] = p1; SqlParameter p2 = new SqlParameter(); p2.ParameterName = "in_groupName"; p2.SqlDbType = SqlDbType.NVarChar; p2.Size = 50; p2.Direction = ParameterDirection.Input; p2.Value = obj.GroupName; parms[1] = p2; SqlParameter p3 = new SqlParameter(); p3.ParameterName = "in_modifiedUser"; p3.SqlDbType = SqlDbType.Int; p3.Direction = ParameterDirection.Input; p3.Value = obj.ModifiedUser; parms[2] = p3; dbEgine.ExecNonQueryStoredProc("UM_EditGroup", parms); isUpdate = true; dbEgine.DBClose(); return isUpdate; }
public UserGroupBO GetUserGroupByGroupId(UserGroupBO obj) { DBEgine dbEgine = new DBEgine(); var objUserGroupBO = new UserGroupBO(); try { dbEgine.DBOpen(); SqlParameter[] parms = new SqlParameter[1]; SqlParameter p1 = new SqlParameter(); p1.ParameterName = "in_groupId"; p1.SqlDbType = SqlDbType.Int; p1.Direction = ParameterDirection.Input; p1.Value = obj.GroupId; parms[0] = p1; SqlDataReader drUserGroup = dbEgine.ExecuteReader("UM_LoadGroupsByGroupId", parms); if (drUserGroup != null && drUserGroup.HasRows) { while (drUserGroup.Read()) { objUserGroupBO = (FillGroup(drUserGroup)); } } dbEgine.DBClose(); } catch { throw; } finally { dbEgine.DBClose(); } return objUserGroupBO; }
private UserGroupBO FillGroup(SqlDataReader dr) { var userGroupBO = new UserGroupBO(); userGroupBO.GroupId = dr.GetInt32(dr.GetOrdinal("GroupId")); userGroupBO.GroupName = dr.GetValue(dr.GetOrdinal("GroupName")).ToString(); return userGroupBO; }