public void AddExpenseItem(string key, string operationExpenseItem, double cost, fad3DataStatus dataStatus, string unit, double unitQuantity, string expenseItemGuid = "")
{
FishingExpenseItemsPerOperation expenseItem = new FishingExpenseItemsPerOperation(key, operationExpenseItem, cost, unit, unitQuantity, dataStatus);
if (dataStatus == fad3DataStatus.statusNew)
{
expenseItemGuid = Guid.NewGuid().ToString();
}
_expenseItemsList.Add(expenseItemGuid, expenseItem);
}
public static (ExpensePerOperation exp, bool success) ReadData(string samplingGuid, bool readComplete = false)
{
ExpensePerOperation exp = new ExpensePerOperation(samplingGuid);
bool success = false;
string sql = $"Select * from tblFishingExpense where SamplingGuid ={{{samplingGuid}}}";
using (var con = new OleDbConnection(global.ConnectionString))
{
using (var dt = new DataTable())
{
con.Open();
var adapter = new OleDbDataAdapter(sql, con);
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
if (double.TryParse(dr["CostOfFishing"].ToString(), out double costOfFishing))
{
SamplingExpenses = $"Cost of fishing: {costOfFishing.ToString()}\r\n";
exp.CostOfFishing = costOfFishing;
}
else
{
SamplingExpenses = $"Cost of fishing: -\r\n";
}
if (double.TryParse(dr["ReturnOfInvestment"].ToString(), out double roi))
{
exp.ReturnOfInvestment = roi;
SamplingExpenses += $"Return of investment: {roi.ToString()}\r\n";
}
else
{
SamplingExpenses += $"Return of investment: -\r\n";
}
if (double.TryParse(dr["IncomeFromFishSold"].ToString(), out double income))
{
exp.IncomeFromFishSale = income;
SamplingExpenses += $"Income from fish sales: {income.ToString()}\r\n";
}
else
{
SamplingExpenses += $"Income from fish sales: -\r\n";
}
if (double.TryParse(dr["FishWeightForConsumption"].ToString(), out double weightFishConsumed))
{
exp.WeightFishConsumed = weightFishConsumed;
SamplingExpenses += $"Weight of fish consumed: {weightFishConsumed.ToString()}";
}
else
{
SamplingExpenses += $"Weight of fish consumed: -";
}
success = true;
}
else
{
SamplingExpenses = "Cost of fishing: -\r\nReturn of investment: -\r\nIncome from fish sales: -\r\nWeight of fish consumed: -";
}
}
if (success)
{
Dictionary <string, FishingExpenseItemsPerOperation> expenseItemsList = new Dictionary <string, FishingExpenseItemsPerOperation>();
sql = $"Select * from tblFishingExpenseItems where SamplingGuid={{{samplingGuid}}}";
//using (var con1 = new OleDbConnection(global.ConnectionString))
//{
using (var dt = new DataTable())
{
//con1.Open();
//var adapter = new OleDbDataAdapter(sql, con1);
var adapter = new OleDbDataAdapter(sql, con);
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
SamplingExpenses += "\r\n\r\nCost items:\r\n";
foreach (DataRow dr in dt.Rows)
{
string key = dr["ExpenseRow"].ToString();
string item = dr["ExpenseItem"].ToString();
double cost = (double)dr["Cost"];
string unit = dr["Unit"].ToString();
double?unitQuantity = null;
if (double.TryParse(dr["UnitQuantity"].ToString(), out double v))
{
unitQuantity = v;
}
FishingExpenseItemsPerOperation expenseItem = new FishingExpenseItemsPerOperation(key, item, cost, unit, unitQuantity, fad3DataStatus.statusFromDB);
SamplingExpenses += $"{item}: {cost.ToString()}\r\n";
exp.AddExpenseItem(key, expenseItem);
}
}
}
//}
}
return(exp, success);
}
}
public void AddExpenseItem(string key, FishingExpenseItemsPerOperation item)
{
_expenseItemsList.Add(key, item);
}