public void DeleteCoach()
{
try
{
Console.WriteLine("Enter Coach id:");
string id = Console.ReadLine();
int tryint;
while (!int.TryParse(id, out tryint))
{
Console.WriteLine("Incorrect id! Try again ");
id = Console.ReadLine();
}
using (swimmingContext swimdb = new swimmingContext())
{
ICoachManager <Coach> coachManager = new CoachRepository(swimdb);
coachManager.Delete(Convert.ToInt32(id));
Console.WriteLine("Coach is deleted");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void CanReadCoach()
{
// Arange
var dbFactory = new DatabaseFactory();
var coachRepository = new CoachRepository(dbFactory);
var unitOfWork = new UnitOfWork(dbFactory);
coachRepository.Add(new COACH
{
COACH_INTERNAL_ID = "1",
PAYMENTRATE = 120.2M,
PAYOFFRATE = 100.2M,
PERSON = new PERSON
{
FIRSTNAME = "Milan",
LASTNAME = "Milanovic",
EMAIL = "*****@*****.**",
TELEPHONE = "0644325665"
}
});
unitOfWork.Commit();
// Act
var coach = coachRepository.Get(c => c.COACH_INTERNAL_ID == "1");
// Assert
Assert.IsNotNull(coach, "coach doesn't exist");
}
public void GetCoachByIdTest()
{
var context = new Core.Data.CSBCDbContext();
var testinit = new CSBCDbInitializer();
var rep = new CoachRepository(context);
var dt = rep.GetCoaches((testinit.CurrentSeason).SeasonID);
Assert.IsTrue(dt.Rows.Count > 0);
}
protected void btnDelete_Click1(object sender, EventArgs e)
{
var rep = new CoachRepository(new CSBCDbContext());
rep.DeleteById(Convert.ToInt32(lblCoachId.Value));
ClearFields();
lblCoachId.Value = "";
LoadCoaches();
LoadVolunteers();
}
public void GetCoachVolunteerTest()
{
var context = new Core.Data.CSBCDbContext();
var testinit = new CSBCDbInitializer();
var rep = new CoachRepository(context);
var coaches = rep.GetCoachVolunteers(1, testinit.CurrentSeason.SeasonID);
Assert.IsTrue(coaches.Count<vw_Coaches>() > 0);
}
public void UpdateCoach()
{
Console.WriteLine("Enter Coach id:");
string coachId = Console.ReadLine();
int tryint;
while (!int.TryParse(coachId, out tryint))
{
Console.WriteLine("Incorrect id! Try again ");
coachId = Console.ReadLine();
}
Console.Write("Enter Coach name:");
string newName = Console.ReadLine();
while (!IsAllAlphabetic(newName))
{
Console.WriteLine("Incorrect Name! Try again");
newName = Console.ReadLine();
}
Console.Write("Enter Coach surname:");
string newSurname = Console.ReadLine();
while (!IsAllAlphabetic(newSurname))
{
Console.WriteLine("Incorrect Surname! Try again");
newSurname = Console.ReadLine();
}
Console.Write("Enter Coach work experience:");
string newWorkExperience = Console.ReadLine();
while ((!int.TryParse(newWorkExperience, out tryint)) || (!WorkExperienceValidationAttribute.IsValidCoachExperience(Convert.ToInt32(newWorkExperience))))
{
Console.WriteLine("Incorrect Work Experience! Try again ");
newWorkExperience = Console.ReadLine();
}
try
{
Coach coach = new Coach {
FirstName = newName, LastName = newSurname, WorkExperience = Convert.ToInt32(newWorkExperience)
};
using (swimmingContext swimdb = new swimmingContext())
{
ICoachManager <Coach> coachManager = new CoachRepository(swimdb);
coachManager.Update(Convert.ToInt32(coachId), coach);
Console.WriteLine("Coach is updated");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public Coach Get(int id)
{
TBL_COACH _coach = new CoachRepository().GetById(id);
aspnet_Users user = new UsersRepository().GetAll().Where(u => u.UserId == _coach.UserID).SingleOrDefault();
aspnet_Membership member = new MembershipRepository().GetAll().Where(m => m.UserId == _coach.UserID).SingleOrDefault();
TBL_REGION _region = new RegionRepository().GetById(_coach.RegionID);
Coach coach = new Coach();
coach.UserName = user.UserName;
coach.RegionName = _region.Name;
coach.Email = member.Email;
CoachMappings.ModelToViewModel(coach, _coach);
return coach;
}
public void Initialize()
{
_connection = new SqliteConnection("DataSource=:memory:");
_connection.Open();
_options = new DbContextOptionsBuilder <SportschoolVanDrunenDbContext>()
.UseSqlite(_connection)
.Options;
using (var c = new SportschoolVanDrunenDbContext(_options))
{
c.Database.EnsureCreated();
}
_sut = new CoachRepository(new SportschoolVanDrunenDbContext(_options));
}
public void CreateCoachTest()
{
var context = new Core.Data.CSBCDbContext();
var rep = new CoachRepository(context);
Debug.Assert(context.People != null, "context.People != null");
var coach = new Coach
{
CompanyID = 1,
PeopleID = context.People.FirstOrDefault().PeopleID,
SeasonID = context.Seasons.First(s => s.CurrentSeason == true).SeasonID,
CoachPhone = "999-000-9090"
};
var i = rep.Insert(coach);
Assert.IsTrue(coach.CoachID > 0);
}
public Coach PostCoach(Coach coach)
{
MembershipUser user;
CoachRepository repository;
TBL_COACH coachToSave;
try
{
repository = new CoachRepository();
if (coach.ID > 0)
{
coachToSave = repository.GetById(coach.ID);
coachToSave.LastUpdatedBy = new Guid(coach.CreatedByCorporateID);
coachToSave.LastCreatedDate = DateTime.Now;
CoachMappings.ViewModelToModel(coachToSave, coach);
repository.Update(coachToSave);
user = Membership.GetUser(coachToSave.UserID);
user.Email = coach.Email;
Membership.UpdateUser(user);
}
else
{
user = Membership.CreateUser(coach.UserName, "pa$$word", coach.Email);
Roles.AddUserToRole(coach.UserName, SandlerRoles.Coach.ToString());
coachToSave = new TBL_COACH();
coachToSave.CreatedBy = new Guid(coach.CreatedByCorporateID);
coachToSave.UserID = (Guid)user.ProviderUserKey;
coachToSave.CreatedDate = DateTime.Now;
coachToSave.LastCreatedDate = DateTime.Now;
coachToSave.IsActive = true;
CoachMappings.ViewModelToModel(coachToSave, coach);
repository.Add(coachToSave);
coach.UserName = user.UserName;
}
//CoachMappings.ModelToViewModel(coach, coachToSave);
}
catch (Exception ex)
{
}
return coach;
}
public void SelectCoaches()
{
try
{
Console.Write("Coaches:\n");
Console.WriteLine("\tCoach Id \tFirstName \tSecondName\tWorkExperience");
using (swimmingContext swimdb = new swimmingContext())
{
ICoachManager <Coach> coachManager = new CoachRepository(swimdb);
var coaches = coachManager.GetList();
foreach (Coach c in coaches)
{
Console.WriteLine($"{c.Id,15}{c.FirstName,15} {c.LastName,17} {c.WorkExperience,15}");
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
protected void cmbAsstCoach_SelectedIndexChanged(object sender, System.EventArgs e)
{
lblCAsstPhone.Text = "";
lblHAsstPhone.Text = "";
Session["AsstCoachID"] = cmbCoach.SelectedItem.Value;
var coachId = Convert.ToInt32(cmbAsstCoach.SelectedItem.Value);
if (!(String.IsNullOrEmpty((string)Session["AsstCoachID"])))
{
var rep = new CoachRepository(new CSBCDbContext());
var coach = rep.GetCoach(coachId);
try
{
if (coach != null)
{
if (coach.CoachPhone.Length > 0)
lblHAsstPhone.Text = "(H) " + coach.CoachPhone;
else
lblHAsstPhone.Text = "";
if (coach.Cellphone.Length > 0)
lblCAsstPhone.Text = "(C) " + coach.Cellphone;
else
lblCAsstPhone.Text = "";
}
}
catch (Exception ex)
{
lblError.Text = "cmbAsstCoach::" + ex.Message;
}
}
}
private IEnumerable<TBL_OPPORTUNITIES> Getopportunities(UserModel user)
{
OpportunitiesRepository opportunitiesSource = new OpportunitiesRepository();
IEnumerable<TBL_OPPORTUNITIES> opportunties = null;
try
{
if (user.Role == SandlerRoles.FranchiseeUser)
opportunties = opportunitiesSource.GetAll().Where(record => record.IsActive == true && record.CreatedBy.ToLower() == user.UserId.ToString().ToLower()).AsEnumerable();
else if (user.Role == SandlerRoles.FranchiseeOwner)
{
//opportunties = from opportunity in opportunitiesSource.GetAll().Where(record => record.IsActive == true)
// from company in companies.Where(record => record.COMPANIESID == opportunity.COMPANYID)
// select opportunity;
opportunties = from opportunity in opportunitiesSource.GetAll().Where(record => record.IsActive == true && record.TBL_COMPANIES.FranchiseeId == user.FranchiseeID)
select opportunity;
}
else if (user.Role == SandlerRoles.Coach)
{
FranchiseeRepository franchiseeSource = new FranchiseeRepository();
CoachRepository coachSource = new CoachRepository();
//opportunties = from opportunity in opportunitiesSource.GetAll().Where(record => record.IsActive == true)
// from company in companies.Where(record => record.COMPANIESID == opportunity.COMPANYID)
// from franchisee in franchisees.Where(record => record.ID == company.FranchiseeId)
// select opportunity;
opportunties = from opportunity in opportunitiesSource.GetAll().Where(record => record.IsActive == true && record.TBL_COMPANIES.TBL_FRANCHISEE.CoachID == user.CoachID)
select opportunity;
}
else if (user.Role == SandlerRoles.Corporate)
{
opportunties = opportunitiesSource.GetAll().Where(record => record.IsActive == true).AsEnumerable();
}
}
catch (Exception ex)
{
throw new Exception("exception in UserEntities.Getopportunities: " + ex.Message);
}
return opportunties;
}
private int Create()
{
var rep = new CoachRepository(new CSBCDbContext());
var coach = new Coach();
try
{
coach.ShirtSize = cmbSizes.Text;
coach.SeasonID = Master.SeasonId;
coach.CompanyID = Master.CompanyId;
coach.CreatedDate = DateTime.Today;
coach.PeopleID = Convert.ToInt32(cmbCoaches.SelectedValue);
if (txtCoachPhone.Text != "")
{
coach.CoachPhone = txtCoachPhone.Text;
}
else
{
coach.CoachPhone = "";
}
coach.CreatedUser = Session["UserName"].ToString();
rep.Insert(coach);
CoachId = (int)coach.CoachID;
Session["coachId"] = CoachId;
}
catch (Exception ex)
{
Session["ErrorMSG"] = ex.Message;
}
return CoachId;
}
public void GetSeasonCoachesTest()
{
var context = new Core.Data.CSBCDbContext();
var testinit = new CSBCDbInitializer();
var rep = new CoachRepository(context);
var coaches = rep.GetSeasonCoaches(testinit.CurrentSeason.SeasonID);
Assert.IsTrue(coaches.Any<vw_Coaches>() );
}
private void LoadCoach(int coachId)
{
using (var db = new CSBCDbContext())
{
var rep = new CoachRepository(db);
cmbCoaches.Visible = false;
var coach = rep.GetById(coachId);
CoachId = coach.CoachID;
Master.PeopleId = coach.PeopleID;
lblCoachId.Value = CoachId.ToString();
if (coach.Person != null)
{
lnkName.Text = coach.Person.FirstName + " " + coach.Person.LastName;
if (coach.Person.Household != null)
{
lblAddress.Text = coach.Person.Household.Address1;
lblPhone.Text = coach.Person.Household.Phone;
lblCSZ.Text = coach.Person.Household.City + ", " + coach.Person.Household.State + " " + coach.Person.Household.Zip;
}
}
txtCoachPhone.Text = coach.CoachPhone;
cmbSizes.SelectedValue = coach.ShirtSize;
}
pnlCoach.Visible = true;
GetKids(coachId);
}
private void LoadCoaches()
{
var rep = new CoachRepository(new CSBCDbContext());
try
{
var rsData = rep.GetSeasonCoaches(Master.SeasonId);
//grdCoaches.Columns.Clear();
if (rsData.Count<vw_Coaches>() > 0)
{
var _with1 = grd;
grd.DataSource = rsData;
grd.DataBind();
}
}
catch (Exception ex)
{
lblError.Text = "LoadCoaches::" + ex.Message;
}
}
private void LoadVolunteers()
{
var rep = new CoachRepository(new CSBCDbContext());
try
{
var coaches = rep.GetCoachVolunteers(Master.CompanyId, Master.SeasonId);
vw_Coaches coach = new vw_Coaches { PeopleID = 0, Name = "" };
cmbCoaches.DataSource = coaches;
cmbCoaches.DataValueField = "PeopleID";
cmbCoaches.DataTextField = "Name";
cmbCoaches.DataBind();
cmbCoaches.Items.Insert(0, new ListItem(String.Empty, String.Empty));
cmbCoaches.SelectedIndex = 0;
}
catch (Exception ex)
{
lblError.Text = "LoadVolunteers::" + ex.Message;
}
}
public void UpdateCoachesTest()
{
var context = new Core.Data.CSBCDbContext();
var testinit = new CSBCDbInitializer();
var rep = new CoachRepository(context);
var coach = context.Coaches.FirstOrDefault();
coach.ShirtSize = shirtSize;
coach.CoachPhone = coachPhone;
rep.Update(coach);
var newcoach = rep.GetById(coach.CoachID);
Assert.IsTrue(newcoach.ShirtSize == shirtSize);
Assert.IsTrue(newcoach.CoachPhone == coachPhone);
}
private void UpdateCoachPhone()
{
if (cmbCoach.SelectedItem.Value != "")
{
Session["CoachID"] = cmbCoach.SelectedItem.Value;
var coachId = Convert.ToInt32(cmbCoach.SelectedItem.Value);
if (!(String.IsNullOrEmpty((string)Session["CoachID"])))
{
var rep = new CoachRepository(new CSBCDbContext());
var coach = rep.GetCoach(coachId);
try
{
if (coach != null)
{
if (coach.CoachPhone.Length > 0)
lblCHPhone.Text = "(H) " + coach.CoachPhone;
else
lblCHPhone.Text = "";
if (coach.Cellphone.Length > 0)
lblCCPhone.Text = "(C) " + coach.Cellphone;
else
lblCHPhone.Text = "";
}
}
catch (Exception ex)
{
lblError.Text = "cmbCoach::" + ex.Message;
}
}
}
}
private void LoadCoaches()
{
try
{
using (var db = new CSBCDbContext())
{
var rep = new CoachRepository(db);
var rsData = rep.GetSeasonCoaches(Master.SeasonId);
cmbCoach.DataSource = rsData;
cmbCoach.DataValueField = "CoachID";
cmbCoach.DataTextField = "Name";
cmbCoach.DataBind();
cmbCoach.Items.Insert(0, new ListItem(String.Empty, String.Empty));
cmbCoach.SelectedIndex = 0;
cmbAsstCoach.DataSource = rsData;
cmbAsstCoach.DataValueField = "CoachID";
cmbAsstCoach.DataTextField = "Name";
cmbAsstCoach.DataBind();
cmbAsstCoach.Items.Insert(0, new ListItem(String.Empty, String.Empty));
cmbAsstCoach.SelectedIndex = 0;
}
}
catch (Exception ex)
{
lblError.Text = "LoadCoaches::" + ex.Message;
}
}
private int Update()
{
var rep = new CoachRepository(new CSBCDbContext());
if (CoachId != 0)
{
//var id = Convert.ToInt32(lblCoachId.Value);
var coach = rep.GetCoachForSeason(Master.SeasonId, Master.PeopleId); //change this logic to only have one call
if (coach == null)
{
Create();
}
else
{
try
{
coach.ShirtSize = cmbSizes.Text;
if (txtCoachPhone.Text != "")
{
coach.CoachPhone = txtCoachPhone.Text;
}
else
{
coach.CoachPhone = "";
}
rep.Update(coach);
}
catch
{
}
}
}
else
{
}
return (CoachId);
}
