public List <Programare> getListaProgramari()
{
List <Programare> listaProgramari = new List <Programare>();
Programare u = null;
String sql = "SELECT * FROM appointment";
try
{
_conn.Open();
SqlCommand cmd = new SqlCommand(sql, _conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
u = new Programare(Int32.Parse(reader["id"].ToString()), reader["appointmentDate"].ToString(), reader["ora"].ToString(), reader["clientName"].ToString(), reader["telefon"].ToString(), reader["services"].ToString(), Int32.Parse(reader["price"].ToString()));
listaProgramari.Add(u);
}
_conn.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(null);
}
return(listaProgramari);
}
public ActionResult Edit(int id, Programare ProgramareRequest)
{
try
{
if (ModelState.IsValid)
{
Programare aux = db.Programari.SingleOrDefault(b => b.ProgramareId.Equals(id));
if (TryUpdateModel(aux))
{
aux.An = ProgramareRequest.An;
aux.Luna = ProgramareRequest.Luna;
aux.Zi = ProgramareRequest.Zi;
aux.Ora = ProgramareRequest.Ora;
aux.TipProgramare = ProgramareRequest.TipProgramare;
aux.Observatii = ProgramareRequest.Observatii;
aux.PacientId = ProgramareRequest.PacientId;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
return(View(ProgramareRequest));
}
catch (Exception e)
{
return(View(ProgramareRequest));
}
}
public ActionResult SelectDate([Bind(Include = "Id,IdUtilizator,Data,Serviciu,Interval")] Programare programare)
{
try
{
var oreLucrate = Enum.GetValues(typeof(Interval)).Cast <Interval>();
var oreOcupate = db.Programari.Where(x => x.Interval.HasValue && x.Data == programare.Data).Select(x => x.Interval).ToList();
var alteOre = oreLucrate.Where(x => !oreOcupate.Contains(x)).Select(e => e.GetDescription()).ToList();
var altIntervalDisponibil = alteOre.Any();
if (!altIntervalDisponibil)
{
ViewBag.alteOre = string.Join(", ", alteOre);
ViewBag.indisponibil = 1;
return(View(programare));
}
programare.Id = Guid.NewGuid();
programare.IdUtilizator = User.Identity.GetUserId();
db.Programari.Add(programare);
db.SaveChanges();
return(RedirectToAction("Create"));
}
catch
{
return(View(programare));
}
}
public async Task <IActionResult> DeleteConfirmed(int id)
{
Programare programare = _programareService.GetProgramare(id);
_programareService.StergereProgramare(programare);
return(RedirectToAction(nameof(Index)));
}
public List <Programare> getProgramariClient(String numeClient)
{
String sql = "SELECT * FROM programare WHERE numeClient=@numeClient";
List <Programare> programari = new List <Programare>();
try
{
_conn.Open();
SqlCommand cmd = new SqlCommand(sql, _conn);
cmd.Parameters.AddWithValue("@numeClient", numeClient);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DateTime dataP = DateTime.Parse(reader["data"].ToString());
DateTime oraP = DateTime.Parse(reader["ora"].ToString());
Programare programare = new Programare(reader["numeClient"].ToString(), dataP, oraP, reader["telefon"].ToString(), null);
programare.setId(Int32.Parse(reader["id_servicii"].ToString()));
programari.Add(programare);
}
_conn.Close();
}
catch (SqlException e)
{
Console.WriteLine(e.Message);
return(null);
}
return(programari);
}
private void LoadProgramari()
{
const string stringSql = "SELECT * FROM Programare";
using (SQLiteConnection connection = new SQLiteConnection(ConnectionString))
{
connection.Open();
var command = new SQLiteCommand(stringSql, connection);
SQLiteDataReader sqlReader = command.ExecuteReader();
while (sqlReader.Read())
{
int id = Convert.ToInt32(sqlReader["ID"]);
DateTime data = Convert.ToDateTime(sqlReader["Data"]);
String medic = (String)sqlReader["Medic"];
String mail = (String)sqlReader["Mail"];
String telefon = (String)sqlReader["Telefon"];
String specialitate = (String)sqlReader["Specialitate"];
String pacient = (String)sqlReader["Pacient"];
Programare p = new Programare(data, new Medic(medic, "", 0), mail, telefon, specialitate, pacient, id);
programari.Add(p);
}
}
}
public ActionResult Programare(string id)
{
string guid = User.Identity.GetUserId();
Medic medic = db.Medic
.Include(_ => _.Programari.Select(y => y.Pacient))//.OrderBy(_ => _.StartDateTime))
.Where(_ => _.accountGuid.ToString() == guid)
.FirstOrDefault();
Pacient pacient = db.Pacient.Find(id);
DateTime refereceDateTime = DateTime.Now;
Programare programare = new Programare
{
StartDateTime = refereceDateTime,
EndDateTime = refereceDateTime,
Medic = medic,
Pacient = pacient,
MedicCNP = medic.CNP,
PacientCNP = pacient.CNP
};
medic.Programari.Add(programare);
medic.Programari =
medic.Programari
.Where(_ => _.StartDateTime >= refereceDateTime)
.OrderBy(_ => _.StartDateTime)
.ToList();
return(View(medic.Programari));
}
public int addProgramare(Programare programare)
{
String sql = "INSERT INTO programare(numeClient,data,ora,telefon)" + "output inserted.id_servicii " + " VALUES (@val1,@val2,@val3,@val4)";
object obj;
try
{
_conn.Open();
SqlCommand cmd = new SqlCommand(sql, _conn);
cmd.Parameters.AddWithValue("@val1", programare.getNumeClient());
cmd.Parameters.AddWithValue("@val2", programare.getData());
cmd.Parameters.AddWithValue("@val3", programare.getOra());
cmd.Parameters.AddWithValue("@val4", programare.getTelefon());
obj = cmd.ExecuteScalar();
_conn.Close();
}
catch (SqlException e)
{
Console.WriteLine(e.Message);
return(-1);
}
return(Int32.Parse(obj.ToString()));
}
public ActionResult Programare(IList <Programare> programari)
{
if (ModelState.IsValid)
{
//dateAdministratorModel = CalculeazaTaxe(ref dateAdministratorModel);
Programare programare = programari.OrderBy(_ => _.Id).FirstOrDefault();
Pacient pacient = db.Pacient.Find(programare.PacientCNP);
Medic medic = db.Medic.Find(programare.MedicCNP);
string emailtext = createEmail(pacient, medic, programare);
DateTime tempStart;
DateTime tempStop;
tempStart = programare.StartDateTime;
tempStop = programare.EndDateTime;
db.Programare.Add(programare);
programare.StartDateTime = new DateTime(tempStart.Year, tempStart.Day, tempStart.Month, tempStart.Hour, tempStart.Minute, tempStart.Second);
programare.EndDateTime = new DateTime(tempStop.Year, tempStop.Day, tempStop.Month, tempStop.Hour, tempStop.Minute, tempStop.Second);
//db.Entry(programari).State = EntityState.Added;
db.SaveChanges();
sendProgramareInEmail(pacient.Email, emailtext);
}
return(RedirectToAction("ProgramariDetails", "Medic"));
}
public List <Programare> getRaport(string startDate, string endDate)
{
List <Programare> listaProgramari = new List <Programare>();
Programare u = null;
String sql = "select * from appointment where appointmentDate between '" + startDate + "' and '" + endDate + "'";
try
{
_conn.Open();
SqlCommand cmd = new SqlCommand(sql, _conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
u = new Programare(Int32.Parse(reader["id"].ToString()), reader["appointmentDate"].ToString(), reader["ora"].ToString(), reader["clientName"].ToString(), reader["telefon"].ToString(), null, Int32.Parse(reader["price"].ToString()));
listaProgramari.Add(u);
}
_conn.Close();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(null);
}
return(listaProgramari);
}
public async Task <IActionResult> Edit(int id, [Bind("ProgramareId,numeClient,telefon,dataOra")] Programare programare)
{
if (id != programare.ProgramareId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_programareService.UpdateProgramare(programare);
}
catch (DbUpdateConcurrencyException)
{
if (!ProgramareExists(programare.ProgramareId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(programare));
}
private void stergeProgramareToolStripMenuItem_Click(object sender, EventArgs e)
{
if (listViewBD.SelectedItems.Count == 0)
{
MessageBox.Show("Alege o programare ");
return;
}
if (MessageBox.Show("Esti sigur? ", "Sterge programarea", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)
{
try
{
ListViewItem selectedItem = listViewBD.SelectedItems[0];
Programare p = (Programare)selectedItem.Tag;
StergeRezervare(p);
AfiseazaProgramari();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public ActionResult DeleteConfirmed(int id)
{
Programare programare = db.Programari.Find(id);
db.Programari.Remove(programare);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <IActionResult> Create([Bind("ProgramareId,numeClient,telefon,dataOra")] Programare programare)
{
if (ModelState.IsValid)
{
programare.username = User.Identity.Name;
_programareService.AdaugareProgramare(programare);
return(RedirectToAction(nameof(Index)));
}
return(View(programare));
}
private string createEmail(Pacient pacient, Medic medic, Programare programare)
{
string mesaj = $"Bună ziua {pacient.Prenume} {pacient.Nume},\n\n" +
$"V-a fost confirmată o programare de către Doctor {medic.Prenume} {medic.Nume} pentru" +
$" data de {programare.StartDateTime.ToString("dd/MM/yyyy")} între orele {programare.StartDateTime.ToString("HH:mm")}" +
$" - {programare.EndDateTime.ToString("HH:mm")}. \n\n";
mesaj = mesaj +
$"Vă rugăm să contactați medicul de familie în caz de orice nelămurire la numărul de telefon: {medic.Numartelefon}\n\n" +
$"Vă mulțumim!";
return(mesaj);
}
public ActionResult Edit([Bind(Include = "ID,MedicID,PacientID,Data")] Programare programare)
{
if (ModelState.IsValid)
{
db.Entry(programare).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MedicID = new SelectList(db.Medici, "ID", "Nume", programare.MedicID);
ViewBag.PacientID = new SelectList(db.Pacienti, "ID", "Nume", programare.PacientID);
return(View(programare));
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetContentView(Resource.Layout.add_programation);
programareaCurenta = new Programare();
programareaCurenta.id_user = Services.LoggedUser.id.ToString();
FindViews();
HndleEvents();
AddSpinerContent();
// Create your application here
}
public ActionResult Delete(int id)
{
Programare aux = db.Programari.Find(id);
if (aux != null)
{
db.Programari.Remove(aux);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(HttpNotFound("Nu am gasit programarea cu id-ul " + id.ToString()));
}
public ActionResult Edit(int?id)
{
if (id.HasValue)
{
Programare aux = db.Programari.Find(id);
if (aux == null)
{
return(HttpNotFound("Nu s-a gasit programarea cu id-ul " + id.ToString()));
}
return(View(aux));
}
return(HttpNotFound("Lipseste parametrul corespunzator id-ului programarii!"));
}
private void StergeRezervare(Programare p)
{
const string stringSql = "DELETE FROM Programare WHERE Id=@id";
using (SQLiteConnection connection = new SQLiteConnection(ConnectionString))
{
connection.Open();
SQLiteCommand command = new SQLiteCommand(stringSql, connection);
command.Parameters.AddWithValue("@id", p.Id);
command.ExecuteNonQuery();
programari.Remove(p);
}
}
// GET: Programares/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Programare programare = db.Programari.Find(id);
if (programare == null)
{
return(HttpNotFound());
}
return(View(programare));
}
public ActionResult Create(Programare reservation)
{
try
{
reservation.Id = Guid.NewGuid();
programareRepository.CreateReservation(reservation);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
// GET: Programare/Edit/5
public async Task <IActionResult> Edit(int?id)
{
if (id == null)
{
return(NotFound());
}
Programare programare = _programareService.GetProgramare(id.GetValueOrDefault());
if (programare == null)
{
return(NotFound());
}
return(View(programare));
}
public ActionResult Create([Bind(Include = "ID,MedicID,PacientID,Data")] Programare programare)
{
Medic medic = db.Medici.FirstOrDefault(u => u.NumeUtilizator == User.Identity.Name);
programare.MedicID = medic.ID;
if (ModelState.IsValid)
{
db.Programari.Add(programare);
db.SaveChanges();
return(RedirectToAction("Index"));
}
//ViewBag.MedicID = new SelectList(db.Medici, "ID", "Nume", programare.MedicID);
ViewBag.PacientID = new SelectList(db.Pacienti, "ID", "Nume", programare.PacientID);
return(View(programare));
}
async void Save_Clicked(System.Object sender, System.EventArgs e)
{
var programare = new Programare {
CabinetId = ((Cabinet)this.PickerCabinet.SelectedItem).CabinetId,
ClientId = ((Client)this.PickerClient.SelectedItem).ClientId,
Data = txtData.Text
};
using (var context = new Services.Context())
{
context.Add(programare);
await context.SaveChangesAsync();
}
await Navigation.PopModalAsync();
}
public ActionResult New(Programare ProgramareRequest)
{
try
{
if (ModelState.IsValid)
{
db.Programari.Add(ProgramareRequest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ProgramareRequest));
}
catch (Exception e)
{
return(View(ProgramareRequest));
}
}
public ActionResult Create([Bind(Include = "Id,IdUtilizator,Data,Serviciu,Interval,Nume,Contact")] Programare programare)
{
try
{
Programare placeholder = db.Programari.Find(programare.Id);
placeholder.Interval = programare.Interval;
if (User.IsInRole("Administrator"))
{
placeholder.Nume = programare.Nume;
placeholder.Contact = programare.Contact;
}
else
{
placeholder.Nume = placeholder.User.Nume;
placeholder.Contact = placeholder.User.Contact ?? placeholder.User.Email;
}
if (ModelState.IsValid)
{
db.Entry(placeholder).State = EntityState.Modified;
db.SaveChanges();
if (User.IsInRole("Administrator"))
{
return(RedirectToAction("Admin"));
}
return(RedirectToAction("Index"));
}
if (User.IsInRole("Administrator"))
{
return(RedirectToAction("Admin"));
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult DeleteConfirmed(Guid id)
{
try
{
Programare programare = db.Programari.Find(id);
db.Programari.Remove(programare);
db.SaveChanges();
if (User.IsInRole("Administrator"))
{
return(RedirectToAction("Admin"));
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
private void AddProgramare(Programare p)
{
var queryString = "insert into Programare( Data ,Medic ,Mail,Telefon,Specialitate,Pacient)" +
" values(@data,@medic,@mail,@telefon,@specialitate,@pacient); " +
"SELECT last_insert_rowid()";
SQLiteConnection connection = new SQLiteConnection(ConnectionString);
connection.Open();
SQLiteCommand command = new SQLiteCommand(queryString, connection);
command.Parameters.AddWithValue("@data", p.Data);
command.Parameters.AddWithValue("@medic", p.MedicP.Nume);
command.Parameters.AddWithValue("@mail", p.Mail);
command.Parameters.AddWithValue("@telefon", p.NrTelefon);
command.Parameters.AddWithValue("@specialitate", p.Specialitate);
command.Parameters.AddWithValue("@pacient", p.NumePacient);
p.Id = Convert.ToInt32(command.ExecuteScalar());
programari.Add(p);
}
//[Authorize(Roles = "Admin")]
public ActionResult Detalii(int?id)
{
if (id.HasValue)
{
Programare aux = db.Programari.Find(id);
bool admin = false;
if (User.IsInRole("Admin") || User.IsInRole("Client"))
{
admin = true;
}
ViewBag.admin = admin;
if (aux != null)
{
return(View(aux));
}
return(HttpNotFound("Nu s-a gasit programarea cu id-ul " + id.ToString()));
}
return(HttpNotFound("Lipseste id-ul programarii!"));
}
