protected void linkbtnEdit_Command(object sender, CommandEventArgs e)
{
try
{
if (e.CommandName == "UpdateID")
{
allowStaticMethods("applyDatatable('.gvdObjectClass'); staticMethod('Enable');");
int cmdArg = Convert.ToInt32(e.CommandArgument);
ObjectModelDLL li = obj.getObjectByObjectID(cmdArg);
ddlClient.SelectedValue = li.ClientID.ToString();
txtObjectName.Text = li.Name;
txtAddress.Text = li.Address;
txtLat.Text = li.LAT.ToString();
txtLong.Text = li.LONG.ToString();
txtIMEI.Text = li.IMEI.ToString();
txtSimNumber.Text = li.SimNumber.ToString();
txtFirmWareVersion.Text = li.FirmWareVersion;
txtHardwareVersion.Text = li.HardwareVersion;
txtContact.Text = li.Contact + ",";
ddlDeviceType.SelectedValue = "1";
chkRelaySt.Checked = Convert.ToBoolean(li.RelayStatus);
chkRelaySt.Checked = Convert.ToBoolean(li.RelayStatus);
Session["ObjectId"] = cmdArg.ToString();
btnAddObject.Text = "Update";
}
}
catch (Exception)
{ BindingClass.ExceptionAlertScriptManager(this.Page, this.GetType()); }
}
public ObjectModelDLL getObjectByObjectID(int objectID)
{
ObjectModelDLL model = null;
string query = "Select * from [Objects] where ObjectID = @ObjectID";
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ObjectID", objectID),
};
using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand(query, CommandType.Text, parameters))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
model = new ObjectModelDLL();
model.ClientID = Convert.ToInt32(row["ClientID"]);
model.Name = row["Name"].ToString();
model.Address = row["Address"].ToString();
model.LAT = Convert.ToDouble(row["LAT"]);
model.LONG = Convert.ToDouble(row["LONG"]);
model.IMEI = Convert.ToInt64(row["IMEI"]);
model.SimNumber = Convert.ToInt64(row["SimNumber"]);
model.FirmWareVersion = row["FirmWareVersion"].ToString();
model.HardwareVersion = row["HardwareVersion"].ToString();
model.Contact = row["Contact"].ToString();
model.ObjectType = row["ObjectType"].ToString();
model.RelayStatus = Convert.ToBoolean(row["RelayStatus"]);
}
}
return(model);
}
public List <ObjectModelDLL> getObjectList(int clientID)
{
List <ObjectModelDLL> list = new List <ObjectModelDLL>();
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ClientID", clientID)
};
using (DataTable table = DBHelper.ExecuteParamerizedSelectCommand("uspGET_ObjectListsByClient", CommandType.StoredProcedure, parameters))
{
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
ObjectModelDLL model = new ObjectModelDLL();
model.ObjectID = Convert.ToInt32(row["ObjectID"]);
model.Name = row["Name"].ToString();
model.Address = row["Address"].ToString();
model.LAT = Convert.ToDouble(row["LAT"]);
model.LONG = Convert.ToDouble(row["LONG"]);
model.IMEI = Convert.ToInt64(row["IMEI"]);
model.SimNumber = Convert.ToInt64(row["SimNumber"]);
model.FirmWareVersion = row["FirmWareVersion"].ToString();
model.HardwareVersion = row["HardwareVersion"].ToString();
model.ClientID = Convert.ToInt32(row["ClientID"]);
model.Contact = row["Contact"].ToString();
model.ObjectType = row["ObjectType"].ToString();
model.RelayStatus = Convert.ToBoolean(row["RelayStatus"]);
model.CreatedDateTime = Convert.ToDateTime(row["CreatedDateTime"]);
list.Add(model);
}
}
}
return(list);
}
public bool postObject(ObjectModelDLL _object)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@ObjectID", _object.ObjectID),
new SqlParameter("@Name", _object.Name),
new SqlParameter("@Address", _object.Address),
new SqlParameter("@LAT", _object.LAT),
new SqlParameter("@LONG", _object.LONG),
new SqlParameter("@IMEI", _object.IMEI),
new SqlParameter("@SimNumber", _object.SimNumber),
new SqlParameter("@FirmWareVersion", _object.FirmWareVersion),
new SqlParameter("@HardwareVersion", _object.HardwareVersion),
new SqlParameter("@ClientID", _object.ClientID),
new SqlParameter("@Contact", _object.Contact),
new SqlParameter("@ObjectType", _object.ObjectType),
new SqlParameter("@RelayStatus", _object.RelayStatus),
};
return(DBHelper.ExecuteNonQuery("uspPOST_Object", CommandType.StoredProcedure, parameters));
}
protected void btnAddObject_Click(object sender, EventArgs e)
{
try
{
if (ddlClient.SelectedValue != "0" && ddlDeviceType.SelectedValue != "0" && txtObjectName.Text != "" && txtAddress.Text != "" && txtLat.Text != "" && txtLong.Text != "" && txtIMEI.Text != "" && txtSimNumber.Text != "" && txtFirmWareVersion.Text != "" && txtHardwareVersion.Text != "")
{
bool RStatus = chkRelaySt.Checked ? true : false;
ObjectModelDLL model = new ObjectModelDLL();
model.Name = txtObjectName.Text;
model.Address = txtAddress.Text;
model.LAT = Convert.ToDouble(txtLat.Text);
model.LONG = Convert.ToDouble(txtLong.Text);
model.IMEI = Convert.ToInt64(txtIMEI.Text);
model.SimNumber = Convert.ToInt64(txtSimNumber.Text);
model.ClientID = Convert.ToInt32(ddlClient.SelectedValue);
model.HardwareVersion = txtHardwareVersion.Text;
model.FirmWareVersion = txtFirmWareVersion.Text;
model.ObjectType = ddlDeviceType.SelectedItem.Text;
model.Contact = txtContact.Text + ",";
model.RelayStatus = RStatus;
if (btnAddObject.Text == "Save")
{
model.ObjectID = 0;
bool exist = obj.objectExist(model.IMEI.ToString());
if (exist == false)
{
bool status = obj.postObject(model);
if (status == true)
{
alert = AlertsClass.SuccessAdd;
}
else
{
alert = AlertsClass.ErrorWentWrong;
}
}
else
{
{ alert = AlertsClass.ErrorExist("IMEI"); }
}
}
if (btnAddObject.Text == "Update")
{
model.ObjectID = Convert.ToInt32(Session["ObjectId"]);
bool status = obj.postObject(model);
if (status == true)
{
alert = AlertsClass.SuccessAdd;
}
else
{
alert = AlertsClass.ErrorWentWrong;
}
}
}
else
{
alert = AlertsClass.ErrorRequired;
}
clearControls();
GridBind();
allowStaticMethods("ALerts('" + alert + "');applyDatatable('.gvdObjectClass'); staticMethod('Disable'); phonenumber();");
}
catch (Exception)
{ BindingClass.ExceptionAlertScriptManager(this.Page, this.GetType()); }
}
public bool postObject(ObjectModelDLL _object)
{
return(obj.postObject(_object));
}
