private void CtlGrid_btnDeleteClicked(int rowID) { try { varID = objTreatmentCollection[rowID].ID; if (System.Windows.MessageBox.Show("Do You Really Want To Delete This Record ?", "Delete Treatement", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { ClsTreatment.Delete(varID); System.Windows.MessageBox.Show("Record Deleted!!", "Treatement Delete", MessageBoxButton.OK, MessageBoxImage.Information); } fncSetGrid(); } catch (Exception ex) { VMuktiHelper.ExceptionHandler(ex, "CtlGrid_btnDeleteClicked()", "CtlTreatment.xaml.cs"); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { // We First Have to delete all treatmentconditions related to treatment from DB. CtlGrid.IsEnabled = true; ClsTreatment objTreatment = new ClsTreatment(); if (VarState == 0) { objTreatment.ID = -1; } else { if (rdDisposition.IsChecked == true) { ClsTreatment.Delete_Disposition(varID); objTreatment.ID = varID; } else { ClsTreatment.Delete_All(varID); objTreatment.ID = varID; } } if (txtName.Text != "" && lstConditionsCreated.Items.Count > 0) { objTreatment.TreatmentName = txtName.Text; objTreatment.Description = txtDescription.Text; objTreatment.IsInclude = true; objTreatment.Type = strTreatmentType; objTreatment.UserID = VMuktiAPI.VMuktiInfo.CurrentPeer.ID; int gID = objTreatment.Save(); for (int i = 0; i < lstConditionsCreated.Items.Count; i++) { ClsTreatmentCondition c = new ClsTreatmentCondition(); string[] str = ((ListBoxItem)lstConditionsCreated.Items[i]).Tag.ToString().Split('~'); if (str[0] != "Call After") { string[] strLeadFormatID = (cmbLeadFormat.SelectedItem.ToString().Split(':')); c.LeadFormatName = strLeadFormatID[1].ToString().TrimStart(); if (strTreatmentType == "Filter") { str[2] = str[2].Replace(",", "~"); if (str[2].Substring(str[2].Length - 1).Contains("~")) { //str[2] = str[2].Substring(str[2].Length - 1).Replace("", "~"); str[2] = str[2].Substring(0, str[2].Length - 1); } } c.FieldName = str[0]; c.Operator = str[1]; c.FieldValues = str[2]; c.ID = -1; c.TreatmentID = gID; c.Save(); } else { c.Duration = str[1]; c.TreatmentID = gID; c.Disposition = str[2]; c.SaveDisposition(); } } System.Windows.MessageBox.Show("Record Saved Successfully!!"); rdDisposition.IsEnabled = true; rdFieldValue.IsEnabled = true; rdFilter.IsChecked = false; fncSetGrid(); fncSetComboboxes(); funClearBoxes(); btnEdit.IsEnabled = true; btnAdd.IsEnabled = true; rdFilter.IsEnabled = true; } else { System.Windows.MessageBox.Show("Treatment Name and Treatment conditions can't be null"); } } catch (Exception ex) { VMuktiHelper.ExceptionHandler(ex, "btnSave_Click()", "CtlTratment.xaml.cs"); } }
private void fncSetComboboxes() { try { //Setting Up Hours Comboboxes for (int i = 0; i < 23; i++) { if (i < 10) { ComboBoxItem m = new ComboBoxItem(); m.Content = "0" + i.ToString(); m.Tag = "0" + i.ToString(); cmbHours.Items.Add(m); } else { ComboBoxItem m = new ComboBoxItem(); m.Content = i.ToString(); m.Tag = i.ToString(); cmbHours.Items.Add(m); } } //Setting Up Minutes Comboboxes for (int i = 0; i < 59; i++) { if (i < 10) { ComboBoxItem m = new ComboBoxItem(); m.Content = "0" + i.ToString(); m.Tag = "0" + i.ToString(); cmbMins.Items.Add(m); } else { ComboBoxItem m = new ComboBoxItem(); m.Content = i.ToString(); m.Tag = i.ToString(); cmbMins.Items.Add(m); } } // Setting Up Fields ComboBoxes. cmbLeadFormat.Items.Clear(); cmbCampaign.Items.Clear(); DataSet dc = ClsTreatment.GetCampaign(null); DataTable dtc = dc.Tables[0]; for (int i = 0; i < dtc.Rows.Count; i++) { ComboBoxItem m = new ComboBoxItem(); m.Content = dtc.Rows[i][0].ToString(); m.Tag = dtc.Rows[i][0].ToString(); cmbCampaign.Items.Add(m); } DataSet df = ClsTreatment.GetLeadFormat(); DataTable dtt = df.Tables[0]; for (int j = 0; j < dtt.Rows.Count; j++) { ComboBoxItem m = new ComboBoxItem(); m.Content = dtt.Rows[j].ItemArray[1].ToString(); m.Tag = dtt.Rows[j].ItemArray[0].ToString(); cmbLeadFormat.Items.Add(m); } cmbField.Items.Clear(); //DataSet ds = ClsTreatment.GetFields(); //DataTable dt = ds.Tables[0]; //for (int i = 0; i < dt.Columns.Count; i++) //{ // ComboBoxItem l = new ComboBoxItem(); // l.Content = dt.Columns[i].Caption; // cmbField.Items.Add(l); //} // Setting Up Operator ComboBoxes. cmbOperator.Items.Clear(); if (strTreatmentType == "Filter") { cmbOperator.Items.Add("IN"); cmbOperator.Items.Add("Not IN"); } else { cmbOperator.Items.Add("=="); cmbOperator.Items.Add("<>"); cmbOperator.Items.Add(">"); cmbOperator.Items.Add(">="); cmbOperator.Items.Add("<"); cmbOperator.Items.Add("<="); cmbOperator.Items.Add("IN"); cmbOperator.Items.Add("BETWEEN"); } } catch (Exception ex) { VMuktiHelper.ExceptionHandler(ex, "fncSetComboboxes()", "CtlTratment.xaml.cs"); } }
private void cmbField_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { if (cmbField.SelectedItem != null) { if (strTreatmentType == "Filter") { txtValues.Text = ""; if (cmbField.Items.Count > 0) { selectedValue = ((ComboBoxItem)cmbField.SelectedItem).Content.ToString(); lstFill.SelectionMode = SelectionMode.Extended; lblExample.Visibility = Visibility.Hidden; cmbValues.Visibility = Visibility.Hidden; txtValues.Visibility = Visibility.Visible; if ((selectedValue.ToLower() == "timezone") || (selectedValue.ToLower() == "country") || (selectedValue.ToLower() == "areacode") || (selectedValue.ToLower() == "state")) { DataSet ds = new DataSet(); if (selectedValue.ToLower() == "timezone") { ds = ClsTreatment.Timezone_GetAll(); } //else if (selectedValue.ToLower() == "country") //{ // ds = ClsTreatment.Country_GetAll(); //} else if (selectedValue.ToLower() == "areacode") { ds = ClsTreatment.AreaCode_GetAll(); } else if (selectedValue.ToLower() == "state") { ds = ClsTreatment.State_GetAll(); } txtValues.IsReadOnly = true; lstFill.Visibility = Visibility.Visible; lstFill.Items.Clear(); DataTable dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { ListBoxItem cbiFormat = new ListBoxItem(); cbiFormat.Content = dt.Rows[i].ItemArray[0]; cbiFormat.Tag = dt.Rows[i].ItemArray[1]; lstFill.Items.Add(cbiFormat); } } else { txtValues.IsReadOnly = false; lstFill.Items.Clear(); lstFill.Visibility = Visibility.Hidden; lblExample.Visibility = Visibility.Visible; } } } else { cmbValues.Items.Clear(); DataSet ds = ClsTreatment.GetFieldValues(((ComboBoxItem)cmbField.SelectedItem).Content.ToString()); DataTable dt = ds.Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { ComboBoxItem l = new ComboBoxItem(); l.Content = dt.Rows[i].ItemArray[0]; cmbValues.Items.Add(l); } } } } catch (Exception ex) { VMuktiHelper.ExceptionHandler(ex, "cmbField_SelectionChanged()", "CtlTreatment.xaml.cs"); } }