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