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; } }
public void Insert(MedicinePlan MedicinePlan) { MedicinePlan.CreatedDate = DateTime.Now; MedicinePlan.CreatedUser = AppContext.LoggedInUser.Id; MedicinePlan.LastUpdatedDate = DateTime.Now; MedicinePlan.LastUpdatedUser = AppContext.LoggedInUser.Id; MedicinePlan.Version = 0; this.Context.MedicinePlans.Add(MedicinePlan); 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; } }
public void Insert(MedicinePlan medicinePlan, List<MedicinePlanDetail> medicinePlanDetails) { using (var scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted })) { medicinePlan.SetInfo(false); this.Context.MedicinePlans.Add(medicinePlan); this.Context.SaveChanges(); foreach (var detail in medicinePlanDetails) { detail.PlanId = medicinePlan.Id; detail.SetInfo(false); this.Context.MedicinePlanDetails.Add(detail); } this.Context.SaveChanges(); scope.Complete(); } }
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) { } }
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) { } }
/// <summary> /// Updates the specified medicine plan. /// </summary> /// <param name="medicinePlan">The medicine plan.</param> public void Update(MedicinePlan medicinePlan) { var oldMedicinePlan = this.Context.MedicinePlans.FirstOrDefault(x => x.Id == medicinePlan.Id); if (oldMedicinePlan == null) return; oldMedicinePlan.Year = medicinePlan.Year; oldMedicinePlan.Month = medicinePlan.Month; oldMedicinePlan.Date = medicinePlan.Date; oldMedicinePlan.ClinicId = medicinePlan.ClinicId; oldMedicinePlan.ApproveId = medicinePlan.ApproveId; oldMedicinePlan.Status = medicinePlan.Status; oldMedicinePlan.Note = medicinePlan.Note; oldMedicinePlan.LastUpdatedUser = AppContext.LoggedInUser.Id; oldMedicinePlan.LastUpdatedDate = DateTime.Now; oldMedicinePlan.Version++; this.Context.SaveChanges(); }
/// <summary> /// Updates the specified medicine plan. /// </summary> /// <param name="medicinePlan">The medicine plan.</param> /// <param name="medicinePlanDetails">The medicine plan details.</param> /// <exception cref="System.Exception">Dự trù không tồn tại</exception> public void Update(MedicinePlan medicinePlan, List<MedicinePlanDetail> medicinePlanDetails) { using (var scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = IsolationLevel.ReadCommitted })) { var plan = this.Context.MedicinePlans.FirstOrDefault(x => x.Id == medicinePlan.Id); if (plan == null) throw new Exception("Dự trù không tồn tại"); plan.Note = medicinePlan.Note; plan.Status = MedicinePlaningStatus.ReEdited; plan.SetInfo(true); var detailList =this.Context.MedicinePlanDetails.Where(x => x.PlanId == plan.Id).ToList(); foreach (var detail in medicinePlanDetails) { foreach (var original in detailList) { if (original.Id != detail.Id) continue; original.Required = detail.Required; original.SetInfo(true); break; } } this.Context.SaveChanges(); scope.Complete(); } }