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