public String CreateNewFiscalYear(String fiscalYear)
{
String message = String.Empty;
RetrieveFromDB rtrv = new RetrieveFromDB();
UpdateDatabase updDB = new UpdateDatabase();
DataSet ds = rtrv.CheckCategoriesBeforeNewFiscalYear(fiscalYear);
if (int.Parse(ds.Tables[0].Rows[4][1].ToString()) != 0)
{
message = "Fiscal year " + fiscalYear + " already exists.";
}
else if (int.Parse(ds.Tables[0].Rows[3][1].ToString()) != 0 & int.Parse(ds.Tables[0].Rows[2][1].ToString()) != 0 && int.Parse(ds.Tables[0].Rows[1][1].ToString()) != 0 && int.Parse(ds.Tables[0].Rows[0][1].ToString())!= 0 )
{
message = "1";
updDB.UpdateNulls(fiscalYear);
updDB.RevenueSummaryInsert(fiscalYear);
}
else
{
if (int.Parse(ds.Tables[0].Rows[3][1].ToString()) == 0)
{
message = "CHG";
}
if (int.Parse(ds.Tables[0].Rows[1][1].ToString()) == 0)
{
if (message == String.Empty)
{
message = "Assessments";
}
else
{
message = message + ", Assessments";
}
}
if (int.Parse(ds.Tables[0].Rows[2][1].ToString()) == 0)
{
if (message == String.Empty)
{
message = "Expendutries";
}
else
{
message = message + ", Expendutries";
}
}
if (int.Parse(ds.Tables[0].Rows[0][1].ToString()) == 0)
{
if (message == String.Empty)
{
message = "Allocated Costs";
}
else
{
message = message + ", Allocated Costs";
}
}
message = "Fiscal year " + fiscalYear + " has not been created. In order to create the fiscal year please submit " + message + ".";
}
return message;
}
