public EditableListBox() { InitializeComponent(); listboxHelper = new ListboxHelper(listbox); textboxHelper = new TextboxHelper(textbox); buttonsHelper = new ButtonsHelper(new Button[5] { buttonSort, buttonUp, buttonDown, buttonAdd, buttonRemove }); }
public ActionResult AddLocation(string Email) { ListboxHelper g = new ListboxHelper(); Location l = new Location(); l.getAllLocationTypes = g.GetAllLocationType(); return View(l); }
// GET: Users/User public ActionResult Index() { UserProfile model = new UserProfile(); ListboxHelper g = new ListboxHelper(); model.getAllGender = g.GetAllGender(); model.getAllUserTypes = g.GetAllUserTypes(); return View(model); }
public ActionResult Index(UserProfile model) { var client = new Connection().ConnectAmazonDynamoDB(new AmazonDBHelper().AmazonDBConnectionString()); var table = Table.LoadTable(client, "user"); var item = new Document(); item["email"] = model.Email; item["password"] = model.Password; item["dob"] = model.DOB; item["firstname"] = model.FirstName; item["lastname"] = model.LastName; if (model.MiddleName != null && model.MiddleName != "") item["middlename"] = model.MiddleName; item["gender"] = model.GenderID; item["mobilephone"] = model.MobilePhone; item["usertype"] = model.UserTypeID; var licenses = new Document(); if (model.LicenseExpireDate != null && model.LicenseExpireDate != "") licenses.Add("licenseexpiredate", model.LicenseExpireDate); if (model.LicenseIssueDate != null && model.LicenseIssueDate != "") licenses.Add("licenseissuedate", model.LicenseIssueDate); if (model.LicenseIssuePlace != null && model.LicenseIssuePlace != "") licenses.Add("licenseissueplace", model.LicenseIssuePlace); if (model.LicenseNumber != null && model.LicenseNumber != "") licenses.Add("licensenumber", model.LicenseNumber); item.Add("license", licenses); table.PutItem(item); ListboxHelper g = new ListboxHelper(); model.getAllGender = g.GetAllGender(); model.getAllUserTypes = g.GetAllUserTypes(); return RedirectToAction("AddLocation", "User", new {Email = model.Email }); }
private Models.Prescription GetPrescription(int PatientID, int DoctorID, string InvoiceId, Models.Prescription model) { ListboxHelper g = new ListboxHelper(); model.getAllPrescriptionTypes = g.GetAllPrescriptionType(); model.Patient = GetUser(PatientID); model.Doctor = GetUser(DoctorID); model.PatientUserId = PatientID; model.PrescribedByUserId = DoctorID; model.InvoiceId = InvoiceId; List<Drug> Drugs = new List<Drug>(); PrescriptionContext pc = new PrescriptionContext(); IEnumerable<HealthDB.Model.Prescription> ps = from Prescriptions in pc.Prescriptions where Prescriptions.Invoice == InvoiceId select Prescriptions; foreach (var p in ps) { Drug d = new Drug(); d.Id = p.Id; d.Direction = p.Instruction; d.DrugName = p.DrugName; d.GroupName = p.GroupName; d.PrescriptionType = (from PrescriptionTypes in pc.PrescriptionTypes where PrescriptionTypes.Id == p.PrescriptionTypeId select PrescriptionTypes.Name).FirstOrDefault(); d.Quantity = p.Quantity; d.Strength = p.Dosage; Drugs.Add(d); } model.Drugs = Drugs.OrderBy(ds => ds.PrescriptionType + ds.GroupName + ds.DrugName).ToList(); return model; }
public bool InsertDrugName(string DrugName) { var result = new CRUD().getItem(new AmazonDBHelper().AmazonDBConnectionString(), "drugname", DrugName, ":v_drugname", "drugname"); if (result.Count == 0) { int ID = 1; //Get ID List<ListboxHelper.CustomListItem> cli = new ListboxHelper().GetTableID(); foreach (var li in cli) { if (li.text == "drugname") { ID = li.value; ID += 1; } } List<string> columnName = new List<string>(); columnName.Add("id"); columnName.Add("drugname"); List<string> types = new List<string>(); types.Add("int"); types.Add("string"); List<string> value = new List<string>(); value.Add(ID.ToString()); value.Add(DrugName.ToLower()); new CRUD().InsertItem(new AmazonDBHelper().AmazonDBConnectionString(), "drugname", columnName, types, value); } return true; }
private bool AddLocation(Location l) { int ID = 1; bool result = false; try { var client = new Connection().ConnectAmazonDynamoDB(new AmazonDBHelper().AmazonDBConnectionString()); //Get ID List<ListboxHelper.CustomListItem> cli = new ListboxHelper().GetTableID(); foreach (var li in cli) { if (li.text == "Location") { ID = li.value; ID += 1; } } var table = Table.LoadTable(client, "location"); var item = new Document(); item["id"] = ID; item["city"] = l.City; item["postalcode"] = l.PostalCode; item["province"] = l.Province; item["street1"] = l.Street1; if (l.Street2 != null && l.Street2 != "") item["street2"] = l.Street2; item["email"] = l.Email; item["locationtypeid"] = l.LocationTypeID; item["locname"] = l.LocName; if (l.LocFax != null && l.LocFax != "") item["locfax"] = l.LocFax; item["locphone"] = l.LocPhoneMain; table.PutItem(item); new CRUD().UpdateItem(new AmazonDBHelper().AmazonDBConnectionString(), "GenerateID", "location", ":i", "ID", "#I", (ID + 1).ToString()); } catch (Exception) { } return result; }