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;
}
