public void TestGetSolutionType() { // Dictionary<string, List<string>> TestDssict1 = new Dictionary<string, List<string>>(); List <string> ClinicalDecisionSupport = new List <string>() { "CDS Online Electronic help" }; List <string> EWES = new List <string>() { "IGS" }; List <string> CSA = new List <string>() { "ISAR", "ISEM", "IVIC-Xi" }; using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity1 = entities.Solutions.Where(e => e.Category.ToLower() == "clinical decision support").Select(Column => Column.Name).ToList(); Assert.AreEqual(ClinicalDecisionSupport[0].Trim(), entity1[0].Trim()); var entity2 = entities.Solutions.Where(e => e.Category.ToLower() == "ewes").Select(Column => Column.Name).ToList(); Assert.AreEqual(EWES[0].Trim(), entity2[0].Trim()); var entity3 = entities.Solutions.Where(e => e.Category.ToLower() == "csa").Select(Column => Column.Name).ToList(); for (int i = 0; i < CSA.Count; i++) { Assert.AreEqual(CSA[i].Trim(), entity3[i].Trim()); } } }
List <string> IGetMonitorOnPortability.GetMonitorOnPortability(string portability) { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { return(entities.Monitors.Where(e => e.Spec1.ToLower() == portability.ToLower()).Select(Column => Column.ModelNo).ToList()); } }
[HttpPut]// Update a model and specs public HttpResponseMessage Put(string sol, [FromBody] Solution product) { try { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity = entities.Solutions.FirstOrDefault(e => e.Name == sol); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Device with ID" + sol.ToString() + "Is not found")); } else { entity.Name = product.Name; entity.Category = product.Category; entity.Spec1 = product.Spec1; entity.Spec3 = product.Spec3; entity.url = product.url; entity.Description = product.Description; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public void TestQuestionController() { //string MonitorCategoryChoice = "Choose the Category of monitor that you want to view?"; string CategorySpecificationChoice = "Do you want monitor based on category or specification?"; string MonitorCategoryChoice = "Choose the category you want to view??"; string MonitorSolutionChoice = "Do you want information about patient monitors or solutions?"; string MonitorSpec1 = "Choose the first specification you want?"; string MonitorSpec2 = "Choose the second Specification you want?"; string MonitorSpecsCategory = "Choose the monitor model you ae interested in?"; string ProductChoice = "Choose the specification you are interested in?"; using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity1 = entities.Questions.Where(e => e.QuestionName == "CategorySpecificationChoice").Select(Columns => Columns.Questions).ToList(); Assert.AreEqual(entity1[0].Trim(), CategorySpecificationChoice.Trim()); var entity2 = entities.Questions.Where(e => e.QuestionName == "MonitorSolutionChoice").Select(Columns => Columns.Questions).ToList(); Assert.AreEqual(entity2[0], MonitorSolutionChoice.Trim()); var entity3 = entities.Questions.Where(e => e.QuestionName == "MonitorSpec1").Select(Columns => Columns.Questions).ToList(); Assert.AreEqual(entity3[0], MonitorSpec1.Trim()); var entity4 = entities.Questions.Where(e => e.QuestionName == "MonitorSpec2").Select(Columns => Columns.Questions).ToList(); Assert.AreEqual(entity4[0], MonitorSpec2.Trim()); var entity5 = entities.Questions.Where(e => e.QuestionName == "MonitorSpecsCategory").Select(Columns => Columns.Questions).ToList(); Assert.AreEqual(entity5[0], MonitorSpecsCategory.Trim()); var entity6 = entities.Questions.Where(e => e.QuestionName == "ProductChoice").Select(Columns => Columns.Questions).ToList(); Assert.AreEqual(entity6[0], ProductChoice.Trim()); var entity7 = entities.Questions.Where(e => e.QuestionName == "MonitorCategoryChoice").Select(Columns => Columns.Questions).ToList(); Assert.AreEqual(entity7[0], MonitorCategoryChoice.Trim()); } }
public List <string> GetProductQuestion(string questionname) { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { return(entities.Questions.Where(e => e.QuestionName.ToLower() == questionname.ToLower()).Select(Column => Column.Questions).ToList()); } }
List <string> IGetMonitorOnSize.GetMonitorOnSize(string size) { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { return(entities.Monitors.Where(e => e.Spec2.ToLower() == size.ToLower()).Select(Column => Column.ModelNo).ToList()); } }
public void TestGetSeries() { // Dictionary<string, List<string>> TestDssict1 = new Dictionary<string, List<string>>(); List <string> TestList1 = new List <string>() { "MX400 ", "MX450 ", "MX500 ", "MX550 ", "MX700 ", "MX800 ", "MP2 ", "MP5 " }; List <string> TestList2 = new List <string>() { "C L", "FM20", "FM30", "FM40", "FM50" }; List <string> TestList3 = new List <string>() { "CM Series", "CMS200" }; List <string> TestList4 = new List <string>() { "VM1", "VM4", "VM6", "VM8", "VSI", "VS2+" }; using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity1 = entities.Monitors.Where(e => e.SeriesName.ToLower() == "intellivue").Select(Column => Column.ModelNo).ToList <string>(); Assert.AreEqual(TestList1[0].Trim(), entity1[0].Trim()); var entity2 = entities.Monitors.Where(e => e.SeriesName.ToLower() == "avalon").Select(Column => Column.ModelNo).ToList <string>(); Assert.AreEqual(TestList2[0].Trim(), entity2[0].Trim()); var entity3 = entities.Monitors.Where(e => e.SeriesName.ToLower() == "efficia").Select(Column => Column.ModelNo).ToList <string>(); Assert.AreEqual(TestList3[1].Trim(), entity3[1].Trim()); } }
List <string> IGetAllCategories.GetAllCategories() { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { return(entities.Monitors.Select(Column => Column.Category).Distinct().ToList()); } }
public void Delete(string sol) { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { entities.Solutions.Remove(entities.Solutions.FirstOrDefault(e => e.Name == sol)); entities.SaveChanges(); } }
[HttpPost]//Adding solution public void Post([FromBody] Solution product) { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { entities.Solutions.Add(product); entities.SaveChanges(); } }
bool IDeleteCustomer.DeleteCustomer(int id) { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity = entities.Registrations.Remove(entities.Registrations.FirstOrDefault(e => e.Id == id)); entities.SaveChanges(); return(true); } }
Registration IAddCustomer.AddCustomer(Registration customer) { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity = entities.Registrations.Add(customer); entities.SaveChanges(); return(entity); } }
bool IDeleteMonitor.DeleteMonitor(string mod) { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity = entities.Monitors.Remove(entities.Monitors.FirstOrDefault(e => e.ModelNo == mod)); entities.SaveChanges(); return(true); } }
Monitor IAddMonitor.AddMonitor(Monitor model) { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity = entities.Monitors.Add(model); entities.SaveChanges(); return(entity); } }
//Get all distinct type of a solutions public HttpResponseMessage GetAllSolutionTypes() { try { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { return(Request.CreateResponse(HttpStatusCode.OK, entities.Solutions.Select(Column => Column.Category).Distinct().ToList())); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public List <string> GetPortabilitySize(string portability, string size) { //string p = portability, s = size; if (portability.ToLower() != "portable") { portability = size; size = portability; } using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { return(entities.Monitors.Where(e => e.Spec2.ToLower() == size.ToLower()) .Where(e => e.Spec1.ToLower() == portability.ToLower()).Select(Column => Column.ModelNo).ToList()); } }
public void TestGetMoniorCategory() { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity = entities.Monitors.Select(Column => Column.Category).Distinct().ToList(); List <string> TestList1 = new List <string>() { "bedside monitor", "high end monitors", "maternity and fetal monitor", "vital signs monitor" }; for (int i = 0; i < TestList1.Count; i++) { Assert.AreEqual(TestList1[i].Trim(), entity[i].Trim()); } } }
Monitor IUpdateMonitor.UpdateMonitor(string mod, Monitor model) { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity = entities.Monitors.FirstOrDefault(e => e.ModelNo == mod); entity.SeriesName = model.SeriesName; entity.ModelNo = model.ModelNo; entity.Spec1 = model.Spec1; entity.Spec2 = model.Spec2; entity.Spec3 = model.Spec3; entity.url = model.url; entities.SaveChanges(); return(entity); } }
public HttpResponseMessage GetMonitorSize(string size = "All") { _getmonitoronsize = _con.Resolve <GetMonitorOnSizeContractsLib.IGetMonitorOnSize>(); try { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { return(Request.CreateResponse(HttpStatusCode.OK, _getmonitoronsize.GetMonitorOnSize(size))); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage GetPortableMonitor(string portability = "all") { _getmonitoronportability = _con.Resolve <GetMonitorOnPortabilityContractsLib.IGetMonitorOnPortability>(); try { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { return(Request.CreateResponse(HttpStatusCode.OK, _getmonitoronportability.GetMonitorOnPortability(portability))); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public void TestGetPortableMonitor() { List <string> TestList1 = new List <string>() { "MX400", "MX450", "MX500", "MX550", "MP2", "MP5", "VM1", "VM4", "VM6", "VM8", "VSI", "C L", "FM20", "FM30", "FM40", "FM50" }; using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity = entities.Monitors.Where(e => e.Spec1.ToLower() == "portable").Select(Column => Column.ModelNo).ToList <string>(); for (int i = 0; i < TestList1.Capacity; i++) { Assert.AreEqual(TestList1[i].Trim(), entity[i].Trim()); } } }
public void TestGetMonitorOnSize() { List <string> TestList1 = new List <string>() { "MX700", "MX800", "VS2+", "CM Series", "CMS200" }; using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity = entities.Monitors.Where(e => e.Spec1.ToLower() == "non-portable").Select(Column => Column.ModelNo).ToList <string>(); for (int i = 0; i < TestList1.Count; i++) { Assert.AreEqual(TestList1[i].Trim(), entity[i].Trim()); } } }
Registration IUpdateMonitor.UpdateCustomer(int id, Registration customer) { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity = entities.Registrations.FirstOrDefault(e => e.Id == id); entity.Name = customer.Name; entity.City = customer.City; entity.Contact = customer.Contact; entity.Mail = customer.Mail; entity.Model = customer.Model; entities.SaveChanges(); return(entity); } }
public void TestGetAllSolutions() { // Dictionary<string, List<string>> TestDssict1 = new Dictionary<string, List<string>>(); List <string> Solutions = new List <string>() { "Clinical Decision Support", "EWES", "CSA" }; using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity = entities.Solutions.Select(Column => Column.Category).ToList(); for (int i = 0; i < Solutions.Count; i++) { Assert.AreEqual(Solutions[i].Trim(), entity[i].Trim()); } } }
//Get all solutions under a type public HttpResponseMessage GetSolutionType(string category = "all") { try { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { return(Request.CreateResponse(HttpStatusCode.OK, entities.Solutions.Where(e => e.Category .ToLower() == category.ToLower()).Select(Column => Column.Name).ToList())); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
//Get all details of a particular solution public HttpResponseMessage GetSolution(string name = "all") { try { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { return(Request.CreateResponse(HttpStatusCode.OK, entities.Solutions.Where(e => e.Name .ToLower() == name.ToLower()).ToList())); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage GetQuestions(string question = "all") { _getproductquestion = _con.Resolve <ProductQuestionContractsLib.IProductQuestions>(); try { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { return(Request.CreateResponse(HttpStatusCode.OK, _getproductquestion.GetProductQuestion(question))); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
List <Monitor> IGetModel.GetModel(string model) { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { return(entities.Monitors.Where(e => e.ModelNo.ToLower() == model.ToLower()).ToList()); } }
public void TestGetMonitorOnSizeAndPortablity() { List <string> TestList1 = new List <string>() { "MP2", "C L" }; List <string> TestList2 = new List <string>() { "MP5", "VSI" }; List <string> TestList3 = new List <string>() { "MX400", "VM1", "VM4" }; List <string> TestList4 = new List <string>() { "MX450", "MX500", "VM6", "VM8", "FM20", "FM30" }; List <string> TestList5 = new List <string>() { "MX550", "FM40", "FM50" }; List <string> TestList6 = new List <string>() { "MX700", "MX800", "CM Series" }; using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { var entity1 = entities.Monitors.Where(e => e.Spec2.ToLower() == "4.5' touch screen").Where(e => e.Spec1.ToLower() == "portable").Select(Column => Column.ModelNo).ToList();; for (int i = 0; i < TestList1.Count; i++) { Assert.AreEqual(TestList1[i].Trim(), entity1[i].Trim()); } var entity2 = entities.Monitors.Where(e => e.Spec2.ToLower() == "5.5' touch screen").Where(e => e.Spec1.ToLower() == "portable").Select(Column => Column.ModelNo).ToList();; for (int i = 0; i < TestList2.Count; i++) { Assert.AreEqual(TestList2[i].Trim(), entity2[i].Trim()); } var entity3 = entities.Monitors.Where(e => e.Spec2.ToLower() == "9' touch screen").Where(e => e.Spec1.ToLower() == "portable").Select(Column => Column.ModelNo).ToList();; for (int i = 0; i < TestList3.Count; i++) { Assert.AreEqual(TestList3[i].Trim(), entity3[i].Trim()); } var entity4 = entities.Monitors.Where(e => e.Spec2.ToLower() == "12' touch screen").Where(e => e.Spec1.ToLower() == "portable").Select(Column => Column.ModelNo).ToList();; for (int i = 0; i < TestList4.Count; i++) { Assert.AreEqual(TestList4[i].Trim(), entity4[i].Trim()); } var entity5 = entities.Monitors.Where(e => e.Spec2.ToLower() == "15' touch screen").Where(e => e.Spec1.ToLower() == "portable").Select(Column => Column.ModelNo).ToList();; for (int i = 0; i < TestList5.Count; i++) { Assert.AreEqual(TestList5[i].Trim(), entity5[i].Trim()); } var entity6 = entities.Monitors.Where(e => e.Spec2.ToLower() == "15' touch screen").Where(e => e.Spec1.ToLower() == "non-portable").Select(Column => Column.ModelNo).ToList();; for (int i = 0; i < TestList6.Count; i++) { Assert.AreEqual(TestList6[i].Trim(), entity6[i].Trim()); } } }
List <string> IGetSeries.GetSeriesType(string name) { using (ChatBotDBEntities1 entities = new ChatBotDBEntities1()) { return(entities.Monitors.Where(e => e.SeriesName.ToLower() == name.ToLower()).Select(Column => Column.ModelNo).ToList()); } }