public void InsertBloodRequest(BloodRequest bloodRequest)
{
using (var cnn = OpenConnection())
{
var id = cnn.Insert(bloodRequest);
}
}
public HttpResponseMessage AddBloodRequest(BloodRequest request)
{
KanTalepleri k = new KanTalepleri()
{
Id = request.Id,
HastaId = request.PatientId,
KanGrupId = request.BloodGroupId,
TalepAciklama = request.Description,
TalepTarihi = DateTime.Now,
UniteAdet = request.UnitQuantity,
BeklenenUnite = request.WaitingUnit,
TeminEdilenUniteAdet = request.SuppliedUnit
};
using (HayatKanaliDB db = new HayatKanaliDB())
{
db.KanTalepleri.Add(k);
try
{
db.SaveChanges();
}
catch (Exception e)
{
throw e;
}
return(Request.CreateResponse(HttpStatusCode.Created, k));
}
}
public ActionResult Create([Bind(Include = "Id,Name,Phone,PatientAge,Problem,Address,HospitalName,BloodRequestDate,BloodNeedDate,Countity,Photo,PhotoPathUrl,GroupId,GenderId")] BloodRequest bloodRequest, HttpPostedFileBase FileUpload)
{
if (ModelState.IsValid)
{
//Save image in folder
string FileName = Path.GetFileName(FileUpload.FileName);
string SaveLocation = Server.MapPath("~/PictureFolder/" + FileName);
FileUpload.SaveAs(SaveLocation);
//save image name in database
bloodRequest.PhotoPathUrl = "~/PictureFolder/" + FileName;
// byte image Save
bloodRequest.Photo = new byte[FileUpload.ContentLength];
ViewBag.BloodDonorPic = FileUpload.InputStream.Read(bloodRequest.Photo, 0, FileUpload.ContentLength);
db.BloodRequests.Add(bloodRequest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.GroupId = new SelectList(db.BloodGroups, "GroupId", "GroupName", bloodRequest.GroupId);
ViewBag.GenderId = new SelectList(db.Genders, "GenderId", "GenderName", bloodRequest.GenderId);
return(View(bloodRequest));
}
public void UpdateBloodRequest(BloodRequest bloodRequest)
{
using (var cnn = OpenConnection())
{
cnn.Update(bloodRequest);
}
}
public ActionResult ForBlood(BloodRequestViewModel viewModel)
{
var memberBloodGroups = SelectListItemExtension.PopulateDropdownList(_db.MemberBloodGroups.ToList <MemberBloodGroup>(), "Id", "BloodGroupName", isEdit: true, selectedValue: viewModel.RequiredBloodGroupId != 0 ? viewModel.RequiredBloodGroupId.ToString() : "0").ToList();
viewModel.ddlMemberBloodGroups = memberBloodGroups;
try
{
if (ModelState.IsValid)
{
BloodRequest model = new BloodRequest {
RequesterName = viewModel.RequesterName, RequesterContactNo = viewModel.RequesterContactNo, RequesterAmount = viewModel.RequesterAmount, PresentLocation = viewModel.PresentLocation, DateOfDonation = Convert.ToDateTime(viewModel.DateOfDonation), AppealMessage = viewModel.AppealMessage, RequiredBloodGroupId = viewModel.RequiredBloodGroupId
};
_db.BloodRequests.Add(model);
_db.SaveChanges();
return(RedirectToAction("Index", "BloodRequest"));
}
//return Content(ExceptionHelper.ModelStateErrorFormat(ModelState));
return(View(viewModel));
}
catch (Exception ex)
{
ExceptionHelper.ExceptionMessageFormat(ex, true);
return(View(viewModel));
}
}
/// <summary>
/// Adds a blood request to DB
/// </summary>
/// <param name="bloodRequest">Blood request to be added</param>
/// <returns>Result of operation</returns>
public bool CreateBloodRequest(BloodRequest bloodRequest)
{
dataBase.BloodRequests.Add(bloodRequest);
var countChanges = dataBase.SaveChanges();
return(true);
}
public ActionResult Adauga(int?idRequest, int?idDonatie)
{
if (Convert.ToString(Session["type"]) != "STAFF")
{
return(Redirect("/Home"));
}
if (idRequest == null || idDonatie == null)
{
return(View("Index"));
}
Donation donation = db.Donations.Find(idDonatie);
BloodRequest br = db.BloodRequests.Find(idRequest);
if (donation.trombocite >= br.trombocite)
{
donation.trombocite = donation.trombocite - br.trombocite;
br.trombocite = 0;
}
else
{
br.trombocite = br.trombocite - donation.trombocite;
donation.trombocite = 0;
}
if (donation.plasma >= br.plasma)
{
donation.plasma = donation.plasma - br.plasma;
br.plasma = 0;
}
else
{
br.plasma = br.plasma - donation.plasma;
donation.plasma = 0;
}
if (donation.globule_rosii >= br.globule_rosii)
{
donation.globule_rosii = donation.globule_rosii - br.globule_rosii;
br.globule_rosii = 0;
}
else
{
br.globule_rosii = br.globule_rosii - donation.globule_rosii;
donation.globule_rosii = 0;
}
if (br.globule_rosii == 0 && br.plasma == 0 && br.trombocite == 0)
{
br.state = "" + br.state.Split('-')[0] + "-FULFILLED";
}
db.Entry(donation).State = EntityState.Modified;
db.SaveChanges();
db.Entry(br).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("SolveRequest", new { id = br.BloodRequestId }));
}
public ActionResult DeleteConfirmed(int id)
{
BloodRequest bloodRequest = db.BloodRequests.Find(id);
db.BloodRequests.Remove(bloodRequest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public async Task <Result <BloodRequestDto> > Handle(CreateBloodRequest request, CancellationToken cancellationToken)
{
var openIdResult = await _currentUser.GetOpenIdUser();
var result = await _bloodRequestRepository.CreateAsync(BloodRequest.Create(request, openIdResult.Value.Id));
await _mediator.Publish(new SendEmailNotification(new List <MailboxAddress> {
new(openIdResult.Value.NickName, openIdResult.Value.EmailAddress)
}, "New Request Created [Blood]", $"Request for blood is created.<br/> Request ID: {result.Id}"), cancellationToken);
public ActionResult Edit(BloodRequest request)
{
if (ModelState.IsValid)
{
db.Entry(request).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(request));
}
// GET api/default1/5
public IHttpActionResult Getnew(int id)
{
BloodRequest bloodRequest = _bloodRequestRepository.GetBloodRequest(id);
if (bloodRequest == null)
{
return(NotFound());
}
return(Ok(bloodRequest));
}
public BloodRequest Map(BloodRequestForm form)
{
var newRequest = new BloodRequest();
newRequest.UnitsRequired = form.UnitsRequired;
newRequest.BloodType = form.BloodType;
newRequest.Date = DateTime.Now;
newRequest.UserId = form.UserId;
return(newRequest);
}
public ActionResult Edit([Bind(Include = "BloodRequestId,ClinicId,CentreId,state,trombocite,plasma,globule_rosii,quantity,PacientCNP")] BloodRequest bloodRequest)
{
if (ModelState.IsValid)
{
db.Entry(bloodRequest).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CentreId = new SelectList(db.Centres, "CentreId", "name", bloodRequest.CentreId);
ViewBag.ClinicId = new SelectList(db.Clinics, "ClinicId", "name", bloodRequest.ClinicId);
return(View(bloodRequest));
}
public async Task <BloodRequest> CreateAsync(BloodRequest request)
{
var db = _connectionMultiplexer.GetDatabase();
var json = JsonSerializer.Serialize(request, _jsonSerializerOptions);
var persistenceResult = await db.JsonSetAsync(request.GetPersistenceKey(), json);
_logger.LogDebug("[User] [INSERT] {json} [{result}]", json, persistenceResult.IsSuccess);
await db.PublishAsync(RedisConstants.NewBloodRequestChannel, json);
return(request);
}
public BloodRequest Map(int n, BloodRequestForm form)
{
var newRequest = new BloodRequest();
newRequest.Id = n;
newRequest.UnitsRequired = form.UnitsRequired;
newRequest.BloodType = form.BloodType;
newRequest.Date = DateTime.Now;
newRequest.UserId = form.UserId;
newRequest.NumDonator = form.NumDonator;
return(newRequest);
}
// GET: Doctors/Edit/5
public ActionResult Edit(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BloodRequest request = db.BloodRequests.Find(id);
if (request == null)
{
return(HttpNotFound());
}
return(View(request));
}
// GET: BloodRequests/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BloodRequest bloodRequest = db.BloodRequests.Find(id);
if (bloodRequest == null)
{
return(HttpNotFound());
}
return(View(bloodRequest));
}
public ActionResult Create([Bind(Include = "BloodRequestId,ClinicId,CentreId,state,trombocite,plasma,globule_rosii,quantity,PacientCNP")] BloodRequest bloodRequest)
{
if (ModelState.IsValid)
{
var detailsDoctor1 = db.PersonalDetailsDoctors.AsEnumerable().Where(x => x.DoctorId == Convert.ToString(Session["token"])).Single().ClinicId;
bloodRequest.ClinicId = detailsDoctor1;
db.BloodRequests.Add(bloodRequest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(bloodRequest));
}
/// <summary>
/// Checks if the BloodRequest is valid
/// </summary>
/// <param name="bloodRequest"></param>
/// <param name="cause"></param>
/// <returns>Result of the operation</returns>
public bool IsValid(BloodRequest bloodRequest, out string cause)
{
var valid = true;
cause = null;
if (bloodRequest.Amount == 0)
{
cause = "No puede ingresar donaciones vacias";
valid = false;
}
if (bloodRequest.MedicalCenterId == 0)
{
cause = "Debe ingresar un n\u00famero de identifiacion de centro medico v\u00E1lido";
valid = false;
}
if (bloodRequest.MedicalCenter == null)
{
cause = "Debe ingresar un centro medico v\u00E1lido";
valid = false;
}
if (bloodRequest.Id == 0)
{
cause = "Debe ingresar una ID v\u00E1lida";
valid = false;
}
var found = false;
foreach (MedicalCenter medicalCenter in dataBase.MedicalCenters)
{
if (medicalCenter.Id == bloodRequest.MedicalCenterId)
{
found = true;
}
}
if (!found)
{
cause = "El centro medico indicado no se encuentra registrado";
valid = false;
}
return(valid);
}
// GET: BloodRequests/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BloodRequest bloodRequest = db.BloodRequests.Find(id);
if (bloodRequest == null)
{
return(HttpNotFound());
}
ViewBag.GroupId = new SelectList(db.BloodGroups, "GroupId", "GroupName", bloodRequest.GroupId);
ViewBag.GenderId = new SelectList(db.Genders, "GenderId", "GenderName", bloodRequest.GenderId);
return(View(bloodRequest));
}
public async Task CreateBloodRequestRecord(BloodRequest request)
{
var fields = new Dictionary <string, RedisValue>
{
{ "requestId", request.Id.ToString() },
{ "userId", request.OpenIdKey.GetPersistenceKey() },
{ "patientName", request.PatientName },
{ "reason", request.Reason },
{ "donationType", (int)request.DonationType },
{ "bloodGroup", (int)request.BloodGroup },
{ "status", (int)request.Status },
{ "priority", (int)request.Priority },
{ "units", request.QuantityInUnits }
};
await _redisSearchClient.AddDocumentAsync(new Document(request.Id.ToString(), fields));
}
public ActionResult SaveBloodRequest(BloodRequest bloodRequest)
{
if (!Session.IsSignedIn())
{
return(Json(new { saved = false }));
}
if (!bloodRequestService.IsValid(bloodRequest, out var cause))
{
return(Json(new { saved = false, cause }));
}
var saved = bloodRequestService.CreateBloodRequest(bloodRequest);
return(Json(new { saved }));
}
// GET: BloodRequests/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
BloodRequest bloodRequest = db.BloodRequests.Find(id);
if (bloodRequest == null)
{
return(HttpNotFound());
}
ViewBag.CentreId = new SelectList(db.Centres, "CentreId", "name", bloodRequest.CentreId);
ViewBag.ClinicId = new SelectList(db.Clinics, "ClinicId", "name", bloodRequest.ClinicId);
return(View(bloodRequest));
}
private void btnAction_Click(object sender, EventArgs e)
{
BloodRequest bloodRequest = new BloodRequest()
{
BloodReqId = Convert.ToInt32(txtId.Text),
Name = txtName.Text,
Email = txtEmail.Text,
Phone = txtPhone.Text,
Remarks = txtRemarks.Text,
RequestDate = DateTime.Now,
NeededBloodGrp = (String)comboBloodGroup.SelectedItem,
NeededBloodAmount = Convert.ToInt32(txtNeededUnit.Text),
GivenBloodAmount = Convert.ToInt32(txtGivenUnit.Text),
RequestStatus = (String)comboStatus.SelectedItem,
DeliveryDate = deliveryDate.Value,
BranchId = this._branchId
};
if (_action == "Save")
{
_context = new DataContext();
if (_context.SaveBloodRequest(bloodRequest))
{
MessageBox.Show("Successfully Saved.");
this.blReqForm.LoadTableData();
this.Dispose();
}
else
{
MessageBox.Show("Failed to Save.");
}
}
else
{
_context = new DataContext();
if (_context.UpdateBloodRequest(bloodRequest))
{
MessageBox.Show("Successfully Updated.");
this.blReqForm.LoadTableData();
this.Dispose();
}
else
{
MessageBox.Show("Failed to Update.");
}
}
}
private void CheckAction(string _action)
{
if (_action == "Save" && BloodReqId == 0)
{
comboStatus.Enabled = false;
btnAction.Text = _action;
}
else
{
deliveryDate.Enabled = true;
label6.Text = "Update Blood Request Information";
btnAction.Text = _action;
_context = new DataContext();
blooodRequest = _context.GetBloodReqById(this.BloodReqId);
LoadData(blooodRequest);
}
}
private void LoadData(BloodRequest blooodRequest)
{
txtId.Text = blooodRequest.BloodReqId.ToString();
txtName.Text = blooodRequest.Name;
txtRemarks.Text = blooodRequest.Remarks;
comboBloodGroup.SelectedIndex = comboBloodGroup.Items.IndexOf(blooodRequest.NeededBloodGrp);
comboStatus.SelectedIndex = comboStatus.Items.IndexOf(blooodRequest.RequestStatus);
txtEmail.Text = blooodRequest.Email;
txtPhone.Text = blooodRequest.Phone;
if (blooodRequest.DeliveryDate == null)
{
deliveryDate.Value = DateTime.Now;
}
else
{
deliveryDate.Value = (DateTime)blooodRequest.DeliveryDate;
}
txtNeededUnit.Text = blooodRequest.NeededBloodAmount.ToString();
txtGivenUnit.Text = blooodRequest.GivenBloodAmount.ToString();
}
public async Task <IActionResult> SendRequest(BloodRequest model)
{
if (ModelState.IsValid)
{
var userName = HttpContext.User.Identity.Name;
var user = await _userManager.FindByEmailAsync(userName);
var request = new BloodRequest {
BloodType = model.BloodType,
DonateLocation = model.DonateLocation,
BloodReqDesc = model.BloodReqDesc,
AplicationUserId = user.Id
};
_unitOfWork.BloodRequest.addBloodRequest(request);
_unitOfWork.Save();
return(Redirect("/BloodRequests"));
}
return(View("Index", model));
}
public ActionResult Create(BloodRequestFormViewModel model)
{
if (!ModelState.IsValid)
{
model.Banks = _unitOfWork.Banks.GetBloodBanks();
return(View("Create", model));
}
var request = new BloodRequest
{
BloodType = model.BloodType,
DueDateTime = model.GetDueDateTime(),
City = model.City,
BankId = model.Bank
};
_unitOfWork.Requests.Add(request);
_unitOfWork.Complete();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Name,Phone,PatientAge,Problem,Address,HospitalName,BloodRequestDate,BloodNeedDate,Countity,Photo,PhotoPathUrl,GroupId,GenderId")] BloodRequest bloodRequest, HttpPostedFileBase FileUpload)
{
if (ModelState.IsValid)
{
BloodRequest DbRecord = db.BloodRequests.Where(b => b.id == bloodRequest.id).FirstOrDefault();
//Save image in folder
try
{
if (FileUpload.FileName != null)
{
string FileName = Path.GetFileName(FileUpload.FileName);
string SaveLocation = Server.MapPath("~/PictureFolder/" + FileName);
FileUpload.SaveAs(SaveLocation);
//save image name in database
DbRecord.PhotoPathUrl = "~/PictureFolder/" + FileName;
// byte image Save
DbRecord.Photo = new byte[FileUpload.ContentLength];
ViewBag.BloodDonorPic = FileUpload.InputStream.Read(bloodRequest.Photo, 0, FileUpload.ContentLength);
}
}
catch (Exception)
{
throw;
}
db.Entry(DbRecord).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.GroupId = new SelectList(db.BloodGroups, "GroupId", "GroupName", bloodRequest.GroupId);
ViewBag.GenderId = new SelectList(db.Genders, "GenderId", "GenderName", bloodRequest.GenderId);
return(View(bloodRequest));
}
public BloodRequestCreated(BloodRequest request) => Request = request;
