private void btnDosageSave_Click(object sender, EventArgs e) { if (txtDosageForm.Text != "") { DosageForm doForm = new DosageForm(); if (_dosageFormId != 0) { doForm.LoadByPrimaryKey(_dosageFormId); } else { doForm.AddNew(); } doForm.Form = txtDosageForm.Text; doForm.Description = txtDosageDescription.Text; doForm.TypeID = ((rdDosDrug.Checked) ? 1 : 2); doForm.Save(); doForm.LoadAll(); PopulateDosageForm(doForm); ResetDosageForm(); } else { txtDosageForm.BackColor = Color.White; } }
public List <DosageForm> GetDosageFormById(int id) { // var form = new ProductForm(); var items = new List <DosageForm>(); string commandText = "SELECT NOC_NUMBER, NOC_PF_DIN_PRODUCT_ID, "; if (this.Lang != null && this.Lang.Equals("fr")) { commandText += " NOC_PF_FORM_FR_NAME AS NOC_PF_FORM_NAME"; } else { commandText += " NOC_PF_FORM_ENG_NAME AS NOC_PF_FORM_NAME"; } commandText += " FROM NOC_ONLINE_OWNER.QRY_NOC_PRODUCT_FORM"; commandText += " WHERE NOC_NUMBER = :id "; using (OracleConnection con = new OracleConnection(DpdDBConnection)) { OracleCommand cmd = new OracleCommand(commandText, con); cmd.Parameters.Add(":id", id); try { con.Open(); using (OracleDataReader dr = cmd.ExecuteReader()) { if (dr.HasRows) { while (dr.Read()) { var form = new DosageForm(); form.noc_number = dr["NOC_NUMBER"] == DBNull.Value ? 0 : Convert.ToInt32(dr["NOC_NUMBER"]); form.noc_pf_din_product_id = dr["NOC_PF_DIN_PRODUCT_ID"] == DBNull.Value ? 0 : Convert.ToInt32(dr["NOC_PF_DIN_PRODUCT_ID"]); form.noc_pf_form_name = dr["NOC_PF_FORM_NAME"] == DBNull.Value ? string.Empty : dr["NOC_PF_FORM_NAME"].ToString().Trim(); items.Add(form); } } } } catch (Exception ex) { string errorMessages = string.Format("DbConnection.cs - GetDosageFormById()"); ExceptionHelper.LogException(ex, errorMessages); } finally { if (con.State == ConnectionState.Open) { con.Close(); } } } return(items); }
/// <summary> /// Handles the gridViewDosageForm focused node changed and updates the form accordingly /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void gridViewDosageForm_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { DataRow dr = gridViewDosageForm.GetFocusedDataRow(); if (dr != null) { DosageForm doForm = new DosageForm(); int formId = Convert.ToInt32(dr["ID"]); doForm.LoadByPrimaryKey(formId); txtDosageForm.Text = doForm.Form; txtDosageDescription.Text = doForm.Description; // if (doForm.TypeID == 1) rdDosDrug.Checked = ((doForm.TypeID == 1) ? true : false); rdDosSupply.Checked = ((doForm.TypeID == 2) ? true : false); _dosageFormId = doForm.ID; btnDosageSave.Text = "Update"; } }
/// <summary> /// Populates lookups and tables /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void SystemSetting_Load(object sender, EventArgs e) { PopulatePrograms(); // TAb IIN BLL.INN innInfo = new INN(); innInfo.LoadAll(); innInfo.Sort = "IIN"; PopulateINN(innInfo); // TAb Category BLL.Type type = new BLL.Type(); type.LoadAll(); lkCategory.DataSource = type.DefaultView; PopulateCategoryTree(); //unit section BLL.Unit uni = new Unit(); uni.LoadAll(); lstUnits.DataSource = uni.DefaultView; // dosage form section DosageForm doForm = new DosageForm(); doForm.LoadAll(); doForm.Sort = "Form"; PopulateDosageForm(doForm); //receiving status section // PopulateManufacturer(); //disposal reasons DisposalReasons reason = new DisposalReasons(); reason.LoadAll(); reason.Sort = "Reason"; PopulateDisposalReason(reason); //location regions zones and woredas PopulateLocationTree(); PopulateSupplyCatTree(); PopulateBalance(); }
public IActionResult Update(DosageForm dosageForm) // method for submitting dosage form add/edit { if (ModelState.IsValid) // check if entries are valid { if (dosageForm.DosageFormId == 0) // check if new dosage form { context.DosageForms.Add(dosageForm); // add new dosage form } else // if edit to existing dosage form { context.DosageForms.Update(dosageForm); // update selected dosage form } context.SaveChanges(); // save add/edit return(RedirectToAction("List")); // redirect to List page } else // if entries are invalid { ViewBag.Action = "Save"; // set to "Save" action return(View("AddUpdate")); // return current add/update page } }
private void AddItem_Load(object sender, EventArgs e) { DosageForm doFrm = new DosageForm(); doFrm.GetDosageForItem(); doFrm.Sort = "Form"; cboDosageForm.DataSource = doFrm.DefaultView; Unit un = new Unit(); un.LoadAll(); un.Sort = "Unit"; cboUnit.DataSource = un.DefaultView; Product pInn = new Product(); pInn.GetInnForItem(); pInn.Sort = "IIN"; cboIIN.DataSource = pInn.DefaultView; if (_categoryId != 0) { SubCategory cat = new SubCategory(); DataTable dtProd = cat.GetSubCategoryByID(_categoryId); string[] categor = { dtProd.Rows[0]["CategoryName"].ToString(), dtProd.Rows[0]["SubCategoryName"].ToString() }; ListViewItem listCat = new ListViewItem(categor) { Tag = dtProd.Rows[0]["ID"] }; lstCat.Items.Add(listCat); //txtCatCode.Text = dtProd.Rows[0]["CategoryCode"].ToString() + "-" + dtProd.Rows[0]["SubCategoryCode"].ToString(); } else { PopulateFields(); } }
private void PopulateDosageForm(DosageForm doForm) { gridDosageForm.DataSource = doForm.DefaultView; }
public IActionResult Delete(DosageForm dosageForm) // method for submitting dosage form deletion { context.DosageForms.Remove(dosageForm); // remove selected dosage form context.SaveChanges(); // save updated list of dosage forms return(RedirectToAction("List")); // redirect to List page }
public IActionResult Delete(int id) // method for deleting existing dosage form { DosageForm dosageForm = context.DosageForms.Find(id); // create & set variable for selected dosage form return(View(dosageForm)); // return page w/ selected dosage form }
public void Update(DosageForm dosageForm) { context.Entry(dosageForm).State = EntityState.Modified; context.SaveChanges(); }