public bool Delete(Int32 itemId, Dbase database = null) { var sql = @"DELETE FROM Items WHERE ID=@ID"; var di = new DbItem("ID", itemId); return(DbaseTools.ExecuteNonQuery(database, sql, di)); }
public static bool Delete(Int32 id) { var sql = @"DELETE FROM Company WHERE ID=@ID"; var di = new DbItem("ID", id); return(DbaseTools.ExecuteNonQuery(null, sql, di)); }
public bool DeleteByProposalId(Int32 proposalId, Dbase database = null) { var sql = @"DELETE FROM Items WHERE ProposalID=@PropoosalID"; var di = new DbItem("ProposalID", proposalId); return(DbaseTools.ExecuteNonQuery(database, sql, di)); }
public bool Delete(int id, Dbase database = null) { var sql = @"DELETE FROM Proposals WHERE ID=@ID"; var di = new DbItem("ID", id); return(DbaseTools.ExecuteNonQuery(database, sql, di)); }
public int Save(Dbase database = null) { var result = false; var id = 0; var sqlu = @"UPDATE Proposals SET ProposalName=@ProposalName, DateSaved=@DateSaved, CompanyName=@CompanyName, CompanyAddress=@CompanyAddress, CompanyCity=@CompanyCity, CompanyPIN=@CompanyPIN, CompanyPhone=@CompanyPhone, CompanyFax=@CompanyFax, CompanyEmail=@CompanyEmail, CompanyIBAN=@CompanyIBAN, ClientName=@ClientName, ClientAddress=@ClientAddress, ClientCity=@ClientCity, ClientPhone=@ClientPhone, ClientEmail=@ClientEmail, ClientPIN=@ClientPIN, ItemsTitle=@ItemsTitle, Amount=@Amount, Tax=@Tax, Total=@Total, Note=@Note, Signature=@Signature WHERE ID=@ID AND UserID=@UserID"; var sqli = @"INSERT INTO Proposals (ProposalName, DateSaved, UserID, CompanyName, CompanyAddress, CompanyCity, CompanyPIN, CompanyPhone, CompanyFax, CompanyEmail, CompanyIBAN, ClientName, ClientAddress, ClientCity, ClientPhone, ClientEmail, ClientPIN, ItemsTitle, Amount, Tax, Total, Note, Signature) VALUES (@ProposalName, @DateSaved, @UserID, @CompanyName, @CompanyAddress, @CompanyCity, @CompanyPIN, @CompanyPhone, @CompanyFax, @CompanyEmail, @CompanyIBAN, @ClientName, @ClientAddress, @ClientCity, @ClientPhone, @ClientEmail, @ClientPIN, @ItemsTitle, @Amount, @Tax, @Total, @Note, @Signature)"; var closeDb = (database == null); Db = DbaseTools.CreateDbase(database); try { if (!Db.Opened) { Db.Open(); } result = DbaseTools.ExecuteNonQuery(Db, sqlu, this); if (!result) { result = DbaseTools.ExecuteNonQuery(Db, sqli, this); if (result) { id = Convert.ToInt32(Db.ExecuteScalar(@"SELECT @@IDENTITY")); SetValue("ID", id); } } } catch (Exception ex) { log.Error("DbProposals, Save: error", ex); } if (closeDb) { Db.Close(); Db.Dispose(); Db = null; } //return result; return((result == false) ? -1 : id); }
public bool Save(Dbase database = null) { var result = false; var sqlu = @"UPDATE Company SET UserID=@UserID, CompanyName=@CompanyName, CompanyAddress=@CompanyAddress, CompanyCity=@CompanyCity, CompanyPIN=@CompanyPIN, CompanyPhone=@CompanyPhone, CompanyFax=@CompanyFax, CompanyEmail=@CompanyEmail, CompanyIBAN=@CompanyIBAN WHERE ID=@ID"; var sqli = @"INSERT INTO Company (UserID, CompanyName, CompanyAddress, CompanyCity, CompanyPIN, CompanyPhone, CompanyFax, CompanyEmail, CompanyIBAN) VALUES (@UserID, @CompanyName, @CompanyAddress, @CompanyCity, @CompanyPIN, @CompanyPhone, @CompanyFax, @CompanyEmail, @CompanyIBAN)"; var closeDb = (database == null); Db = DbaseTools.CreateDbase(database); try { if (!Db.Opened) { Db.Open(); } result = DbaseTools.ExecuteNonQuery(Db, sqlu, this); if (!result) { result = DbaseTools.ExecuteNonQuery(Db, sqli, this); if (result) { SetValue("ID", Convert.ToInt32(Db.ExecuteScalar(@"SELECT @@IDENTITY"))); } } } catch (Exception ex) { log.Error("DbCompany, Save: error", ex); } if (closeDb) { Db.Close(); Db.Dispose(); Db = null; } return(result); }
public bool Save(Dbase database = null) { var result = false; var sqlu = @"UPDATE Items SET ProposalID=@ProposalID, ItemNumber=@ItemNumber, ItemText=@ItemText, Unit=@Unit, Quantity=@Quantity, UnitPrice=@UnitPrice, TotalPrice=@TotalPrice WHERE ID=@ID"; var sqli = @"INSERT INTO Items (ProposalID, ItemNumber, ItemText, Unit, Quantity, UnitPrice, TotalPrice) VALUES (@ProposalID, @ItemNumber, @ItemText, @Unit, @Quantity, @UnitPrice, @TotalPrice)"; var closeDb = (database == null); Db = DbaseTools.CreateDbase(database); try { if (!Db.Opened) { Db.Open(); } result = DbaseTools.ExecuteNonQuery(Db, sqlu, this); if (!result) { result = DbaseTools.ExecuteNonQuery(Db, sqli, this); if (result) { SetValue("ID", Convert.ToInt32(Db.ExecuteScalar(@"SELECT @@IDENTITY"))); } } } catch (Exception ex) { log.Error("DbItems, Save: error", ex); } if (closeDb) { Db.Close(); Db.Dispose(); Db = null; } return(result); }
public bool Save(Dbase database = null) { var result = false; var sqlu = @"UPDATE [User] SET Role=@Role, Username=@Username, Password=@Password, Email=@Email, Permission=@Permission, Deleted=@Deleted WHERE ID=@ID"; var sqli = @"INSERT INTO [User] (Role, Username, Password, Email, Permission, Deleted) VALUES (@Role, @Username, @Password, @Email, @Permission, @Deleted)"; var closeDb = (database == null); Db = DbaseTools.CreateDbase(database); try { if (!Db.Opened) { Db.Open(); } result = DbaseTools.ExecuteNonQuery(Db, sqlu, this); if (!result) { result = DbaseTools.ExecuteNonQuery(Db, sqli, this); if (result) { SetValue("ID", Convert.ToInt32(Db.ExecuteScalar(@"SELECT @@IDENTITY"))); } } } catch (Exception ex) { log.Error("DbUser, Save: error", ex); } if (closeDb) { Db.Close(); Db.Dispose(); Db = null; } return(result); }
public bool Delete() { var sql = @"DELETE FROM User WHERE ID=@ID"; return(DbaseTools.ExecuteNonQuery(null, sql, this)); }