private bool IsValid() { CbStatus.GetBindingExpression(ComboBox.SelectedValueProperty).UpdateSource(); TbName.GetBindingExpression(TextBox.TextProperty).UpdateSource(); return(!Validation.GetHasError(CbStatus) && !Validation.GetHasError(TbName)); }
public FMasterPelajaran() { InitializeComponent(); this.SetControlFrom(); CbStatus.LoadYN(false); tbhalaman.SetHalaman(bprev, ldarihalaman, bnext, Loaddb); TbCari.TextChanged += TbCari_TextChanged; }
private void BSimpan_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(TbKodeMapel.Text)) { MessageBox.Show("Kode mapel kosong!", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (string.IsNullOrEmpty(TbMataPelajaran.Text)) { MessageBox.Show("Mata Pelajaran kosong!", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if (CbStatus.SelectedIndex < 0) { MessageBox.Show("Status kosong!", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { if (Dg.Enabled) { if (MessageBox.Show("Simpan pelajaran baru?", "Pertanyaan", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { A.SetInsert("INSERT INTO `r_matapelajaran` (`kodepelajaran`, `kodemapel`, `namapelajaran`, `status`)"); A.SetValues("VALUES('" + A.GenerateKode("MP", "r_matapelajaran", "kodepelajaran") + "', '" + TbKodeMapel.Text + "', " + "'" + TbMataPelajaran.StrEscape() + "', '" + CbStatus.ToYN() + "')"); A.SetQueri(A.GetInsert() + A.GetValues() + ";"); if (A.GetQueri().ManipulasiData()) { MessageBox.Show("Data telah ditambahkan!", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information); TbKodeMapel.Clear(); TbMataPelajaran.Clear(); CbStatus.SelectedIndex = -1; Loaddb(); } } } else { if (MessageBox.Show("Simpan perubahan pelajaran?", "Pertanyaan", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { A.SetUpdate("UPDATE `r_matapelajaran` "); A.SetSet("SET `kodemapel` = '" + TbKodeMapel.Text + "', `namapelajaran` = '" + TbMataPelajaran.StrEscape() + "', `status` = '" + CbStatus.ToYN() + "' "); A.SetWhere("WHERE `kodepelajaran` = '" + Dg.CurrentRow.Cells[0].Value.ToString() + "' "); A.SetQueri(A.GetUpdate() + A.GetSet() + A.GetWhere() + ";"); if (A.GetQueri().ManipulasiData()) { MessageBox.Show("Data telah diubah!", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information); TbKodeMapel.Clear(); TbMataPelajaran.Clear(); CbStatus.SelectedIndex = -1; Dg.LoadIndex(Loaddb, 1); } } } } }
private bool IsValidProduct() { CbProduct.GetBindingExpression(ComboBox.SelectedValueProperty).UpdateSource(); CbStatus.GetBindingExpression(ComboBox.SelectedValueProperty).UpdateSource(); TbOriginStock.GetBindingExpression(TextBox.TextProperty).UpdateSource(); CbUnit.GetBindingExpression(ComboBox.SelectedValueProperty).UpdateSource(); TbSupplyPrice.GetBindingExpression(TextBox.TextProperty).UpdateSource(); TbPrice.GetBindingExpression(TextBox.TextProperty).UpdateSource(); return(!Validation.GetHasError(CbProduct) && !Validation.GetHasError(CbStatus) && !Validation.GetHasError(TbOriginStock) && !Validation.GetHasError(CbUnit) && !Validation.GetHasError(TbSupplyPrice) && !Validation.GetHasError(TbPrice)); }
private void LoadAlterarStatus() { int cont = 0; if (usuarioLogin.NomePerfil != "Admin") { CbStatus.DataSource = new StatusController().FinByStatusPerfil(usuarioLogin.Codigo_perfil); cont = CbStatus.FindStringExact(chamado.Nomestatus); CbStatus.SelectedIndex = cont; } else { CbStatus.DataSource = new StatusController().FindAll(); cont = CbStatus.FindStringExact(chamado.Nomestatus); CbStatus.SelectedIndex = cont; } CbStatus.DisplayMember = "NomeStatus"; }
private void BtnAdd_Click(object sender, RoutedEventArgs e) { if (DpDateTimeLeadCreated.SelectedDate.ToString() == "") { FolderClass.ClassMB.MBError("Введите дату создания лида"); DpDateTimeLeadCreated.Focus(); } else if (string.IsNullOrEmpty(TbNumberPhone.Text)) { FolderClass.ClassMB.MBError("Введите контактные данные лида"); TbNumberPhone.Focus(); } else if (string.IsNullOrEmpty(TbMasteringSalesSkills.Text)) { FolderClass.ClassMB.MBError("Введите овладение навыками продаж"); TbMasteringSalesSkills.Focus(); } else if (string.IsNullOrEmpty(TbWorkingWithObjections.Text)) { FolderClass.ClassMB.MBError("Введите работу с возражениями"); TbWorkingWithObjections.Focus(); } else if (string.IsNullOrEmpty(TbKnowledgeOfCompanysProducts.Text)) { FolderClass.ClassMB.MBError("Введите знания продуктов компании"); TbKnowledgeOfCompanysProducts.Focus(); } else if (CbStatus.SelectedValue.ToString() == "") { FolderClass.ClassMB.MBError("Введите статус"); CbStatus.Focus(); } else { FolderClass.ClassStatusLead.IdStatus = Int32.Parse(CbStatus.SelectedValue.ToString()); try { sqlConnection.Open(); sqlCommand = new SqlCommand("Insert into dbo.Lead " + "(DateTimeLeadCreated, NumberPhoneLead, " + "Comment, MasteringSalesSkills, WorkingWithObjections, " + "KnowledgeOfCompanysProducts, IdStatus) " + "Values " + "(@DateTimeLeadCreated, " + "@NumberPhoneLead, " + "@Comment, " + "@MasteringSalesSkills, " + "@WorkingWithObjections, " + "@KnowledgeOfCompanysProducts, " + "@IdStatus)", sqlConnection); sqlCommand.Parameters.AddWithValue("DateTimeLeadCreated", DpDateTimeLeadCreated.SelectedDate.GetValueOrDefault()); sqlCommand.Parameters.AddWithValue("NumberPhoneLead", TbNumberPhone.Text); sqlCommand.Parameters.AddWithValue("Comment", TbComment.Text); sqlCommand.Parameters.AddWithValue("MasteringSalesSkills", TbMasteringSalesSkills.Text); sqlCommand.Parameters.AddWithValue("WorkingWithObjections", TbWorkingWithObjections.Text); sqlCommand.Parameters.AddWithValue("KnowledgeOfCompanysProducts", TbKnowledgeOfCompanysProducts.Text); sqlCommand.Parameters.AddWithValue("IdStatus", FolderClass.ClassStatusLead.IdStatus); sqlCommand.ExecuteNonQuery(); FolderClass.ClassMB.MBInformation("Добавление лида прошло успешно"); } catch (Exception ex) { FolderClass.ClassMB.MBError(ex); } finally { sqlConnection.Close(); } } }