private void BtnSelect_Click(object sender, EventArgs e) { LblBusinessDescription.Show(); LblBusinessName.Show(); LblCategory.Show(); LblPrice.Show(); LblRating.Show(); LblTelephone.Show(); LblUser.Show(); LblWebsite.Show(); LblWorkHours.Show(); LblBusinessType.Show(); LblLocation.Show(); TbxBusinessName.Show(); TbxCategory.Show(); TbxDescription.Show(); TbxPrice.Show(); TbxRating.Show(); TbxTelephone.Show(); TbxWebsite.Show(); CmbLocation.Show(); CmbTypes.Show(); CmbUser.Show(); CmbWorkHours.Show(); ChbReservation.Show(); BtnEdit.Show(); LblSelect.Hide(); CmbBusinesses.Hide(); BtnSelect.Hide(); SelectedData = DCom.GetData(String.Format(SqlExec, CmbBusinesses.SelectedValue)); TbxBusinessName.Text = (string)SelectedData.Rows[0]["Business_Name"]; TbxCategory.Text = (string)SelectedData.Rows[0]["Category"]; TbxDescription.Text = (string)SelectedData.Rows[0]["Description"]; TbxPrice.Text = SelectedData.Rows[0]["Price_Range"].ToString(); TbxRating.Text = (string)SelectedData.Rows[0]["Rating"].ToString(); TbxTelephone.Text = (string)SelectedData.Rows[0]["Telephone"]; TbxWebsite.Text = (string)SelectedData.Rows[0]["Website"]; CmbLocation.DataSource = DCom.GetData("SELECT ID,CONCAT(Address_Name, ', ', Address_Number) AS NAME FROM location"); CmbLocation.DisplayMember = "NAME"; CmbLocation.ValueMember = "ID"; CmbTypes.DataSource = DCom.GetData("SELECT * FROM businesses_types"); CmbTypes.DisplayMember = "Type"; CmbTypes.ValueMember = "Type"; CmbUser.DataSource = DCom.GetData("SELECT * FROM users"); CmbUser.DisplayMember = "Username"; CmbUser.ValueMember = "Username"; CmbWorkHours.DataSource = DCom.GetData("SELECT * FROM work_hours"); CmbWorkHours.DisplayMember = "ID"; CmbWorkHours.ValueMember = "ID"; }
/// <summary> /// When the client select the user that wants to edit the not necessarily labels, tetxboxes and comboboxes are hiding /// from the form and then the neccesarily labels, tetxboxes and comboboxes are pop up. Then fills all the fields with /// the data of the selected user. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void BtnSelect_Click(object sender, EventArgs e) { label2.Show(); label3.Show(); label4.Show(); label5.Show(); label6.Show(); label7.Show(); TbxAddressNumber.Show(); TbxAdressName.Show(); TbxLat.Show(); TbxLong.Show(); TbxPostalCode.Show(); CmbMunicipality.Show(); BtnEdit.Show(); label1.Hide(); CmbLocation.Hide(); BtnSelect.Hide(); SelectedData = DCom.GetData(String.Format(SqlExec, CmbLocation.SelectedValue)); TbxAdressName.Text = SelectedData.Rows[0]["Address_Name"].ToString(); TbxAddressNumber.Text = SelectedData.Rows[0]["Address_Number"].ToString(); TbxLat.Text = SelectedData.Rows[0]["Lat"].ToString(); TbxLong.Text = SelectedData.Rows[0]["Long"].ToString(); TbxPostalCode.Text = SelectedData.Rows[0]["Postal_Code"].ToString(); CmbMunicipality.DataSource = DCom.GetData("SELECT * FROM municipality"); CmbMunicipality.DisplayMember = "Municipality_Name"; CmbMunicipality.ValueMember = "Municipality_Name"; CmbMunicipality.Text = SelectedData.Rows[0]["Municipality"].ToString(); }
private void Load() { latestTransNo = transactionNumber.Fetch(); foreach (var obj in (transaction.FetchAll())) { CmbTransactionNumbers.Add(obj.TransactionNumber); } CmbTransactionNumbers.Add(latestTransNo); CmbTransactionType.Add(new TransactionTypesModel()); foreach (var type in transactionType.FetchAll()) { CmbTransactionType.Add(type); } transactionDate = currentDate.ToString("MM/dd/yyyy"); CmbWarehouse.Add(new WareHouseModel()); foreach (var wh in warehouse.FetchAll()) { CmbWarehouse.Add(wh); } CmbLocation.Add(new LocationModel()); foreach (var loc in location.FetchAll()) { CmbLocation.Add(loc); } priceCategoryList.Add(""); priceCategoryList.Add("Selling Price"); priceCategoryList.Add("Purchase Price"); priceTypeList.Add(""); priceTypeList.Add("Current"); priceTypeList.Add("3 Months Ago"); priceTypeList.Add("6 Months Ago"); ReasonList = reason.FetchAll(); EnableDestination = false; }
public EdiBusinessForm() { InitializeComponent(); LblBusinessDescription.Hide(); LblBusinessName.Hide(); LblCategory.Hide(); LblPrice.Hide(); LblRating.Hide(); LblTelephone.Hide(); LblUser.Hide(); LblWebsite.Hide(); LblWorkHours.Hide(); LblBusinessType.Hide(); LblLocation.Hide(); TbxBusinessName.Hide(); TbxCategory.Hide(); TbxDescription.Hide(); TbxPrice.Hide(); TbxRating.Hide(); TbxTelephone.Hide(); TbxWebsite.Hide(); CmbLocation.Hide(); CmbTypes.Hide(); CmbUser.Hide(); CmbWorkHours.Hide(); ChbReservation.Hide(); BtnEdit.Hide(); CmbBusinesses.DataSource = DCom.GetData("SELECT businesses.ID, CONCAT(businesses.Business_Name, ', ', location.Address_Name, ', ', location.Municipality) AS NAME FROM businesses, location WHERE businesses.Location_ID = location.ID"); CmbBusinesses.DisplayMember = "NAME"; CmbBusinesses.ValueMember = "ID"; }