public bool Finalize() { string Query = string.Empty; string finalizeDate = DataFormat.DateToDB(System.DateTime.Now.ToShortDateString()); Query = "UPDATE Expense_Details SET Finalized = " + finalizeDate + " WHERE Finalized=0"; if (_dbHelper.ExecuteNonQuery(Query) > 0) { return(true); } else { return(false); } }
public bool UpdateFinalizationDetails() { string Query = string.Empty; string finalizeDate = DataFormat.DateToDB(System.DateTime.Now.ToShortDateString()); Query = "UPDATE Finalization_Details SET Finalize_Date = '" + DataFormat.GetCurrentDate() + "' WHERE IsDeleted=0"; if (_dbHelper.ExecuteNonQuery(Query) > 0) { return(true); } else { return(false); } }