public OrderMedicineModal(HomeWindow home, MedicineDTO medicine)
{
InitializeComponent();
this.DataContext = this;
this.Home = home;
this.Medicine = medicine;
}
public List <MedicineDTO> GetPatients()
{
List <MedicineDTO> medicines = new List <MedicineDTO>();
String query = "SELECT * FROM Medicine";
MySqlCommand cmd = new MySqlCommand(query, dbConn);
dbConn.Open();
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int id = (int)reader["med_id"];
String n = reader["name"].ToString();
String quantity = reader["quantity"].ToString();
float price = (float)reader["price"];
MedicineDTO p = new MedicineDTO(id, n, quantity, price);
medicines.Add(p);
}
reader.Close();
dbConn.Close();
return(medicines);
}
// Get: /Medicine/ShowMedicines
public ActionResult DetialsMedicine(int id)
{
//check if user is login in App
string username = User.Identity.Name;
if (string.IsNullOrEmpty(username))
{
return(RedirectToAction("login", "Account"));
}
// Declare a list of Medicine
MedicineDetialsVM model;
using (Db db = new Db())
{
// Get the Medicine
MedicineDTO dto = db.Medicines.Find(id);
// Make sure Medicine exists
if (dto == null)
{
return(Content("هذا الدواء غير موجود "));
}
// init model
model = new MedicineDetialsVM(dto);
}
// Return view with list
return(View(model));
}
public async Task <List <MedicineDTO> > GetMedicines()
{
var Medicines = await _repository.GetMedicinesAsync();
List <MedicineDTO> list = new List <MedicineDTO>();
var listPHMedicines = await _repository.GetAllPHMedicines();
List <string> headNames = new List <string>();
List <PharmacyHead> heads = new List <PharmacyHead>();
foreach (var med in Medicines)
{
var meds = listPHMedicines.Where(x => x.MedicineId == med.Id).ToList();
if (meds != null)
{
heads = meds.Select(x => x.Head).ToList();
}
headNames = heads.Select(x => x.Name).ToList();
MedicineDTO medicine = new MedicineDTO()
{
Name = med.Name,
Manufacturer = med.Manufacturer,
Packaging = med.Packaging,
Form = med.Form,
Price = med.Price,
Strength = med.Strength,
WayOfIssuing = med.WayOfIssuing,
HeadNames = headNames
};
list.Add(medicine);
}
return(list);
}
public async Task <IActionResult> PutMedicine([FromQuery] MedicineDTO medicineDTO)
{
var medicine = await _context.MedDbSet.FindAsync(medicineDTO.Id);
if (medicine == null)
{
return(NoContent());
}
medicine.Notes = medicineDTO.Notes;
_context.Entry(medicine).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MedicineExists(medicineDTO.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public bool updateMedicineInfo(MedicineDTO medicineDTO)
{
try
{
Db.Ado.BeginTran();
MEDICINE_INFORMATION medicineInformation = new MEDICINE_INFORMATION()
{
MEDICINE_ID = medicineDTO._medicine_id,
MEDICINE_APPLICABILITY = medicineDTO._medicine_applicability,
MEDICINE_CHARACTER = medicineDTO._medicine_character,
MEDICINE_ATTENTION = medicineDTO._medicine_attention,
MEDICINE_NAME = medicineDTO._medicine_name,
MEDICINE_TYPE = medicineDTO._medicine_type,
MEDICINE_INGREDIENTS = medicineDTO._medicine_ingredients,
MEDICINE_USAGE = medicineDTO._medicine_usage,
SUPPLIER_ID = medicineDTO._supplier_id,
MEDICINE_IMAGE = medicineDTO._medicine_image
};
Db.Updateable(medicineInformation).ExecuteCommand();
Db.Ado.CommitTran();
return(true);
}
catch (Exception ex)
{
Db.Ado.RollbackTran();
return(false);
}
}
public IActionResult updateMedicineInfo([FromForm] MedicineDTO medicine)
{
if (medicine == null)
{
return(BadRequest(new JsonCreate()
{
message = Utils.ConstMessage.BAD_REQUEST, data = false
}));
}
MedicineManager medicineManager = new MedicineManager();
bool judge = medicineManager.updateMedicineInfo(medicine);
if (judge)
{
return(Ok(new JsonCreate()
{
message = Utils.ConstMessage.UPDATE_SUCCESS, data = true
}));
}
else
{
return(Conflict(new JsonCreate()
{
message = Utils.ConstMessage.CONFILICT, data = false
}));
}
}
public bool insertNewMedicine(MedicineDTO medicine)
{
try
{
Db.Ado.BeginTran();
MEDICINE_INFORMATION medicineInformation = new MEDICINE_INFORMATION()
{
MEDICINE_ID = medicine._medicine_id,
MEDICINE_APPLICABILITY = medicine._medicine_applicability,
MEDICINE_CHARACTER = medicine._medicine_character,
MEDICINE_ATTENTION = medicine._medicine_attention,
MEDICINE_NAME = medicine._medicine_name,
MEDICINE_TYPE = medicine._medicine_type,
MEDICINE_INGREDIENTS = medicine._medicine_ingredients,
MEDICINE_USAGE = medicine._medicine_usage,
SUPPLIER_ID = medicine._supplier_id,
MEDICINE_IMAGE = medicine._medicine_image
};
bool judge = Db.Queryable <MEDICINE_INFORMATION>().Where(it => it.MEDICINE_ID == medicine._medicine_id).Any();
if (!judge)
{
Db.Insertable(medicineInformation).ExecuteCommand();
}
Db.Ado.CommitTran();
return(true);
}
catch (Exception ex)
{
Db.Ado.RollbackTran();
return(false);
}
}
public ActionResult EditMedicine(MedicineVM model)
{
// Get Medicine id
int id = model.Id;
// Check model state
if (!ModelState.IsValid)
{
ModelState.AddModelError("", "لم تتم عملية التعديل ");
return(View(model));
}
// Make sure MedicineName is unique
using (Db db = new Db())
{
if (db.Medicines.Where(x => x.Id != id).Any(x => x.MedicineName == model.MedicineName))
{
ModelState.AddModelError("", "شركة " + model.MedicineName + " موجودة مسبقا.");
return(View(model));
}
}
int medicineTotalePrice, TotaleNumberOfTapesOfMedicine;
if (model.IsHasTapes == true)
{
TotaleNumberOfTapesOfMedicine = model.Number * model.NumberOfTapesInOneMedicine;
medicineTotalePrice = model.Price * TotaleNumberOfTapesOfMedicine;
}
else
{
medicineTotalePrice = model.Price * model.Number;
TotaleNumberOfTapesOfMedicine = 0;
model.NumberOfTapesInOneMedicine = 0;
}
// Update Medicine
using (Db db = new Db())
{
MedicineDTO dto = db.Medicines.Find(id);
dto.MedicineName = model.MedicineName;
dto.Number = model.Number;
dto.Price = model.Price;
dto.ExpiryDate = model.ExpiryDate;
dto.IsHasTapes = model.IsHasTapes;
dto.NumberOfTapesInOneMedicine = model.NumberOfTapesInOneMedicine;
dto.TotaleNumberOfTapes = TotaleNumberOfTapesOfMedicine;
dto.TotalePrice = medicineTotalePrice;
db.SaveChanges();
}
// Set TempData message
TempData["SM"] = "تم تعديل بيانات الدواء بنجاح ";
// Redirect
return(RedirectToAction("EditMedicine"));
}
public MedicineVM(MedicineDTO row)
{
this.Id = row.Id;
this.MedicineName = row.MedicineName;
this.Number = row.Number;
this.Price = row.Price;
this.ExpiryDate = row.ExpiryDate;
this.IsHasTapes = row.IsHasTapes;
this.NumberOfTapesInOneMedicine = row.NumberOfTapesInOneMedicine;
}
public MedicineDTO CreateMedicine([FromBody] MedicineDTO medicine)
{
Medicine medicineEntity = _mapper.Map <Medicine>(medicine);
_repository.CreateMedicine(medicineEntity);
_repository.Save();
MedicineDTO newMedicine = _mapper.Map <MedicineDTO>(medicineEntity);
return(newMedicine);
}
private void PillManagement_Load(object sender, EventArgs e)
{
//LOCK OUR TEXT BOXES
Block_or_Unlock_Textbox(false);
Hide_Show_Buttons(false);
currentMedi = new MedicineDTO();
medBus = new MedicineBUS();
currentMedi = null;
LoadAll();
name_suggestion();
quantity_suggestion();
}
public int insertCoreMedicine(MedicineDTO newMedicine)
{
int flagInsert = new MEDICINETableAdapter().insertMedicineQuery(
newMedicine.IdUnitMedicine,
newMedicine.FullName,
newMedicine.Symbol,
newMedicine.Ingredient,
newMedicine.PriceUnit
);
return(flagInsert);
}
public int updateCoreMedicine(MedicineDTO originalMedicine)
{
int flagUpdate = new MEDICINETableAdapter().updateMedicineQuery(
originalMedicine.IdUnitMedicine,
originalMedicine.FullName,
originalMedicine.Symbol,
originalMedicine.Ingredient,
originalMedicine.PriceUnit,
originalMedicine.IdMedicine
);
return(flagUpdate);
}
private MedicineDTO ToDTO(Medicine med)
{
MedicineDTO dto = new MedicineDTO();
dto.med_ID = med.med_ID;
dto.med_name = med.med_name;
dto.cost_price = med.cost_price;
dto.sell_price = med.sell_price;
dto.unit = med.unit;
dto.num = med.num;
dto.producer = med.producer;
return(dto);
}
public MedicineDTO Insert(String n, String quantity, float price)
{
String query = string.Format("INSERT INTO Medicine(name,quantity,price) VALUES " +
"('{0}', '{1}','{2}')",
n, quantity, price);
MySqlCommand cmd = new MySqlCommand(query, dbConn);
dbConn.Open();
cmd.ExecuteNonQuery();
int id = (int)cmd.LastInsertedId;
MedicineDTO p = new MedicineDTO(id, n, quantity, price);
dbConn.Close();
return(p);
}
public bool add(MedicineDTO m)
{
try
{
string query = "insert into Medicine (Name, Quantity, Price, Supplier) values ('" + m.Name + "'," + m.Quantity + "," + m.Price + ",'" + m.Supplier + "')";
c.sqlComm = new SqlCommand(query, c.sqlConn);
c.sqlComm.ExecuteNonQuery();
c.sqlConn.Close();
return(true);
}
catch (Exception e)
{
return(false);
}
}
public ActionResult <Medicine> Create(MedicineDTO medicineDTO)
{
var medicine = new Medicine()
{
name = medicineDTO.name,
quantity = medicineDTO.quantity,
creationDate = medicineDTO.creationDate
};
_medicineService.Create(medicine);
return(CreatedAtRoute
("GetMidicine",
new { id = medicine.Id },
medicine));
}
public bool update(MedicineDTO m)
{
string query = "update Medicine set Quantity=" + m.Quantity + ", Price=" + m.Price + ", Supplier='" + m.Supplier + "' where Name='" + m.Name + "'";
try
{
c.sqlComm = new SqlCommand(query, c.sqlConn);
c.sqlComm.ExecuteNonQuery();
c.sqlConn.Close();
return(true);
}
catch (Exception e)
{
c.sqlConn.Close();
return(false);
}
}
public int insertDoctor(
string idUnitMedicine,
string fullName,
string symbol,
string ingredient,
string priceUnit)
{
MedicineDTO currentMedicineDatarow = new MedicineDTO();
currentMedicineDatarow.IdUnitMedicine = Convert.ToInt32(idUnitMedicine);
currentMedicineDatarow.FullName = Convert.ToString(fullName);
currentMedicineDatarow.Symbol = Convert.ToString(symbol);
currentMedicineDatarow.Ingredient = Convert.ToString(ingredient);
currentMedicineDatarow.PriceUnit = Convert.ToDecimal(priceUnit);
return(medicineDal.insertCoreMedicine(currentMedicineDatarow));
}
//Viualize our Data from listView to text boxes
private void listView_SelectedIndexChanged(object sender, EventArgs e)
{
if (listView.SelectedItems.Count > 0)
{
ListViewItem item = listView.SelectedItems[0];
currentMedi = (MedicineDTO)item.Tag;
int id = id_checked = currentMedi.medicine_id;
String n = currentMedi.name;
String quan = currentMedi.quantity;
String price = currentMedi.price.ToString();
nameTxt.Text = n;
quantTxt.Text = quan;
priceTxt.Text = price;
flag = 1;
}
}
private void btnCancel_Click(object sender, EventArgs e)
{
Enable_Uneable_Function(true);
Hide_Show_Buttons(false);
currentMedi = null;
nameTxt.Text = "";
quantTxt.Text = "";
priceTxt.Text = "";
//Deal with Error Provider
ePro.SetError(nameTxt, "");
ePro.SetError(quantTxt, "");
ePro.SetError(priceTxt, "");
Block_or_Unlock_Textbox(false);
}
public string backbuymedicine(int med_ID, int order_ID, int payment_QTY)
{
// Delete OrderOutDetials from DB
string data;
using (Db db = new Db())
{
OrderInDetialsDTO dto = db.OrderInDetials.Find(order_ID);
if (dto == null)
{
data = "البيانات غير موجودة";
}
else
{
db.OrderInDetials.Remove(dto);
db.SaveChanges();
MedicineDTO mdto = db.Medicines.Find(med_ID);
if (mdto != null)
{
if (mdto.IsHasTapes)
{
mdto.Number = (mdto.TotaleNumberOfTapes - (payment_QTY * mdto.NumberOfTapesInOneMedicine)) / mdto.NumberOfTapesInOneMedicine;
mdto.TotaleNumberOfTapes -= (payment_QTY * mdto.NumberOfTapesInOneMedicine);
mdto.TotalePrice -= ((payment_QTY * mdto.NumberOfTapesInOneMedicine) * mdto.Price);
}
else
{
mdto.Number -= payment_QTY;
mdto.TotalePrice -= (payment_QTY * mdto.Price);
}
db.SaveChanges();
}
data = "تمت عملية التراجع بنجاح";
}
}
return(data);
}
public async Task <IEnumerable <MedicineDTO> > SearchMedicines(string query)
{
var SearchQuery = await _repository.SearchMedicines(query);
List <MedicineDTO> list = new List <MedicineDTO>();
var listPHMedicines = await _repository.GetAllPHMedicines();
List <string> headNames = new List <string>();
List <PharmacyHead> heads = new List <PharmacyHead>();
foreach (var med in SearchQuery)
{
var meds = listPHMedicines.Where(x => x.MedicineId == med.Id).ToList();
if (meds != null)
{
heads = meds.Select(x => x.Head).ToList();
}
if (heads != null)
{
headNames = heads?.Select(x => x?.Name).ToList();
}
MedicineDTO medicine = new MedicineDTO()
{
Name = med.Name,
Manufacturer = med.Manufacturer,
Packaging = med.Packaging,
Form = med.Form,
Price = med.Price,
Strength = med.Strength,
WayOfIssuing = med.WayOfIssuing,
HeadNames = headNames
};
list.Add(medicine);
headNames = new List <string>();
}
return(list);
}
// POST: /Medicine/DeleteMedicine/id
public ActionResult DeleteMedicine(int id)
{
//check if user is login in App
string username = User.Identity.Name;
if (string.IsNullOrEmpty(username))
{
return(RedirectToAction("login", "Account"));
}
// Delete Medicine from DB
using (Db db = new Db())
{
MedicineDTO dto = db.Medicines.Find(id);
if (dto == null)
{
return(HttpNotFound());
}
db.Medicines.Remove(dto);
db.SaveChanges();
}
// Redirect
return(RedirectToAction("ShowMedicines"));
}
public MedicineDTO getMedicineInfoById(String medicineId, String batchId)
{
DateTime dateTime = DateTime.Now;
var dto_base = Db.Queryable <MEDICINE_INFORMATION, MEDICINE_INSTANCE, MEDICINE_STOCK>
((minfo, mins, ms) => minfo.MEDICINE_ID == mins.MEDICINE_ID && mins.MEDICINE_ID == ms.MEDICINE_ID &&
mins.BATCH_ID == ms.BATCH_ID).Where((minfo, mins, ms) => mins.MEDICINE_ID == medicineId &&
mins.BATCH_ID == batchId).Select((minfo, mins, ms) => new MedicineDTO
{
_medicine_id = minfo.MEDICINE_ID,
_batch_id = mins.BATCH_ID,
_medicine_amount = ms.AMOUNT,
_medicine_applicability = minfo.MEDICINE_APPLICABILITY,
_medicine_attention = minfo.MEDICINE_ATTENTION,
_medicine_character = minfo.MEDICINE_CHARACTER,
_medicine_ingredients = minfo.MEDICINE_INGREDIENTS,
_medicine_type = minfo.MEDICINE_TYPE,
_medicine_image = minfo.MEDICINE_IMAGE,
_medicine_name = minfo.MEDICINE_NAME,
_medicine_usage = minfo.MEDICINE_USAGE,
_production_date = mins.PRODUCTION_DATE,
_purchase_price = mins.PURCHASE_PRICE,
_sale_price = mins.SALE_PRICE,
_supplier_id = minfo.SUPPLIER_ID,
_validity_date = mins.VALIDITY_DATE
}).ToList();
var discountPrice = Db.Queryable <SET_DISCOUNT, DISCOUNT>((sd, d) => sd.DISCOUNT_ID == d.DISCOUNT_ID)
.Where((sd, d) => sd.MEDICINE_ID == medicineId && sd.BATCH_ID == batchId).Select((sd, d) => d.DISCOUNT_PRICE).Single();
MedicineDTO dto = dto_base[0];
dto._discount_price = discountPrice;
return(dto);
}
public string buyMedicine(int medicine_id = 0, int medicine_order_id = 0, int medicine_QTY = 0,
int medicine_price = 0, int totalAmount = 0, Boolean medicine_isContainTapes = false, int medicine_OrderDetials_id = 0,
int medicine_old_QTY = 0
)
{
long id;
if (medicine_OrderDetials_id == 0)
{
using (Db db = new Db())
{
var n = db.Medicines.Where(x => x.Id == medicine_id).Select(x => x.MedicineName).First();
// Create OrderOutDTO
OrderInDetialsDTO orderInDTO = new OrderInDetialsDTO()
{
OrderId = medicine_order_id,
MedicineId = medicine_id,
MedicineName = n,
MedicineQuantity = medicine_QTY,
MedicinePrice = medicine_price,
TotalPrice = totalAmount
};
// Add the DTO
db.OrderInDetials.Add(orderInDTO);
// Save
db.SaveChanges();
}
// edit medicine data
using (Db db = new Db())
{
MedicineDTO dto = db.Medicines.Find(medicine_id);
if (medicine_isContainTapes)
{
dto.Number = (dto.TotaleNumberOfTapes + (medicine_QTY * dto.NumberOfTapesInOneMedicine)) / dto.NumberOfTapesInOneMedicine;
dto.TotaleNumberOfTapes += (medicine_QTY * dto.NumberOfTapesInOneMedicine);
dto.TotalePrice += ((medicine_QTY * dto.NumberOfTapesInOneMedicine) * dto.Price);
}
else
{
dto.Number += medicine_QTY;
dto.TotalePrice += (medicine_QTY * dto.Price);
}
db.SaveChanges();
}
//end edit medicine
//get last orderoutdetials id
using (Db db = new Db())
{
// Get the OrderOut
id = db.OrderInDetials.ToArray().Select(x => x.Id).Last();
};
}
//edit medicine OrderOutDetials info
else
{
// edit medicine data
using (Db db = new Db())
{
OrderInDetialsDTO orderDTO = db.OrderInDetials.Find(medicine_OrderDetials_id);
orderDTO.MedicineQuantity = medicine_QTY;
orderDTO.TotalPrice = totalAmount;
orderDTO.MedicinePrice = medicine_price;
MedicineDTO dto = db.Medicines.Find(medicine_id);
if (medicine_isContainTapes)
{
dto.TotaleNumberOfTapes = (dto.NumberOfTapesInOneMedicine * medicine_QTY) + medicine_old_QTY;
dto.Number = (dto.TotaleNumberOfTapes) / dto.NumberOfTapesInOneMedicine;
dto.TotalePrice = ((dto.NumberOfTapesInOneMedicine * medicine_QTY) + medicine_old_QTY) * dto.Price;
}
else
{
dto.Number = medicine_old_QTY + medicine_QTY;
dto.TotalePrice = (medicine_QTY + medicine_old_QTY) * dto.Price;
}
// dto.TotalePrice = (dto.TotalePrice + medicine_old_totaleAmount) - totalAmount;
db.SaveChanges();
}
id = medicine_OrderDetials_id;
}
return(id.ToString());
}
public async Task AddNewMedicine(MedicineDTO request)
{
await _unitOfWork.Pharmacy.SaveMedicine(_mapper.Map <Medicine>(request));
}
public async Task DeleteMedicine(MedicineDTO request)
{
await _unitOfWork.Pharmacy.DeleteMedicine(_mapper.Map <Medicine>(request));
}
public string payMedicine(int medicine_id = 0, int medicine_order_id = 0, int medicine_QTY = 0,
int totalAmount = 0, Boolean medicine_isContainTapes = false, int medicine_OrderDetials_id = 0,
int medicine_old_totaleAmount = 0, int medicine_old_QTY = 0
)
{
int id;
if (medicine_OrderDetials_id == 0)
{
using (Db db = new Db())
{
var mName = db.Medicines.Where(x => x.Id == medicine_id).Select(x => x.MedicineName).First();
var mPrice = db.Medicines.Where(x => x.Id == medicine_id).Select(x => x.Price).First();
// Create OrderOutDTO
OrderOutDetialsDTO orderoutDTO = new OrderOutDetialsDTO()
{
OrderId = medicine_order_id,
MedicineId = medicine_id,
OrderDate = DateTime.Now,
TotaleAmount = totalAmount,
QTY = medicine_QTY,
OrderDay = DateTime.Now.Date,
MedicineName = mName,
MedicinePrice = mPrice
};
;
// Add the DTO
db.OrderOutDetials.Add(orderoutDTO);
// Save
db.SaveChanges();
id = orderoutDTO.Id;
}
// edit medicine data
using (Db db = new Db())
{
MedicineDTO dto = db.Medicines.Find(medicine_id);
if (medicine_isContainTapes)
{
dto.Number = (dto.TotaleNumberOfTapes - medicine_QTY) / dto.NumberOfTapesInOneMedicine;
dto.TotaleNumberOfTapes -= medicine_QTY;
}
else
{
dto.Number -= medicine_QTY;
}
dto.TotalePrice -= totalAmount;
db.SaveChanges();
// id = db.OrderOutDetials.ToArray().Select(x => x.Id).Last();
}
//end edit medicine
//get last orderoutdetials id
/* using (Db db = new Db())
* {
* // Get the OrderOut
* id = db.OrderOutDetials.ToArray().Select(x => x.Id).Last();
* };*/
}
//edit medicine OrderOutDetials info
else
{
// edit medicine data
using (Db db = new Db())
{
OrderOutDetialsDTO orderDTO = db.OrderOutDetials.Find(medicine_OrderDetials_id);
orderDTO.QTY = medicine_QTY;
orderDTO.TotaleAmount = totalAmount;
MedicineDTO dto = db.Medicines.Find(medicine_id);
if (medicine_isContainTapes)
{
dto.TotaleNumberOfTapes = (dto.TotaleNumberOfTapes + medicine_old_QTY) - medicine_QTY;
dto.Number = (dto.TotaleNumberOfTapes) / dto.NumberOfTapesInOneMedicine;
}
else
{
dto.Number = (dto.Number + medicine_old_QTY) - medicine_QTY;
}
dto.TotalePrice = (dto.TotalePrice + medicine_old_totaleAmount) - totalAmount;
db.SaveChanges();
}
id = medicine_OrderDetials_id;
}
return(id.ToString());
}
