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);
}
/// <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 "";
}
public void Delete(Medicine entity) => medicineService.Delete(entity);
public Boolean Delete(int medicineId)
{
return(medicineService.Delete(medicineId));
}