public void StartGeneration(int generationCount) { for (int i = 0; i < generationCount; i++) { CreateTable(); InitilizePopulationBaseOnFitness(populationSize); } TimeTable t = TimeTable.GetBestTimeTable(); ClsMeetingTable objMeetingTable = new ClsMeetingTable(); ClsMeetingTable.strcMeetingTable myRowMeetingTable = objMeetingTable.GetNewRow(); ClsPublic objPublic = new ClsPublic(); foreach (Chromosome myChromosome in t.submittedChromosomes) { myRowMeetingTable.IDMeeting = myChromosome.IDMeeting; myRowMeetingTable.IDSubmitter = idPerson; myRowMeetingTable.Date = objPublic.DateTimeOfEndOfWeek(dateCurrentWeekEnd); myRowMeetingTable.Day = (short)(myChromosome.Slot.Start / 48); int temp = (myChromosome.Slot.Start % 48); temp *= 15; myRowMeetingTable.TimeFrom = TimeSpan.Parse(((temp / 60) + 8) + ":" + (temp % 60)); temp = (myChromosome.Slot.End % 48); temp *= 15; myRowMeetingTable.TimeTo = TimeSpan.Parse(((temp / 60) + 8) + ":" + (temp % 60)); objMeetingTable.Insert(myRowMeetingTable); } }
public bool AproposPresence(string id, ClsPublic p) { bool reponse = false; try { if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed) { ImplementeConnexion.Instance.Conn.Open(); } using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand()) { cmd.CommandText = "select * from tabagent where Id=@Id"; cmd.Parameters.Add(ClsParametres.Instance.AjouterParametre(cmd, "@Id", 50, DbType.String, id)); dr = cmd.ExecuteReader(); while (dr.Read()) { p.Nom = dr["Nom"].ToString(); p.Fonction = dr["Fonction"].ToString(); p.Phone = dr["Phone"].ToString(); reponse = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { dr.Close(); } return(reponse); }
protected void Page_Load(object sender, EventArgs e) { ClsPublic objPublic = new ClsPublic(); //dateCurrentWeekStart = objPublic.DateTimeOfStartOfWeek(); //dateCurrentWeekEnd = objPublic.DateTimeOfEndOfWeek(); dateCurrentWeekStart = objPublic.DateTimeOfStartOfWeek(DateTime.Parse("2016-08-10")); dateCurrentWeekEnd = objPublic.DateTimeOfEndOfWeek(DateTime.Parse("2016-08-10")); }