protected override String DoIt()
{
VAdvantage.Model.X_C_Contract contract = new VAdvantage.Model.X_C_Contract(GetCtx(), contractID, Get_TrxName());
DateTime start = (DateTime)contract.GetBillStartDate();
DateTime end = (DateTime)contract.GetEndDate();
int frequency = contract.GetC_Frequency_ID();
string Sql = "SELECT NoofMonths FROM C_Frequency WHERE C_Frequency_ID=" + frequency;
int months = Util.GetValueOfInt(DB.ExecuteScalar(Sql, null, Get_TrxName()));
int count = Util.GetValueOfInt(contract.GetTotalInvoice());
for (int i = 1; i <= count; i++)
{
VAdvantage.Model.X_C_ContractSchedule CSchedule = new VAdvantage.Model.X_C_ContractSchedule(GetCtx(), 0, Get_TrxName());
//Neha ---Set Tenant, Organization On Invoice Schedule when we create Invoice Schedule from Schedule Contract button on header--12 Sep,2018
CSchedule.SetAD_Client_ID(contract.GetAD_Client_ID());
CSchedule.SetAD_Org_ID(contract.GetAD_Org_ID());
//-----------------------End--------------------
CSchedule.SetC_Contract_ID(contractID);
CSchedule.SetC_BPartner_ID(contract.GetC_BPartner_ID());
CSchedule.SetFROMDATE(start);
CSchedule.SetProcessed(true);
CSchedule.SetUnitsDelivered(contract.GetQtyEntered());
CSchedule.SetFROMDATE(start);
DateTime toDate = start.AddMonths(months);
toDate = toDate.AddDays(-1);
CSchedule.SetEndDate(toDate);
start = start.AddMonths(months);
// if (i != count)
// {
// CSchedule.SetNoOfDays(days);
// }
// else
// {
// CSchedule.SetEndDate(end);
// CSchedule.SetNoOfDays((end - start).Days+1);
// }
CSchedule.SetM_Product_ID(contract.GetM_Product_ID());
// Added by Vivek on 21/11/2017 asigned by Pradeep
CSchedule.SetM_AttributeSetInstance_ID(contract.GetM_AttributeSetInstance_ID());
CSchedule.SetTotalAmt(contract.GetLineNetAmt());
CSchedule.SetGrandTotal(contract.GetGrandTotal());
CSchedule.SetTaxAmt(contract.GetTaxAmt());
// if Surcharge Tax is selected on Tax, then set value in Surcharge Amount
if (CSchedule.Get_ColumnIndex("SurchargeAmt") > 0)
{
CSchedule.SetSurchargeAmt(contract.GetSurchargeAmt());
}
CSchedule.SetC_UOM_ID(contract.GetC_UOM_ID());
CSchedule.SetPriceEntered(contract.GetPriceEntered());
if (CSchedule.Save())
{
contract.SetProcessed(true);
contract.SetScheduleContract("Y");
contract.Save();
}
else
{
//Neha----If Invoice Shedule not saved then will show the exception---12 Sep,2018
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Cannot save Invoice Schedule. " + pp.GetName());
}
throw new ArgumentException("Cannot save Invoice Schedule.");
}
}
return(Msg.GetMsg(GetCtx(), "ContractScheduleDone"));
}
