public OrderOutDetialsVM(OrderOutDetialsDTO row)
{
this.Id = row.Id;
this.OrderId = row.OrderId;
this.MedicineName = row.MedicineName;
this.MedicineId = row.MedicineId;
this.MedicinePrice = row.MedicinePrice;
this.OrderDate = row.OrderDate;
this.OrderDay = row.OrderDay;
this.TotaleAmount = row.TotaleAmount;
this.QTY = row.QTY;
}
public string backpaymedicine(int med_ID, int order_ID, int payment_QTY, int payment_total_price)
{
// Delete OrderOutDetials from DB
string data;
using (Db db = new Db())
{
OrderOutDetialsDTO dto = db.OrderOutDetials.Find(order_ID);
if (dto == null)
{
data = "البيانات غير موجودة";
}
else
{
db.OrderOutDetials.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.TotaleNumberOfTapes += payment_QTY;
}
else
{
mdto.Number += payment_QTY;
}
mdto.TotalePrice += payment_total_price;
db.SaveChanges();
}
data = "تمت عملية التراجع بنجاح";
}
}
return(data);
}
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());
}
