protected void linkbtnEdit_Command(object sender, CommandEventArgs e)
{
try
{
if (e.CommandName == "UpdateID")
{
int cmdArg = Convert.ToInt32(e.CommandArgument);
EventConfigurationModel li = obj.getEventConfigByID(cmdArg);
if (li != null)
{
ddlObject.SelectedValue = li.ObjectID.ToString();
ddlObjsensorbind(Convert.ToInt32(li.ObjectID));
ddlObjSensor.SelectedValue = li.ObjectSensorID.ToString();
txtMin.Text = li.Min.ToString();
txtMax.Text = li.MAX.ToString();
ddlCondition.SelectedValue = li.Condition.ToString();
cbEnabled.Checked = Convert.ToBoolean(li.EnableOrDisable);
Session["eventConfigId"] = cmdArg.ToString();
btnSave.Text = "Update";
}
}
}
catch (Exception)
{ BindingClass.ExceptionAlertScriptManager(this.Page, this.GetType()); }
}
public EventConfigurationModel getEventConfigByID(int eventConfigID)
{
EventConfigurationModel model = null;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@EventConfigID", eventConfigID)
};
using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("Select * from [EventConfiguration] Where EventConfigID = @EventConfigID", CommandType.Text, parameters))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
model = new EventConfigurationModel();
model.EventConfigID = Convert.ToInt32(row["EventConfigID"]);
model.ObjectID = Convert.ToInt32(row["ObjectID"]);
model.ObjectSensorID = Convert.ToInt64(row["ObjectSensorID"]);
model.Min = Convert.ToDouble(row["Min"]);
model.MAX = Convert.ToDouble(row["MAX"]);
model.a0 = Convert.ToDouble(row["a0"]);
model.a1 = Convert.ToDouble(row["a1"]);
model.Condition = Convert.ToInt32(row["Condition"]);
model.Contact = row["Contact"].ToString();
model.Units = row["Units"].ToString();
model.Format = row["Format"].ToString();
model.EnableOrDisable = Convert.ToBoolean(row["EnableOrDisable"]);
}
}
return(model);
}
public List <EventConfigurationModel> getEventConfigByObject(int objectID)
{
List <EventConfigurationModel> list = new List <EventConfigurationModel>();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ObjectID", objectID)
};
using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("uspGET_EventConfigurationByObject", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
EventConfigurationModel model = new EventConfigurationModel();
model.EventConfigID = Convert.ToInt32(row["EventConfigID"]);
model.ObjectID = Convert.ToInt32(row["ObjectID"]);
model.ObjectSensorID = Convert.ToInt64(row["ObjectSensorID"]);
model.Name = row["Name"].ToString();
model.Min = Convert.ToDouble(row["Min"]);
model.MAX = Convert.ToDouble(row["MAX"]);
model.a0 = Convert.ToDouble(row["a0"]);
model.a1 = Convert.ToDouble(row["a1"]);
model.Condition = Convert.ToInt32(row["Condition"]);
model.Contact = row["Contact"].ToString();
model.Units = row["Units"].ToString();
model.Format = row["Format"].ToString();
model.EnableOrDisable = Convert.ToBoolean(row["EnableOrDisable"]);
list.Add(model);
}
}
}
return(list);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (ddlObject.SelectedValue != "0" && ddlObjSensor.SelectedValue != "0" && ddlCondition.SelectedValue != "0")
{
EventConfigurationModel model = new EventConfigurationModel();
model.EnableOrDisable = cbEnabled.Checked ? true : false;
model.ObjectID = Convert.ToInt32(ddlObject.SelectedValue);
model.ObjectSensorID = Convert.ToInt32(ddlObjSensor.SelectedValue);
model.Min = Convert.ToDouble(txtMin.Text);
model.MAX = Convert.ToDouble(txtMax.Text);
model.Condition = Convert.ToInt32(ddlCondition.SelectedValue);
model.a0 = Convert.ToDouble(txta0.Text);
model.a1 = Convert.ToDouble(txta1.Text);
model.Contact = txtContact.Text + ",";
model.Format = txtFormat.Text;
model.Units = txtUnit.Text;
if (btnSave.Text == "Save")
{
model.EventConfigID = 0;
bool status = obj.postEventConfig(model);
if (status == true)
{
alert = AlertsClass.SuccessUpdate;
}
else
{
alert = AlertsClass.ErrorWentWrong;
}
}
if (btnSave.Text == "Update")
{
model.EventConfigID = Convert.ToInt32(Session["eventConfigId"]);
bool status = obj.postEventConfig(model);
if (status == true)
{
alert = AlertsClass.SuccessUpdate;
}
else
{
alert = AlertsClass.ErrorWentWrong;
}
}
}
else
{
alert = AlertsClass.ErrorRequired;
}
gridBind(Convert.ToInt32(ddlObject.SelectedValue));
allowStaticMethods("ALerts('" + alert + "');applyDatatable('.gvdEventConfigClass');staticMethod('Disable');");
}
catch (Exception)
{ BindingClass.ExceptionAlertScriptManager(this.Page, this.GetType()); }
}
public EventConfigurationModel GetEventConfigurationById(int ECId)
{
var url = "api/EventConfiguration/" + ECId;
string result = SC.Getcaller(url);
if (result != null)
{
EventConfigurationModel _EventConfigurationModel = JsonConvert.DeserializeObject <EventConfigurationModel>(result);
return(_EventConfigurationModel);
}
else
{
return(null);
}
}
public bool postEventConfig(EventConfigurationModel _object)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@EventConfigID", _object.EventConfigID),
new SqlParameter("@ObjectSensorID", _object.ObjectSensorID),
new SqlParameter("@ObjectID", _object.ObjectID),
new SqlParameter("@Min", _object.Min),
new SqlParameter("@MAX", _object.MAX),
new SqlParameter("@a0", _object.a0),
new SqlParameter("@a1", _object.a1),
new SqlParameter("@Contact", _object.Contact),
new SqlParameter("@Units", _object.Units),
new SqlParameter("@Format", _object.Format),
new SqlParameter("@Condition", _object.Condition),
new SqlParameter("@EnableOrDisable", _object.EnableOrDisable),
};
return(DBHelper.ExecuteNonQuery("uspPOST_EventConfiguration", CommandType.StoredProcedure, parameters));
}
