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