/// <summary>
/// Generate Contract Invoice
/// </summary>
/// <param name="contSchedule"></param>
private void GenerateInvoice(VAdvantage.Model.X_C_ContractSchedule contSchedule)
{
if (contSchedule.IsActive())
{
int res = 0;
sql.Clear();
sql.Append(MRole.GetDefault(GetCtx()).AddAccessSQL("SELECT MIN(C_DOCTYPE_ID) FROM C_DocType WHERE DOCBASETYPE='ARI' AND ISACTIVE ='Y'", "C_DocType", true, true));
int C_DocType_ID = Util.GetValueOfInt(DB.ExecuteScalar(sql.ToString(), null, Get_TrxName()));
// sql = "select noofdays from c_frequency where c_frequency_id = " + cont.GetC_Frequency_ID();
// Decimal? days = Util.GetValueOfDecimal(DB.ExecuteScalar(sql, null, null));
Decimal?price = null;
if (!cont.IsCancel())
{
price = Decimal.Multiply(cont.GetPriceEntered(), cont.GetQtyEntered());
}
else
{
sql.Clear();
sql.Append("UPDATE C_Contract SET RenewalType = NULL WHERE C_Contract_ID = " + cont.GetC_Contract_ID());
int res2 = Util.GetValueOfInt(DB.ExecuteQuery(sql.ToString(), null, Get_TrxName()));
if (contSchedule.GetEndDate() <= cont.GetCancellationDate())
{
price = Decimal.Multiply(cont.GetPriceEntered(), cont.GetQtyEntered());
}
else
{
sql.Clear();
sql.Append("SELECT MAX(C_ContractSchedule_ID) FROM C_ContractSchedule WHERE NVL(C_INVOICE_ID,0) > 0 AND C_Contract_ID = " + cont.GetC_Contract_ID());
int c_contractschedule_id = Util.GetValueOfInt(DB.ExecuteScalar(sql.ToString(), null, Get_TrxName()));
if (c_contractschedule_id != 0)
{
string date = cont.GetCancellationDate().Value.ToString("dd-MMM-yyyy");
sql.Clear();
sql.Append("SELECT DaysBetween('" + date + "', EndDate) FROM C_ContractSchedule WHERE C_ContractSchedule_ID = " + c_contractschedule_id);
Decimal?diffDays = Util.GetValueOfDecimal(DB.ExecuteScalar(sql.ToString(), null, Get_TrxName()));
price = Decimal.Multiply(cont.GetPriceEntered(), cont.GetQtyEntered());
sql.Clear();
sql.Append("UPDATE C_ContractSchedule SET IsActive = 'N' WHERE EndDate > '" + date + "' AND C_Contract_ID = " + cont.GetC_Contract_ID());
res = Util.GetValueOfInt(DB.ExecuteQuery(sql.ToString(), null, Get_TrxName()));
}
else
{
sql.Clear();
sql.Append("SELECT DaysBetween(CancellationDate, StartDate) FROM C_Contract WHERE C_Contract_ID = " + cont.GetC_Contract_ID());
Decimal?diffDays = Util.GetValueOfDecimal(DB.ExecuteScalar(sql.ToString(), null, Get_TrxName()));
price = Decimal.Multiply(cont.GetPriceEntered(), cont.GetQtyEntered());
if (diffDays > 0)
{
sql.Clear();
sql.Append("UPDATE C_ContractSchedule SET IsActive = 'N' WHERE C_Contract_ID = " + cont.GetC_Contract_ID());
res = Util.GetValueOfInt(DB.ExecuteQuery(sql.ToString(), null, Get_TrxName()));
}
else
{
sql.Clear();
sql.Append("UPDATE C_ContractSchedule SET IsActive = 'N' WHERE C_Contract_ID = " + cont.GetC_Contract_ID());
res = Util.GetValueOfInt(DB.ExecuteQuery(sql.ToString(), null, Get_TrxName()));
}
}
}
}
price = Decimal.Round(price.Value, 2, MidpointRounding.AwayFromZero);
inv = new VAdvantage.Model.MInvoice(GetCtx(), 0, Get_TrxName());
inv.SetAD_Client_ID(cont.GetAD_Client_ID());
inv.SetAD_Org_ID(cont.GetAD_Org_ID());
inv.SetC_BPartner_ID(cont.GetC_BPartner_ID());
if (Util.GetValueOfInt(cont.GetC_Order_ID()) != 0)
{
inv.SetC_Order_ID(cont.GetC_Order_ID());
}
// JID_0872: System has To pick the Payment Method defined with the Business Partner against whom the Invoice is getting generated.
if (Env.IsModuleInstalled("VA009_"))
{
if (bp.GetVA009_PaymentMethod_ID() > 0)
{
inv.SetVA009_PaymentMethod_ID(bp.GetVA009_PaymentMethod_ID());
}
else
{
throw new ArgumentException(Msg.GetMsg(GetCtx(), "VIS_PaymentMethodNotDefined") + " : " + bp.GetName());
}
}
inv.SetC_DocType_ID(C_DocType_ID);
inv.SetC_DocTypeTarget_ID(C_DocType_ID);
inv.SetC_BPartner_Location_ID(cont.GetBill_Location_ID());
inv.SetC_Currency_ID(cont.GetC_Currency_ID());
inv.SetC_PaymentTerm_ID(cont.GetC_PaymentTerm_ID());
inv.SetC_Campaign_ID(cont.GetC_Campaign_ID());
inv.SetIsSOTrx(true);
inv.SetM_PriceList_ID(cont.GetM_PriceList_ID());
inv.SetSalesRep_ID(cont.GetSalesRep_ID());
inv.SetC_Contract_ID(cont.GetC_Contract_ID());
if (!inv.Save())
{
//Neha----If Invoice not saved then will show the exception---11 Sep,2018
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Cannot save Invoice. " + pp.GetName());
}
throw new ArgumentException("Cannot save Invoice");
}
else
{
VAdvantage.Model.MInvoiceLine invLine = new VAdvantage.Model.MInvoiceLine(GetCtx(), 0, Get_TrxName());
invLine.SetAD_Client_ID(inv.GetAD_Client_ID());
invLine.SetAD_Org_ID(inv.GetAD_Org_ID());
invLine.SetC_Campaign_ID(inv.GetC_Campaign_ID());
invLine.SetC_Invoice_ID(inv.GetC_Invoice_ID());
invLine.SetC_UOM_ID(cont.GetC_UOM_ID());
invLine.SetM_Product_ID(cont.GetM_Product_ID());
// Added by Vivek on 21/11/2017 asigned by Pradeep
invLine.SetM_AttributeSetInstance_ID(cont.GetM_AttributeSetInstance_ID());
if (Util.GetValueOfInt(cont.GetC_OrderLine_ID()) != 0)
{
invLine.SetC_OrderLine_ID(cont.GetC_OrderLine_ID());
}
invLine.SetC_Tax_ID(cont.GetC_Tax_ID());
invLine.SetQty(cont.GetQtyEntered());
invLine.SetQtyEntered(cont.GetQtyEntered());
// invLine.SetQtyInvoiced(1);
// invLine.SetPrice(price.Value);
invLine.SetPriceActual(cont.GetPriceEntered());
invLine.SetPriceEntered(cont.GetPriceEntered());
// invLine.SetPriceLimit(price);
invLine.SetPriceList(cont.GetPriceEntered());
if (!invLine.Save())
{
//Neha----If Invoice Line not saved then will show the exception---11 Sep,2018
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Cannot save Invoice Line. " + pp.GetName());
}
throw new ArgumentException("Cannot save Invoice Line");
}
}
string comp = inv.CompleteIt();
//Neha---If Invoice Completed then Set Document Action, Document Status and Contract on Invoice Header---11 Sep,2018
if (comp == "CO")
{
inv.SetDocAction("CL");
inv.SetDocStatus("CO");
//Neha---Set C_Contract_ID on C_invoice table using MClass object--11 Sep,2018
inv.SetC_Contract_ID(cont.GetC_Contract_ID());
if (!inv.Save())
{
//Neha----If Invoice not saved then will show the exception---11 Sep,2018
ValueNamePair pp = VAdvantage.Logging.VLogger.RetrieveError();
if (pp != null)
{
throw new ArgumentException("Cannot save Invoice. " + pp.GetName());
}
throw new ArgumentException("Cannot save Invoice");
}
}
else
{
//Neha----If Invoice not completed then will show the exception---11 Sep,2018
if (inv.GetProcessMsg() != null)
{
throw new ArgumentException("Cannot complete the Invoice. " + inv.GetProcessMsg());
}
throw new ArgumentException("Cannot complete the Invoice");
}
#region Commented Code
//Neha---Set C_Contract_ID on C_invoice table using MClass object--11 Sep,2018
//sql = "UPDATE c_invoice SET C_Contract_ID = " + cont.GetC_Contract_ID() + " WHERE c_invoice_id = " + inv.GetC_Invoice_ID();
//res = Util.GetValueOfInt(DB.ExecuteQuery(sql, null, null));
//Neha---taxAmt not used in this class----11 Sep,2018
//sql = "SELECT SUM(taxamt) FROM c_invoicetax WHERE c_invoice_id = " + inv.GetC_Invoice_ID();
//Decimal? taxAmt = Util.GetValueOfDecimal(DB.ExecuteScalar(sql, null, null));
# endregion
sql.Clear();
sql.Append("UPDATE C_ContractSchedule SET C_Invoice_ID = " + inv.GetC_Invoice_ID() + ", Processed = 'Y' WHERE C_ContractSchedule_ID = " + contSchedule.GetC_ContractSchedule_ID());
res = Util.GetValueOfInt(DB.ExecuteQuery(sql.ToString(), null, Get_TrxName()));
//Neha---Append Document No. in sb----12 Sep,2018
sb.Append(inv.GetDocumentNo() + ", ");
//_count++;
}
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"));
}
