public int Update(IncidentTypeData incidentType)
{
int _return = 0;
var _incidentTypes =
from _r in _niEntities.IncidentTypes
where _r.IncidentTypeId == incidentType.IncidentTypeId
select _r;
if (_incidentTypes.Count() > 0)
{
IncidentType _incidentType = _incidentTypes.First();
_incidentType.IncidentTypeShortDesc = incidentType.IncidentTypeShortDesc;
_incidentType.IncidentTypeDesc = incidentType.IncidentTypeDesc;
_incidentType.IncidentTypeFromServer = incidentType.IncidentTypeFromServer;
_incidentType.IncidentTypeSubjectLine = incidentType.IncidentTypeSubjectLine;
_incidentType.IncidentTypeEmailTemplate = incidentType.IncidentTypeEmailTemplate;
_incidentType.IncidentTypeTimeTemplate = incidentType.IncidentTypeTimeTemplate;
_incidentType.IncidentTypeThanksTemplate = incidentType.IncidentTypeThanksTemplate;
_incidentType.IncidentTypeLogTemplate = incidentType.IncidentTypeLogTemplate;
_incidentType.IncidentTypeTemplate = incidentType.IncidentTypeTemplate;
_niEntities.SaveChanges();
_return = 1; // one row updated
}
return(_return);
}
//
/// <summary>
/// Return one row of IncidentType
/// </summary>
/// <param name="incidentTypeShortDesc"></param>
/// <returns></returns>
public IncidentTypeData GetByShortDesc(string incidentTypeShortDesc)
{
IncidentTypeData _incidentType = null;
var _incidentTypes = ListIncidentTypeQueryable()
.Where(_r => _r.IncidentTypeShortDesc == incidentTypeShortDesc);
if (_incidentTypes.Count() > 0)
{
_incidentType = _incidentTypes.First();
}
return(_incidentType);
}
//
/// <summary>
/// Return one row of IncidentType
/// </summary>
/// <param name="incidentTypeId">Incident type id</param>
/// <returns>A single IncidentTypeData or null</returns>
public IncidentTypeData GetByPrimaryKey(int incidentTypeId)
{
IncidentTypeData _incidentType = null;
var _incidentTypes = ListIncidentTypeQueryable()
.Where(_r => _r.IncidentTypeId == incidentTypeId);
if (_incidentTypes.Count() > 0)
{
_incidentType = _incidentTypes.First();
}
return(_incidentType);
}
public IncidentTypeData Insert(IncidentTypeData incidentType)
{
if (_niEntities.IncidentTypes.Where(
_r => _r.IncidentTypeShortDesc == incidentType.IncidentTypeShortDesc).Count() == 0
)
{
IncidentType _incidentType = new IncidentType();
_incidentType.IncidentTypeShortDesc = incidentType.IncidentTypeShortDesc;
_incidentType.IncidentTypeDesc = incidentType.IncidentTypeDesc;
_incidentType.IncidentTypeFromServer = incidentType.IncidentTypeFromServer;
_incidentType.IncidentTypeSubjectLine = incidentType.IncidentTypeSubjectLine;
_incidentType.IncidentTypeEmailTemplate = incidentType.IncidentTypeEmailTemplate;
_incidentType.IncidentTypeTimeTemplate = incidentType.IncidentTypeTimeTemplate;
_incidentType.IncidentTypeThanksTemplate = incidentType.IncidentTypeThanksTemplate;
_incidentType.IncidentTypeLogTemplate = incidentType.IncidentTypeLogTemplate;
_incidentType.IncidentTypeTemplate = incidentType.IncidentTypeTemplate;
_niEntities.IncidentTypes.Add(_incidentType);
_niEntities.SaveChanges();
//
incidentType.IncidentTypeId = _incidentType.IncidentTypeId;
return(incidentType);
}
return(null);
}