public User Create(User user, string password)
{
// validation
if (string.IsNullOrWhiteSpace(password))
{
throw new AppException("Password is required");
}
if (_context.Users.Any(x => x.Username == user.Username))
{
throw new AppException("Username \"" + user.Username + "\" is already taken");
}
byte[] passwordHash, passwordSalt;
CreatePasswordHash(password, out passwordHash, out passwordSalt);
user.PasswordHash = passwordHash;
user.PasswordSalt = passwordSalt;
_context.Users.Add(user);
_context.SaveChanges();
return(user);
}
public static void Main(string[] args)
{
using (var db = new PharmacyContext())
{
db.Database.EnsureCreated();
Prescription prescription = new Prescription();
Customer customer = new Customer();
customer.CustomerType = CustomerType.Druzinska_medicina;
customer.Prescription = prescription;
db.Customers.Add(customer);
db.SaveChanges();
}
CreateWebHostBuilder(args).Build().Run();
}
public Drug Create(Drug model)
{
using (var ctx = new PharmacyContext(CONNECTION_STRING))
{
model.Form = new Form()
{
Name = "Solution"
};
model.FormId = 0;
ctx.Drugs.Add(model);
ctx.SaveChanges();
};
return(model);
}
public void DoneOreder(PharmacyContext context, int orderId, int quantity)
{
var order = context.Orders.Single(x => x.Id == orderId);
var medicine = context.Medicines.Single(m => m.Id == order.MedicineId);
medicine.Quantity = medicine.Quantity - quantity;
context.Medicines.Update(medicine);
order.StatusOfOrder = "Zamowienie zrealizowane";
context.Orders.Update(order);
context.SaveChanges();
}
public void AddOrder(OrderDto dto, PharmacyContext context)
{
var order = new Order
{
UserID = dto.UserID,
MedicineId = dto.MedicineId,
Quantity = dto.Quantity,
DeliveryMethod = dto.DeliveryMethod,
DataOfOrder = dto.DataOfOrder,
StatusOfOrder = dto.StatusOfOrder,
Price = dto.Price
};
context.Orders.Add(order);
context.SaveChanges();
}
public void AddUser(UserDto dto, PharmacyContext context)
{
var user = new User
{
Name = dto.Name,
Surname = dto.Surname,
Login = dto.Login,
Password = dto.Password,
Role = dto.Role,
City = dto.City,
Street = dto.Street,
PhoneNumber = dto.PhoneNumber
};
context.Users.Add(user);
context.SaveChanges();
}
public void AddMedicine(CreateMedicineDto dto, PharmacyContext context)
{
var medicine = new Medicine
{
DataExpiration = dto.DataExpiration,
Manufacturer = dto.Manufacturer,
Name = dto.Name,
Perscription = dto.Perscription,
Price = dto.Price,
Refunded = dto.Refunded,
StorageMethod = dto.StorageMethod,
Use = dto.Use,
Quantity = dto.Quantity
};
context.Medicines.Add(medicine);
context.SaveChanges();
}
public IActionResult CreateProduct([FromBody] Product product)
{
try
{
if (ModelState.IsValid)
{
_context.Products.Add(product);
_context.SaveChanges();
return(CreatedAtAction("GetProduct", new { id = product.Id }, product));
}
}
catch (Exception e)
{
ModelState.AddModelError(string.Empty, e.Message);
}
return(BadRequest(ModelState));
}
public ActionResult View_RefillDetails(Refill refill)
{
string Token = HttpContext.Request.Cookies["Token"];
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", Token);
HttpResponseMessage response = client.GetAsync(client.BaseAddress + "/Refill/RefillStatus/" + refill.Subscription_ID).Result;
if (response.IsSuccessStatusCode)
{
string scheduleData = response.Content.ReadAsStringAsync().Result;
Refill r = JsonConvert.DeserializeObject <Refill>(scheduleData);
context.RefillDetails.Add(r);
context.SaveChanges();
return(View("RefillStatus", r));
}
return(View());
}
public static void Initialize(PharmacyContext context)
{
context.Database.EnsureCreated();
if (context.Categorii.Any())
{
return; // BD a fost creata anterior
}
var categorii = new Categorie[]
{
new Categorie {
NumeCategorie = "Durere"
},
new Categorie {
NumeCategorie = "Răceală şi gripă"
},
new Categorie {
NumeCategorie = "Cardiovascular"
},
new Categorie {
NumeCategorie = "Dermatologie"
},
new Categorie {
NumeCategorie = "Afecţiuni gastrointestinale"
},
};
foreach (Categorie s in categorii)
{
context.Categorii.Add(s);
}
context.SaveChanges();
var furnizori = new Furnizor[]
{
new Furnizor {
FurnizorID = 1, NumeFurnizor = "BAYER SRL", Adresa = "Şos Pipera nr 42, etajele: 1,16,17, România", Telefon = "0215295900", Email = "*****@*****.**"
},
new Furnizor {
FurnizorID = 2, NumeFurnizor = "TERAPIA SA", Adresa = "Str. Fabricii nr.124, România", Telefon = "0264501500", Email = "*****@*****.**"
},
new Furnizor {
FurnizorID = 3, NumeFurnizor = "ACTAVIS Group", Adresa = "Reykjavíkurvegi 76-78, ICELAND", Telefon = "3545503300", Email = "*****@*****.**"
},
new Furnizor {
FurnizorID = 4, NumeFurnizor = "RECKITT BENCKISER România SRL", Adresa = "Str. Grigore Alexandrescu, nr. 89-97, Et.5, Sector 1, România", Telefon = "0215296700", Email = "*****@*****.**"
},
new Furnizor {
FurnizorID = 5, NumeFurnizor = "S.C. BIOFARM SA", Adresa = "Str.Logofatul Tautu nr.99, sector 3, Romania", Telefon = "0213010600", Email = "*****@*****.**"
},
};
foreach (Furnizor c in furnizori)
{
context.Furnizori.Add(c);
}
context.SaveChanges();
var produse = new Produs[]
{
new Produs {
CategorieID = 1, FurnizorID = 1, NumeMedicament = "ASPIRIN", Doza = "20 compr x 500 mg", Pret = 0, DataExpirare = DateTime.Parse("2020-12-22")
},
new Produs {
CategorieID = 1, FurnizorID = 3, NumeMedicament = "ADAGIN", Doza = "10 cps x 400 mg", Pret = 0, DataExpirare = DateTime.Parse("2020-12-22")
},
new Produs {
CategorieID = 2, FurnizorID = 4, NumeMedicament = "NUROFEN", Doza = "100 ml", Pret = 0, DataExpirare = DateTime.Parse("2020-12-22")
},
new Produs {
CategorieID = 3, FurnizorID = 2, NumeMedicament = "ASPACARDIN", Doza = "39mg/12mg x 30 tb", Pret = 0, DataExpirare = DateTime.Parse("2020-12-22")
},
new Produs {
CategorieID = 5, FurnizorID = 4, NumeMedicament = "GAVISCON MENTOL", Doza = "200 ml", Pret = 0, DataExpirare = DateTime.Parse("2020-12-22")
},
new Produs {
CategorieID = 2, FurnizorID = 5, NumeMedicament = "BIXTONIM Xylo", Doza = "10 ml", Pret = 0, DataExpirare = DateTime.Parse("2020-12-22")
},
new Produs {
CategorieID = 2, FurnizorID = 2, NumeMedicament = "PARACETAMOL", Doza = "10 cps X 400 mg", Pret = 0, DataExpirare = DateTime.Parse("2020-12-22")
},
};
foreach (Produs e in produse)
{
context.Produse.Add(e);
}
context.SaveChanges();
var tipuri = new Tip[]
{
new Tip {
TipMedicament = "Comprimate"
},
new Tip {
TipMedicament = "Capsule"
},
new Tip {
TipMedicament = "Sirop"
},
new Tip {
TipMedicament = "Spray"
},
new Tip {
TipMedicament = "Picături"
},
};
foreach (Tip p in tipuri)
{
context.Tipuri.Add(p);
}
context.SaveChanges();
var formaproduse = new FormaProdus[]
{
new FormaProdus {
ProdusID = produse.Single(c => c.NumeMedicament == "ASPIRIN").ProdusID, TipID = tipuri.Single(i => i.TipMedicament == "Comprimate").TipID
},
new FormaProdus {
ProdusID = produse.Single(c => c.NumeMedicament == "ADAGIN").ProdusID, TipID = tipuri.Single(i => i.TipMedicament == "Capsule").TipID
},
new FormaProdus {
ProdusID = produse.Single(c => c.NumeMedicament == "NUROFEN").ProdusID, TipID = tipuri.Single(i => i.TipMedicament == "Sirop").TipID
},
new FormaProdus {
ProdusID = produse.Single(c => c.NumeMedicament == "ASPACARDIN").ProdusID, TipID = tipuri.Single(i => i.TipMedicament == "Comprimate").TipID
},
new FormaProdus {
ProdusID = produse.Single(c => c.NumeMedicament == "GAVISCON MENTOL").ProdusID, TipID = tipuri.Single(i => i.TipMedicament == "Sirop").TipID
},
new FormaProdus {
ProdusID = produse.Single(c => c.NumeMedicament == "BIXTONIM Xylo").ProdusID, TipID = tipuri.Single(i => i.TipMedicament == "Spray").TipID
},
new FormaProdus {
ProdusID = produse.Single(c => c.NumeMedicament == "BIXTONIM Xylo").ProdusID, TipID = tipuri.Single(i => i.TipMedicament == "Picături").TipID
},
};
foreach (FormaProdus pb in formaproduse)
{
context.FormaProduse.Add(pb);
}
context.SaveChanges();
}
public IActionResult Subscribe([Bind("InsurancePolicyNumber,InsuranceProvider,PrescriptionDate,DrugName,DoctorName,RefillOccurrence")] PrescriptionDetails prescription)
{
if (String.IsNullOrEmpty(HttpContext.Session.GetString("Token")))
{
_log4net.Warn("Anonymous user trying to Subscribe");
return(RedirectToAction("Index", "Home"));
}
// Get MemberId from Session
SubscriptionDetails result = new SubscriptionDetails();
int id = (int)HttpContext.Session.GetInt32("MemberId");
string policy = "sad";
// Call Subscription Service -- Subscribe method with prescription details and policy details and Member Id
using (var httpClient = new HttpClient())
{
var content = new StringContent(JsonConvert.SerializeObject(prescription), Encoding.UTF8, "application/json");
string url = "" + configuration["ServiceUrls:Subscription"] + "PostSubscribe";
var request = new HttpRequestMessage(HttpMethod.Post, url + "/" + policy + "/" + id)
{
Content = content
};
request.Headers.Authorization = new AuthenticationHeaderValue("Bearer", HttpContext.Session.GetString("Token"));
using (var response = httpClient.SendAsync(request).Result)
{
if (!response.IsSuccessStatusCode)
{
_log4net.Error("False Response");
string message = "Something Went Wrong " + response.StatusCode;
return(RedirectToAction("Subscribe", new { message }));
}
var data = response.Content.ReadAsStringAsync().Result;
result = JsonConvert.DeserializeObject <SubscriptionDetails>(data);
if (result == null)
{
_log4net.Error("Exception On Subscription Service side");
string message = "Something Went Wrong " + response.StatusCode;
return(RedirectToAction("Subscribe", new { message }));
}
if (!result.Status)
{
_log4net.Info(prescription.DrugName + " Drug Not Available.... Subscription Failed ");
string message = "Subscription failed due to InAvailability of Drugs ";
return(RedirectToAction("Subscribe", new { message }));
}
details.Add(result);
var db = context.Subscriptions.FirstOrDefault(x => x.Id == result.Id);
if (db == null)
{
context.Subscriptions.Add(result);
context.SaveChanges();
}
string status1 = "Success";
string message1 = " Subscription Successfull..... Subscription Id is " + result.Id;
return(RedirectToAction("Index", new { status = status1, message = message1 }));
}
}
}
public void SaveChanges()
{
context.SaveChanges();
}
public void SaveChanges() => _context.SaveChanges();
public int Complete()
{
return(_context.SaveChanges());
}
