public async Task UpdateAsync() { DbContextOptions <ReFreshDbContext> options = new DbContextOptionsBuilder <ReFreshDbContext>().UseInMemoryDatabase("UpdateProduct").Options; using (ReFreshDbContext context = new ReFreshDbContext(options)) { Product testProduct = new Product(); testProduct.ID = 1; testProduct.Sku = 1; testProduct.Name = "Test Product"; testProduct.Price = 5; testProduct.Description = "This is a test"; testProduct.Image = "https://image-url.com"; InventoryManagementService ims = new InventoryManagementService(context); await ims.CreateAsync(testProduct); Product updateProduct = testProduct; updateProduct.Name = "Update Product"; await ims.UpdateAsync(updateProduct); Product p = await ims.GetOneByIdAsync(testProduct.ID); Assert.True(p.Name == "Update Product"); } }
// GET: OrderController/Upload public ActionResult Upload() { var uploadOrder = new InventoryManagementService(); uploadOrder.SaveCsvOrders(Config.PathToSalesFile); return(RedirectToAction(nameof(Index))); }
public ActionResult Create(Product product) { var Insert = new InventoryManagementService(); if (!Insert.InsertNewProduct(product)) { ViewBag.Message = "Failed to insert Product"; return(RedirectToAction(nameof(Index))); } return(RedirectToAction(nameof(Index))); }
public ActionResult Edit(Product product) { var Update = new InventoryManagementService(); if (!Update.UpdateProductById(product)) { ViewBag.Message = "Update Unsusccesfull"; return(RedirectToAction(nameof(Index))); } return(RedirectToAction(nameof(Index))); }
public string SaveCheckList(string CheckNumber, string JsonData) { IEnumerable <WarehouseCheckDetail> receivelist = JSONStringToList <WarehouseCheckDetail>(JsonData).AsEnumerable(); List <WarehouseCheckDetail> list = new List <WarehouseCheckDetail>(); var response = new InventoryManagementService().InsertCheckDetailList(receivelist.ToList(), Session["Name"].ToString(), CheckNumber); if (response) { return("1"); } return("0"); }
public JsonResult MoveLocation(string BoxNumber, string NewLocation) { try { SysLogWriter.Error(Session["Name"].ToString() + "提交移库" + BoxNumber + ":" + NewLocation); var response = new InventoryManagementService().MoveLocation(long.Parse(Session["CustomerID"].ToString()), Session["WareHouseName"].ToString(), BoxNumber, NewLocation, Session["Name"].ToString()); return(Json(new { Code = response })); } catch (Exception ex) { SysLogWriter.Error("MoveLocation(整箱)" + Session["Name"].ToString() + ex.ToString()); } return(Json(new { Code = 0 })); }
// GET: OrderController/Upload public async System.Threading.Tasks.Task <ActionResult> UploadAsync(IFormFile file) { if (file != null && file.Length > 0) { try { var filePath = Path.GetTempFileName(); var uploadOrder = new InventoryManagementService(); int rowsAffected = 0; FileStream stream = null; using (stream = System.IO.File.Create(filePath)) { await file.CopyToAsync(stream); } rowsAffected = uploadOrder.SaveCsvOrders(stream.Name); if (rowsAffected > 0) { TempData["rowsAffected"] = rowsAffected == 1 ? "1 row was affected" : $"{rowsAffected} rows were affected"; } else { TempData["rowsAffected"] = "0 rows were affected"; } return(RedirectToAction(nameof(Index))); } catch (Exception ex) { var Err = new CreateLogFiles(); Err.ErrorLog(Config.PathToData + "err.log", ex.Message); Console.WriteLine("Fatal error : " + ex.Message + ", please find a complete error at ErrorLog file"); throw; } } else { ViewBag.Message = "Unable to upload file"; var uploadOrder = new InventoryManagementService(); uploadOrder.SaveCsvOrders(Config.PathToSalesFileWeb); return(RedirectToAction(nameof(Index))); } }
public JsonResult CheckBoxNumber(string BoxNumber) { try { SysLogWriter.Error(Session["Name"].ToString() + "开始验证原库位" + BoxNumber); var response = new InventoryManagementService().CheckBoxNumber(long.Parse(Session["CustomerID"].ToString()), Session["WareHouseName"].ToString(), BoxNumber); if (response > 0) { return(Json(new { Code = response })); } else { return(Json(new { Code = 0 })); } } catch (Exception ex) { SysLogWriter.Error("CheckBoxNumber(整箱)" + Session["Name"].ToString() + ex.ToString()); } return(Json(new { Code = 0 })); }
public async Task DeleteAsync() { DbContextOptions <ReFreshDbContext> options = new DbContextOptionsBuilder <ReFreshDbContext>().UseInMemoryDatabase("DeleteProduct").Options; using (ReFreshDbContext context = new ReFreshDbContext(options)) { Product testProduct = new Product(); testProduct.Sku = 1; testProduct.Name = "Test Product"; testProduct.Price = 5; testProduct.Description = "This is a test"; testProduct.Image = "https://image-url.com"; InventoryManagementService ims = new InventoryManagementService(context); await ims.CreateAsync(testProduct); await ims.DeleteAsync(testProduct.ID); await Assert.ThrowsAsync <ArgumentNullException> (() => ims.DeleteAsync(testProduct.ID)); } }
public async Task CreateAsync() { DbContextOptions <ReFreshDbContext> options = new DbContextOptionsBuilder <ReFreshDbContext>().UseInMemoryDatabase("CreateProduct").Options; using (ReFreshDbContext context = new ReFreshDbContext(options)) { Product testProduct = new Product(); testProduct.Sku = 1; testProduct.Name = "Test Product"; testProduct.Price = 5; testProduct.Description = "This is a test"; testProduct.Image = "https://image-url.com"; InventoryManagementService ims = new InventoryManagementService(context); await ims.CreateAsync(testProduct); var result = context.Inventory.FirstOrDefaultAsync(pr => pr.ID == testProduct.ID); Assert.True(testProduct.Sku == result.Result.Sku); } }
public async Task GetAllAsync() { DbContextOptions <ReFreshDbContext> options = new DbContextOptionsBuilder <ReFreshDbContext>().UseInMemoryDatabase("GetAllProduct").Options; using (ReFreshDbContext context = new ReFreshDbContext(options)) { Product testProduct = new Product(); testProduct.Sku = 1; testProduct.Name = "Test Product"; testProduct.Price = 5; testProduct.Description = "This is a test"; testProduct.Image = "https://image-url.com"; InventoryManagementService ims = new InventoryManagementService(context); await ims.CreateAsync(testProduct); List <Product> result = await ims.GetAllAsync() as List <Product>; Assert.True(result.Count == 1); } }
public ActionResult Create(Order order) { var insert = new InventoryManagementService(); if (order.SaleType == "Credit") { if (insert.CreateCreditCardOrder(order)) { return(RedirectToAction(nameof(Index))); } else { ViewBag.Message = "Invalid Credit Card"; return(View()); } } else if (order.SaleType == "Cash") { if (insert.CreateCashOrder(order)) { return(RedirectToAction(nameof(Index))); } else { ViewBag.Message = "Problem Inserting order"; return(View()); } } else { ViewBag.Message = "Invalid type of sale"; return(View()); } }
public ActionResult GetInventory(string SKU) { IEnumerable <Inventorys> checklist = new InventoryManagementService().GetInventoryForRFBySKU(long.Parse(Session["CustomerID"].ToString()), Session["WareHouseName"].ToString(), SKU); return(Json(checklist.ToList(), JsonRequestBehavior.AllowGet)); }
public ActionResult GetCheckList(string CustomerID, string WareHouseName, string WareHouseID) { IEnumerable <WarehouseCheck> checklist = new InventoryManagementService().GetWarehouseCheck(long.Parse(Session["CustomerID"].ToString()), Session["WareHouseName"].ToString()); return(Json(checklist.ToList(), JsonRequestBehavior.AllowGet)); }
// public PatientDTO a; // public DoctorDTO b; // public SecretaryDTO c; public App() { // HCI medicalRoles = new List <string> { "Svi", "Opšte Prakse", "Hirurg", "Dermatolog", "Očni lekar", "Stomatolog" }; roomTypes = new List <string> { "Bolnička Soba", "Operaciona Sala", "Soba za preglede" }; medicalAppointmentTypes = new List <string> { "Pregled", "Operacija", "Ležanje" }; AddressDTO address = new AddressDTO("1", "Bulevar despota Stefan 7A", "Novi Sad", "Srbija", "21000"); director = new DirectorDTO(address, "Dusan", "Urosevic", "1231231231231", "021021", "Male", new DateTime(1990, 5, 5), 123, new TimeInterval(new DateTime(2020, 12, 12), new DateTime(2020, 12, 12)), new TimeInterval(new DateTime(2020, 12, 12), new DateTime(2020, 12, 12)), "[email protected]", "pass", "Klinicki Centar Vojvodina"); SelectedDate = DateTime.Now; // Converters var addressConverter = new AddressConverter(); var patientConverter = new PatientConverter(addressConverter); var medicineConverter = new MedicineConverter(); var questionConverter = new QuestionConverter(patientConverter); var prescriptionConverter = new PrescriptionConverter(patientConverter, medicineConverter); var medicalConsumableConverter = new MedicalConsumableConverter(); var roomConverter = new RoomConverter(); var equipmentConverter = new EquipmentConverter(roomConverter); var guestConverter = new GuestConverter(addressConverter); var hospitalConverter = new HospitalConverter(); var doctorConverter = new DoctorConverter(addressConverter); var medicalAppointmentConverter = new MedicalAppointmentConverter(roomConverter, guestConverter, doctorConverter); var renovationConverter = new RenovationConverter(roomConverter); var feedbackConverter = new FeedbackConverter(); var reviewConverter = new ReviewConverter(doctorConverter); var anamnesisConvertor = new AnamnesisConvertor(); var secretaryConverter = new SecretaryConverter(questionConverter, addressConverter); var inventoryManagementConverter = new InventoryManagementConverter(equipmentConverter, roomConverter); var orderConverter = new OrderConverter(medicalConsumableConverter, medicineConverter, equipmentConverter); var reportConverter = new ReportConverter(); var approvalConverter = new ApprovalConverter(doctorConverter); var propositionConverter = new PropositionConverter(medicineConverter, approvalConverter, doctorConverter); var referralConverter = new ReferralConverter(medicalAppointmentConverter); // Repositories // Many to Many var medicalAppointmentToDoctorRepository = new MedicalAppointmentToDoctorRepository( new CSVStream <MedicalAppointmentToDoctor>( MEDICAL_APPOINTMENT_TO_DOCTOR_FILEPATH, new MedicalAppointmentToDoctorCSVConverter(DELIMITER)), new LongSequencer() ); var inventoryManagementToEquipmentRepository = new InventoryManagementToEquipmentRepository( new CSVStream <InventoryManagementToEquipment>( INVENTORY_EQUIPMENT_FILEPATH, new InventoryManagementToEquipmentCSVConverter(DELIMITER)), new LongSequencer() ); var addressRepository = new AddressRepository(new CSVStream <Address>(ADDRESS_FILEPATH, new AddressCSVConverter(DELIMITER)), new LongSequencer()); var patientRepository = new PatientRepository( new CSVStream <Patient>(PATIENT_FILEPATH, new PatientCSVConverter(DELIMITER, DATETIME_FORMAT)), new CSVStream <Patient>(PATIENT_FILEPATH, new PatientCSVConverter(DELIMITER, DATETIME_FORMAT)), new CSVStream <Doctor>(DOCTOR_FILEPATH, new DoctorCSVConverter(DELIMITER, DATETIME_FORMAT, TIME_FORMAT)), new CSVStream <Secretary>(SECRETARY_FILEPATH, new SecretaryCSVConverter(DELIMITER, DATETIME_FORMAT, TIME_FORMAT)), addressRepository, new LongSequencer()); var doctorRepository = new DoctorRepository( new CSVStream <Doctor>(DOCTOR_FILEPATH, new DoctorCSVConverter(DELIMITER, DATETIME_FORMAT, TIME_FORMAT)), new CSVStream <Patient>(PATIENT_FILEPATH, new PatientCSVConverter(DELIMITER, DATETIME_FORMAT)), new CSVStream <Doctor>(DOCTOR_FILEPATH, new DoctorCSVConverter(DELIMITER, DATETIME_FORMAT, TIME_FORMAT)), new CSVStream <Secretary>(SECRETARY_FILEPATH, new SecretaryCSVConverter(DELIMITER, DATETIME_FORMAT, TIME_FORMAT)), addressRepository, new LongSequencer()); var secretaryRepository = new SecretaryRepository( new CSVStream <Secretary>(SECRETARY_FILEPATH, new SecretaryCSVConverter(DELIMITER, DATETIME_FORMAT, TIME_FORMAT)), new CSVStream <Patient>(PATIENT_FILEPATH, new PatientCSVConverter(DELIMITER, DATETIME_FORMAT)), new CSVStream <Doctor>(DOCTOR_FILEPATH, new DoctorCSVConverter(DELIMITER, DATETIME_FORMAT, TIME_FORMAT)), new CSVStream <Secretary>(SECRETARY_FILEPATH, new SecretaryCSVConverter(DELIMITER, DATETIME_FORMAT, TIME_FORMAT)), addressRepository, new LongSequencer()); var inventoryManagementRepository = new InventoryManagementRepository(new CSVStream <InventoryManagement>(INVENTORY_FILEPATH, new InventoryManagementCSVConverter(DELIMITER, DATETIME_FORMAT)), inventoryManagementToEquipmentRepository, new LongSequencer()); var orderDetailsRepository = new OrderDetailsRepository(new CSVStream <OrderDetails>(ORDER_DETAILS_FILEPATH, new OrderDetailsCSVConverter(DELIMITER)), new LongSequencer()); var questionRepository = new QuestionRepository(new CSVStream <Question>(QUESTION_FILEPATH, new QuestionCSVConverter(DELIMITER, DATETIME_FORMAT)), new LongSequencer()); var medicalConsumableRepository = new MedicalConsumableRepository( new CSVStream <MedicalConsumables>(MEDICAL_CONSUMABLE_FILEPATH, new MedicalConsumableCSVConverter(DELIMITER)), new CSVStream <Equipment>(EQUIPMENT_FILEPATH, new EquipmentCSVConverter(DELIMITER)), new CSVStream <MedicalConsumables>(MEDICAL_CONSUMABLE_FILEPATH, new MedicalConsumableCSVConverter(DELIMITER)), new CSVStream <Medicine>(MEDICINE_FILEPATH, new MedicineCSVConverter(DELIMITER)), new LongSequencer()); var equipmentRepository = new EquipmentRepository( new CSVStream <Equipment>(EQUIPMENT_FILEPATH, new EquipmentCSVConverter(DELIMITER)), new CSVStream <Equipment>(EQUIPMENT_FILEPATH, new EquipmentCSVConverter(DELIMITER)), new CSVStream <MedicalConsumables>(MEDICAL_CONSUMABLE_FILEPATH, new MedicalConsumableCSVConverter(DELIMITER)), new CSVStream <Medicine>(MEDICINE_FILEPATH, new MedicineCSVConverter(DELIMITER)), new LongSequencer()); var medicineRepository = new MedicineRepository( new CSVStream <Medicine>(MEDICINE_FILEPATH, new MedicineCSVConverter(DELIMITER)), new CSVStream <Equipment>(EQUIPMENT_FILEPATH, new EquipmentCSVConverter(DELIMITER)), new CSVStream <MedicalConsumables>(MEDICAL_CONSUMABLE_FILEPATH, new MedicalConsumableCSVConverter(DELIMITER)), new CSVStream <Medicine>(MEDICINE_FILEPATH, new MedicineCSVConverter(DELIMITER)), new LongSequencer()); var prescriptionRepository = new PrescriptionRepository(new CSVStream <Prescription>(PRESCRIPTION_FILEPATH, new PrescriptionCSVConverter(DELIMITER, DATETIME_FORMAT)), medicineRepository, patientRepository, new LongSequencer()); var medicalAppointmentRepository = new MedicalAppointmentRepository( new CSVStream <MedicalAppointment>(MEDICAL_APPOINTMENT_FILEPATH, new MedicalAppointmentCSVConverter(DELIMITER, DATETIME_DETAIL_FORMAT)), medicalAppointmentToDoctorRepository, patientRepository, doctorRepository, new LongSequencer()); var roomRepository = new RoomRepository(new CSVStream <Room>(ROOM_FILEPATH, new RoomCSVConverter(DELIMITER)), new LongSequencer(), equipmentRepository); var orderRepository = new OrderRepository(new CSVStream <Order>(ORDER_FILEPATH, new OrderCSVConverter(DELIMITER, DATETIME_FORMAT)), medicineRepository, equipmentRepository, medicalConsumableRepository, orderDetailsRepository, new LongSequencer()); var renovationRepository = new RenovationRepository(new CSVStream <Renovation>(RENOVATION_FILEPATH, new RenovationCSVConverter(DELIMITER, DATETIME_FORMAT)), new LongSequencer()); var feedbackRepository = new FeedbackRepository(new CSVStream <Feedback>(FEEDBACK_FILEPATH, new FeedbackCSVConverter(DELIMITER)), new LongSequencer()); var reviewRepository = new ReviewRepository(new CSVStream <Review>(REVIEW_FILEPATH, new ReviewCSVConverter(DELIMITER)), new LongSequencer()); var anamnesisRepository = new AnamnesisRepository(new CSVStream <Anamnesis>(ANAMNESIS_FILEPATH, new AnamnesisCSVConverter(DELIMITER)), new LongSequencer()); var propositionRepository = new PropositionRepository(new CSVStream <Proposition>(PROPOSITION_FILEPATH, new PropositionCSVConverter(DELIMITER, DATETIME_FORMAT)), new LongSequencer(), medicineRepository); // Referral var admitionReferralRepository = new AdmitionReferralRepository( new CSVStream <Referral>(ADMITION_REFERRAL_FILEPATH, new ReferralCSVConventer(DELIMITER, DATETIME_FORMAT)), new LongSequencer() ); var operationReferralRepository = new OperationReferralRepository( new CSVStream <Referral>(OPERATION_REFERRAL_FILEPATH, new ReferralCSVConventer(DELIMITER, DATETIME_FORMAT)), new LongSequencer()); var examReferralRepository = new ExamReferralRepository( new CSVStream <Referral>(EXAM_REFERRAL_FILEPATH, new ReferralCSVConventer(DELIMITER, DATETIME_FORMAT)), new LongSequencer()); var approvalRepository = new ApprovalRepository(new CSVStream <Approval>(APPROVAL_FILEPATH, new ApprovalCSVConverter(DELIMITER)), new LongSequencer()); // Services var patientService = new PatientService(patientRepository); var questionService = new QuestionService(questionRepository); var addressService = new AddressService(addressRepository); var medicineService = new MedicineService(medicineRepository); var medicalConsumableService = new MedicalConsumableService(medicalConsumableRepository); var prescriptionService = new PrescriptionService(prescriptionRepository, medicineService, patientService); var reportService = new ReportService(); var guestService = new GuestService(patientRepository); var equipmentService = new EquipmentService(equipmentRepository); var doctorService = new DoctorService(doctorRepository); var medicalAppointmentService = new MedicalAppointmentService(medicalAppointmentRepository, doctorService); var roomService = new RoomService(roomRepository); var renovationService = new RenovationService(renovationRepository, roomRepository); var feedbackService = new FeedbackService(feedbackRepository); var reviewService = new ReviewService(reviewRepository); var employeeService = new EmployeeService(secretaryRepository, doctorRepository); var authenticationService = new AuthenticationService(employeeService, patientService); var secretaryService = new SecretaryService(secretaryRepository); var inventoryManagementService = new InventoryManagementService(inventoryManagementRepository); var orderService = new OrderService(orderRepository); var anamnesisService = new AnamnesisService(anamnesisRepository); var propositionService = new PropositionService(propositionRepository); var approvalService = new ApprovalService(approvalRepository); // Controllers PatientController = new PatientController(patientService, patientConverter, guestConverter); GuestController = new GuestController(guestService, guestConverter); AddressController = new AddressController(addressService, addressConverter); MedicineController = new MedicineController(medicineService, medicineConverter); QuestionController = new QuestionController(questionService, questionConverter, patientConverter); MedicalConsumableController = new MedicalConsumableController(medicalConsumableService, medicalConsumableConverter); AuthenticationController = new AuthenticationController(); ReportController = new ReportController(reportConverter); PrescriptionController = new PrescriptionController(prescriptionService, prescriptionConverter); EquipmentController = new EquipmentController(equipmentService, equipmentConverter); MedicalAppointmentController = new MedicalAppointmentController( medicalAppointmentService, medicalAppointmentConverter, doctorConverter, roomConverter ); RoomController = new RoomController(roomService, roomConverter); RenovationController = new RenovationController(renovationService, renovationConverter); FeedbackController = new FeedbackController(feedbackService, feedbackConverter); ReviewController = new ReviewController(reviewService, reviewConverter); SecretaryController = new SecretaryController(secretaryService, secretaryConverter); InventoryManagementController = new InventoryManagementController(inventoryManagementService, inventoryManagementConverter); OrderController = new OrderController(orderService, orderConverter); DoctorController = new DoctorController(doctorService, doctorConverter); AnamnesisController = new AnamnesisController(anamnesisService, anamnesisConvertor); PropositionController = new PropositionController(propositionService, propositionConverter); // Generators SecretaryAppointmentReportGenerator = new SecretaryAppointmentReportGenerator(REPORT_APPOINTMENT_FILEPATH); PatientAppointmentReportGenerator = new PatientAppointmentReportGenerator(REPORT_APPOINTMENT_FILEPATH); PrescriptionReportGenerator = new PrescriptionReportGenerator(REPORT_PRESCRIPTION_FILEPATH); DoctorsAppointmentReport = new DirectorReportGenerator(REPORT_DOCTOR_APPOINTMENTS_FILEPATH, doctorRepository, medicalAppointmentRepository); MedicineReportGenerator = new MedicineReportGenerator(REPORT_MEDICINE_FILEPATH, medicineRepository); Synchronise(RenovationController); }