public ServiceResult SeansEkle(SeanceDTO dto)
{
DateTime cd = DateTime.Now;
Seance seance = new Seance()
{
FinishTime = dto.FinishTime,
StartTime = dto.StartTime,
IsActive = true,
IsDeleted = false,
CreatedDate = cd.Date,
UserId = SessionHelper.CurrentUser.Id,
Id = Guid.NewGuid()
};
ServiceResult result;
try
{
Seance islemYapildiMi = _uow.GetRepository <Seance>().Add(seance);
if (islemYapildiMi != null)
{
result = new ServiceResult("İşlem başarılı", ResultState.Success);
}
else
{
result = new ServiceResult("Yapılacak bir işlem kaydına rastlanmadı.", ResultState.Warning);
}
}
catch (Exception ex)
{
result = new ServiceResult("Hata", ResultState.Error);
}
return(result);
}
public ServiceResult SeansSil(SeanceDTO dto)
{
var seance = _uow.GetRepository <Seance>().Get(dto.Id);
seance.IsDeleted = true;
seance.UserId = SessionHelper.CurrentUser.Id;
ServiceResult result;
try
{
Seance islemYapildiMi = _uow.GetRepository <Seance>().Update(seance);
if (islemYapildiMi != null)
{
result = new ServiceResult("İşlem Başarılıdır.", ResultState.Success);
}
else
{
result = new ServiceResult("Yapılacak bir işlem kaydına rastlanamadı", ResultState.Warning);
}
}
catch (Exception ex)
{
result = new ServiceResult("Hata", ResultState.Error);
}
return(result);
}
public List <SeanceDTO> getAllSeancesByGroupId(String idGroupe)
{
MySqlCommand cmd = new MySqlCommand(queryReadAllseances, connexion);
MySqlDataReader reader = null;
List <SeanceDTO> result = new List <SeanceDTO>();
try
{
connexion.Open();
cmd.Parameters.AddWithValue("@idgroupe", idGroupe);
reader = cmd.ExecuteReader();
while (reader.Read())
{
SeanceDTO seanceDTO = new SeanceDTO();
seanceDTO.IdGroupe = reader.GetString("idgroupe");
seanceDTO.IdSeance = reader.GetString("idseance");
seanceDTO.DateDebut = reader.GetDateTime("datedebut");
seanceDTO.DateFin = reader.GetDateTime("datefin");
result.Add(seanceDTO);
}
}
catch (Exception e)
{
Console.WriteLine("Erreur dans la requete getAllSeances");
Console.Write(e.Message);
}
finally
{
connexion.Close();
}
return(result);
}
public ServiceResult SeansGuncelle(SeanceDTO dto)
{
var seance = _uow.GetRepository <Seance>().Get(dto.Id);
DtotoSeance(dto, seance);
ServiceResult result;
try
{
Seance islemYapildiMi = _uow.GetRepository <Seance>().Update(seance);
if (islemYapildiMi != null)
{
result = new ServiceResult("İşlem Başarılıdır.", ResultState.Success);
}
else
{
result = new ServiceResult("Yapılacak bir işlem kaydına rastlanamadı", ResultState.Warning);
}
}
catch (Exception ex)
{
result = new ServiceResult("Hata", ResultState.Error);
}
return(result);
}
public void init()
{
try
{
EnseigneDTO enseigneDTO = CentreView.DbCreateur.ServicePersonne.getEnseigneByGroupId(groupeDTO.IdGroupe);
PersonneDTO professeurDTO = CentreView.DbCreateur.ServicePersonne.findById(int.Parse(enseigneDTO.IdPersonne));
ActiviteDTO activiteDTO = CentreView.DbCreateur.ServiceActivite.findById(groupeDTO.IdActivite);
List <SeanceDTO> seances = CentreView.DbCreateur.ServiceGroupe.getAllSeancesByGroupId(groupeDTO.IdGroupe);
SeanceDTO lastSeance = seances.Last();
textBox1.Text = "" + seances.Count;
textBox2.Text = lastSeance.DateFin.Day + " / " + lastSeance.DateFin.Month + " / " + lastSeance.DateFin.Year;
textBox3.Text = "" + groupeDTO.Prix;
textBox4.Text = activiteDTO.Nom;
seances.ForEach(delegate(SeanceDTO seance)
{
int i = this.dataGridView1.Rows.Add();
dataGridView1.Rows[i].Cells[0].Value = seance.DateDebut.ToString();
dataGridView1.Rows[i].Cells[1].Value = seance.DateDebut.DayOfWeek;
dataGridView1.Rows[i].Cells[2].Value = seance.DateDebut.Hour + "h";
dataGridView1.Rows[i].Cells[3].Value = seance.DateFin.Hour + "h";
dataGridView1.Rows[i].Cells[4].Value = professeurDTO.Prenom + " " + professeurDTO.Nom;
});
}
catch (Exception ee)
{
Console.WriteLine("Erreur dans la requete get all seances");
Console.Write(ee.Message);
}
}
public ServiceResult SeanceDelete(SeanceDTO dto)
{
var seance = _uow.GetRepository <Seance>().Get(dto.Id);
seance.IsDeleted = true;
seance.UserId = SessionHelper.CurrentUser.Id;
ServiceResult result;
_uow.BeginTran();
try
{
Seance islemYapildiMi = _uow.GetRepository <Seance>().Update(seance);
if (islemYapildiMi != null)
{
_lc.AddLog <Seance>(seance, ProcessTypeEnum.Delete, seance.Id);
_uow.Commit();
result = new ServiceResult("İşlem Başarılıdır.", ResultState.Success);
}
else
{
result = new ServiceResult("Yapılacak bir işlem kaydına rastlanamadı", ResultState.Warning);
}
}
catch (Exception ex)
{
_uow.Rollback();
result = new ServiceResult("Hata", ResultState.Error);
}
return(result);
}
private void btnAdd_Click(object sender, EventArgs e)
{
int movieTime = 75;//movietime'dan alınacak
int movieHour = movieTime / 60;
int movieMinute = movieTime % 60;
TimeSpan movieTimeSpan = new TimeSpan(movieHour, movieMinute, 0);
string message = "";
var dto = new SeanceDTO();
#region Validation
if (cmbFinishHour.SelectedIndex != -1 && cmbStartHour.SelectedIndex != -1 && cmbFinishMinute.SelectedIndex != -1 && cmbStartMinute.SelectedIndex != -1)
{
TimeSpan startTime = new TimeSpan(int.Parse(cmbStartHour.SelectedItem.ToString()),
int.Parse(cmbStartMinute.SelectedItem.ToString()), 0);
TimeSpan finishTime = new TimeSpan(int.Parse(cmbFinishHour.SelectedItem.ToString()),
int.Parse(cmbFinishMinute.SelectedItem.ToString()), 0);
TimeSpan kalan = movieTimeSpan - (finishTime - startTime);
if (finishTime - startTime < movieTimeSpan)
{
message += ("Film " + movieHour + " saat, " + movieMinute + "dakikadır.\n" + "Lütfen " + kalan.Hours + " saat, " + kalan.Minutes + " dk daha ekleyiniz.");
}
TimeSpan seansTime = (finishTime - startTime) - movieTimeSpan;
if (finishTime - startTime > movieTimeSpan)
{
message += ("Film " + movieHour + " saat, " + movieMinute + "dakikadır.\n" + seansTime.Hours + " saat, " + seansTime.Minutes + " dk çıkartınız.");
}
dto.StartTime = startTime;
dto.FinishTime = finishTime;
}
else
{
if (cmbStartHour.SelectedIndex == -1)
{
message += "Başlangıç Saati boş geçilemez \n";
}
if (cmbFinishHour.SelectedIndex == -1)
{
message += "Bitiş Saati boş geçilemez \n";
}
if (cmbStartMinute.SelectedIndex == -1)
{
message += "Başlangıç Dakikası boş geçilemez \n";
}
if (cmbFinishMinute.SelectedIndex == -1)
{
message += "Bitiş Dakikası boş geçilemez \n";
}
}
#endregion
if (message != "")
{
MessageBox.Show(message);
return;
}
var result = _sc.SeansEkle(dto);
result.NotificationShow();
}
private List <SeanceDTO> SeanceToDto(IEnumerable <Seance> seances)
{
List <SeanceDTO> result = new List <SeanceDTO>();
foreach (var seance in seances)
{
SeanceDTO dto = new SeanceDTO();
SeanceToDto(seance, dto);
result.Add(dto);
}
return(result);
}
public ServiceResult SeanceAdd(SeanceDTO dto)
{
Seance seance = new Seance()
{
FinishTime = dto.FinishTime,
StartTime = dto.StartTime,
IsActive = true,
IsDeleted = false,
CreatedDate = DateTime.Now,
UserId = SessionHelper.CurrentUser.Id,
Id = Guid.NewGuid()
};
ServiceResult result;
_uow.BeginTran();
try
{
var seanceIsAdded = _uow.GetRepository <Seance>().GetSpesific(s => s.StartTime == dto.StartTime && s.FinishTime == dto.FinishTime && s.IsDeleted == false);
if (seanceIsAdded == null)
{
Seance islemYapildimi = _uow.GetRepository <Seance>().Add(seance);
if (islemYapildimi != null)
{
_lc.AddLog <Seance>(seance, ProcessTypeEnum.Add, seance.Id);
_uow.Commit();
result = new ServiceResult("İşlem başarılı", ResultState.Success);
}
else
{
result = new ServiceResult("Yapılacak bir işlem kaydına rastlanmadı.", ResultState.Warning);
}
}
else
{
result = new ServiceResult("Eklemek istediğiniz kayıt Seans listesinde mevcut!", ResultState.Error);
}
}
catch (Exception ex)
{
_uow.Rollback();
result = new ServiceResult("Hata", ResultState.Error);
}
return(result);
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
this.dataGridView1.Rows.Clear();
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
label6.Text = "Message : ";
groupeDTO = null;
listSeanceDTO = null;
lastSeanceDTO = null;
groupeDTO = (GroupeDTO)comboBox2.SelectedItem;
EnseigneDTO enseigneDTO = CentreView.DbCreateur.ServicePersonne.getEnseigneByGroupId(groupeDTO.IdGroupe);
PersonneDTO professeur = CentreView.DbCreateur.ServicePersonne.findById(int.Parse(enseigneDTO.IdPersonne));
this.dataGridView1.Rows.Clear();
listSeanceDTO = CentreView.DbCreateur.ServiceGroupe.getAllSeancesByGroupId(groupeDTO.IdGroupe);
lastSeanceDTO = listSeanceDTO.Last();
textBox1.Text = "" + listSeanceDTO.Count;
textBox2.Text = lastSeanceDTO.DateFin.Day + " / " + lastSeanceDTO.DateFin.Month + " / " + lastSeanceDTO.DateFin.Year;
textBox3.Text = "" + groupeDTO.Prix;
listSeanceDTO.ForEach(delegate(SeanceDTO seance)
{
int i = this.dataGridView1.Rows.Add();
dataGridView1.Rows[i].Cells[0].Value = seance.DateDebut.DayOfWeek;
dataGridView1.Rows[i].Cells[1].Value = seance.DateDebut.Hour + "h";
dataGridView1.Rows[i].Cells[2].Value = seance.DateFin.Hour + "h";
dataGridView1.Rows[i].Cells[3].Value = professeur.Prenom + " " + professeur.Nom;
});
}
catch (Exception ee)
{
label6.Text += "Erreur dans le chargement des séances du groupe " + groupeDTO.NumeroGroupe;
Console.WriteLine("Erreur dans la requete get all seances");
Console.Write(ee.Message);
}
}
public void addSeance(SeanceDTO seanceDTO)
{
MySqlCommand cmd = new MySqlCommand(queryCreateSeance, connexion);
cmd.Parameters.AddWithValue("@idgroupe", seanceDTO.IdGroupe);
cmd.Parameters.AddWithValue("@datedebut", seanceDTO.DateDebut);
cmd.Parameters.AddWithValue("@datefin", seanceDTO.DateFin);
try
{
connexion.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.Write(e.Message);
}
finally
{
connexion.Close();
}
}
public ServiceResult SeanceUpdate(SeanceDTO dto)
{
var seance = _uow.GetRepository <Seance>().Get(dto.Id);
DtotoSeance(dto, seance);
ServiceResult result;
_uow.BeginTran();
try
{
var seanceUpdated = _uow.GetRepository <Seance>().GetSpesific(s => s.StartTime == dto.StartTime && s.FinishTime == dto.FinishTime && s.IsDeleted == false);
if (seanceUpdated == null)
{
Seance islemYapildiMi = _uow.GetRepository <Seance>().Update(seance);
if (islemYapildiMi != null)
{
_lc.AddLog <Seance>(seance, ProcessTypeEnum.Update, seance.Id);
_uow.Commit();
result = new ServiceResult("İşlem Başarılıdır.", ResultState.Success);
}
else
{
result = new ServiceResult("Yapılacak bir işlem kaydına rastlanamadı", ResultState.Warning);
}
}
else
{
result = new ServiceResult("Eklemek istediğiniz kayıt Seans listesinde mevcut!", ResultState.Error);
}
}
catch (Exception ex)
{
_uow.Rollback();
result = new ServiceResult("Hata", ResultState.Error);
}
return(result);
}
public void addSeance(SeanceDTO seanceDTO)
{
groupeDAO.addSeance(seanceDTO);
}
public FormSeansUpdate(SeanceDTO seance)
{
InitializeComponent();
_seance = seance;
_sc = new SeanceController();
}
private void button1_Click(object sender, EventArgs e)
{
label4.Text = "Message : ";
try
{
ActiviteDTO activiteDTO = (ActiviteDTO)comboBox1.SelectedItem;
PersonneDTO professeur = (PersonneDTO)comboBox2.SelectedItem;
groupeDTO.IdActivite = activiteDTO.IdActivite;
groupeDTO.NumeroGroupe = textBox3.Text;
groupeDTO.Prix = decimal.Parse(textBox4.Text);
if (this.mode.Equals("Créer"))
{
String idgroupe = CentreView.DbCreateur.ServiceGroupe.creer(groupeDTO);
// add prof
EnseigneDTO enseigneDTO = new EnseigneDTO();
enseigneDTO.IdGroupe = idgroupe;
enseigneDTO.IdPersonne = professeur.IdPersonne;
CentreView.DbCreateur.ServicePersonne.addEnseigne(enseigneDTO);
//Crée les seance
int nbSeance = int.Parse(textBox2.Text);
DateTime nextSeanceDebut = dateTimePicker2.Value;
int seanceHour = (int)numericUpDown1.Value;
nextSeanceDebut = ChangeTime(nextSeanceDebut, seanceHour, 0, 0, 0);
DateTime nextSeanceFin = nextSeanceDebut.AddHours(int.Parse(activiteDTO.Duree));
for (int i = 0; i < nbSeance; i++)
{
if (checkBox1.Checked)
{
for (int j = 0; j < 7; j++)
{
SeanceDTO seanceDTO = new SeanceDTO();
seanceDTO.IdGroupe = idgroupe;
seanceDTO.DateDebut = nextSeanceDebut.AddDays(j);
seanceDTO.DateFin = nextSeanceFin.AddDays(j);
CentreView.DbCreateur.ServiceGroupe.addSeance(seanceDTO);
}
}
else
{
SeanceDTO seanceDTO = new SeanceDTO();
seanceDTO.IdGroupe = idgroupe;
seanceDTO.DateDebut = nextSeanceDebut;
seanceDTO.DateFin = nextSeanceFin;
CentreView.DbCreateur.ServiceGroupe.addSeance(seanceDTO);
}
nextSeanceDebut = nextSeanceDebut.AddDays(7);
nextSeanceFin = nextSeanceFin.AddDays(7);
}
label4.Text += "Le groupe " + groupeDTO.NumeroGroupe + " a bien été crée";
CentreView.RefreshTableGroupe();
}
else if (this.mode.Equals("Modifier"))
{
groupeDTO.IdGroupe = textBox1.Text;
CentreView.DbCreateur.ServiceGroupe.update(groupeDTO);
label4.Text += "Le groupe " + groupeDTO.NumeroGroupe + " a bien été modifié";
CentreView.RefreshTableGroupe();
}
}
catch (Exception ee)
{
label4.Text = "Informations incorrectes";
Console.WriteLine("Erreur dans la connexion par ID");
Console.Write(ee.Message);
}
}
private void DtotoSeance(SeanceDTO dto, Seance seance)
{
seance.Id = dto.Id;
seance.StartTime = dto.StartTime;
seance.FinishTime = dto.FinishTime;
}
private void SeanceToDto(Seance seance, SeanceDTO dto)
{
dto.Id = seance.Id;
dto.StartTime = seance.StartTime;
dto.FinishTime = seance.FinishTime;
}
