/// <summary> /// Populates user related info /// </summary> private void PopulateUser() { User us = new User(); DataTable dtUser = us.GetUsers(); int count = 1; int col = 0; lstUsers.Items.Clear(); foreach (DataRow dv in dtUser.Rows) { string[] str = { count.ToString(), dv["FullName"].ToString(), dv["Mobile"].ToString(), dv["UserName"].ToString(), dv["Type"].ToString() }; ListViewItem lst = new ListViewItem(str) { Tag = dv["ID"] }; if (col != 0) { lst.BackColor = Color.FromArgb(233, 247, 248); col = 0; } else { col++; } lstUsers.Items.Add(lst); count++; } UserType uType = new UserType(); uType.LoadAll(); cboUserType.DataSource = uType.DefaultView; BLL.Type comUser = new BLL.Type(); comUser.LoadAll(); cbCommodity.Properties.DataSource = comUser.DefaultView; cbCommodity.Properties.DisplayMember = "Name"; cbCommodity.Properties.ValueMember = "ID"; Stores storeUser = new Stores(); storeUser.LoadAll(); cbStore.Properties.DataSource = storeUser.DefaultView; cbStore.Properties.DisplayMember = "StoreName"; cbStore.Properties.ValueMember = "ID"; }
/// <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(); }
/// <summary> /// Update the form based on the selected user /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void lstUsers_SelectedIndexChanged(object sender, EventArgs e) { if (lstUsers.SelectedItems.Count > 0) { int selected = Convert.ToInt32(lstUsers.SelectedItems[0].Tag); User us = new User(); us.LoadByPrimaryKey(selected); txtFullName.Text = us.FullName; txtAddress.Text = us.Address; txtMobile.Text = us.Mobile; ckActive.Checked = us.Active; cboUserType.SelectedValue = us.UserType.ToString(); _userId = us.ID; grpLoginInfo.Enabled = false; BLL.Type ucType = new BLL.Type(); ucType.LoadAll(); UserCommodityType usc = new UserCommodityType(); DataTable comUser = usc.GetUserCommodityType(_userId); cbCommodity.Properties.DataSource = ucType.DefaultView.ToTable(); cbCommodity.Properties.DisplayMember = "Name"; cbCommodity.Properties.ValueMember = "ID"; string[] arr = new string[comUser.DefaultView.ToTable().Rows.Count]; int index = 0; foreach (DataRow dr in comUser.DefaultView.ToTable().Rows) { arr[index] = Convert.ToString(dr["ID"]); index++; } char separator = cbCommodity.Properties.SeparatorChar; string result = string.Empty; foreach (var element in arr) { result += element + separator; } cbCommodity.SetEditValue(result); UserStore ust = new UserStore(); DataTable storeUser = ust.GetUserStore(_userId); Stores stuser = new Stores(); stuser.LoadAll(); cbStore.Properties.DataSource = stuser.DefaultView; cbStore.Properties.DisplayMember = "StoreName"; cbStore.Properties.ValueMember = "ID"; string[] arrst = new string[storeUser.DefaultView.ToTable().Rows.Count]; int rowindex = 0; foreach (DataRow drs in storeUser.DefaultView.ToTable().Rows) { arrst[rowindex] = Convert.ToString(drs["ID"]); rowindex++; } char separatorst = cbStore.Properties.SeparatorChar; string resultst = string.Empty; foreach (var element in arrst) { resultst += element + separatorst; } cbStore.SetEditValue(resultst); } }
public DataTable GetAllCategory() { BLL.Type type = new Type(); type.LoadAll(); return(type.DataTable); }
public static DataTable GetAllTypes() { BLL.Type type = new Type(); type.LoadAll(); return(type.DataTable); }