public ActionResult ProductUpdate(MedicineModel medicine) { int result = 0; PractitionerProcess process = new PractitionerProcess(); result = process.UpdateProduct(medicine); if (result == 0) { PractitionerBaseViewModel viewModel = new PractitionerBaseViewModel(); viewModel.AccId = medicine.PractitionerId; viewModel.MedicineModel = medicine; return(View(viewModel)); } else { return(Content(@"<body> <script type='text/javascript'> if(confirm('Product update is updated successfully. Press Ok to close this tab.')){ window.close();window.opener.location.reload(); }; </script> </body> ")); } }
// GET: Home/Delete/5 public ActionResult Delete(int id) { MedicineModel model = new MedicineModel(); model.delete(id); return(RedirectToAction("Catalog")); }
// GET: Home/Details/5 public ActionResult Details(int id) { MedicineModel model = new MedicineModel(); List <string> ListChart = model.GetMedicineChart(id); return(View(ListChart)); }
// GET: Medicines public ActionResult Index() { MedicineModel medicineModel = new MedicineModel(); var medicines = medicineModel.getMedicineVms(); return(View(medicines)); }
private void BtnSaveAll_Click(object sender, EventArgs e) { try { for (int i = 0; i < dgvMedicine.RowCount - 1; i++) { var model = new MedicineModel { MedicineName = Convert.ToString(dgvMedicine.Rows[i].Cells[0].Value), Price = Convert.ToDecimal(dgvMedicine.Rows[i].Cells[1].Value), Qty = Convert.ToInt32(dgvMedicine.Rows[i].Cells[2].Value) }; medicineService.AddMedicine(model); MessageBox.Show("Data has saved successfully!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearFields(); LoadMedicine(); } } catch (Exception) { } }
public ActionResult Edit(FormCollection collection) { var doctor = (Doctor)TempData["doctor"]; var patient = (Patient)TempData["patient"]; var medicines = (List <MedicineTimes>)TempData["medicines"]; var prescription = (Prescription)TempData["prescription"]; string MedicineName = collection.Get("name"); DateTime start = new DateTime(); DateTime end = new DateTime(); if (!DateTime.TryParse(collection.Get("start"), out start) && !DateTime.TryParse(collection.Get("end"), out end) || MedicineName == "" && Request.Form["Add"] == null) { TempData["prescription"] = prescription; TempData["medicines"] = medicines; return(RedirectToAction("Check", "Interactions")); } var MedicinesNames = (SelectList)TempData["MedicineNames"]; MedicineModel medicineModel = new MedicineModel(); PrescriptionModel prescriptionModel = new PrescriptionModel(); MedicineTimes medicine = new MedicineTimes(medicineModel.GetMedicine(MedicineName), start, end); //PrescriptionMedicine rm = new PrescriptionMedicine(patient.TZ,MedicineNames, start, end); prescriptionModel.AddMedicine(medicines, medicine); PrescriptionViewModel viewModel = new PrescriptionViewModel(patient, doctor, medicines); ViewBag.MedicineNames = MedicinesNames; TempData["viewModel"] = viewModel; return(RedirectToAction("Edit")); }
private void GetTotalBill() { try { foreach (DataRow tableData in dataTable.Rows) { var id = Convert.ToInt32(tableData["Id"]); var qty = Convert.ToInt32(tableData["Qty"]); var data = service.GetQty(id); var updatedQty = Convert.ToInt32(data.Qty) - Convert.ToInt32(qty); var model = new MedicineModel { Id = id, MedicineName = Convert.ToString(tableData["Medicine Name"]), Price = Convert.ToDecimal(tableData["Price"]), Qty = updatedQty, }; service.UpdateQty(model); } } catch (Exception) { } }
public List <MedicineModel> ProductSearch(MedicineViewModel search) { List <MedicineModel> result = new List <MedicineModel>(); try { SqlConnection conn = new SqlConnection(ConstantHelper.DBAppSettings.FYP); conn.Open(); SqlCommand cmd = new SqlCommand(ConstantHelper.StoredProcedure.ProductSearch, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter(ConstantHelper.StoredProcedure.Parameter.SearchText, search.SearchText)); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { MedicineModel medicine = new MedicineModel(); medicine.ProductCode = reader[ConstantHelper.SQLColumn.ProductSearch.ProductCode].ToString(); medicine.ProductName = reader[ConstantHelper.SQLColumn.ProductSearch.ProductName].ToString(); medicine.TotalAmount = Convert.ToInt32(reader[ConstantHelper.SQLColumn.ProductSearch.TotalAmount].ToString()); medicine.CompanyId = Guid.Parse(reader[ConstantHelper.SQLColumn.ProductSearch.CompanyId].ToString()); medicine.CompanyName = reader[ConstantHelper.SQLColumn.ProductSearch.CompanyName].ToString(); medicine.CompanyPostalCode = reader[ConstantHelper.SQLColumn.ProductSearch.PostalCode].ToString(); medicine.CompanyState = reader[ConstantHelper.SQLColumn.ProductSearch.State].ToString(); result.Add(medicine); } } catch (Exception err) { new LogHelper().LogMessage("PatientData.ProductSearch : " + err); } return(result); }
public async Task <IActionResult> AddMedicine(MedicineViewModel model) { if (model.ExpiryDate.Date <= DateTime.Now.Date) { return(_baseRepo.CustomResponce(statusCode: StatusCodes.Status400BadRequest, success: false, message: "ExpiryDate should be greater than today's date", data: "")); } MedicineModel medicine = new MedicineModel() { Id = _generateID.GeneratID(), Brand = model.Brand, ExpiryDate = model.ExpiryDate, Notes = model.Notes, Price = model.Price, Quantity = model.Quantity }; bool isAdded = await _repo.AddMedicine(model : medicine); if (isAdded) { return(_baseRepo.CustomResponce(statusCode: StatusCodes.Status200OK, success: true, message: SuccessContants.RecordAddedSuccessfully, data: "")); } else { return(_baseRepo.CustomResponce(statusCode: StatusCodes.Status200OK, success: false, message: ErrorContants.Techincalproblempleasetryagain, data: "")); } }
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
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 ActionResult MedicineAdd(MedicineModel obj) { try { // TODO: Add insert logic here DB3Entities2 entity = new DB3Entities2(); var medicine = new Medicine(); medicine.Medicine_Name = obj.name; medicine.Mfg_Date = obj.mfg_date; medicine.Exp_Date = obj.exp_date; medicine.Type = obj.type; medicine.Batch = obj.batch; medicine.Price = obj.price; var c = entity.Companies.Where(x => x.C_Name == obj.company_Name).First(); medicine.CompanyID = c.Company_id; entity.Medicines.Add(medicine); entity.SaveChanges(); return(RedirectToAction("MedicineList")); } catch { return(View()); } }
public ActionResult Createproduct(MedicineModel newMedicine) { if (newMedicine != null) { PractitionerProcess process = new PractitionerProcess(); int result = 0; result = process.CreateProduct(newMedicine); if (result != 0) { return(Content(@"<body> <script type='text/javascript'> if(confirm('Product has been created successfully. Press Ok to close this tab.')){ window.close();window.opener.location.reload(); }; </script> </body> ")); } else { return(Content(@"<body> <script type='text/javascript'> if(confirm('Product creation error. Press Ok to go back the view.')){ window.history.back(); }; </script> </body> ")); } } else { return(View()); } }
public ActionResult CreateProduct(PractitionerBaseViewModel viewModel) { MedicineModel model = new MedicineModel(); model.PractitionerId = viewModel.AccId; return(View(model)); }
internal static List <MedicineModel> GetMedicineList(int accountId) { List <MedicineModel> modelList = new List <MedicineModel>(); using (DBConnector connector = new DBConnector("get_MedicineList", CommandType.StoredProcedure)) { connector.Cmd.Parameters.AddWithValue("@AccountID", accountId); connector.Execute(DBOperation.GetWhileReader); if (connector.Rdr.HasRows) { while (connector.Rdr.Read()) { MedicineModel model = new MedicineModel(); model.MedicineID = Convert.ToInt32(connector.Rdr["IDMedicine"]); model.Name = connector.Rdr["Name"].ToString(); model.Description = connector.Rdr["Description"].ToString(); model.MedImg = connector.Rdr["MedImg"].ToString(); model.MedColor = connector.Rdr["MedColor"].ToString(); model.MedType = connector.Rdr["MedType"].ToString(); model.Quantity = Convert.ToDecimal(connector.Rdr["Quantity"]); modelList.Add(model); } } } return(modelList); }
public IActionResult Edit(MedicineModel model) { Medicine medicineModel = new Medicine { Id = model.MedicineId, Name = model.Name, SKU = model.SKU, ProductGUID = model.ProductGUID, Price = model.Price, Manufacturer = model.Manufacturer, ManufacturingDate = model.ManufacturingDate, Description = model.Description, //Image = model.Image, ExpiryDate = model.ExpiryDate, IsActive = model.IsActive, IsDeleted = false }; var medicineModels = _medicineService.UpdateMedicine(medicineModel); if (medicineModels == null) { // Failed ViewBag.AddCategoryStatus = "Failed"; return(RedirectToAction("Edit")); } else { // Success ViewBag.AddUserStatus = "Success"; return(RedirectToAction("List")); } }
public ActionResult Add() { var model = new MedicineModel(); model.LoadAllListData(); return(View(model)); }
public IActionResult List(int?page) { //get all medicine data. var medicineData = _medicineService.GetAllMedicines(); var medicineList = new List <MedicineModel>(); foreach (var item in medicineData) { var model = new MedicineModel(); model.MedicineId = item.Id; model.Name = item.Name; model.SKU = item.SKU; model.PictureStr = item.PictureStr; model.ProductGUID = item.ProductGUID; model.Price = item.Price; model.Manufacturer = item.Manufacturer; model.ExpiryDate = item.ExpiryDate; model.IsActive = item.IsActive; model.IsDeleted = false; medicineList.Add(model); } var pageNumber = page ?? 1; var pageSize = 3; return(View(medicineList.ToPagedList(pageNumber, pageSize))); }
// GET: Patient/Edit/5 public ActionResult Create(FormCollection collection) { string MedicineName = collection.Get("name"); var patient = (Patient)TempData["patient"]; var doctor = (Doctor)TempData["doctor"]; DateTime start = DateTime.Parse(collection.Get("start")); DateTime end = DateTime.Parse(collection.Get("end")); var prescription = (Prescription)TempData["prescription"]; var MedicinesNames = (SelectList)TempData["MedicineNames"]; MedicineModel medicineModel = new MedicineModel(); PrescriptionModel prescriptionModel = new PrescriptionModel(); MedicineTimes medicine = new MedicineTimes(medicineModel.GetMedicine(MedicineName), start, end); List <MedicineTimes> medicines = new List <MedicineTimes>(); prescriptionModel.AddMedicine(medicines, medicine); PrescriptionViewModel viewModel = new PrescriptionViewModel(patient, doctor, medicines); ViewBag.MedicineNames = MedicinesNames; TempData["viewModel"] = viewModel; TempData["prescription"] = prescription; TempData["doctor"] = doctor; TempData["medicines"] = medicines; return(RedirectToAction("Edit")); }
public IActionResult Edit(int id) { var medicineModel = _medicineService.GetMedicineById(id); var categories = _categoryService.GetAllCategories() /*.ToList()*/; SelectList list = new SelectList(categories, "Id", "Name"); ViewBag.categories = list; MedicineModel model = new MedicineModel { MedicineId = medicineModel.Id, Name = medicineModel.Name, SKU = medicineModel.SKU, ProductGUID = medicineModel.ProductGUID, Price = medicineModel.Price, Manufacturer = medicineModel.Manufacturer, ManufacturingDate = medicineModel.ManufacturingDate, Description = medicineModel.Description, ExpiryDate = medicineModel.ExpiryDate, IsActive = medicineModel.IsActive, IsDeleted = false, Stock = medicineModel.Stock, CategoryName = medicineModel.CategoryName, }; return(View(model)); }
public void updateMedicines(MedicineModel medicine) { List <MedicineModel> medicineList = new List <MedicineModel>(); try { var filePath = Path.Combine(_hostingEnvironment.ContentRootPath, $"wwwroot\\{"JsonFiles\\medicines.json"}"); var json = File.ReadAllText(filePath); medicineList = JsonConvert.DeserializeObject <List <MedicineModel> >(json); medicineList.ForEach((x) => { if (x.id == medicine.id) { x.fullName = medicine.fullName; x.price = medicine.price; x.quantity = medicine.quantity; x.expiryDate = medicine.expiryDate; x.brand = medicine.brand; } ; }); string output = JsonConvert.SerializeObject(medicineList, Newtonsoft.Json.Formatting.Indented); File.WriteAllText(filePath, output); } catch (Exception ex) { throw ex; } }
public ActionResult SearchMedicine(string searchString) { // Get particular user data var medicineByName = _medicineService.GetMedicineByName(searchString); var medicineNameList = new List <MedicineModel>(); foreach (var item in medicineByName) { var lst = new MedicineModel(); lst.MedicineId = item.Id; lst.Name = item.Name; lst.SKU = item.SKU; lst.ProductGUID = item.ProductGUID; lst.Manufacturer = item.Manufacturer; lst.ManufacturingDate = item.ManufacturingDate; lst.ExpiryDate = item.ExpiryDate; medicineNameList.Add(lst); } if (medicineNameList == null) { return(View("List", medicineNameList)); } else { return(View("List", medicineNameList)); } }
public void AddNewMedicine() { SelectedMedicine = new MedicineModel() { CreatedDate = DateTime.Today }; }
// GET: MedicinesList public ActionResult Index() { MedicineModel Model = new MedicineModel(); MedicineViewModel viewModel = new MedicineViewModel(Model.GetList()); return(View(viewModel.GetList())); }
public ActionResult Edit(int id) { MedicineModel model = new MedicineModel(); var Medicine = model.GetMedicines().First(m => m.Id == id); return(View(Medicine)); }
public async Task <ActionResult> Add(MedicineModel model) { try { if (ModelState.IsValid) { Medicine med = new Medicine(); med.CategoryId = model.Category; med.Name = model.Name; med.Dosage = model.Dosage; await _context.Medicines.AddAsync(med); await _context.SaveChangesAsync(); } else { TempData["message"] = ModelState.ErrorGathering(); } return(RedirectToAction(nameof(Index))); } catch (Exception ex) { TempData["message"] = ex.Message; return(RedirectToAction(nameof(Index))); } }
public ActionResult Catalog() { MedicineModel model = new MedicineModel(); var Medicines = model.GetMedicines(); return(View(Medicines)); }
public async Task <ActionResult> Edit(MedicineModel model) { try { if (!ModelState.IsValid) { TempData["message"] = ModelState.ErrorGathering(); } var med = await _context.Medicines.FirstOrDefaultAsync(x => x.Id.Equals(model.Id)); if (med != null) { med.Name = model.Name; med.Dosage = model.Dosage; _context.Medicines.Update(med); await _context.SaveChangesAsync(); } else { TempData["message"] = "Medicine not found."; } return(RedirectToAction(nameof(Index))); } catch (Exception ex) { TempData["message"] = ex.Message; return(View()); } }
public ActionResult Prescription_(FormCollection collection) { var ID = TempData["ID"]; var first = TempData["first"]; var last = TempData["last"]; //var ID = collection["PatientId"]; if (DateTime.Parse(collection["BeginDate"]) > DateTime.Parse(collection["FinishDate"])) { ViewBag.errorDate = "Begin date should be before the finish date"; TempData["ID"] = ID; ViewBag.id = ID; TempData["first"] = first; ViewBag.first = first; TempData["last"] = last; ViewBag.last = last; MedicineModel model = new MedicineModel(); return(View(model.GetMedicines())); } var medicines = new MedicineModel(); return(RedirectToAction("AreYouSure", new Prescription { Id = int.Parse(ID.ToString()), DoctorFirstName = RouteConfig.user.FirstName, DoctorLastName = RouteConfig.user.LastName, Medicine = collection["Medicine"], BeginTime = DateTime.Parse(collection["BeginDate"]), FinishTime = DateTime.Parse(collection["FinishDate"]), Frequency = collection["Frequency"], Comments = collection["Comments"], Ndc = medicines.GetMedicines().Where(x => x.CommercialName == collection["Medicine"].ToString()).FirstOrDefault().NDC //get current prescription ndc })); }
/// <summary> /// 更新体检中 中医体质辨识得分Key /// </summary> /// <param name="customerID"></param> /// <param name="ID"></param> /// <param name="model"></param> /// <returns></returns> public bool UpdateMediphysDist(string customerID, int ID, MedicineModel model) { StringBuilder builder = new StringBuilder(); builder.Append("UPDATE ARCHIVE_MEDI_PHYS_DIST D SET "); builder.Append("MedicineResultID=@MedicineResultID, "); builder.Append("Mild=@Mild,Faint=@Faint,"); builder.Append("Yang=@Yang,Yin=@Yin,"); builder.Append("PhlegmDamp=@PhlegmDamp,Muggy=@Muggy,"); builder.Append("BloodStasis=@BloodStasis,QiConstraint=@QiConstraint,"); builder.Append("Characteristic=@Characteristic "); builder.Append("WHERE OutKey=@OutKey"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@OutKey", customerID), new MySqlParameter("@MedicineResultID", ID), new MySqlParameter("@Mild", model.Mild), new MySqlParameter("@Faint", model.Faint), new MySqlParameter("@Yang", model.Yang), new MySqlParameter("@Yin", model.Yin), new MySqlParameter("@PhlegmDamp", model.PhlegmDamp), new MySqlParameter("@Muggy", model.Muggy), new MySqlParameter("@BloodStasis", model.BloodStasis), new MySqlParameter("@QiConstraint", model.QiConstraint), new MySqlParameter("@Characteristic", model.Characteristic) }; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }