private void ReloadPlannedInfo() { // Medicine plan detail var medicines = this._medicineRepo.GetAll(); var stocks = _warehouseRepo.GetAll(AppContext.CurrentClinic.Id); var startDate1 = new DateTime(this._medicinePlan.Year, this._medicinePlan.Month, 1); var endDate1 = startDate1.AddMonths(1).AddDays(-1); var currentMonthDeliverTotal = _deliveryRepo.GetMedicineDeliveryTotal(AppContext.CurrentClinic.Id, startDate1, endDate1); var endDate2 = startDate1.AddDays(-1); var startDate2 = startDate1.AddMonths(-1); var lastMonthDeliverTotal = _deliveryRepo.GetMedicineDeliveryTotal(AppContext.CurrentClinic.Id, startDate2, endDate2); // Create Medicine Planning Detail this._medicinePlanDetails = new List <MedicinePlanDetail>(); foreach (var medicine in medicines) { var medicinePlanDetail = new MedicinePlanDetail { MedicineId = medicine.Id, Version = 0, MedicineName = medicine.Name, UnitName = medicine.Define.Name, TradeName = medicine.TradeName }; var warehouseList = stocks.Where(x => x.MedicineId == medicine.Id).ToList(); foreach (var medicineInStock in warehouseList) { medicinePlanDetail.InStock = medicineInStock.Volumn; break; } foreach (var currentMonthUsage in currentMonthDeliverTotal) { if (currentMonthUsage.MedicineId != medicine.Id) { continue; } medicinePlanDetail.CurrentMonthUsage = currentMonthUsage.Quantity; break; } foreach (var lastMonthUsage in lastMonthDeliverTotal) { if (lastMonthUsage.MedicineId != medicine.Id) { continue; } medicinePlanDetail.CurrentMonthUsage = lastMonthUsage.Quantity; break; } medicinePlanDetail.Required = medicinePlanDetail.LastMonthUsage - medicinePlanDetail.CurrentMonthUsage - medicinePlanDetail.InStock; if (medicinePlanDetail.Required < 0) { medicinePlanDetail.Required = 0; } this._medicinePlanDetails.Add(medicinePlanDetail); } bdsPlanning.DataSource = this._medicinePlan; bdsPlanningDetail.DataSource = this._medicinePlanDetails; }
public void Update(MedicinePlanDetail medicinePlanDetail) { try { var oldMedicinePlanDetail = this.Context.MedicinePlanDetails.FirstOrDefault(x => x.Id == medicinePlanDetail.Id); if (oldMedicinePlanDetail == null) { return; } oldMedicinePlanDetail.PlanId = medicinePlanDetail.PlanId; oldMedicinePlanDetail.MedicineId = medicinePlanDetail.MedicineId; oldMedicinePlanDetail.InStock = medicinePlanDetail.InStock; oldMedicinePlanDetail.LastMonthUsage = medicinePlanDetail.LastMonthUsage; oldMedicinePlanDetail.CurrentMonthUsage = medicinePlanDetail.CurrentMonthUsage; oldMedicinePlanDetail.Required = medicinePlanDetail.Required; oldMedicinePlanDetail.UnitPrice = medicinePlanDetail.UnitPrice; oldMedicinePlanDetail.UnitPrice = medicinePlanDetail.UnitPrice; oldMedicinePlanDetail.Amount = medicinePlanDetail.Amount; oldMedicinePlanDetail.LastUpdatedDate = DateTime.Now; oldMedicinePlanDetail.Version++; this.Context.SaveChanges(); } catch (Exception ex) { throw; } }
public void Insert(MedicinePlanDetail medicinePlanDetail) { medicinePlanDetail.Version = 0; medicinePlanDetail.LastUpdatedDate = DateTime.Now; this.Context.MedicinePlanDetails.Add(medicinePlanDetail); this.Context.SaveChanges(); }
private void InitializeData() { // Init data if (this._mode == ViewModes.Add) { // Medicine plan this._medicinePlan = new Data.Entities.MedicinePlan(); this._medicinePlan.Date = DateTime.Today; this._medicinePlan.ClinicId = AppContext.CurrentClinic.Id; var date = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1, 0, 0, 0); date = date.AddMonths(1); this._medicinePlan.Month = date.Month; this._medicinePlan.Year = date.Year; this._medicinePlan.Status = 0; ReloadPlannedInfo(); } else { this._medicinePlan = this._planingRepo.Get(this._planningId); if (this._medicinePlan == null) { throw new Exception("Dự trù thuốc không tồn tại"); } bdsPlanning.DataSource = this._medicinePlan; this._medicinePlanDetails = this._planingDetailRepo.GetByPlanId(this._planningId); var medicines = this._medicineRepo.GetAll(); foreach (var planDetail in _medicinePlanDetails) { foreach (var medicine in medicines) { if (medicine.Id != planDetail.MedicineId) { continue; } planDetail.TradeName = medicine.TradeName; planDetail.MedicineName = medicine.Define.Name; var medicinePlanDetail = new MedicinePlanDetail { MedicineId = medicine.Id, Version = 0, MedicineName = medicine.Name, UnitName = medicine.Define.Name, TradeName = medicine.TradeName }; } } bdsPlanningDetail.DataSource = this._medicinePlanDetails; this.txtYear.Enabled = false; this.txtMonth.Enabled = false; } }
private void btnInsert_Click(object sender, EventArgs e) { try { Medical.Data.Entities.MedicinePlan medicinePlan = repMedicinePlan.GetById(PlanId); // medicinePlan.Status = cboStatus.SelectedItem.ToString(); medicinePlan.Date = DateTime.Now; medicinePlan.Note = txtNote.Text; if (IsOwner) { medicinePlan.Year = int.Parse(cboYear.SelectedItem.ToString()); medicinePlan.Month = int.Parse(cboMonth.SelectedItem.ToString()); foreach (DataGridViewRow row in grd.Rows) { int id = int.Parse(row.Cells["Id"].Value.ToString()); MedicinePlanDetail item = repMedicinePlanDetail.GetById(id); if (row.Cells["Required"].Value != null) { item.Required = int.Parse(row.Cells["Required"].Value.ToString()); } else { item.Required = 0; } repMedicinePlanDetail.Update(item); } } repMedicinePlan.Update(medicinePlan); // Status = medicinePlan.Status; MessageBox.Show("Tạo kế hoạch thành công!"); this.Close(); } catch (Exception ex) { } }
private void btnInsert_Click(object sender, EventArgs e) { try { //Insert data to MedicinePlan Medical.Data.Entities.MedicinePlan medicinePlan = new Medical.Data.Entities.MedicinePlan(); medicinePlan.Year = int.Parse(cboYear.SelectedItem.ToString()); medicinePlan.Month = int.Parse(cboMonth.SelectedItem.ToString()); // medicinePlan.Status = Constants.Status_Wait; medicinePlan.Date = DateTime.Now; medicinePlan.Note = txtNote.Text; medicinePlan.ClinicId = int.Parse(cbClinic.SelectedValue.ToString()); repMedicinePlan.Insert(medicinePlan); //Insert data to MedicinePlanDetail foreach (DataGridViewRow row in grd.Rows) { if (ValidateRowData(row)) { MedicinePlanDetail item = new MedicinePlanDetail(); item.PlanId = medicinePlan.Id; item.MedicineId = int.Parse(row.Cells["MedicineId"].Value.ToString()); item.InStock = int.Parse(row.Cells["InStock"].Value.ToString()); item.LastMonthUsage = int.Parse(row.Cells["LastMonthUsage"].Value.ToString()); item.CurrentMonthUsage = int.Parse(row.Cells["CurrentMonthUsage"].Value.ToString()); item.Required = int.Parse(row.Cells["Required"].Value.ToString()); repMedicinePlanDetail.Insert(item); } } MessageBox.Show("Tạo kế hoạch thành công!"); grd.DataSource = new List <MedicinePlanDetail>(); } catch (Exception ex) { } }
public List <MedicinePlanDetail> GetByPlan(int clinicId, int year, int month) { List <MedicinePlanDetail> list = new List <MedicinePlanDetail>(); try { var listWareHouse = (from x in Context.WareHouses where x.ClinicId == clinicId select x).ToList(); foreach (WareHouse whItem in listWareHouse) { MedicinePlanDetail item = new MedicinePlanDetail(); item.MedicineId = whItem.MedicineId; item.MedicineName = whItem.MedicineName; item.InStock = whItem.Volumn; item.LastMonthUsage = GetMedicineInMonth(year, month - 1, 1, whItem.MedicineId); item.CurrentMonthUsage = GetMedicineInMonth(year, month, 1, whItem.MedicineId); list.Add(item); } } catch (Exception ex) { } return(list); }