public void AddSubcategory()
{
JobSubcategory item = new JobSubcategory();
item.JobCategory = SelectedCategory;
JobSubcategoryRepository.Instance.SetItem(item);
Subcategories.Add(item);
SelectedSubcategory = item;
}
public bool UpdateJobSubcategory(JobSubcategory item)
{
//admin check
return(JobSubcategoryRepository.Instance.UpdateItem(item));
}
public bool SetJobSubcategory(JobSubcategory item)
{
//admin check
return(JobSubcategoryRepository.Instance.SetItem(item));
}
bool IBaseRepository <JobSubcategory> .UpdateItem(JobSubcategory item)
{
return(Channel.UpdateJobSubcategory(item));
}
bool IBaseRepository <JobSubcategory> .SetItem(JobSubcategory item)
{
return(Channel.SetJobSubcategory(item));
}
public void Load()
{
//Persons
//PersonManager.Instance.Persons = new Dictionary<Guid, Person>();
//Clients
ClientManager.Instance.Clients = new Dictionary <Guid, Client>();
ConnectionState state = cnn.State;
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
String query = "Select * From Person p INNER JOIN Client c on p.Id = c.PersonId";
DataTable dt = new DataTable();
SqlDataAdapter adapter = new SqlDataAdapter(query, cnn);
adapter.Fill(dt);
foreach (DataRow row in dt.Rows)
{
Guid id = (Guid)row["Id"];
Client c = new Client(id, (String)row["Login"], (String)row["Password"]);
c.Name = (String)row["Name"];
c.SName = (String)row["SName"];
c.Email = (String)row["Email"];
c.TimeZone = (String)row["TimeZone"];
c.IsCompany = (bool)row["IsCompany"];
c.CompanyName = (String)row["CompanyName"];
c.Overview = (String)row["Overview"];
ClientManager.Instance.Clients.Add(id, c);
//PersonManager.Instance.Persons.Add(id, c);
}
//Authors
AuthorManager.Instance.Authors = new Dictionary <Guid, Author>();
state = cnn.State;
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
query = "Select * From Person p INNER JOIN Author a on p.Id = a.PersonId";
dt = new DataTable();
adapter = new SqlDataAdapter(query, cnn);
adapter.Fill(dt);
foreach (DataRow row in dt.Rows)
{
Guid id = (Guid)row["Id"];
Author a = new Author(id, (String)row["Login"], (String)row["Password"]);
a.Name = (String)row["Name"];
a.SName = (String)row["SName"];
a.Email = (String)row["Email"];
a.TimeZone = (String)row["TimeZone"];
a.Title = (String)row["Title"];
a.PhotoPath = (String)row["PhotoPath"];
a.Overview = (String)row["Overview"];
AuthorManager.Instance.Authors.Add(id, a);
//PersonManager.Instance.Persons.Add(id, a);
}
//JobCategories
JobCategoryManager.Instance.JobCategorys = new Dictionary <Guid, JobCategory>();
state = cnn.State;
if (cnn.State == ConnectionState.Closed)
{
cnn.Open();
}
query = "Select * From JobCategory";
dt = new DataTable();
adapter = new SqlDataAdapter(query, cnn);
adapter.Fill(dt);
foreach (DataRow row in dt.Rows)
{
JobCategoryManager.Instance.JobCategorys.Add((Guid)row["Id"],
JobCategory.getByValue((Guid)row["Id"], (String)row["Name"], (String)row["Description"]));
}
//JobSubcategories
JobSubcategoryManager.Instance.JobSubcategorys = new Dictionary <Guid, JobSubcategory>();
query = "Select * From JobSubcategory";
dt = new DataTable();
adapter = new SqlDataAdapter(query, cnn);
adapter.Fill(dt);
foreach (DataRow row in dt.Rows)
{
JobSubcategoryManager.Instance.JobSubcategorys.Add((Guid)row["Id"], JobSubcategory.getByValue(
(Guid)row["Id"], (Guid)row["JobCategoryId"], (String)row["Name"],
(String)row["Description"]));
}
//TimeZones
TimeZoneManager.Instance.TimeZones = new List <String>();
query = "Select * From TimeZone";
dt = new DataTable();
adapter = new SqlDataAdapter(query, cnn);
adapter.Fill(dt);
foreach (DataRow row in dt.Rows)
{
TimeZoneManager.Instance.TimeZones.Add((String)row["Title"]);
}
}