/// <summary>
///
/// </summary>
/// <returns></returns>
protected override string DoIt()
{
mf = new X_C_MasterForecast(GetCtx(), GetRecord_ID(), null);
if (mf.IsProcessed())
{
C_Period_ID = mf.GetC_Period_ID();
sql = "select * from c_masterforecast where c_period_id = " + C_Period_ID + " and ad_client_ID = " + GetCtx().GetAD_Client_ID();
IDataReader idr = null;
try
{
// bool opp = false;
idr = DB.ExecuteReader(sql, null, null);
while (idr.Read())
{
sql = "update c_masterforecast set currentversion = 'N' where ad_client_id = " + GetCtx().GetAD_Client_ID() + " and c_masterforecast_id = " + Util.GetValueOfInt(idr["C_MasterForecast_ID"]);
int res = Util.GetValueOfInt(DB.ExecuteQuery(sql, null, null));
//string check = Util.GetValueOfString(idr["IsIncludeOpp"]);
//if (check == "Y")
//{
// opp = true;
//}
}
idr.Close();
if (_includeOpp)
{
CreateMasterForecast(_includeOpp);
GenerateLines();
}
else
{
CreateMasterForecast(_includeOpp);
GenerateLines();
}
msg = Msg.GetMsg(GetCtx(), "NewVersionIsCreatedSuccessfully");
}
catch
{
if (idr != null)
{
idr.Close();
}
}
finally
{
if (idr != null)
{
idr.Close();
}
}
}
else
{
msg = Msg.GetMsg("ProcessRecordFirst", "ProcessRecordFirst");
}
return(msg);
}