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)
{
}
}
