public List <Inspector> Update()
{
string sql = @"
UPDATE bp_INSPECTORS
SET
Active = @Active,
Name = @Name,
Vehicle = @Vehicle,
RBL = @RBL,
CBL = @CBL,
REL = @REL,
CEL = @CEL,
RME = @RME,
CME = @CME,
RPL = @RPL,
CPL = @CPL,
PrivateProvider = @PrivateProvider,
Fire = @Fire
WHERE
ID = @Id";
var i = Constants.Exec_Query <Inspector>(sql, this, Constants.csWATSC);
if (i > -1)
{
Inspector.UpdateInspectorCache();
return(GetCachedInspectors());
}
return(new List <Inspector>());
}
public Inspector Insert()
{
string sql = @"
INSERT INTO bp_INSPECTORS (
PhoneNbr,
Name,
Intl,
Active,
Vehicle,
RBL,
CBL,
REL,
CEL,
RME,
CME,
RPL,
CPL,
PrivateProvider,
Fire,
Color
)
VALUES (
'',
@Name,
@Intl,
@Active,
@Vehicle,
@RBL,
@CBL,
@REL,
@CEL,
@RME,
@CME,
@RPL,
@CPL,
@PrivateProvider,
@Fire,
@Color
);
SELECT
id,
Active,
Intl,
LTRIM(RTRIM(Name)) Name,
ISNULL(Color, '') Color,
Vehicle,
RBL,
CBL,
REL,
CEL,
RME,
CME,
RPL,
CPL,
PrivateProvider,
Fire
FROM bp_INSPECTORS
WHERE Id = @@IDENTITY;";
var inspectors = Constants.Get_Data <Inspector>(sql, this, Constants.csWATSC);
if (inspectors.Count() == 1)
{
Inspector.UpdateInspectorCache();
return(inspectors.First());
}
return(null);
}
