public List <ProgramareServiciu> selectServiciiClient(int id)
{
List <ProgramareServiciu> programareServiciuList = new List <ProgramareServiciu>();
String sql = "SELECT * FROM programareServiciu WHERE id=@id";
try
{
_conn.Open();
SqlCommand cmd = new SqlCommand(sql, _conn);
cmd.Parameters.AddWithValue("@id", id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ProgramareServiciu programareServiciu = new ProgramareServiciu(Int32.Parse(reader["id"].ToString()), reader["numeServiciu"].ToString());
programareServiciuList.Add(programareServiciu);
}
_conn.Close();
}
catch (SqlException e)
{
Console.WriteLine(e.Message);
return(null);
}
return(programareServiciuList);
}
public async Task <IActionResult> Create([Bind("ProgramareId,ServiciuId")] ProgramareServiciu programareServiciu)
{
if (ModelState.IsValid)
{
_context.Add(programareServiciu);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ProgramareId"] = new SelectList(_context.Programare, "ProgramareId", "ProgramareId", programareServiciu.ProgramareId);
ViewData["ServiciuId"] = new SelectList(_context.Serviciu, "ServiciuId", "ServiciuId", programareServiciu.ServiciuId);
return(View(programareServiciu));
}
public bool addProgramareServicii(ProgramareServiciu programareServiciu)
{
String sql = "INSERT INTO programareServiciu(id,numeServiciu) VALUES (@val1,@val2)";
try
{
_conn.Open();
SqlCommand cmd = new SqlCommand(sql, _conn);
cmd.Parameters.AddWithValue("@val1", programareServiciu.getId());
cmd.Parameters.AddWithValue("@val2", programareServiciu.getNumeServiciu());
cmd.ExecuteNonQuery();
_conn.Close();
}
catch (SqlException e)
{
Console.WriteLine(e.Message);
return(false);
}
return(true);
}
public bool adaugareProgramare(String numeClient, String data, String ora, String telefon, List <String> servicii)
{
DateTime dataP;
DateTime oraP;
try
{
dataP = DateTime.ParseExact(data, "yyyy-MM-dd", null);
oraP = DateTime.Parse(ora);
}catch (FormatException e)
{
return(false);
}
if (!esteNrTelefon(telefon) || servicii.Count == 0)
{
return(false);
}
//verificare sa nu mai fie programari la aceeasi ora si cu aceleasi servicii sau cu un serviciu la fel.
List <Programare> programari = listaProgramari(data);
if (programari != null)
{
foreach (Programare programareV in programari)
{
if (programareV.getOra() == oraP)
{
foreach (String serviciu in servicii)
{
foreach (Serviciu serviciuP in programareV.getServicii())
{
if (serviciu.Equals(serviciuP.getNume()))
{
return(false);
}
}
}
}
}
}
List <Serviciu> serviciiList = new List <Serviciu>();
foreach (String numeServiciu in servicii)
{
Serviciu ser = _serviciuDAO.getServiciu(numeServiciu);
serviciiList.Add(ser);
}
Programare programare = new Programare(numeClient, dataP, oraP, telefon, serviciiList);
int id_servicii = _programareDAO.addProgramare(programare);
if (id_servicii != -1)
{
foreach (Serviciu serviciu in programare.getServicii())
{
ProgramareServiciu programareServiciu = new ProgramareServiciu(id_servicii, serviciu.getNume());
_programareServiciuDAO.addProgramareServicii(programareServiciu);
}
}
return(id_servicii != -1);
}
public bool addProgramareServiciu(ProgramareServiciu programareServiciu)
{
return(_programareServiciuDAO.addProgramareServicii(programareServiciu));
}
