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();
}
