public async Task <IActionResult> PutClient(string id, Planning pln)
{
if (id != pln.codePlanning)
{
return(BadRequest());
}
dbContext.Entry(pln).State = EntityState.Modified;
try
{
await dbContext.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PlanningExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void Reset()
{
Inputs.Clear();
Outputs.Clear();
TFOutputs.Clear();
Planning.Clear();
}
public async Task <ActionResult <Planning> > PostClient(Planning pln)
{
dbContext.Plannings.Add(pln);
await dbContext.SaveChangesAsync();
return(Ok(new{ success = "success" }));
}
public void Query()
{
Planning planningOutput = _planningRepository.Create(_planningInput);
IEnumerable <Planning> planningsOutput = _planningRepository.Query().ToList();
Assert.True(planningsOutput.Count() > 0);
}
public IActionResult GetById(/*[FromRoute]*/ int Id)
{
Planning plan = new Planning();
plan = _planRepo.GetById(Id);
return(Ok(plan));
}
public void GetByLabel()
{
Planning planningOutput = _planningRepository.Create(_planningInput);
Planning planningOutput2 = _planningRepository.GetByLabel(planningOutput.LabelPlanning);
Assert.True(planningOutput2 != null);
}
public void ModifyPlanning(Planning planning, Priority priority)
{
Priority = priority;
Planning = planning;
DomainEvents.Add(new FeaturePlanningModifiedEvent(planning, priority));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Nom")] Planning planning)
{
if (id != planning.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(planning);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PlanningExists(planning.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(planning));
}
private static void DaysSelector(Planning pParams, List <Day> days, List <Day> selectedDay)
{
for (int i = pParams.StartingDayId; i <= pParams.EndingDayId; i++)
{
selectedDay.Add(days[i - 1]);
}
}
public RegSummaryPage(Planning planning)
{
InitializeComponent();
this.planning = planning;
this.Title = string.Format("{0}-{1}", planning.Reference, planning.Customer);
lvRegistrations.ItemTapped += LvRegistrations_ItemTapped;
registrations = App.dbHandler.db.Query <Registration> ("select * from Registration where PlanningID=? Order by Priority", planning.ID);
editedReg = null;
ToolbarItem addItem = new ToolbarItem()
{
Text = AppResources.itemAdd
};
addItem.Clicked += BtnAddRegistrationClicked;
ToolbarItems.Add(addItem);
switch (Device.RuntimePlatform)
{
case Device.iOS:
edResult.BackgroundColor = Color.FromHex("#e6e6e6");
break;
case Device.Android:
edResult.BackgroundColor = Color.LightGray; // Color.FromHex("#2c3e50");
edResult.TextColor = Color.Black;
break;
case Device.UWP:
edResult.BackgroundColor = Color.FromHex("#2c3e50");
break;
}
}
Planning ConvertPlanning(XElement element)
{
Planning p = new Planning();
for (int i = 0; i < 7; i++)
{
p.Plan[i].Selected = (from X in element.Elements()
where X.Name == String.Format("Day{0}", i + 1)
select Convert.ToBoolean(X.Element("Selected").Value)
).FirstOrDefault();
p.Plan[i].Day = (from X in element.Elements()
where X.Name == String.Format("Day{0}", i + 1)
select(X.Element("Name").Value)).FirstOrDefault();
p.Plan[i].Start = (from X in element.Elements()
where X.Name == String.Format("Day{0}", i + 1)
select DateTime.Parse(X.Element("Start").Value)).FirstOrDefault();
p.Plan[i].End = (from X in element.Elements()
where X.Name == String.Format("Day{0}", i + 1)
select DateTime.Parse(X.Element("End").Value)).FirstOrDefault();
}
return(p);
}
public Guid Create(Planning obj)
{
try
{
obj.Id = Guid.NewGuid();
obj.InternalInvestments.ForEach(x => { x.Id = Guid.NewGuid(); });
_context.Entry(obj).State = EntityState.Modified;
_context.Planning.Add(obj);
obj.InternalInvestments.ForEach(i =>
{
_context.Entry(i).State = EntityState.Modified;
_context.InternalInvestment.Add(i);
});
_context.SaveChanges();
return(obj.Id);
}
catch (Exception)
{
return(Guid.Empty);
}
}
public Planning SavePlanning(Planning planning)
{
_repository.MyPlanning = planning;
Persist();
return(planning);
}
private void btnRemove_Click(object sender, EventArgs e)
{
DialogResult result = FormUtility.MsgDelete();
if (result == DialogResult.Yes)
{
int i = gridView1.GetSelectedRows().FirstOrDefault();
Planning row = gridView1.GetRow(i) as Planning;
if (row == null)
{
return;
}
try
{
using (IUnitOfWork uow = new UnitOfWork())
{
uow.PlanningRepository.Remove(row.PlanningId);
uow.PlanningDetailRepository.RemovebyPlanning(row);
uow.Commit();
}
gridView1.DeleteRow(i);
}
catch
{
lblNotify1.SetText(UI.removefailed, ToolBoxCS.LabelNotify.EnumStatus.Failed);
}
}
}
public async Task <IActionResult> Edit(string id, [Bind("ProfileId,Goal,SavedForMonth,Paid,StartDate,FinalDate")] Planning planning)
{
if (id != planning.ProfileId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(planning);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PlanningExists(planning.ProfileId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["ProfileId"] = new SelectList(_context.Users, "Id", "Id", planning.ProfileId);
return(View(planning));
}
public Planning Create(Planning planning)
{
planning = Context.Plannings.Add(planning);
Context.SaveChanges();
return(planning);
}
public int AddEvent(int dossierId, string description, int responsible, DateTime deadline, DateTime?completionDate)
{
int result = 0;
using (Database.DossierContext dossierContext = new Database.DossierContext())
{
Planning planning = new Planning();
planning.DossierId = dossierId;
planning.Description = description;
planning.Responsible = responsible;
planning.Deadline = deadline;
planning.CompletionDate = completionDate;
planning.Created = DateTime.Now;
/* FluentValidation.Results.ValidationResult validationResult = new DossierValidator().Validate(dossier);
*
* if (validationResult.IsValid)
* {*/
dossierContext.Planning.Add(planning);
result = dossierContext.SaveChanges();
/* }
* else
* {
* DossierValidator.DisplayErrorMessage(validationResult);
* }*/
}
return(result);
}
public static List <Planning> GetPlanningsBack(Int32?_Mois = null, Int32?_Annee = null, Int32?_Plus = null)
{
DBModelsParameters _DB = new WS.Models.DBModelsParameters();
List <PlanningResult> _PlanningResults = _DB.GetPlanningsBack(_Mois, _Annee, _Plus).ToList();
List <Planning> _Plannings = new List <Planning>();
foreach (PlanningResult _CurrentP in _PlanningResults)
{
Planning _NewPlanning = new Planning();
_NewPlanning.Id = _CurrentP.Id;
_NewPlanning.Creneau0809 = (String.IsNullOrEmpty(_CurrentP.Creneau0809) ? null : _CurrentP.Creneau0809.Trim());
_NewPlanning.Creneau0910 = (String.IsNullOrEmpty(_CurrentP.Creneau0910) ? null : _CurrentP.Creneau0910.Trim());
_NewPlanning.Creneau1011 = (String.IsNullOrEmpty(_CurrentP.Creneau1011) ? null : _CurrentP.Creneau1011.Trim());
_NewPlanning.Creneau1112 = (String.IsNullOrEmpty(_CurrentP.Creneau1112) ? null : _CurrentP.Creneau1112.Trim());
_NewPlanning.Creneau1213 = (String.IsNullOrEmpty(_CurrentP.Creneau1213) ? null : _CurrentP.Creneau1213.Trim());
_NewPlanning.Creneau1314 = (String.IsNullOrEmpty(_CurrentP.Creneau1314) ? null : _CurrentP.Creneau1314.Trim());
_NewPlanning.Creneau1415 = (String.IsNullOrEmpty(_CurrentP.Creneau1415) ? null : _CurrentP.Creneau1415.Trim());
_NewPlanning.Creneau1516 = (String.IsNullOrEmpty(_CurrentP.Creneau1516) ? null : _CurrentP.Creneau1516.Trim());
_NewPlanning.Creneau1617 = (String.IsNullOrEmpty(_CurrentP.Creneau1617) ? null : _CurrentP.Creneau1617.Trim());
_NewPlanning.Creneau1718 = (String.IsNullOrEmpty(_CurrentP.Creneau1718) ? null : _CurrentP.Creneau1718.Trim());
_NewPlanning.Creneau1819 = (String.IsNullOrEmpty(_CurrentP.Creneau1819) ? null : _CurrentP.Creneau1819.Trim());
_NewPlanning.Creneau1920 = (String.IsNullOrEmpty(_CurrentP.Creneau1920) ? null : _CurrentP.Creneau1920.Trim());
_NewPlanning.Jour = _CurrentP.Jour;
_Plannings.Add(_NewPlanning);
}
return(_Plannings);
}
public PlanningViewModel(JAGToddlerDatabaseContext context, DateTime planDate, int storeId, int classId)
{
SelectedPlanDate = new DateTime(planDate.Year, planDate.Month, 1, 0, 0, 0);
StoreList = context.Stores
.OrderBy(s => s.StoreName)
.AsNoTracking()
.ToList();
SelectedStoreId = storeId;
StoreSelect = new SelectList(StoreList, "StoreId", "StoreName", SelectedStoreId).ToList();
//#TODO
//Should this search StoreList instead even though I would need to use a loop?
int?companyId = context.Stores
.Find(storeId)
.CompanyId;
ClassList = context.Classifications
.Include(c => c.Dept)
.Where(c => c.Dept.CompanyId == companyId)
.Select(c => new Classifications
{
Classes = c.Classes,
ClassId = c.ClassId
})
.OrderBy(c => c.Classes)
.AsNoTracking()
.ToList();
SelectedClassId = classId;
ClassSelect = new SelectList(ClassList, "ClassId", "Classes", SelectedClassId);
PlanningModel = new Planning(context, SelectedPlanDate, SelectedStoreId, SelectedClassId);
}
public ActionResult GetPlanning(int id, int planningId)
{
if (planningId == 0)
{
return(Last(id));
}
var workbook = new XLWorkbook();
JourEvenement jour;
string strPrefixFile = "new";
using (var ctx = new FestivArtsContext())
{
jour = ctx.JourEvenements.First(s => s.Id == id);
Planning p = ctx.Plannings.Include("Affectations.Benevole").First(s => s.Id == planningId);
if (p != null)
{
if (!string.IsNullOrWhiteSpace(p.Nom))
{
strPrefixFile = p.Nom;
}
else
{
strPrefixFile = p.Date.ToShortDateString();
}
}
ExcelUtils.FillPlanning(workbook, ctx, jour, p);
}
var stream = new MemoryStream();
workbook.SaveAs(stream);
stream.Position = 0;
return(File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", strPrefixFile + "Planning" + jour.Nom + ".xlsx"));
}
public void GetBySuperUser()
{
Planning planningOutput = _planningRepository.Create(_planningInput);
Planning planningOutput2 = _planningRepository.GetBySuperUser(planningOutput.IdSuperUser);
Assert.True(planningOutput2 != null);
}
public static Planning getOneById(int id)
{
Planning bean = new Planning();
NpgsqlConnection connect = new Connexion().Connection();
try
{
string query = "select * from yvs_grh_planning_employe where id =" + id + ";";
NpgsqlCommand Lcmd = new NpgsqlCommand(query, connect);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
if (lect.HasRows)
{
while (lect.Read())
{
bean = Return(lect);
}
}
return(bean);
}
catch (Exception ex)
{
Messages.Exception("PlanningDao (getOneById) ", ex);
return(bean);
}
finally
{
Connexion.Close(connect);
}
}
public static Planning getOneByDateEmploye(long employe, long tranche, DateTime dateDebut, DateTime dateFin)
{
Planning bean = new Planning();
NpgsqlConnection connect = new Connexion().Connection();
try
{
string query = "select * from yvs_grh_planning_employe where employe = " + employe + " and tranche = " + tranche + " and date_debut = '" + dateDebut.ToString("dd-MM-yyyy") + "' and date_fin = '" + dateFin.ToString("dd-MM-yyyy") + "'";
NpgsqlCommand Lcmd = new NpgsqlCommand(query, connect);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
if (lect.HasRows)
{
while (lect.Read())
{
bean = Return(lect);
}
}
return(bean);
}
catch (Exception ex)
{
Messages.Exception("PlanningDao (getOneByDateEmploye) ", ex);
return(bean);
}
finally
{
Connexion.Close(connect);
}
}
private void Awake()
{
// Recogida de componenetes
cookerPathSeeker = GetComponent <Unit>();
pathfinding = GetComponent <Pathfinding>();
world = FindObjectOfType <World>();
plannifier = GetComponent <Planning>();
}
public ActionResult DeleteConfirmed(int id)
{
Planning planning = db.Plannings.Find(id);
db.Plannings.Remove(planning);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public FormAjouterActivite(Jour tempJourActuel, List<Astronautes> tempListeAstronautes, List<Lieu> tempListeLieu, Planning tempPlanning)
{
InitializeComponent();
jourActuel = tempJourActuel;
listeAstronautes = tempListeAstronautes;
listeLieu = tempListeLieu;
planning = tempPlanning;
}
public async Task DeletePlanningAsync(Planning planning)
{
var r = await _dpContext.Planning.FindAsync(planning.PlanningId);
_dpContext.Planning.Remove(r);
await _dpContext.SaveChangesAsync();
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Planning planning = await db.Planning.FindAsync(id);
db.Planning.Remove(planning);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
//Constructeur par défaut
public Form2(List<Jour> tempListeJour, int tempJourSelection, Planning tempPlanning, List<Astronautes> tempListeAstronautes, List<Lieu> tempListeLieu)
{
listeJour = tempListeJour;
jourSelection = tempJourSelection;
InitializeComponent();
planning = tempPlanning;
listeAstronautes = tempListeAstronautes;
listeLieu = tempListeLieu;
}
public ActionResult Edit([Bind(Include = "Id,Titre")] Planning planning)
{
if (ModelState.IsValid)
{
db.Entry(planning).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(planning));
}
private void btnClear_Click(object sender, EventArgs e)
{
m_Po = null;
m_Planning = new Planning();
m_Product = new Product();
txtPlanningCode.ReadOnly = true;
FormUtility.ResetForm(this);
listView1.Items.Clear();
gridControl1.DataSource = null;
}
public FeaturePlanningModifiedEvent(Planning planning, Priority priority)
{
Priority = priority;
Effort = planning.Effort;
BusinessValue = planning.BusinessValue;
TimeCriticality = planning.TimeCriticality;
StartDate = planning.StartDate;
TargetDate = planning.TargetDate;
Risk = planning.Risk;
}
protected override bool BindingExists(Activation.IContext context, Planning.Targets.ITarget target)
{
if (target.HasDefaultValue)
return true;
var targetType = GetTargetType(target);
var searchKernel = context.Kernel;
while(searchKernel != null)
{
if (searchKernel.GetBindings(targetType).Any(b => !b.IsImplicit))
return true;
if (searchKernel is IChildKernel)
searchKernel = (searchKernel as IChildKernel).ParentResolutionRoot as IKernel;
else break;
}
return false;
}
//FinAccesseurs//
//Au chargement de la page, on initialise le planning qui contient la liste de jour et propose un premier affichage par défaut.
private void Form1_Load_1(object sender, EventArgs e)
{
Lieu stationMars = new Lieu("base principale", 0, 0);
Lieu lieuExploration1 = new Lieu("cratere 1 ", 50, 50);
listeDeLieux.Add(stationMars);
listeDeLieux.Add(lieuExploration1);
List<Astronautes> listeAstronautesParDefaut1 = new List<Astronautes>();
List<Astronautes> listeAstronautesParDefaut2 = new List<Astronautes>();
Astronautes a1 = new Astronautes("Johnson", "John", 30);
Astronautes a2 = new Astronautes("Billyson", "Billy Junior", 30);
Astronautes a3 = new Astronautes("Pokora", "Matt", 30);
Astronautes a4 = new Astronautes("Josianeson", "Josiane", 28);
Astronautes a5 = new Astronautes("Poliakoff", "Paula", 35);
listeDesAstronautes.Add(a1);
listeDesAstronautes.Add(a2);
listeDesAstronautes.Add(a3);
listeDesAstronautes.Add(a4);
listeDesAstronautes.Add(a5);
listeAstronautesParDefaut1.Add(a1);
listeAstronautesParDefaut1.Add(a2);
listeAstronautesParDefaut1.Add(a3);
listeAstronautesParDefaut2.Add(a4);
listeAstronautesParDefaut2.Add(a5);
// Activité 1
List<Activités> listeActiviteParDefaut = new List<Activités>();
// DateTime horaireDebut = new DateTime(2015, 11, 19, 08, 00, 00);
//DateTime horaireFin = new DateTime(2015, 11, 19, 09, 00, 00);
Activités activité1 = new Activités("Dormir", "Sleeping", 0, 600, stationMars, listeAstronautesParDefaut1, "Sieste matinale pour l'équipe 1");
listeActiviteParDefaut.Add(activité1);
// Activité 2
//DateTime horaireDebut2 = new DateTime(2015, 11, 19, 09, 00, 00);
//DateTime horaireFin2 = new DateTime(2015, 11, 19, 11, 00, 00);
Activités activité2 = new Activités("Repas midi", "Eating", 600, 800, stationMars, listeAstronautesParDefaut2, "Repas de l'équipe 2");
listeActiviteParDefaut.Add(activité2);
// Activité 3
//DateTime horaireDebut3 = new DateTime(2015, 11, 19, 11, 00, 00);
//DateTime horaireFin3 = new DateTime(2015, 11, 19, 13, 00, 00);
Activités activité3 = new Activités("Travail privé", "Private", 800, 1000, stationMars, listeAstronautesParDefaut2, "Temps alloué pour réaliser des tâches personnelles");
listeActiviteParDefaut.Add(activité3);
// Activité 4
//DateTime horaireDebut4 = new DateTime(2015, 11, 19, 13, 00, 00);
//DateTime horaireFin4 = new DateTime(2015, 11, 19, 14, 00, 00);
Activités activité4 = new Activités("Récurer les chiotes", "Cleaning", 1000, 1200, stationMars, listeAstronautesParDefaut1, "Nettoyage des sanitaires");
listeActiviteParDefaut.Add(activité4);
// Exploration
DateTime horaireDebut5 = new DateTime(2015, 11, 19, 14, 00, 00);
DateTime horaireFin5 = new DateTime(2015, 11, 19, 18, 00, 00);
Activités exploration = new Exploration("Exploration du cratere 0", "Vehicle", 1200, 1480, lieuExploration1, listeAstronautesParDefaut2, "Exploration du cratere numero 0");
listeActiviteParDefaut.Add(exploration);
Activités Test = new Activités("Toto", "Cleaning", 1000, 1200, lieuExploration1, listeAstronautesParDefaut2, "Exploration du cratere numero 0");
List<Activités> listeActiviteRecherche = new List<Activités>();
listeActiviteRecherche.Add(Test);
//Cette boucle implémente 500 jours pour la liste de jour
for (int i = 0; i <= 499; i++)
{
if(i==50){
Jour j = new Jour(listeActiviteRecherche);
listeJourForm1.Add(j);
}else{
Jour j = new Jour(listeActiviteParDefaut);
listeJourForm1.Add(j);
}
}
//Initialisation du planning
DateTime dateDebut = new DateTime(2015, 11, 15, 0, 0, 0);
List<Jour> listeJourPlanning = new List<Jour>();
listeJourPlanning = listeJourForm1;
planning = new Planning("Planning de Mars", listeJourPlanning, dateDebut);
jourPivot = 0;
jourActuel = planning.getJourActuel();
//Affiche les jours colorés selon leur temporalité
ListeBoutons.Add(boutonJour1);
ListeBoutons.Add(boutonJour2);
ListeBoutons.Add(boutonJour3);
ListeBoutons.Add(boutonJour4);
ListeBoutons.Add(boutonJour5);
ListeBoutons.Add(boutonJour6);
ListeBoutons.Add(boutonJour7);
ListeBoutons.Add(boutonJour8);
ListeBoutons.Add(boutonJour9);
ListeBoutons.Add(boutonJour10);
ListeBoutons.Add(boutonJour11);
ListeBoutons.Add(boutonJour12);
ListeBoutons.Add(boutonJour13);
ListeBoutons.Add(boutonJour14);
ListeBoutons.Add(boutonJour15);
ListeBoutons.Add(boutonJour16);
ListeBoutons.Add(boutonJour17);
ListeBoutons.Add(boutonJour18);
ListeBoutons.Add(boutonJour19);
ListeBoutons.Add(boutonJour20);
ListeBoutons.Add(boutonJour21);
//Affichage des jours, par défaut : 7 jours.
afficherJour(jourPivot);
affichage7Jours.PerformClick();
}
public void SetBindingType(Planning.Bindings.BindingTarget target)
{
this.BindingTarget = target;
}
