public void AddCerere(Cerere cerere, String username, List <Pacient> pacienti)
{
using (UnitOfWork unitOfWork = new UnitOfWork())
{
UserMedic userMedic = unitOfWork.UserMedicRepo.GetBy(um => um.Username.Equals(username));
Medic medic = unitOfWork.MedicRepo.GetBy(m => m.UserMedic.Equals(userMedic));
cerere.Medic = medic;
unitOfWork.CerereRepo.Save(cerere);
unitOfWork.Save();
Cerere cerereSalvata = unitOfWork.CerereRepo.GetBy(c => c.RH.Equals(cerere.RH) && c.Grupa.Equals(cerere.Grupa) && c.Medic.Equals(cerere.Medic) && c.Data.Equals(cerere.Data));
medic.Cereri.Add(cerereSalvata);
List <Pacient> pacientiFromDb = new List <Pacient>();
pacienti.ForEach(p => pacientiFromDb.Add(unitOfWork.PacientRepo.GetBy(pdb => pdb.Id.Equals(p.Id))));
pacientiFromDb.ForEach(p =>
{
CererePacient cp = new CererePacient()
{
IdCerere = cerereSalvata.Id, Pacient = p, Cerere = cerereSalvata, IdPacient = p.Id
};
p.CereriPacienti.Add(cp);
cerereSalvata.CererePacienti.Add(cp);
});
unitOfWork.Save();
}
}
public ActionResult EditCerere([Bind(Include = "Celula_Ceruta,Cantitate_Ceruta")] Cerere cerere)
{
var user = (Utilizator)Session["Utilizator"];
if (ModelState.IsValid)
{
cerere.Status = "procesata";
var stoc = db.Stoc.Where(x => x.OperatorCentru.Utilizator.Id_Utilizator == user.Id_Utilizator).First();
int numVal = Int32.Parse(cerere.Cantitate_Ceruta);
if (cerere.Celula_Ceruta.ToLower() == "plasma")
{
stoc.CantitatePlasma = stoc.CantitatePlasma - numVal;
}
else if (cerere.Celula_Ceruta.ToLower() == "trombocite")
{
stoc.CantitateTrombocite = stoc.CantitateTrombocite - numVal;
}
else if (cerere.Celula_Ceruta.ToLower() == "globulerosii")
{
stoc.CantitateGlobuleRosii = stoc.CantitateGlobuleRosii - numVal;
}
db.SaveChanges();
}
return(View("CerereProcesata", db.Cerere.Where(x => x.Cantitate_Ceruta == cerere.Cantitate_Ceruta && x.Celula_Ceruta == cerere.Celula_Ceruta).First().Medic));
}
private void button4_Click(object sender, EventArgs e)
{
string message = "";
Cerere cerere_de_selectat = (Cerere)dataGridView3.SelectedRows[0].DataBoundItem;
var lista_cereri = serviceCentru.GetAllCereri();
Cerere cerere = null;
foreach (var i in lista_cereri)
{
if (i.Id == cerere_de_selectat.Id)
{
cerere = i;
}
}
if (cerere != null && cerere.Efectuata != true)
{
var stoc = serviceCentru.GetAllStocuri();
int grupa;
Stoc stocBun = null;
foreach (var i in stoc)
{
if (cerere.Grupa == i.Grupa && cerere.RH == i.RH)
{
stocBun = i;
if (cerere.CantitateGlobuleRosii <= i.GlobuleRosii &&
cerere.CantitatePlasma <= i.Plasma &&
cerere.CantitateTrombocite <= i.Trombocite &&
cerere.CantitateSange <= i.TotalSange)
{
message = "Cantitatea este suficienta pentru a implini cererea";
}
else
{
message = "Ne pare rau dar nu este suficient sange pentru cererea dumneavoastra. \n Notificati donatori sau trimiteti cantitatea de sange din stoc.";
}
}
}
if (stocBun != null)
{
CentruService cService = new CentruService();
CentruTransfuzie ctr = cService.GetCentruTransfuzieByName(username);
CerereForm formCerere = new CerereForm(message, cerere, stocBun, ctr, this);
formCerere.Show();
loadStocSange();
}
}
else
{
MessageBox.Show("Cererea a fost deja completata.");
}
}
public ActionResult Edit(CerereViewModel model)
{
try
{
Cerere cerere = db.Cereri.Find(model.Formular.CerereId);
cerere.Specializare = model.Formular.Specializare;
cerere.An = model.Formular.An;
cerere.Grupa = model.Formular.Grupa;
cerere.Medie = model.Formular.Medie;
cerere.NrCredite = model.Formular.NrCredite;
cerere.CNP = model.Formular.CNP;
cerere.SerieCI = model.Formular.SerieCI;
cerere.NumarCI = model.Formular.NumarCI;
cerere.IdBursaCeruta = model.Formular.IdBursaCeruta;
if (model.Document != null)
{
var uploadedFile = new byte[model.Document.InputStream.Length];
model.Document.InputStream.Read(uploadedFile, 0, uploadedFile.Length);
cerere.Document = uploadedFile;
}
db.SaveChanges();
}
catch (Exception e)
{
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
private void buttonSave_Click(object sender, EventArgs e)
{
try
{
if (comboBoxRH.SelectedItem == null || comboBoxGrupa.SelectedItem == null || comboBoxPr == null)
{
throw new Exception("Trebuie selectata grupa, Rh-ul si gradul de urgenta!");
}
if (comboBoxGrupa.Enabled)
{
Cerere cerere = BuildCerereSave();
serviceMedic.AddCerere(cerere, usernameMedic, GetPacientiSelectati());
}
else
{
Cerere cerere = BuildCerereUpdate();
serviceMedic.UpdateCerere(cerere);
}
tabControl1.SelectedTab = tabPage2;
Refresh();
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Eroare!", MessageBoxButtons.OK);
}
}
private Cerere BuildCerereUpdate()
{
Cerere cerere = new Cerere();
DataGridViewRow row = dataGridView2.SelectedRows[0];
cerere.Id = Int32.Parse(row.Cells[0].Value.ToString());
Int32 total, plasma, trombocite, globule;
if (textBoxTotal.Enabled)
{
total = Int32.Parse(textBoxTotal.Text);
cerere.CantitateSange = total;
}
else
{
plasma = Int32.Parse(textBoxPlasma.Text);
trombocite = Int32.Parse(textBoxTrombocite.Text);
globule = Int32.Parse(textBoxGlobule.Text);
total = plasma + trombocite + globule;
cerere.CantitateGlobuleRosii = globule;
cerere.CantitatePlasma = plasma;
cerere.CantitateTrombocite = trombocite;
cerere.CantitateSange = total;
}
return(cerere);
}
private Cerere BuildCerereSave()
{
Cerere cerere = new Cerere();
cerere.Data = DateTime.Now.Date.ToShortDateString();
cerere.Efectuata = false;
TipRh RH = (TipRh)Enum.Parse(typeof(TipRh), comboBoxRH.Text);
GrupaSange grupa = (GrupaSange)Enum.Parse(typeof(GrupaSange), comboBoxGrupa.Text);
cerere.Grupa = grupa;
cerere.RH = RH;
Int32 total, plasma, trombocite, globule;
if (textBoxTotal.Enabled)
{
total = Int32.Parse(textBoxTotal.Text);
cerere.CantitateSange = total;
}
else
{
plasma = Int32.Parse(textBoxPlasma.Text);
trombocite = Int32.Parse(textBoxTrombocite.Text);
globule = Int32.Parse(textBoxGlobule.Text);
total = plasma + trombocite + globule;
cerere.CantitateGlobuleRosii = globule;
cerere.CantitatePlasma = plasma;
cerere.CantitateTrombocite = trombocite;
cerere.CantitateSange = total;
}
return(cerere);
}
public void TestUpdateCerere()
{
int count = medicService.GetAllCereri().Count;
Cerere cerere = new Cerere("xx-xx-xxxx", 1, 1, 1, 1, false, null, GrupaSange.AII, TipRh.Negativ);
medicService.AddCerere(cerere, "ioana", new List <Pacient>());
Cerere cerereSalvata = medicService.GetCereriByMedic("ioana").Where(c => c.Data.Equals("xx-xx-xxxx") && c.Grupa.Equals(GrupaSange.AII) && c.RH.Equals(TipRh.Negativ)).FirstOrDefault();
Assert.AreEqual(count + 1, medicService.GetAllCereri().Count);
try
{
medicService.AddCerere(cerereSalvata, "ioana", new List <Pacient>());
}
catch (Exception ex)
{
Assert.AreEqual(count + 1, medicService.GetAllCereri().Count);
}
cerereSalvata.Efectuata = true;
cerereSalvata.CantitateSange = 100;
medicService.UpdateCerere(cerereSalvata);
cerereSalvata = medicService.GetCereriByMedic("ioana").Where(c => c.Data.Equals("xx-xx-xxxx") && c.Grupa.Equals(GrupaSange.AII) && c.RH.Equals(TipRh.Negativ)).FirstOrDefault();
Assert.AreEqual(true, cerereSalvata.Efectuata);
Assert.AreEqual(100, cerereSalvata.CantitateSange);
medicService.DeleteCerere(cerereSalvata);
Assert.AreEqual(count, medicService.GetAllCereri().Count());
}
public async Task <IActionResult> Edit(Guid id, [Bind("Id,Nume,Prenume,InitialaTatalui,Email,NumarMatricol,SerieBuletin,NumarBuletin,StareCerere")] Cerere cerere)
{
if (id != cerere.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(cerere);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CerereExists(cerere.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(cerere));
}
public CerereForm(string message, Cerere cerere, Stoc stoc, CentruTransfuzie centru)
{
this.message = message;
this.cerere = cerere;
this.stoc = stoc;
this.centru = centru;
InitializeComponent();
}
public async Task <IActionResult> Create([Bind("Id,Nume,Prenume,InitialaTatalui,Email,NumarMatricol,SerieBuletin,NumarBuletin,StareCerere")] Cerere cerere)
{
if (ModelState.IsValid)
{
cerere.Id = Guid.NewGuid();
_context.Add(cerere);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(cerere));
}
public ActionResult Edit(int id)
{
Cerere cerere = db.Cereri.Find(id);
var model = new CerereViewModel()
{
Formular = cerere,
Document = null
};
model.Formular.Burse = GetToateBursele();
model.Formular.UserId = User.Identity.GetUserId();
return(View(model));
}
public void UpdateCerere(Cerere cerere)
{
using (UnitOfWork unitOfWork = new UnitOfWork())
{
Cerere cerereSalvata = unitOfWork.CerereRepo.GetBy(c => c.Id.Equals(cerere.Id));
cerereSalvata.CantitateSange = cerere.CantitateSange;
cerereSalvata.CantitateGlobuleRosii = cerere.CantitateGlobuleRosii;
cerereSalvata.CantitatePlasma = cerere.CantitatePlasma;
cerereSalvata.CantitateTrombocite = cerere.CantitateTrombocite;
cerereSalvata.Efectuata = cerere.Efectuata;
cerereSalvata.Prioritate = cerere.Prioritate;
unitOfWork.CerereRepo.Update(cerereSalvata);
unitOfWork.Save();
}
}
public ActionResult Contribuit(Guid id)
{
try
{
Cerere cerere = db.Cereri.Find(id);
cerere.Contributii = cerere.Contributii + 1;
db.Entry(cerere).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", "Programare"));
}
catch
{
return(RedirectToAction("Contribuie"));
}
}
// GET: Cerere/Edit/5
public ActionResult Edit(Guid id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Cerere cerere = db.Cereri.Find(id);
if (cerere == null)
{
return(HttpNotFound());
}
return(View(cerere));
}
// GET: cerere/Delete/5
public ActionResult Delete(Guid id)
{
try
{
Cerere cerere = db.Cereri.Find(id);
db.Cereri.Remove(cerere);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
public ActionResult Create([Bind(Include = "Id,Centru,DataLimita,DonatiiNecesare,Contributii,GrupaSanguinaNecesara")] Cerere cerere)
{
try
{
cerere.Id = Guid.NewGuid();
cerere.Contributii = 0;
db.Cereri.Add(cerere);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(cerere));
}
}
public void TestVizualizareCereri()
{
int count = medicService.GetCereriByMedic("ioana").Count;
if (count == 0)
{
Cerere cerere = new Cerere("xx-xx-xxxx", 1, 1, 1, 1, false, null, GrupaSange.AII, TipRh.Negativ);
medicService.AddCerere(cerere, "ioana", new List <Pacient>());
Assert.AreEqual(count + 1, medicService.GetPacientByMedic(1));
Cerere cerereSalvata = medicService.GetCereriByMedic("ioana").Where(c => c.Data.Equals("xx-xx-xxxx") && c.Grupa.Equals(GrupaSange.AII) && c.RH.Equals(TipRh.Negativ)).FirstOrDefault();
medicService.DeleteCerere(cerereSalvata);
}
else
{
Assert.IsTrue(medicService.GetPacientByMedic(1).Count > 0);
}
}
public void DeleteCerere(Cerere cerere)
{
using (UnitOfWork unitOfWork = new UnitOfWork())
{
Cerere cerereBD = unitOfWork.CerereRepo.GetBy(c => c.Id.Equals(cerere.Id));
List <CererePacient> cereriPacienti = unitOfWork.CererePacientRepo.GetAll().ToList();
cereriPacienti.ForEach(cp =>
{
if (cp.IdCerere.Equals(cerereBD.Id))
{
unitOfWork.CererePacientRepo.Delete(cp);
}
});
unitOfWork.CerereRepo.Delete(cerereBD);
unitOfWork.Save();
}
}
public ActionResult CerereSange([Bind(Include = "Celula_Ceruta,Cantitate_Ceruta,SelectPacienti")] Cerere cerere)
{
string selectedPacientId = Request.Form["SelectPacienti"];
var user = (Utilizator)Session["Utilizator"];
if (ModelState.IsValid && cerere.Celula_Ceruta != null && cerere.Cantitate_Ceruta != null)
{
cerere.Status = "Inregistrata";
cerere.Pacient = db.Pacient.Find(Convert.ToInt32(selectedPacientId));
cerere.Medic = db.Medic.Where(x => x.Utilizator.Id_Utilizator == user.Id_Utilizator).First();
db.Cerere.Add(cerere);
db.SaveChanges();
ViewBag.Msg = "Cererea a fost inregistrata cu succes!";
return(View("Success"));
}
return(View(cerere));
}
public ActionResult Edit([Bind(Include = "Id,Centru,DataLimita,DonatiiNecesare,Contributii,GrupaSanguinaNecesara")] Cerere cerere)
{
try
{
if (ModelState.IsValid)
{
db.Entry(cerere).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
static void InitializeCereri(CTContext context)
{
if (context.Cerere.Any())
{
return;
}
Cerere c1 = new Cerere("1-1-2018", 5, 1, 3, 1, true, context.Medic.Find(1), GrupaSange.AII, TipRh.Pozitiv);
Cerere c2 = new Cerere("2-1-2018", 7, 2, 1, 4, false, context.Medic.Find(2), GrupaSange.AII, TipRh.Pozitiv);
c1.Prioritate = GradUrgenta.Mediu;
c2.Prioritate = GradUrgenta.Ridicat;
var cereri = new Cerere[] { c1, c2 };
foreach (Cerere c in cereri)
{
context.Cerere.Add(c);
}
context.SaveChanges();
}
public void AddCererenoua(CerereDto dto)
{
var newCerere = new Cerere
{
PersoanaId = dto.Id,
FromDate = dto.ToDate,
StatusCerere = (int)StatusCerereEnum.New
};
var newCerere1 = new Cerere
{
PersoanaId = dto.Id,
FromDate = dto.ToDate,
StatusCerere = 0
};
//var dtoNew = new CerereDto
//{
// StatusCerereName = StatusCerereEnum.Approved.ToString()
//}
//var approvedId
}
public ActionResult Show(int id)
{
Cerere cerere = db.Cereri.Find(id);
cerere.User = db.Users.Find(cerere.UserId);
Bursa bursa = db.Burse.Find(cerere.IdBursaCeruta);
if (cerere.User != null)
{
ViewBag.Student = cerere.User.UserName;
}
else
{
ViewBag.Student = "Fara nume";
}
ViewBag.Bursa = bursa;
ViewBag.existaDocument = true;
if (cerere.Document == null)
{
ViewBag.existaDocument = false;
}
return(View(cerere));
}
public FileResult Download(int id)
{
Cerere cerere = db.Cereri.Find(id);
return(File(cerere.Document, "application/pdf"));
}
public void AddCerere(Cerere cerere)
{
_context.Cereri.Add(cerere);
_context.SaveChanges();
}
public ActionResult Show(int id)
{
Cerere cerere = db.Cereri.Find(id);
return(View(cerere));
}
public CerereForm(string message, Cerere cerere, Stoc stoc, CentruTransfuzie centru, FormCentru parentForm) : this(message, cerere, stoc, centru)
{
this.parentForm = parentForm;
}
