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 "";
}