public static TotalAmount GetTotalAmount()
{
var result = new TotalAmount();
try
{
using (DBHelper helper = new DBHelper())
{
DataRowCollection dataRowCollection = helper.GetDataRowCollection("SELECT * FROM TotalAmount");
for (int i = 0; i < dataRowCollection.Count; i++)
{
DataRow row = dataRowCollection[i];
TotalAmount currentAmount = new TotalAmount();
if (!string.IsNullOrEmpty(row["Amount"].ToString()))
{
currentAmount.Amount = ((double)row["Amount"]);
}
result = currentAmount;
}
}
}
catch (Exception cEx)
{
//Diagnostics.RegisterError("SQL error during deleting folder: " + cEx.Message, cEx);
//throw new CoreException(cEx.Message, cEx);
}
return(result);
}
public static bool ChangeTotalAmount(TotalAmount total)
{
bool result = false;
try
{
using (DBHelper helper = new DBHelper())
{
helper.AddSQLCommandParameter("Amount", total.Amount);
helper.Execute("UPDATE TotalAmount SET Amount=@Amount");
result = true;
}
}
catch (Exception ex) { result = false; }
return(result);
}