public ActionResult Display() { MedicineService medserve = new MedicineService(); var QResult = medserve.QueryAll(); return(Json(QResult, JsonRequestBehavior.AllowGet)); }
// GET: Medicine public ActionResult Index() { MedicineService medserve = new MedicineService(); var med = medserve.QueryAll(); return(View(med)); }
public void GetAllMedicinesByUserIdTest() { var medicineService = new MedicineService(medicinecontextmock.Object); var medicinelist = medicineService.GetMedicine(123); Assert.AreEqual(1, medicinelist.Count()); }
public ActionResult Delete(string ID) { MedicineService medserve = new MedicineService(); medserve.DeleteOld(ID); return(Json("true")); }
public ActionResult Edit(string med_ID, string med_name, int cost_price, int sell_price, string unit, int num, string producer) { MedicineService medserve = new MedicineService(); medserve.ModNew(med_ID, med_name, cost_price, sell_price, unit, num, producer); return(Json("true")); }
public void DeleteMedicineDeatail() { var medicineService = new MedicineService(medicinecontextmock.Object); var x = medicineService.DeleteMedicine(1); Assert.IsNotNull(x); }
public OperationController() { operationService = new OperationService(); treatmentService = new TreatmentService(); typeOperationService = new TypeOperationService(); medicineService = new MedicineService(); }
public async Task <IHttpActionResult> UpdateMedicine(MedicineModel medicine) { if (medicine == null) { return(BadRequest("Please provide valid inputs!")); } CommonResponse validatedResponse = await AuthService.ValidateUserAndToken(); if (!validatedResponse.IsError) { if (await MedicineService.MedicineExist(medicine)) { if (await MedicineService.UpdateMedicine(medicine)) { return(Ok("Medicine Updated Successfully!")); } else { return(BadRequest("Failed to Update Medicine!")); } } else { return(BadRequest("No Such Medicine Exisits!")); } } else { return(Unauthorized()); } }//end of update
public async Task <IHttpActionResult> AddMedicine(MedicineModel medicine) { if (medicine == null) { return(BadRequest("Please provide valid inputs!")); } CommonResponse validatedResponse = await AuthService.ValidateUserAndToken(); if (!validatedResponse.IsError) { if (await MedicineService.MedicineExist(medicine)) { return(BadRequest("Medicine Already Exists")); } else { if (await MedicineService.AddMedicine(medicine)) { return(Ok("Medicine Added Successfully!")); } else { return(BadRequest("Medicine Adding Failed!")); } } } else { return(Unauthorized()); } }//end of add
protected void ok_Click(object sender, EventArgs e) { if (MedicineService.UpdateMedicine(drug_name.Text, manufacter.Text, Convert.ToDecimal(price.Text), Convert.ToInt32(amount.Text), type.Text, drug_num.Text)) { Response.Write("<script language=javascript>window.alert('更新药品信息成功!');</script>"); } }
public async Task DeleteShouldReturnTrueAndDeletedMedicine() { var db = Tests.GetDatabase(); var medicineService = new MedicineService(db); await medicineService.Create("Lekarstvo", "6 x 2", "Lekuva vsichkooooooooooooooooo"); await db.SaveChangesAsync(); var id = await db.Medicines .Where(d => d.Name == "Lekarstvo") .Select(d => d.Id) .FirstOrDefaultAsync(); var deleted = await medicineService.Delete(id); await db.SaveChangesAsync(); deleted.Should() .BeTrue(); db.Medicines.Should() .HaveCount(0); }
/*[HttpPost] * public ActionResult Add(string med_ID) * { * MedicineService medserve = new MedicineService(); * * return Json("true"); * }*/ public ActionResult Query(string ID) { MedicineService medserve = new MedicineService(); var QResult = medserve.QueryByID(ID); return(Json(QResult)); }
public ActionResult Increase(string med_ID, int num) { MedicineService medserve = new MedicineService(); medserve.IncreaseMedicine(med_ID, num); return(Json("true")); }
private string GetMedicineDetail(IMedicineRepository service, ViewMedicineViewModel model) { var _service = new MedicineService(service); var fullName = (_service.GetMedicineDetails(model).FullName); return(fullName); }
//search medicine private void search_tb_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { medServ = new MedicineService(); medSearch_table.DataSource = medServ.GetMeds(search_tb.Text); } }
public void AddMedicineDetailTest() { var medicineService = new MedicineService(medicinecontextmock.Object); var x = medicineService.PostMedicine(new Medicine { Mid = 23, ExpiryDate = DateTime.Now, Mname = "Walhabibi", Price = 345, QuantityRemaining = 5 }); Assert.IsNotNull(x); }
public SharingPrescriptionController(MyDbContext context) { MedicineService = new MedicineService(context); PatientService = new PatientService(context); MedicineDescriptionService = new MedicineDescriptionService(context); PrescriptionFileService = new PrescriptionFileService(context); MedicineAvailabilityTable = new MedicineAvailabilityTable(); Environment = Program.Environment; }
public String getText(DateOfOrder date, DoctorsOrder order, StringBuilder stringBuilder) { foreach (MedicineForOrdering medicine in MedicineService.GetAll()) { if (isOrderInRequiredPeriod(medicine, date, order)) { stringBuilder.Append("\n Medicine name: " + medicine.Name + "\n Ordered quantity: " + medicine.Quantity + " (Date: " + order.DateEnd.Date.ToString() + ")\n"); } } return(stringBuilder.ToString()); }
public async Task CreateShouldReturnTrueAndNewMedicine() { var db = Tests.GetDatabase(); var medicineService = new MedicineService(db); await medicineService.Create("Lekarstvo", "6 x 2", "Lekuva vsichkooooooooooooooooo"); db.Medicines.Should() .HaveCount(1); }
protected void delete_drug_Click(object sender, EventArgs e) { if (MedicineService.DeleteMedicine(device_num.Text)) { Response.Write("<script language=javascript>window.alert('删除成功!');</script>"); device_num.Text = ""; device_name.Text = ""; manufacter.Text = ""; single_price.Text = ""; department_num.Text = ""; } }
public List <string> GetMedicineNamesAndStockQuantities() { var medicinesInStock = MedicineService.GetAllMedicinesInStock(); var results = new List <string>(medicinesInStock.Count); foreach (var medicine in medicinesInStock) { results.Add($@"{medicine.Name} - {medicine.Quantity}"); } return(results); }
public ActionResult Add(string med_ID, string med_name, int cost_price, int sell_price, string unit, int num, string producer) { MedicineService medserve = new MedicineService(); if (medserve.Check(med_ID) == null) { medserve.AddNew(med_ID, med_name, cost_price, sell_price, unit, num, producer); } else { medserve.IncreaseMedicine(med_ID, num); } return(Json("true")); }
private static int Exist(int id) { while (true) { MedicineService medicine = new MedicineService(); if (medicine.Exist(id)) { return(id); //break; } Menu.RedText("Nie ma takiego leku w bazie, spróbój ponowanie"); id = int.Parse(Console.ReadLine()); } }
private void search_tb_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { if (search_tb.Text == "") { MessageBox.Show("Your search box is empty"); } else { medServ = new MedicineService(); medTable.DataSource = medServ.GetMeds(search_tb.Text); } } }
public CourseController( PMDbContext context, CourseService courseService, MedicineService medicineService, ProcedureService procedureService, MeasurementService measurementService, CourseHistoryService courseHistoryService) { _context = context; _courseService = courseService; _medicineService = medicineService; _procedureService = procedureService; _measurementService = measurementService; _courseHistoryService = courseHistoryService; }
protected void Search_Drug_Click(object sender, EventArgs e) { medicine = MedicineService.QueryMedicineByNum(search_num.Text); if (medicine.Count == 0) { Response.Write("<script language=javascript>window.alert('输入的药品编号不存在!')</script>"); } else { drug_num.Text = medicine[0].Number.ToString(); drug_name.Text = medicine[0].Name.ToString(); manufacter.Text = medicine[0].Manufacter.ToString(); price.Text = medicine[0].Price.ToString(); amount.Text = medicine[0].Amount.ToString(); type.Text = medicine[0].Type.ToString(); } }
protected void Add_Click(object sender, EventArgs e) { if (MedicineService.AddMedicine(drug_num.Text, drug_name.Text, manufacturer.Text, Convert.ToDecimal(price.Text), int.Parse(amount.Text), type.Text) != -1) { Response.Write("<script language=javascript>window.alert('添加药品成功');</script>"); drug_num.Text = ""; drug_name.Text = ""; manufacturer.Text = ""; price.Text = ""; amount.Text = ""; type.Text = ""; } else { Response.Write("<script language=javascript>window.alert('该药品编号已存在,请输入其他编号!');</script>"); } }
private void MedicineList_Load(object sender, EventArgs e) { try { InitControlPosition(); var service = new MedicineService(); dataList = service.GetMedicineList(txt_search.Text.Trim()); InitData(); //加载页数 InitPageCount(dataList.Count); lbl_Sum.Text = $"总数:{dataList.Count}"; } catch (Exception) { throw; } }
private void done_del_bt_Click(object sender, EventArgs e) { medServ = new MedicineService(); try { int result = medServ.DeleteMed(Convert.ToInt32(medId_del_tb.Text)); if (result > 0) { MessageBox.Show("Medicine Deleted"); medId_del_tb.Text = ""; UpdateGridview(); } else { MessageBox.Show("Please Try Again"); } } catch (Exception ex) { MessageBox.Show(ex.StackTrace); } }
public async Task <IHttpActionResult> GetMedicine(MedicineModel medicine) { CommonResponse validatedResponse = await AuthService.ValidateUserAndToken(); if (!validatedResponse.IsError) { var Medicine = await MedicineService.GetMedicine(medicine); if (Medicine.Count > 0) { return(Ok(Medicine)); } else { return(BadRequest("No Medicine record Exists!")); } } else { return(Unauthorized()); } }//end of get
public BasicInfoModel ReadBasicInfo(string type) { var basicInfoModel = new BasicInfoModel {Type = type}; var names = new List<NameModel>(); basicInfoModel.Names = names; if (type == "治疗") { List<cure_type> cureTypes = new CureTypeService().FindAll(); foreach (cure_type cureType in cureTypes) { var nameModel = new NameModel {Name = cureType.Name, Id = cureType.Id}; names.Add(nameModel); } } else if (type == "药物") { List<medicine> medicineTypes = new MedicineService().FindAll(); foreach (medicine medicineType in medicineTypes) { var nameModel = new NameModel {Name = medicineType.Name, Id = medicineType.Id}; names.Add(nameModel); } } else if (type == "单位") { List<unit> unitTypes = new UnitService().FindAll(); foreach (unit unitType in unitTypes) { var nameModel = new NameModel {Name = unitType.Name, Id = unitType.Id}; names.Add(nameModel); } } else if (type == "异常") { List<exception_type> exceptionTypes = new ExceptionTypeService().FindAll(); foreach (exception_type exceptionType in exceptionTypes) { var nameModel = new NameModel {Name = exceptionType.Name, Id = exceptionType.Id}; names.Add(nameModel); } } else if (type == "饲料") { List<fodder_type> fodderTypes = new FodderTypeService().FindAll(); foreach (fodder_type fodderType in fodderTypes) { var nameModel = new NameModel {Name = fodderType.Name, Id = fodderType.Id}; names.Add(nameModel); } } else if (type == "生猪") { List<pig_type> pigTypes = new PigTypeService().FindAll(); foreach (pig_type pigType in pigTypes) { var nameModel = new NameModel {Name = pigType.Name, Id = pigType.Id}; names.Add(nameModel); } } else if (type == "防疫") { List<prevention_type> preventionTypes = new PreventionTypeService().FindAll(); foreach (prevention_type preventionType in preventionTypes) { var nameModel = new NameModel { Name = preventionType.Name, Id = preventionType.Id, MedicineId = preventionType.MedicineId, Quality = Convert.ToInt32(preventionType.Quality), UnitId = preventionType.UnitId }; names.Add(nameModel); } } else if (type == "猪舍") { List<pig_house_type> pigHouseTypes = new PigHouseTypeService().FindAll(); foreach (pig_house_type pigHouseType in pigHouseTypes) { var nameModel = new NameModel {Name = pigHouseType.Name, Id = pigHouseType.Id}; names.Add(nameModel); } } else if (type == "任务状态") { List<task_status_type> taskStatusTypes = new TaskStatusTypeService().FindAll(); foreach (task_status_type taskStatusType in taskStatusTypes) { var nameModel = new NameModel {Name = taskStatusType.Name, Id = taskStatusType.Id}; names.Add(nameModel); } } else if (type == "任务类型") { List<task_type> taskTypes = new TaskTypeService().FindAll(); foreach (task_type taskType in taskTypes) { var nameModel = new NameModel {Name = taskType.Name, Id = taskType.Id}; names.Add(nameModel); } } else if (type == "角色") { List<role_type> roleTypes = new RoleTypeService().FindAll(); foreach (role_type roleType in roleTypes) { var nameModel = new NameModel {Name = roleType.Name, Id = roleType.Id}; names.Add(nameModel); } } else if (type == "客户名称") { List<customer> customerTypes = new CustomerService().FindAll(); foreach (customer customer in customerTypes) { var nameModel = new NameModel {Name = customer.Name, Id = customer.Id}; names.Add(nameModel); } } if (names.Count == 0) { var nullNameModel = new NameModel(); names.Add(nullNameModel); } return basicInfoModel; }
public void MedicineTypeSaveChanges(BasicInfoModel model) { var medicineTypeService = new MedicineService(); List<medicine> medicineTypes = medicineTypeService.FindAll(); foreach (medicine medicineType in medicineTypes) { int idFlag = 0; int nameFlag = 0; string newname = ""; foreach (NameModel name in model.Names) { if (medicineType.Id == name.Id) { idFlag = 1; if (medicineType.Name.Equals(name.Name)) { nameFlag = 1; } else { newname = name.Name; } } } //若存在此Id,但是name变化了的,则需要修改数据库 if (idFlag == 1) { if (nameFlag == 0) { if (newname == "") { throw new Exception(); } medicine modifyCure = medicineTypeService.Find(medicineType.Id); modifyCure.Name = newname; medicineTypeService.Update(modifyCure); } } } //如果model里的Id为0,说明是新建的类型 foreach (NameModel name in model.Names) { if (name.Id == 0 && medicineTypeService.FindByName(name.Name) == null) { var newMedicineType = new medicine {Name = name.Name}; medicineTypeService.Insert(newMedicineType); } } }
/// <summary> /// 获得药下拉列表 /// </summary> /// <returns>返回集合</returns> public IEnumerable<SelectListItem> GetMedicineList() { var medicine = new MedicineService(); IEnumerable<SelectListItem> medicineSelectList = medicine.FindAll().Select(medicineItem => new SelectListItem { Text = medicineItem.Name, Value = medicineItem.Id + "" }).OrderBy(m => m.Text); return medicineSelectList; }
//判断类型是否重复 public bool JudgeNameByType(string name, string typename) { var cureTypeService = new CureTypeService(); var medicineService = new MedicineService(); var unitService = new UnitService(); var fodderTypeService = new FodderTypeService(); var excetionTypeService = new ExceptionTypeService(); var pigTypeService = new PigTypeService(); var pigHouseTypeService = new PigHouseTypeService(); var taskStatusTypeService = new TaskStatusTypeService(); var taskTypeService = new TaskTypeService(); var roleTypeService = new RoleTypeService(); var preventionTypeService = new PreventionTypeService(); var customerService = new CustomerService(); if (typename == "治疗") { if (cureTypeService.FindByName(name) == null) return true; } if (typename == "单位") { if (unitService.FindByName(name) == null) return true; } if (typename == "药物") { if (medicineService.FindByName(name) == null) return true; } if (typename == "异常") { if (excetionTypeService.FindByName(name).Count == 0) return true; } if (typename == "饲料") { if (fodderTypeService.FindByName(name) == null) return true; } if (typename == "生猪") { if (pigTypeService.FindByName(name) == null) return true; } if (typename == "防疫") { if (preventionTypeService.FindByName(name) == null) return true; } if (typename == "猪舍") { if (pigHouseTypeService.FindByName(name) == null) return true; } if (typename == "任务状态") { if (taskStatusTypeService.FindByName(name) == null) return true; } if (typename == "任务类型") { if (taskTypeService.FindByName(name) == null) return true; } if (typename == "角色") { if (roleTypeService.FindByName(name) == null) return true; } if (typename == "客户名称") { if (customerService.FindByName(name) == null) return true; } return false; }
/// <summary> /// 根据类型id查找关联它的表是否为0 /// </summary> /// <param name="typeid">类型id</param> /// <param name="typename">类型名字</param> /// <returns></returns> public string GetRelationtById(long typeid, string typename) { var cureTypeService = new CureTypeService(); var medicineService = new MedicineService(); var unitService = new UnitService(); var fodderTypeService = new FodderTypeService(); var excetionTypeService = new ExceptionTypeService(); var pigTypeService = new PigTypeService(); var pigHouseTypeService = new PigHouseTypeService(); var taskStatusTypeService = new TaskStatusTypeService(); var taskTypeService = new TaskTypeService(); var roleTypeService = new RoleTypeService(); var preventionTypeService = new PreventionTypeService(); var roleAuthorityService = new RoleAuthorityService(); var customerService = new CustomerService(); if (typeid == 0) { return "不存在于数据库,可以删除"; } try { if (typename == "治疗") { cureTypeService.Delete(cureTypeService.Find(typeid)); } if (typename == "单位") { unitService.Delete(unitService.Find(typeid)); } if (typename == "药物") { medicineService.Delete(medicineService.Find(typeid)); } if (typename == "异常") { excetionTypeService.Delete(excetionTypeService.Find(typeid)); } if (typename == "饲料") { fodderTypeService.Delete(fodderTypeService.Find(typeid)); } if (typename == "生猪") { if (pigTypeService.Find(typeid).Name == "母猪" || pigTypeService.Find(typeid).Name == "公猪") { return "不可删除"; } pigTypeService.Delete(pigTypeService.Find(typeid)); } if (typename == "防疫") { preventionTypeService.Delete(preventionTypeService.Find(typeid)); } if (typename == "猪舍") { pigHouseTypeService.Delete(pigHouseTypeService.Find(typeid)); } if (typename == "任务状态") { if (taskStatusTypeService.Find(typeid).Name == "未完成" || taskStatusTypeService.Find(typeid).Name == "已完成" || taskStatusTypeService.Find(typeid).Name == "正在进行") { return "不可删除"; } taskStatusTypeService.Delete(taskStatusTypeService.Find(typeid)); } if (typename == "任务类型") { if (taskTypeService.Find(typeid).Name == "喂饲" || taskTypeService.Find(typeid).Name == "防疫" || taskTypeService.Find(typeid).Name == "巡查" || taskTypeService.Find(typeid).Name == "治疗" || taskTypeService.Find(typeid).Name == "销售" || taskTypeService.Find(typeid).Name == "转栏" || taskTypeService.Find(typeid).Name == "添加生猪") { return "不可删除"; } taskTypeService.Delete(taskTypeService.Find(typeid)); } if (typename == "角色") { foreach (role_authority c in roleAuthorityService.FindByRoleTypeId(typeid)) roleAuthorityService.Delete(roleAuthorityService.Find(c.Id)); roleTypeService.Delete(roleTypeService.Find(typeid)); } if (typename == "客户名称") { customerService.Delete(customerService.Find(typeid)); } } catch (Exception) { return "不可删除"; } return ""; }