public bool CancelRules() { ProcessRulesData _unitRules = new ProcessRulesData(); RulesData _units = new RulesData(); bool cStatus = false; //foreach (DataListItem item in CancelUnitDataList.Items) //{ //CheckBox chkUnit = (CheckBox)item.FindControl("UnitCheckBox"); if (_ddlUnits.SelectedIndex > 0) { //Label UnitID = (Label)item.FindControl("lblUnitID"); _units.UnitID = int.Parse(_ddlUnits.SelectedValue.ToString()); _unitRules.RulesData = _units; _unitRules.CancelRules(); cStatus = true; } //if (cStatus) //{ // ConfirmationFlageLabel.ForeColor = System.Drawing.Color.Green; // ConfirmationFlageLabel.Text = "Rules update Succesfull."; // cStatus = true; // //FormRest(); //} //else //{ // ConfirmationFlageLabel.ForeColor = System.Drawing.Color.Red; // ConfirmationFlageLabel.Text = "Failed to Update Rules!"; // cStatus = false; // //FormRest(); //} return cStatus; }
private void ShowRules() { ProcessRulesData _rulesData = new ProcessRulesData(AlarmasABC.BLL.InvokeOperations.operations.SELECT); DataSet _ds = new DataSet(); try { int _comID = int.Parse(Session["trkCompany"].ToString()); _rulesData.ComID = _comID; _rulesData.invoke(); _ds = _rulesData.Ds; _rgriDRules.DataSource = _ds; _rgriDRules.DataBind(); } catch (Exception ex) { } }
private bool AddRules() { try { RulesData _rulesObj = new RulesData(); ProcessRulesData _rulesAdd=new ProcessRulesData(AlarmasABC.BLL.InvokeOperations.operations.INSERT); _rulesObj.RulesID=1; _rulesObj.RulesOperator="<"; _rulesObj.RulesOperatorName="Less Than"; _rulesObj.RulesValue=_txtValue.Text.Trim(); _rulesObj.ComID=int.Parse(Session["trkCompany"].ToString()); _rulesAdd.RulesObj=_rulesObj; _rulesAdd.invoke(); return true; } catch (Exception ex) { ex.Message.ToString(); return false; } }
private void LoadUnitRulesInfo() { try { ProcessRulesData _unitRules = new ProcessRulesData(); RulesData _units = new RulesData(); _units.UnitID = int.Parse(_ddlUnits.SelectedValue.ToString()); _unitRules.RulesData = _units; _unitRules.UnitRuleInfo(); DataSet _ds = _unitRules.Ds; EmailTextBox.Text = _ds.Tables[0].Rows[0][0].ToString(); SubjectTextBox.Text = _ds.Tables[0].Rows[0][1].ToString(); DescriptionTextBox.Text = _ds.Tables[0].Rows[0][2].ToString(); isActiveCheckBox.Checked = bool.Parse(_ds.Tables[0].Rows[0][3].ToString()); _ddlGeofence.SelectedValue = _ds.Tables[0].Rows[0][4].ToString(); } catch (Exception ex) { } }
private void EditRules() { //string updateSQl = ""; bool flag = false; //bool Status = cancelStatus; bool isActive = isActiveCheckBox.Checked; //foreach (DataListItem item in CancelUnitDataList.Items) //{ // CheckBox chkUnit = (CheckBox)item.FindControl("UnitCheckBox"); if (_ddlUnits.SelectedIndex > 0) { //Label UnitID = (Label)item.FindControl("lblUnitID"); RulesData rules = new RulesData(); ProcessRulesData rulesObj = new ProcessRulesData(); rules.UnitID = int.Parse(_ddlUnits.SelectedValue.ToString()); rules.RulesID = int.Parse(_ddlRules.SelectedValue.ToString()); rules.GeoID = int.Parse(_ddlGeofence.SelectedValue.ToString()); rules.Email = EmailTextBox.Text.ToString(); rules.Message = SubjectTextBox.Text.ToString(); rules.IsActive = isActive; rulesObj.RulesData = rules; rulesObj.UpdateRules(); flag = true; //updateSQl += " Update tblUnitWiseRules set RulesID=" + _ddlRules.SelectedValue.ToString() + ",GeofenceID=" + _ddlGeofence.SelectedValue.ToString() + ",Email='" + EmailTextBox.Text.Trim() + "',Subject='" + SubjectTextBox.Text.Trim() + "',Description='" + DescriptionTextBox.Text.Trim() + "',isActive=" + isActive + " where UnitID=" + UnitID.Text.Trim() + ";"; } if (flag ) { ConfirmationFlageLabel.ForeColor = System.Drawing.Color.Green; ConfirmationFlageLabel.Text = "Rules update Succesfull."; FormReset(); } else { ConfirmationFlageLabel.ForeColor = System.Drawing.Color.Red; ConfirmationFlageLabel.Text = "Failed to Update Rules!"; //FormRest(); } }
private void createStr() { foreach (DataGridItem item in _grdMain.Items) { DataList lstUnit = (DataList)item.FindControl("lstUnits"); foreach (DataListItem lstItem in lstUnit.Items) { CheckBox chkUnit = (CheckBox)lstItem.FindControl("chkUnit"); if (chkUnit.Checked) { Label UnitID = (Label)lstItem.FindControl("lblUnitID"); RulesData rules = new RulesData(); ProcessRulesData rulesObj = new ProcessRulesData(); rules.UnitID = int.Parse(UnitID.Text.Trim()); rules.RulesID = int.Parse(_ddlRules.SelectedValue.ToString()) ; rules.GeoID = int.Parse(_ddlGeofence.SelectedValue.ToString()); rules.Email = Email.Text.ToString(); rules.Message = Subject.Text.ToString(); rules.IsActive = true; rulesObj.RulesData = rules; rulesObj.AssignRules(); ConfirmationFlagLabel.ForeColor = System.Drawing.Color.Green; ConfirmationFlagLabel.Text = "Rules Applied Succesfully."; //FormRest(); } } } //Database db = new Database(); //bool flag = db.executeNonQry(insertSQl); //db.Close(); //if (flag) //{ // ConfirmationFlagLabel.ForeColor = System.Drawing.Color.Green; // ConfirmationFlagLabel.Text = "Rules Applied Succesfully."; // FormRest(); // BindParentGrid(Session["trkCompany"].ToString()); //} //else //{ // ConfirmationFlagLabel.ForeColor = System.Drawing.Color.Red; // ConfirmationFlagLabel.Text = "Failed To Apply Rules!"; // FormRest(); //} }
private void BindParentGrid(string comID) { try { ProcessRulesData _unitRules = new ProcessRulesData(); RulesData _units = new RulesData(); if (Session["roleID"] != null) { if (Session["roleID"].ToString() != "3") { _units.ComID = int.Parse(comID); _units.UID = int.Parse(Session["roleID"].ToString()); _unitRules.RulesData = _units; _unitRules.GetUnits(); _ds = _unitRules.Ds; } else { //RulesData _units = new RulesData(); _units.ComID = int.Parse(comID); _unitRules.RulesData = _units; _unitRules.GetUnits3(); _ds = _unitRules.Ds; } } _ds.Tables[0].TableName = "Group"; _ds.Tables[1].TableName = "Units"; int count = _ds.Tables[0].Rows.Count; _grdMain.DataSource = _ds.Tables["Group"]; _grdMain.DataBind(); if (count > 1) { chkAllUnit.Visible = true; } else { chkAllUnit.Visible = false; ConfirmationFlagLabel.ForeColor = System.Drawing.Color.Red; ConfirmationFlagLabel.Text = "No Unit Record Found For This company"; } } catch (Exception ex) { } }