/// <summary>
/// load dropdownlist
/// </summary>
/// <param name="ddl">System.Web.UI.WebControls.DropDownList ddl</param>
public static void fillDropDownItems(System.Web.UI.WebControls.DropDownList ddl, string comID, string type)
{
try
{
RulesData _r = new RulesData();
Geofence _g = new Geofence();
Units _u = new Units();
if (type == "rules")
{
new RulesDataSelect().RulesDropDownList(_r._dropDownList, comID);
ddl.DataSource = _r._dropDownList;
ddl.DataTextField = "Name";
ddl.DataValueField = "Value";
ddl.DataBind();
}
else if ( type == "geo")
{
new RulesDataSelect("geo").GeoDropDownList(_g._dropDownList, comID);
ddl.DataSource = _g._dropDownList;
ddl.DataTextField = "Name";
ddl.DataValueField = "Value";
ddl.DataBind();
}
else if (type == "units")
{
new RulesDataSelect("units").UnitsDropDownList(_u._dropDownList, comID);
ddl.DataSource = _u._dropDownList;
ddl.DataTextField = "Name";
ddl.DataValueField = "Value";
ddl.DataBind();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
ddl = null;
}
}
public void UpdateRules()
{
RulesData _rules = new RulesData();
ProcessSpeedingNotQueries update = new ProcessSpeedingNotQueries(AlarmasABC.BLL.InvokeOperations.operations.UPDATE);
try
{
bool _status = false;
bool isSMS = _ckOnSMS.Checked;
_status = _chkOn.Checked;
_rules.RulesValue = _txtSpeedValue.Text.ToString();
_rules.Email = _txtNotificationEmails.Text.ToString();
_rules.Message = _txtMessage.Text.ToString();
_rules.SpeedingPhoneNum = _txtPhoneNumber.Text.Trim();
if (_txtPhoneNumber.Text == "")
{
isSMS = false;
}
_rules.IsSMS = isSMS;
_rules.UnitID = int.Parse( Request.QueryString["unitID"].ToString());
_rules.RulesID = int.Parse(ViewState["rulesID"].ToString());
_rules.IsActive = _status;
update.RulesInfo = _rules;
update.invoke();
_lblMessage.ForeColor = System.Drawing.Color.Green;
_lblMessage.Text = "Rules Update Successfully.";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message.ToString());
_lblMessage.ForeColor = System.Drawing.Color.Red;
_lblMessage.Text = "Rules Update fail.";
}
finally
{
_rules = null;
}
}
public void AssignRules()
{
RulesData _rules = new RulesData();
ProcessSpeedingNotQueries insert = new ProcessSpeedingNotQueries(AlarmasABC.BLL.InvokeOperations.operations.INSERT);
try
{
_rules.RulesName = "";
_rules.RulesValue = _txtSpeedValue.Text.ToString();
_rules.Email = _txtNotificationEmails.Text.ToString();
bool isSMS = _ckOnSMS.Checked;
if (_txtPhoneNumber.Text == "")
{
isSMS = false;
}
_rules.SpeedingPhoneNum = _txtPhoneNumber.Text.Trim();
_rules.IsSMS = isSMS;
_rules.Message = _txtMessage.Text.ToString();
string _comID = Session["trkCompany"].ToString();
_rules.ComID = int.Parse(_comID);
_rules.UnitID =int.Parse( Request.QueryString["unitID"].ToString());
insert.RulesInfo = _rules;
insert.invoke();
_lblMessage.ForeColor = System.Drawing.Color.Green;
_lblMessage.Text = "Rules Assign Successfully.";
}
catch (Exception ex)
{
Console.WriteLine(ex.Message.ToString());
_lblMessage.ForeColor = System.Drawing.Color.Red;
_lblMessage.Text = "Rules Assign fail.";
}
finally
{
_rules = null;
}
}
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 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;
}
}
public makeSpeedingParam(RulesData _rules)
{
this._rulesInfo = _rules;
build();
}
private void ShowRulesDetails()
{
try
{
ProcessSpeedingQueries _rulesData = new ProcessSpeedingQueries();
RulesData _rulesInfo = new RulesData();
_rulesInfo.ComID = int.Parse(Session["trkCompany"].ToString());
_rulesInfo.UnitID = int.Parse(Request.QueryString["unitID"].ToString());
_rulesData.RulesInfo = _rulesInfo;
_rulesData.invoke();
DataSet _ds = new DataSet();
_ds = _rulesData.Ds;
if (_ds.Tables[0].Rows.Count > 0)
{
_txtSpeedValue.Text = _ds.Tables[0].Rows[0]["rulesValue"].ToString();
_txtNotificationEmails.Text = _ds.Tables[0].Rows[0]["email"].ToString();
_txtMessage.Text = _ds.Tables[0].Rows[0]["description"].ToString();
_txtPhoneNumber.Text = _ds.Tables[0].Rows[0]["speedPhoneNum"].ToString();
bool isActive = bool.Parse(_ds.Tables[0].Rows[0]["isActive"].ToString());
ViewState["rulesID"] = _ds.Tables[0].Rows[0]["rulesID"].ToString();
if (isActive)
{
_chkOff.Checked = false;
}
else
{
_chkOff.Checked = true;
_chkOn.Checked = false;
}
bool isSMS = false;
string tmp = _ds.Tables[0].Rows[0]["isSMS"].ToString();
if (tmp.Length > 0)
{
isSMS = bool.Parse(tmp);
}
if (isSMS)
{
_ckOnSMS.Checked = true;
_chkOffSMS.Checked = false;
}
else
{
_ckOnSMS.Checked = false;
_chkOffSMS.Checked = true;
}
_btnOk.Text = "Update";
}
else
{
_btnOk.Text = "Assign Rules";
}
}
catch (Exception ex)
{
}
}
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)
{
}
}
public TreeColor3(RulesData _rules)
{
this.Rules = _rules;
Command = @"SELECT frulesFor,r.rulesOperator,r.rulesValue FROM tblRules r INNER JOIN" +
@" tblRulesFor f ON f.rulesForID=r.rulesForID WHERE rulesID = :rulesID;";
}
public SpeedingInsertParams(RulesData _rules)
{
this._rulesInfo = _rules;
build();
}
public SpeedingUpdateParams(RulesData _rules)
{
this._rulesInfo = _rules;
build();
}
public makeRulesDeleteParam(RulesData rules)
{
this._rulesData = rules;
build();
}