private string SaveTeamHiearchyTree()
{
JavaScriptSerializer jss = new JavaScriptSerializer();
var paramDes = jss.Deserialize <IEnumerable <AppDivisions> >(Request["queryParam"]);
if (paramDes != null)
{
using (MainDBUnitWorkContext context = new MainDBUnitWorkContext())
{
ITeamRepository teamRepository = new TeamRepository(context);
ISegmentRepository segRepository = new SegmentRepository(context);
// Remove current structure from the database scheme level
IDivisionRepository repository = new DivisionRepository(context);
AppDivisionSegmentsService service = new AppDivisionSegmentsService(teamRepository, segRepository, repository);
#region Submit the new changes
return(jss.Serialize(service.SaveTeamSiteHierarchy(paramDes)));
#endregion
}
}
return(null);
}
public ChangeActivityOutput <DivisionDto, long> ChangeActivity(ChangeActivityInput input)
{
DivisionRepository.Includes.Add(r => r.LastModifierUser);
DivisionRepository.Includes.Add(r => r.CreatorUser);
DivisionRepository.Includes.Add(r => r.Teams);
Division divisionEntity = DivisionRepository.Get(input.EntityId);
if (divisionEntity == null)
{
throw new CityQuestItemNotFoundException(CityQuestConsts.CityQuestItemNotFoundExceptionMessageBody, "\"Division\"");
}
if (!DivisionPolicy.CanChangeActivityForEntity(divisionEntity))
{
throw new CityQuestPolicyException(CityQuestConsts.CQPolicyExceptionChangeActivityDenied, "\"Division\"");
}
divisionEntity.IsActive = input.IsActive == null ? !divisionEntity.IsActive : (bool)input.IsActive;
DivisionDto newDivisionDto = (divisionEntity).MapTo <DivisionDto>();
DivisionRepository.Update(divisionEntity);
DivisionRepository.Includes.Clear();
return(new ChangeActivityOutput <DivisionDto, long>()
{
Entity = newDivisionDto
});
}
public RetrieveAllPagedResultOutput <DivisionDto, long> RetrieveAllPagedResult(RetrieveAllDivisionsPagedResultInput input)
{
if (input.IsActive ?? true)
{
UowManager.Current.EnableFilter(Filters.IPassivableFilter);
}
DivisionRepository.Includes.Add(r => r.LastModifierUser);
DivisionRepository.Includes.Add(r => r.CreatorUser);
DivisionRepository.Includes.Add(r => r.Teams);
IQueryable <Division> divisionsQuery = DivisionPolicy.CanRetrieveManyEntities(
DivisionRepository.GetAll()
.WhereIf(!input.DivisionIds.IsNullOrEmpty(), r => input.DivisionIds.Contains(r.Id))
.WhereIf(!String.IsNullOrEmpty(input.Name), r => r.Name.ToLower().Contains(input.Name.ToLower())));
int totalCount = divisionsQuery.Count();
IReadOnlyList <DivisionDto> divisionDtos = divisionsQuery
.OrderByDescending(r => r.IsDefault).ThenByDescending(r => r.IsActive).ThenBy(r => r.Name)
.Skip(input.SkipCount).Take(input.MaxResultCount)
.ToList().MapIList <Division, DivisionDto>().ToList();
DivisionRepository.Includes.Clear();
return(new RetrieveAllPagedResultOutput <DivisionDto, long>()
{
Items = divisionDtos,
TotalCount = totalCount
});
}
public CreateOutput <DivisionDto, long> Create(CreateInput <DivisionDto, long> input)
{
Division newDivisionEntity = input.Entity.MapTo <Division>();
newDivisionEntity.IsDefault = false;
newDivisionEntity.IsActive = true;
if (!DivisionPolicy.CanCreateEntity(newDivisionEntity))
{
throw new CityQuestPolicyException(CityQuestConsts.CQPolicyExceptionCreateDenied, "\"Division\"");
}
DivisionRepository.Includes.Add(r => r.LastModifierUser);
DivisionRepository.Includes.Add(r => r.CreatorUser);
DivisionRepository.Includes.Add(r => r.Teams);
DivisionDto newDivisionDto = (DivisionRepository.Insert(newDivisionEntity)).MapTo <DivisionDto>();
DivisionRepository.Includes.Clear();
return(new CreateOutput <DivisionDto, long>()
{
CreatedEntity = newDivisionDto
});
}
public UpdateOutput <DivisionDto, long> Update(UpdateInput <DivisionDto, long> input)
{
Division newDivisionEntity = input.Entity.MapTo <Division>();
if (newDivisionEntity == null)
{
throw new CityQuestItemNotFoundException(CityQuestConsts.CityQuestItemNotFoundExceptionMessageBody, "\"Division\"");
}
if (!DivisionPolicy.CanUpdateEntity(newDivisionEntity))
{
throw new CityQuestPolicyException(CityQuestConsts.CQPolicyExceptionUpdateDenied, "\"Division\"");
}
DivisionRepository.Includes.Add(r => r.LastModifierUser);
DivisionRepository.Includes.Add(r => r.CreatorUser);
DivisionRepository.Includes.Add(r => r.Teams);
DivisionRepository.Update(newDivisionEntity);
DivisionDto newDivisionDto = (DivisionRepository.Get(newDivisionEntity.Id)).MapTo <DivisionDto>();
DivisionRepository.Includes.Clear();
return(new UpdateOutput <DivisionDto, long>()
{
UpdatedEntity = newDivisionDto
});
}
public RetrieveAllOutput <DivisionDto, long> RetrieveAll(RetrieveAllDivisionInput input)
{
if (input.IsActive ?? true)
{
UowManager.Current.EnableFilter(Filters.IPassivableFilter);
}
DivisionRepository.Includes.Add(r => r.LastModifierUser);
DivisionRepository.Includes.Add(r => r.CreatorUser);
DivisionRepository.Includes.Add(r => r.Teams);
IList <Division> divisionEntities = DivisionPolicy.CanRetrieveManyEntities(
DivisionRepository.GetAll()
.WhereIf(!input.DivisionIds.IsNullOrEmpty(), r => input.DivisionIds.Contains(r.Id))
.WhereIf(!String.IsNullOrEmpty(input.Name), r => r.Name.ToLower().Contains(input.Name.ToLower())))
.ToList();
IList <DivisionDto> result = divisionEntities.MapIList <Division, DivisionDto>();
DivisionRepository.Includes.Clear();
return(new RetrieveAllOutput <DivisionDto, long>()
{
RetrievedEntities = result
});
}
public RetrieveOutput <DivisionDto, long> Retrieve(RetrieveDivisionInput input)
{
if (input.IsActive ?? true)
{
UowManager.Current.EnableFilter(Filters.IPassivableFilter);
}
DivisionRepository.Includes.Add(r => r.LastModifierUser);
DivisionRepository.Includes.Add(r => r.CreatorUser);
DivisionRepository.Includes.Add(r => r.Teams);
IList <Division> divisionEntities = DivisionRepository.GetAll()
.WhereIf(input.Id != null, r => r.Id == input.Id)
.WhereIf(!String.IsNullOrEmpty(input.Name), r => r.Name.ToLower().Contains(input.Name.ToLower()))
.ToList();
if (divisionEntities.Count != 1)
{
throw new CityQuestItemNotFoundException(CityQuestConsts.CityQuestItemNotFoundExceptionMessageBody, "\"Division\"");
}
if (!DivisionPolicy.CanRetrieveEntity(divisionEntities.Single()))
{
throw new CityQuestPolicyException(CityQuestConsts.CQPolicyExceptionRetrieveDenied, "\"Division\"");
}
DivisionDto divisionEntity = divisionEntities.Single().MapTo <DivisionDto>();
DivisionRepository.Includes.Clear();
return(new RetrieveOutput <DivisionDto, long>()
{
RetrievedEntity = divisionEntity
});
}
public UnitOfWork(RestaurantContext context)
{
_context = context;
Adjustments = new AdjustmentRepository(_context);
AdjustmentsItems = new AdjustmentItemRepository(_context);
Branches = new BranchRepository(_context);
Categories = new CategoryRepository(_context);
Customers = new CustomerRepository(_context);
Deliveries = new DeliveryRepository(_context);
DeliveryItems = new DeliveryItemRepository(_context);
Divisions = new DivisionRepository(_context);
Expirations = new ExpirationRepository(_context);
Groups = new GroupRepository(_context);
Stocks = new InventoryItemRepository(_context);
Locations = new LocationRepository(_context);
Units = new MeasurementUnitRepository(_context);
Productions = new ProductionRepository(_context);
Ingredients = new ProductionItemRepository(_context);
Products = new ProductRepository(_context);
Purchases = new PurchaseRepository(_context);
PurchaseItems = new PurchaseItemRepository(_context);
PurchaseOrders = new PurchaseOrderRepository(_context);
PurchaseOrderItems = new PurchaseOrderItemRepository(_context);
SalesInvoices = new SalesInvoiceRepository(_context);
SalesInvoiceItems = new SalesInvoiceItemRepository(_context);
Suppliers = new SupplierRepository(_context);
Transfers = new TransferRepository(_context);
TransferItems = new TransferItemRepository(_context);
Wastages = new WastageRepository(_context);
WastageItems = new WastageItemRepository(_context);
Workers = new WorkerRepository(_context);
ItemLocation = new ItemLocationRepository(_context);
StockHistory = new StockHistoryRepository(_context);
Currencies = new CurrencyRepository(_context);
}
public PersonalController()
{
dbContext = new GovernmentDbContext();
personalRepo = new PersonalRepository(dbContext);
divisionRepo = new DivisionRepository(dbContext);
sectionRepo = new SectionRepository(dbContext);
}
public string GetAllSegments()
{
JavaScriptSerializer jss = new JavaScriptSerializer();
using (MainDBUnitWorkContext context = new MainDBUnitWorkContext())
{
ITeamRepository teamRepository = new TeamRepository(context);
ISegmentRepository segRepository = new SegmentRepository(context);
// Remove current structure from the database scheme level
IDivisionRepository repository = new DivisionRepository(context);
AppDivisionSegmentsService service = new AppDivisionSegmentsService(teamRepository, segRepository, repository);
var segments = service.GetAllSegments();
// Divid all the segments into array
int len = segments.Count / 6 == 0?segments.Count:segments.Count + 1;
AppSegment[][] array = new AppSegment[len][];
for (int i = 0; i < 6; i++)
{
array[i] = new AppSegment[] { };
}
return(jss.Serialize(segments));
}
}
public void AddDivisions()
{
// Arrange
var repository = new DivisionRepository();
var dbContext = A.Fake <ProFootballEntities>();
var divisions = new List <Division>();
for (int i = 1; i <= 3; i++)
{
var division = new Division
{
Name = "Division " + i
};
divisions.Add(division);
}
A.CallTo(() => dbContext.Divisions.AddRange(A <IEnumerable <Division> > .Ignored)).Returns(divisions);
// Act
var result = repository.AddEntities(dbContext, divisions);
// Assert
A.CallTo(() => dbContext.Divisions.AddRange(divisions)).MustHaveHappenedOnceExactly();
Assert.AreSame(divisions, result);
}
private void DisplayDivisionList()
{
DivisionRepository repo = new DivisionRepository();
this.ddlDivisionList.DataSource = repo.GetDivisions();
ddlDivisionList.DataTextField = "DivisionName";
ddlDivisionList.DataValueField = "DivisionId";
this.ddlDivisionList.DataBind();
}
//[TestCase]
public void TestCase1()
{
// Arrange
var repository = new DivisionRepository();
// Act
// Assert
}
public UnitofWork(ApplicationDbContext context)
{
_context = context;
Departments = new DepartmentRepository(_context);
Divisions = new DivisionRepository(_context);
Letters = new LetterRepository(_context);
LetterTypes = new LetterTypeRepository(_context);
Senders = new SenderRepository(_context);
}
public JsonResult Division(int?draw, int?start, int?length, List <Dictionary <string, string> > order, List <Dictionary <string, string> > columns)
{
var search = Request["search[value]"];
var dir = order[0]["dir"].ToLower();
var column = columns[int.Parse(order[0]["column"])]["data"];
var dataTableData = new DivisionRepository().GetPage(search, draw, start, length, dir, column);
return(Json(dataTableData, JsonRequestBehavior.AllowGet));
}
private void DisplayDivisions()
{
DivisionRepository divisions = new DivisionRepository();
lstDivisions.DataSource = divisions.GetDivisions();
lstDivisions.DataTextField = "DivisionName";
lstDivisions.DataValueField = "DivisionId";
lstDivisions.DataBind();
}
public ActionResult DivisionDetail(int?id)
{
DivisionViewModel model = new DivisionViewModel();
if (id.HasValue)
{
model = new DivisionRepository().GetByID((int)id);
}
return(PartialView("_Division", model));
}
public void GetDivisionRecordsTest()
{
context = new CSBCDbContext();
var house = new Division();
var rep = new DivisionRepository(context);
var seasonRep = new SeasonRepository(context);
var season = seasonRep.GetCurrentSeason(1);
var divisions = rep.GetDivisions(season.SeasonID);
Assert.IsTrue(divisions.Any<Division>());
}
protected List<Division> GetDivisionList(int seasonId)
{
using (var db = new CSBCDbContext())
{
var rep = new DivisionRepository(db);
var divisions = rep.GetDivisions(seasonId).ToList<Division>();
return divisions;
}
}
public void GetDivisions_HappyPath()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new DivisionRepository(dbContext);
// Act
var result = repository.GetEntities();
// Assert
Assert.IsInstanceOf <IEnumerable <Division> >(result);
}
public void GetPlayerDivisionTest()
{
context = new CSBCDbContext();
var repPeople = new PlayerRepository(context);
var player = context.Players.FirstOrDefault();
//var person = repPeople.GetById(2);
var repSeason = new SeasonRepository(context);
var season = repSeason.GetCurrentSeason(1);
var repDivision = new DivisionRepository(context);
var dt = repDivision.GetPlayerDivision(1, season.SeasonID, player.PeopleID);
Assert.IsTrue(dt != 0);
}
public void EditDivision_ExceptionCaught_LogsAndRethrowsException()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new DivisionRepository(dbContext);
var division = new Division();
A.CallTo(() => dbContext.SetModified(A <Division> .Ignored)).Throws <Exception>();
// Act & Assert
Assert.Throws <Exception>(() => repository.EditEntity(division));
}
public void EditDivision_HappyPath()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new DivisionRepository(dbContext);
var division = new Division();
// Act
repository.EditEntity(division);
// Assert
A.CallTo(() => dbContext.SetModified(division)).MustHaveHappenedOnceExactly();
}
public WoodVolumeController(IWoodVolumeRepository woodVolumeRepository
, DivisionRepository divisionRepository
, DistrictRepository districtRepository
, RangeRepository rangeRepository
, TalukRepository talukRepository
, VillageRepository villageRepository)
{
_WoodVolumeRepository = woodVolumeRepository;
_DivisionRepository = divisionRepository;
_DistrictRepository = districtRepository;
_RangeRepository = rangeRepository;
_TalukRepository = talukRepository;
_VillageRepository = villageRepository;
}
public UnitOfWork(AppDbContext context)
{
_dbContext = context;
Countries = new CountryRepository(context);
BudgetHeads = new BudgetHeadRepository(context);
CostCodes = new CostCodeRepository(context);
Currencies = new CurrencyRepository(context);
Divisions = new DivisionRepository(context);
Budgets = new BudgetRepository(context);
Employees = new EmployeeRepository(context);
Vendors = new VendorRepository(context);
NumberingSequences = new NumberingSequenceRepository(context);
BudgetCategories = new BudgetCategoriesRepository(context);
Departments = new DepartmentRepository(context);
}
public JsonResult SaveDivision(DivisionViewModel model)
{
ResponseData result = new Models.ResponseData();
if (model.DivID != 0)
{
result = new DivisionRepository().UpdateByEntity(model);
}
else
{
result = new DivisionRepository().AddByEntity(model);
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public void CreateDivision_HappyPath()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new DivisionRepository(dbContext);
A.CallTo(() => dbContext.Divisions.Create()).Returns(new Division());
// Act
var result = repository.CreateEntity();
// Assert
A.CallTo(() => dbContext.Divisions.Create()).MustHaveHappenedOnceExactly();
Assert.IsInstanceOf <Division>(result);
}
public void InitDivisionTest()
{
context = new CSBCDbContext();
var repDivision = new DivisionRepository(context);
var division = new Division
{
Div_Desc = "Unit Test",
CompanyID = 1,
Gender = "M",
MinDate = DateTime.Now,
MaxDate = DateTime.Now.AddDays(60)
};
var divisionret = repDivision.Insert(division);
Assert.IsTrue(divisionret != null);
}
public async Task GetDivisionsAsync()
{
// Arrange
var repository = new DivisionRepository();
var dbContext = A.Fake <ProFootballEntities>();
dbContext.SetUpFakeDivisionsAsync();
// Act
var result = await repository.GetEntitiesAsync(dbContext);
// Assert
Assert.IsInstanceOf <IEnumerable <Division> >(result);
}
public RetrieveAllDivisionsLikeComboBoxesOutput RetrieveAllDivisionsLikeComboBoxes(RetrieveAllDivisionsLikeComboBoxesInput input)
{
if (input.IsActive ?? true)
{
UowManager.Current.EnableFilter(Filters.IPassivableFilter);
}
IReadOnlyList <ComboboxItemDto> divisionsLikeComboBoxes = DivisionPolicy.CanRetrieveManyEntities(
DivisionRepository.GetAll()).ToList()
.Select(r => new ComboboxItemDto(r.Id.ToString(), r.Name)).ToList();
return(new RetrieveAllDivisionsLikeComboBoxesOutput()
{
Items = divisionsLikeComboBoxes
});
}
public void CreateDivision_ExceptionCaught_LogsAndRethrowsException()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new DivisionRepository(dbContext);
A.CallTo(() => dbContext.Divisions.Create()).Throws <Exception>();
// Act
Division result = null;
Assert.Throws <Exception>(() => result = repository.CreateEntity());
// Assert
Assert.IsNull(result);
}
//[TestCase]
public void TestCase1()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new DivisionRepository(dbContext);
// TODO: Define argument variables of method under test.
// TODO: Set up needed infrastructure of class under test.
// Act
// TODO: Call method under test.
// Assert
// TODO: Assert results of call to method under test.
}
public void GetDivisions_ExceptionCaught_LogsAndRethrowsException()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new DivisionRepository(dbContext);
A.CallTo(() => dbContext.Divisions).Throws <Exception>();
// Act
IEnumerable <Division> result = null;
Assert.Throws <Exception>(() => result = repository.GetEntities());
// Assert
Assert.IsNull(result);
}
public void AddDivisions_HappyPath()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new DivisionRepository(dbContext);
var divisions = new List <Division>();
A.CallTo(() => dbContext.Divisions.AddRange(A <IEnumerable <Division> > .Ignored)).Returns(divisions);
// Act
var result = repository.AddEntities(divisions);
// Assert
A.CallTo(() => dbContext.Divisions.AddRange(divisions)).MustHaveHappenedOnceExactly();
Assert.AreSame(divisions, result);
}
public void GetDivisionTeamsTest2()
{
var divisions = new List<Division>();
using (var context = new CSBCDbContext())
{
var repSeason = new SeasonRepository(context);
var currentSeason = repSeason.GetCurrentSeason(1);
var repDivision = new DivisionRepository(context);
divisions = repDivision.GetDivisions(currentSeason.SeasonID).ToList<Division>();
}
var division = divisions.FirstOrDefault();
var rep = new TeamVM();
var teams = rep.GetDivisionTeams(division.DivisionID);
Assert.IsTrue(teams.Any());
var team = teams.FirstOrDefault();
Assert.IsTrue(team.DivisionID > 0);
}
protected void grdDivisions_RowCommand(object sender, GridViewCommandEventArgs e)
{
var id = e.CommandArgument.ToString();
var rep = new DivisionRepository(new CSBCDbContext());
var division = rep.GetById(Convert.ToInt32(id));
DivisionId = division.DivisionID;
LoadRow(division);
LoadTeams(DivisionId);
}
//protected void btnSave_Click(object sender, System.EventArgs e)
//{
// lblError.Text = "";
// Session["ErrorMSG"] = "";
// if (DivisionId > 0)
// {
// UpdDivision();
// }
// else
// {
// AddDivision();
// }
//}
//private void AddDivision()
//{
// if (errorRTN() == true)
// {
// MsgBox("ERROR: " + lblError.Text);
// return;
// }
// if (string.IsNullOrEmpty(Session["ErrorMsg"].ToString()))
// ADDRow();
// if (string.IsNullOrEmpty(Session["ErrorMsg"].ToString()))
// //Interaction.MsgBox("New Record Added Successfully");
// if (string.IsNullOrEmpty(Session["ErrorMsg"].ToString()))
// LoadTeams(DivisionId);
// if (string.IsNullOrEmpty(Session["ErrorMsg"].ToString()))
// LoadRow(DivisionId);
// if (String.IsNullOrEmpty(Session["ErrorMsg"].ToString()))
// ReassignDivision(DivisionId);
// if (string.IsNullOrEmpty(Session["ErrorMsg"].ToString()))
// LoadDivisions();
// lblError.Text = Session["ErrorMsg"].ToString();
//}
//private void UpdDivision()
//{
// if (errorRTN() == true)
// {
// //Interaction.MsgBox("ERROR: " + lblError.Text);
// return;
// }
// if (String.IsNullOrEmpty(Session["ErrorMsg"].ToString()))
// {
// UpdRow(DivisionId);
// //Interaction.MsgBox("Changes successfully completed");
// LoadTeams(DivisionId);
// LoadRow(DivisionId);
// ReassignDivision(DivisionId);
// LoadDivisions();
// }
// else
// {
// lblError.Text = Session["ErrorMsg"].ToString();
// }
//}
protected void btnSave_Command(object sender, CommandEventArgs e)
{
var division = new Division();
DateTime date;
if (lblDivisionID.Value == "")
division.DivisionID = 0;
else
division.DivisionID = Convert.ToInt32(lblDivisionID.Value);
division.CompanyID = Master.CompanyId;
division.SeasonID = Master.SeasonId;
division.Div_Desc = txtName.Text;
division.MinDate = DateTime.Parse(txtMinDate.Text);
division.MaxDate = DateTime.Parse(txtMaxDate.Text);
if (radGender.SelectedIndex == 0)
division.Gender = "M";
if (radGender.SelectedIndex == 1)
division.Gender = "F";
if (DateTime.TryParse(txtMinDate2.Text, out date))
division.MinDate2 = date;
DateTime goodDate;
if (DateTime.TryParse(txtMaxDate2.Text, out goodDate))
division.MaxDate2 = DateTime.Parse(txtMaxDate2.Text);
if (radGender2.SelectedIndex == 0)
division.Gender2 = "M";
if (radGender2.SelectedIndex == 1)
division.Gender2 = "F";
division.DraftVenue = txtVenue.Text;
if (DateTime.TryParse(txtDate.Text, out date))
division.DraftDate = date;
division.DraftTime = txtTime.Text;
division.DirectorID = Int32.Parse(cboAD.SelectedValue);
division.CoDirectorID = 0;
//cboAD.SelectedValue
division.CreatedUser = Session["UserName"].ToString();
using (var db = new CSBCDbContext())
{
try
{
var rep = new DivisionRepository(db);
if (division.DivisionID == 0)
{
var newDivision = rep.Insert(division);
lblDivisionID.Value = newDivision.DivisionID.ToString();
}
else
rep.Update(division);
}
catch (Exception ex)
{
Console.WriteLine("Unable to save" + ex.InnerException);
}
}
ReassignDivision(DivisionId);
LoadDivisions();
}
protected void btnDelete_Command(object sender, CommandEventArgs e)
{
var rep = new TeamVM();
var divisionId = Convert.ToInt32(lblDivisionID.Value);
var teams = rep.GetDivisionTeams(divisionId);
if (teams.Count() > 0)
{
lblError.Text = "Cannot delete Division because teams exist!";
}
else
{
var repDivision = new DivisionRepository(new CSBCDbContext());
repDivision.Delete(repDivision.GetById(divisionId));
LoadDivisions();
DivisionId = 0;
//LoadTeams();
}
}
private void LoadDivisions()
{
var rep = new DivisionRepository(new CSBCDbContext());
var divisions = rep.GetDivisions(Master.SeasonId).ToList();
try
{
if (divisions.Any())
{
var _with1 = cboDivisions;
_with1.DataSource = divisions;
_with1.DataValueField = "DivisionID";
_with1.DataTextField = "Div_Desc";
_with1.DataBind();
}
}
catch (Exception ex)
{
lblError.Text = "LoadDivisions::" + ex.Message;
}
}
//Private Sub CheckForStats()
// If KeepStats() Then
// 'transfer to stats
// Response.Redirect("GamesStats.aspx")
// Exit Sub
// End If
//End Sub
private bool CheckAD(int divisionId, User user)
{
bool functionReturnValue = false;
using (var db = new CSBCDbContext())
{
var divisionRepo = new DivisionRepository(db);
var division = divisionRepo.GetById(divisionId);
if (division.DirectorID != 0)
{
if (user.HouseID != 0)
{
var householdMembers = db.Set<Person>().Where(p => p.HouseID == user.HouseID);
functionReturnValue = householdMembers.Any(h => h.PeopleID == division.DirectorID);
lblName.Text = user.Name;
lblName.Visible = true;
}
}
}
return functionReturnValue;
}
private void GetDivisions()
{
try
{
using (var db = new CSBCDbContext())
{
var rep = new DivisionRepository(db);
var divisions = rep.GetDivisions(Convert.ToInt32(Session["SeasonID"]));
var grid = ddlDivisions;
grid.DataSource = divisions.ToList<Division>();
grid.DataValueField = "DivisionID";
grid.DataTextField = "Div_Desc";
grid.Items.Add("");
grid.DataBind();
LoadSchedule(divisions.FirstOrDefault().DivisionID, 0);
}
}
catch (Exception ex)
{
//lblError.Text = "GetDivisions:" + ex.Message;
}
}
private void LoadDivisions()
{
var rep = new DivisionRepository(new CSBCDbContext());
try
{
var divisions = rep.GetDivisions(Master.SeasonId).ToList<Division>();
cmbDivisions.DataSource = divisions;
cmbDivisions.DataValueField = "DivisionID";
cmbDivisions.DataTextField = "Div_Desc";
cmbDivisions.DataBind();
ddlDivisions.DataSource = divisions;
ddlDivisions.DataValueField = "DivisionID";
ddlDivisions.DataTextField = "Div_Desc";
ddlDivisions.DataBind();
}
catch (Exception ex)
{
lblError.Text = "LoadDivisions::" + ex.Message;
}
}
private void LoadDivisions()
{
//var oDivisions = new CSBC.Components.Season.ClsDivisions();
//DataTable rsData = default(DataTable);
var rep = new DivisionRepository(new CSBCDbContext());
try
{
var data = rep.GetDivisions(Master.SeasonId).ToList();
grdDivisions.DataSource = data;
grdDivisions.DataBind();
var _with2 = grdDivisions;
}
catch (Exception ex)
{
lblError.Text = "LoadDivisions::" + ex.Message;
}
finally
{
}
}
private void LoadDivisions(int division, int companyId, int seasonId)
{
var divisions = new DivisionRepository(new CSBCDbContext());
try
{
var rsData = divisions.LoadDivisions(seasonId);
var count = rsData.Count<vw_Divisions>();
cmbDivisions.DataSource = rsData;
cmbDivisions.DataValueField = "DivisionID";
cmbDivisions.DataTextField = "Div_Desc";
cmbDivisions.DataBind();
}
catch (Exception ex)
{
lblError.Text = "LoadDivisions::" + ex.Message;
}
finally
{
//if (Session["DivisionID"] != null)
// cmbDivisions.SelectedValue = Session["DivisionID"].ToString();
}
}
public void LoadDivisionTest()
{
context = new CSBCDbContext();
var repDivision = new DivisionRepository(context);
var divisions = repDivision.LoadDivisions(2);
Assert.IsTrue(divisions.Count<vw_Divisions>() != 0);
}
private void LoadRow(int rowId)
{
try
{
var rep = new DivisionRepository(new CSBCDbContext());
var division = rep.GetById(Convert.ToInt32(rowId));
DivisionId = division.DivisionID;
LoadRow(division);
}
catch (Exception ex)
{
lblError.Text = "LoadRow::" + ex.Message;
}
LoadTeams(DivisionId);
}
private int GetDivision()
{
ClsDivisions oDivisions = new CSBC.Components.Season.ClsDivisions();
var rep = new DivisionRepository(new CSBCDbContext());
var rsData = rep.GetPlayerDivision(Master.CompanyId, Master.SeasonId, Master.PeopleId);
try
{
if (rsData == 0)
{
Master.DivisionId = 0;
}
else
{
Master.DivisionId = rsData;
}
return Master.DivisionId;
}
catch (Exception ex)
{
lblError.Text = "GetDivision::" + ex.Message;
return 0;
}
}
