public int InsertSave(NetworkLogData data)
{
int _return = Insert(data);
_niEntities.SaveChanges();
return(_return);
}
public int UpdateIncidentIdSave(NetworkLogData data)
{
int _return = UpdateIncidentId(data);
if (_return > 0)
{
_niEntities.SaveChanges();
}
return(_return);
}
//
// Return one row of NetworkLog
//
public NetworkLogData GetByPrimaryKey(long networkLogId)
{
NetworkLogData _networkLog = null;
var _networkLogs = ListNetworkLogQueryable()
.Where(_r => _r.NetworkLogId == networkLogId);
if (_networkLogs.Count() > 0)
{
_networkLog = _networkLogs.First();
}
return(_networkLog);
}
//
/// <summary>
/// Extension method...
/// can be called fluently by the class or as a static method.
/// </summary>
/// <param name="networkLog"></param>
/// <returns>a populated NetworkLogData class</returns>
public static NetworkLog ToNetworkLog(this NetworkLogData networkLog)
{
return(new NetworkLog()
{
NetworkLogId = networkLog.NetworkLogId,
ServerId = networkLog.ServerId,
IncidentId = networkLog.IncidentId,
IPAddress = networkLog.IPAddress,
NetworkLogDate = networkLog.NetworkLogDate,
Log = networkLog.Log,
IncidentTypeId = networkLog.IncidentTypeId,
});
}
//
// Insert one row into NetworkLog
//
public int Insert(NetworkLogData data)
{
int _return = 0;
NetworkLog _networkLog = new NetworkLog();
_networkLog.ServerId = data.ServerId;
_networkLog.IPAddress = data.IPAddress;
_networkLog.NetworkLogDate = data.NetworkLogDate;
_networkLog.Log = data.Log;
_networkLog.IncidentTypeId = data.IncidentTypeId;
_niEntities.NetworkLogs.Add(_networkLog);
_return = 1; // one row updated
return(_return);
}
//
// Update one row of NetworkLog
//
public int UpdateIncidentId(NetworkLogData data)
{
int _return = 0;
var _networkLogs =
from _r in _niEntities.NetworkLogs
where _r.NetworkLogId == data.NetworkLogId
select _r;
if (_networkLogs.Count() > 0)
{
NetworkLog _networkLog = _networkLogs.First();
if (_networkLog.IncidentId != data.IncidentId)
{
_networkLog.IncidentId = data.IncidentId;
}
_return = 1; // one row updated
}
return(_return);
}
