public JsonResult InsertWifiSettings(FM_TrackerWifiSetting wifimodel) { try { var result = model.Insert_WifiSettings("Insert_TrackerWifiSettings", wifimodel); bool ConnectionEstb = CreateTCPClient(); if (wifimodel.WifiStatus) { if (!ConnectionEstb) { //Connection Failed return(this.Json(new { success = false, message = ErrorMsg.ToString() })); } bool retval = ServerCommunication(wifimodel.TrackerID.ToString(), "5870", wifimodel.SSID, wifimodel.WifiPassword, wifimodel.WifiStatus); if (!retval) { //failure message removed as per requirement. return(this.Json(new { success = false, message = ErrorMsg.ToString(), wifimodel.SSID, wifimodel.WifiPassword, wifimodel.WifiStatus })); } } else if (!wifimodel.WifiStatus) { bool retval = ServerCommunication(wifimodel.TrackerID.ToString(), "5870", "", "", wifimodel.WifiStatus); } return(Json(new { success = true })); } catch (Exception ex) { return(this.Json(new { success = false, message = ex.ToString() })); } }
public int Insert_WifiSettings(string Filter, FM_TrackerWifiSetting fm_trackerwifisettings) { try { return(model.Insert_WifiSettings(Filter, fm_trackerwifisettings)); } catch (Exception ex) { throw ex; } }
//Fleet Replay Records End public int Insert_WifiSettings(string Filter, FM_TrackerWifiSetting fm_wifistngs) { SqlCommand loCommand = DataContext.OpenConnection(); try { loCommand = DataContext.SetStoredProcedure(loCommand, "FM_ManageFleetSettings"); loCommand = DataContext.StartTransaction(loCommand); bool result = DataContext.ExecuteNonQuery(DataContext.AddParameters(loCommand, "@Filter", Filter, "@IsAppliedStatus", fm_wifistngs.IsAppliedStatus, "@WifiStatus", fm_wifistngs.WifiStatus, "@SSID", fm_wifistngs.SSID, "@Password", fm_wifistngs.WifiPassword, "@IsAppliedSSID", fm_wifistngs.IsAppliedSSID, "@IsAppliedPwd", fm_wifistngs.IsAppliedPwd, "@TrackerSerialNo", fm_wifistngs.TrackerID)); DataContext.EndTransaction(loCommand); return(Convert.ToInt32(result)); } catch (Exception ex) { throw ex; } finally { DataContext.CloseConnection(loCommand); } }