public Workshops AddWorkshop(Workshops workshopToBeAdded)
{
var addedWorkshop = conferenceContext.Add(workshopToBeAdded);
conferenceContext.SaveChanges();
return(addedWorkshop.Entity);
}
// GET: api/Workshop
public List <Workshops> Get()
{
List <Workshops> pomList = new List <Workshops>();
using (var conn = new NpgsqlConnection("Host = localhost; Port = 5555; Username = db_201617z_va_proekt_invoke_mk_owner; Password = invoke_finki; Database = db_201617z_va_proekt_invoke_mk"))
{
conn.Open();
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "SELECT * from invoke.workshops";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Workshops works = new Workshops();
works.WorkshopID = reader.GetInt64(0);
works.WorkshopName = reader.GetString(1);
works.GameName = reader.GetString(2);
pomList.Add(works);
}
}
}
}
return(pomList);
}
public async Task ExecuteLoadWorkshopsCommandAsync()
{
if (IsBusy)
{
return;
}
try
{
IsBusy = true;
var items = (await StoreManager.WorkshopStore.GetSpeakerWorkshopsAsync(SelectedSpeaker.Id)).Where(x => x.Id != _workshopId);
Workshops.ReplaceRange(items);
HasAdditionalWorkshops = Workshops.Count > 0;
}
catch (Exception ex)
{
HasAdditionalWorkshops = false;
Logger.Log(ex.Message, Prism.Logging.Category.Exception, Priority.High);
}
finally
{
IsBusy = false;
}
}
public Workshops CreateWorkshop(Workshops workshops)
{
var create = conferenceContext.Workshops.Add(workshops);
conferenceContext.SaveChanges();
return(create.Entity);
}
async Task ExecuteLoadWorkshopsCommandAsync()
{
if (LoadingWorkshops)
{
return;
}
LoadingWorkshops = true;
try
{
NoWorkshops = false;
Workshops.Clear();
OnPropertyChanged("Workshops");
var workshops = (await StoreManager.WorkshopStore.GetNextWorkshops()).ToWorkshopCellViews(WorkshopCellViewModelFactory);
if (workshops != null)
{
Workshops.AddRange(workshops);
}
NoWorkshops = Workshops.Count == 0;
}
catch (Exception ex)
{
ex.Data["method"] = "ExecuteLoadWorkshopsCommandAsync";
Logger.Log(ex.Message, Prism.Logging.Category.Exception, Priority.High);
NoWorkshops = true;
}
finally
{
LoadingWorkshops = false;
}
}
public Workshops Update(Workshops workshops)
{
var update = conferenceContext.Workshops.Update(workshops);
conferenceContext.SaveChanges();
return(update.Entity);
}
public Workshops Update(Workshops workshopToUpdate)
{
var updatedWorkshop = conferenceContext.Update(workshopToUpdate);
conferenceContext.SaveChanges();
return(updatedWorkshop.Entity);
}
public Workshops CreateWorkshops(Workshops workshops)
{
if (Isunique(workshops.Name))
{
return(workshopRepository.CreateWorkshop(workshops));
}
return(null);
}
public void Add(Workshop workshop)
{
if (workshop == null || Workshops.Contains(workshop))
{
return;
}
Workshops.Add(workshop);
}
// GET: Workshops/Details/5
public ActionResult Details(int id)
{
Workshops workshops = workshopService.GetWorkshopById(id);
WorkshopViewModel model = new WorkshopViewModel();
model.InjectFrom(workshops);
return(View(workshops));
}
public ActionResult DeletConfirmed(int id)
{
Workshops workshops = db.Workshops.Find(id);
db.Workshops.Remove(workshops);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(int id, WorkshopViewModel model)
{
Workshops workshop = new Workshops();
workshop.InjectFrom(model);
var workshopToUpdate = workshopService.UpdateWorkshop(workshop);
return(RedirectToAction(nameof(Index)));
}
public ActionResult Edit(int id, WorkshopViewModel model)
{
Workshops edit = new Workshops();
edit.InjectFrom(model);
var createNewWorkshop = workshop.Update(edit);
return(RedirectToAction(nameof(Index)));
}
async Task <bool> ExecuteLoadWorkshopsAsync(bool force = false)
{
if (IsBusy)
{
return(false);
}
try
{
NextForceRefresh = DateTime.UtcNow.AddMinutes(45);
IsBusy = true;
NoWorkshopsFound = false;
Filter = string.Empty;
Workshops.ReplaceRange((await StoreManager.WorkshopStore.GetItemsAsync(force)).ToWorkshopCellViews(WorkshopCellViewModelFactory));
WorkshopsFiltered.ReplaceRange(Workshops.Search());
SortWorkshops();
if (WorkshopsGrouped.Count == 0)
{
if (Settings.FavoritesOnly)
{
if (!Settings.ShowPastWorkshops)
{
NoWorkshopsFoundMessage = "You haven't favorited\nany workshops yet.";
}
else
{
NoWorkshopsFoundMessage = "No Workshops Found";
}
}
else
{
NoWorkshopsFoundMessage = "No Workshops Found";
}
NoWorkshopsFound = true;
}
else
{
NoWorkshopsFound = false;
}
}
catch (Exception ex)
{
Logger.Log($"{ex.Message}, Method, ExecuteLoadWorkshopsAsync", Prism.Logging.Category.Exception, Priority.High);
EventAggregator.GetEvent <ErrorEvent>().Publish(ex);
}
finally
{
IsBusy = false;
}
return(true);
}
public ActionResult Delete(int id, WorkshopViewModel model)
{
Workshops workshopToDelete = new Workshops();
workshopToDelete = workshopService.GetWorkshopById(id);
model.InjectFrom(workshopToDelete);
workshopService.Delete(workshopToDelete);
workshopService.Save();
return(RedirectToAction(nameof(Index)));
}
public Workshops AddWorkshop(Workshops workshopToBeAdded)
{
if (IsUniqueWorkshop(workshopToBeAdded.Name))
{
return(workshopRepository.AddWorkshop(workshopToBeAdded));
}
else
{
return(null);
}
}
public async void addWorkshop(Workshops workshop)
{
workshops.Add(workshop);
await service.addWorkshopAsync(new addWorkshopRequest(new addWorkshopRequestBody()
{
name = workshop.name,
speakerName = workshop.speakerName,
date = workshop.date,
description = workshop.description,
imagePath = workshop.imagePath
}));
}
public ActionResult Delete(int id, WorkshopViewModel model)
{
Workshops deleteWorkshop = new Workshops();
deleteWorkshop = workShopService.GetWorkshopsById(id);
model.InjectFrom(deleteWorkshop);
workShopService.DeleteAWorkshop(deleteWorkshop);
return(RedirectToAction(nameof(Index)));
}
// GET: Workshops/Delete/5
public ActionResult Delet(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Workshops workshops = db.Workshops.Find(id);
if (workshops == null)
{
return(HttpNotFound());
}
return(View(workshops));
}
private void AddWorkshop_Clicked(object sender, RoutedEventArgs e)
{
Workshops tempWorkhop = new Workshops(TextBoxName.Text, TextBoxOrganizer.Text, Convert.ToDateTime(TextBoxDate.Text), TextBoxDescription.Text, "Image/Path");
serviceMethods.addWorkshop(tempWorkhop);
WorkshopDataGrid.Items.Add(tempWorkhop);
//Workshop tempWorkshop = new Workshop();
//tempWorkshop.workshopName = TextBoxName.Text;
//tempWorkshop.workshopOrganizer = TextBoxOrganizer.Text;
//tempWorkshop.workshopDescription = TextBoxDescription.Text;
//tempWorkshop.workshopDate = TextBoxDate.Text;
//WorkshopDataGrid.Items.Add(tempWorkshop);
}
private void Seed()
{
Users.Add(
"Roman", new User()
{
City = "Lviv",
Country = "Ukraine",
Email = "*****@*****.**",
PostalCode = 81000,
UserName = "******"
});
Users.Add(
"Dariia", new User()
{
City = "Kyiv",
Country = "Ukraine",
Email = "*****@*****.**",
PostalCode = 79000,
UserName = "******"
});
Workshops.Add("Car Repair",
new CarWorkshop
{
PostalCode = 81000,
Country = "Ukraine",
City = "Lviv",
CompanyName = "Car Repair",
CarTrademarks = new List <string>
{
"VW", "BMW"
}
});
Workshops.Add("Automoto",
new CarWorkshop
{
PostalCode = 79000,
Country = "Ukraine",
City = "Kyiv",
CompanyName = "Automoto",
CarTrademarks = new List <string>
{
"VW", "MB"
}
});
}
private void editWorkshop(object sender, RoutedEventArgs e)
{
Workshops tempWorkshop = new Workshops();
serviceMethods.updateWorkshop(new Workshops(TextBoxName.Text, TextBoxOrganizer.Text, Convert.ToDateTime(TextBoxDate.Text), TextBoxDescription.Text, "workshopIcon.png"));
foreach (Workshops workshop in serviceMethods.getWorkshops())
{
if (workshop.name.Equals(TextBoxName.Text))
{
WorkshopDataGrid.Items.Remove(workshop);
tempWorkshop = workshop;
break;
}
}
}
public ActionResult Create(WorkshopViewModel model)
{
if (ModelState.IsValid)
{
Workshops newWorkshop = new Workshops();
newWorkshop.InjectFrom(model);
var createWorkshop = workshop.CreateWorkshops(newWorkshop);
if (createWorkshop == null)
{
ModelState.AddModelError("CompanyName", "Must be unique");
return(View(model));
}
}
return(RedirectToAction(nameof(Index)));
}
async Task ExecuteFilterWorkshopsAsync()
{
IsBusy = true;
NoWorkshopsFound = false;
// Abort the current command if the query has changed and is not empty
if (!string.IsNullOrEmpty(Filter))
{
var query = Filter;
await Task.Delay(250);
if (query != Filter)
{
return;
}
}
WorkshopsFiltered.ReplaceRange(Workshops.Search(Filter));
SortWorkshops();
if (WorkshopsGrouped.Count == 0)
{
if (Settings.FavoritesOnly)
{
if (!Settings.ShowPastWorkshops && !string.IsNullOrWhiteSpace(Filter))
{
NoWorkshopsFoundMessage = "You haven't favorited\nany workshops yet.";
}
else
{
NoWorkshopsFoundMessage = "No Workshops Found";
}
}
else
{
NoWorkshopsFoundMessage = "No Workshops Found";
}
NoWorkshopsFound = true;
}
else
{
NoWorkshopsFound = false;
}
IsBusy = false;
}
private void deleteWorkshop(object sender, RoutedEventArgs e)
{
Workshops tempWorkshop = new Workshops();
foreach (Workshops workshop in serviceMethods.getWorkshops())
{
if (workshop.name.Equals(TextBoxName.Text))
{
//serviceMethods.getWorkshops().Remove(workshop);
serviceMethods.deleteWorkshop(workshop);
tempWorkshop = workshop;
refreshList();
break;
}
}
WorkshopDataGrid.Items.Remove(tempWorkshop);
}
public ActionResult Create(WorkshopViewModel model)
{
if (ModelState.IsValid)
{
Workshops workshop = new Workshops();
workshop.InjectFrom(model);
var createNewWorkshop = workshopService.AddWorkshop(workshop);
if (createNewWorkshop == null)
{
ModelState.AddModelError("Name", "The Name must be unique!");
return(View(model));
}
}
return(RedirectToAction(nameof(Index)));
}
public ActionResult AddWorkshop(WorkshopViewModel Workshop, FormCollection form)
{
// var userid = User.Identity.GetUserId();
// var tal = _context.TalentedUser.Single(w => w.TalentedId == userid);
var viewmodel = new Workshops
{
TalentedId = User.Identity.GetUserId(),
workshop_Name = Workshop.workshop_Name,
workshop_Date = Workshop.workshop_Date.Date,
workshop_Fees = Workshop.workshop_Fees,
workshop_Location = Workshop.workshop_Location,
workshop_Description = Workshop.workshop_Description,
workshop_Sessions = Workshop.workshop_Sessions,
DateTime = DateTime.Now
};
_context.Workshops.Add(viewmodel);
_context.SaveChanges();
string SelectVal = form["SelectVal"];
string[] FavIds = SelectVal.Split(',');
WorkshopUserTable fav = new WorkshopUserTable();
for (int i = 0; i < FavIds.Length; i++)
{
var id = int.Parse(FavIds[i]);
fav.Tagsid = id;
fav.Userid = User.Identity.GetUserId();
fav.Workshopid = viewmodel.Id;
_context.WorkshopUserTable.Add(fav);
_context.SaveChanges();
}
return(RedirectToAction("AddWorkshop", "TalentedUser"));
}
/*public ObservableCollection<Poststed> Source
* {
* get
* {
* // TODO WTS: Replace this with your actual data
* ObservableCollection<Poststed> poststed = PoststedDataService.AllOrdersAsync().Result;
* return poststed;
* //return PoststedDataService.GetGridSampleData();
* }
* }*/
internal async Task LoadWorkshopsAsync()
{
await LoadPoststedsAsyns();
var workshops = await workshopsDataAccess.GetWorkshopsAsync();
for (int i = 0; i < workshops.Length; i++)
{
Poststed postnumber = workshops[i].Ws_poststed;
Workshops.Add(new Workshop
{
Ws_address = workshops[i].Ws_address,
Ws_id = workshops[i].Ws_id,
Ws_name = workshops[i].Ws_name,
Ws_orgnumber = workshops[i].Ws_orgnumber,
Ws_poststed = Poststeds[5000]
});
}
}
public ActionResult Edit(int id, WorkshopViewModel model)
{
if (ModelState.IsValid)
{
Workshops workshops = new Workshops();
workshops.InjectFrom(model);
var updateWorkshop = workShopService.UpdateAWorkshop(workshops);
if (updateWorkshop == null)
{
ModelState.AddModelError("Name", "The Name must be unique");
return(View(model));
}
return(RedirectToAction(nameof(Index)));
}
else
{
return(View(model));
}
}
// POST: api/Workshop
public IHttpActionResult Post(Workshops works)
{
// using (var conn = new NpgsqlConnection("Host = localhost; Port = 5432; Username = postgres; Database = invokeTest; "))
using (var conn = new NpgsqlConnection("Host = localhost; Port = 5555; Username = db_201617z_va_proekt_invoke_mk_owner; Password = invoke_finki; Database = db_201617z_va_proekt_invoke_mk"))
{
conn.Open();
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = conn;
// Insert some data
cmd.CommandText = "INSERT INTO invoke.workshops " +
"(workshopsname,gamesname) " +
$"VALUES('{works.WorkshopName}','{works.GameName}');";
cmd.ExecuteNonQuery();
}
return(Ok("Added workshop"));
}
}
