protected override String DoIt()
{
int C_Contract_ID = 0;
String Sql = "Select C_Order_ID from C_OrderLine where C_OrderLine_ID=" + orderLineID;
int orderID = Util.GetValueOfInt(DB.ExecuteScalar(Sql, null, null));
VAdvantage.Model.X_C_Order order = new VAdvantage.Model.X_C_Order(GetCtx(), orderID, null);
// string DocStatus = order.GetDocStatus();
//if (DocStatus != "CO")
//{
// return Msg.GetMsg(GetCtx(), "FirstCompleteOrder");
//}
VAdvantage.Model.X_C_OrderLine line = new VAdvantage.Model.X_C_OrderLine(GetCtx(), orderLineID, null);
if (!line.IsProcessed())
{
return(Msg.GetMsg(GetCtx(), "FirstCompleteOrder"));
}
if (line.IsContract() && line.GetC_Contract_ID() == 0)
{
VAdvantage.Model.X_C_Contract contact = new VAdvantage.Model.X_C_Contract(GetCtx(), 0, null);
VAdvantage.Model.MProductPricing pp = new VAdvantage.Model.MProductPricing(GetCtx().GetAD_Client_ID(), GetCtx().GetAD_Org_ID(),
line.GetM_Product_ID(), order.GetC_BPartner_ID(), line.GetQtyOrdered(), true);
int M_PriceList_ID = Util.GetValueOfInt(order.GetM_PriceList_ID());
pp.SetM_PriceList_ID(M_PriceList_ID);
string sql = "SELECT pl.IsTaxIncluded,pl.EnforcePriceLimit,pl.C_Currency_ID,c.StdPrecision,"
+ "plv.M_PriceList_Version_ID,plv.ValidFrom "
+ "FROM M_PriceList pl,C_Currency c,M_PriceList_Version plv "
+ "WHERE pl.C_Currency_ID=c.C_Currency_ID"
+ " AND pl.M_PriceList_ID=plv.M_PriceList_ID"
+ " AND pl.M_PriceList_ID=" + M_PriceList_ID // 1
+ "ORDER BY plv.ValidFrom DESC";
int M_PriceList_Version_ID = 0;
int C_Currency_ID = 0;
DataSet ds = DB.ExecuteDataset(sql, null);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr1 = ds.Tables[0].Rows[i];
// Tax Included
// bool isTaxIncluded = Util.GetValueOfBool(ds.Tables[0].Rows[i]["IsTaxIncluded"]);
// Price Limit Enforce
// bool isTaxIncluded = Util.GetValueOfBool(ds.Tables[0].Rows[i]["IsTaxIncluded"]);
// Currency
// int ii = Util.GetValueOfInt(dr[2].ToString());
C_Currency_ID = Util.GetValueOfInt(ds.Tables[0].Rows[i]["C_Currency_ID"]);
// int prislst = Util.GetValueOfInt(dr[4].ToString());
// PriceList Version
M_PriceList_Version_ID = Util.GetValueOfInt(ds.Tables[0].Rows[i]["M_PriceList_Version_ID"]);
}
//int M_PriceList_Version_ID = GetCtx().GetContextAsInt(WindowNo, "M_PriceList_Version_ID");
pp.SetM_PriceList_Version_ID(M_PriceList_Version_ID);
contact.SetDescription(order.GetDescription());
contact.SetC_Order_ID(order.GetC_Order_ID());
contact.SetC_OrderLine_ID(line.GetC_OrderLine_ID());
contact.SetStartDate(line.GetStartDate());
contact.SetEndDate(line.GetEndDate());
contact.SetC_BPartner_ID(order.GetC_BPartner_ID());
contact.SetBill_Location_ID(order.GetBill_Location_ID());
contact.SetBill_User_ID(order.GetBill_User_ID());
contact.SetSalesRep_ID(order.GetSalesRep_ID());
contact.SetC_Currency_ID(line.GetC_Currency_ID());
contact.SetC_ConversionType_ID(order.GetC_ConversionType_ID());
contact.SetC_PaymentTerm_ID(order.GetC_PaymentTerm_ID());
contact.SetM_PriceList_ID(order.GetM_PriceList_ID());
contact.SetC_Frequency_ID(line.GetC_Frequency_ID());
contact.SetPriceList(pp.GetPriceList());
contact.SetPriceActual(pp.GetPriceStd());
contact.SetPriceEntered(pp.GetPriceStd());
contact.SetQtyEntered(line.GetQtyPerCycle());
Decimal discount = Decimal.Round(Decimal.Divide(Decimal.Multiply(Decimal.Subtract(pp.GetPriceList(), pp.GetPriceStd()), new Decimal(100)), pp.GetPriceList()), 2);
contact.SetDiscount(discount);
//contact.SetGrandTotal(
// invoice Count Start
DateTime SDate = (DateTime)(line.GetStartDate());
DateTime Edate = (DateTime)(line.GetEndDate());
int frequency = Util.GetValueOfInt(line.GetC_Frequency_ID());
string PSql = "Select NoOfDays from C_Frequency where C_Frequency_ID=" + frequency;
int days = Util.GetValueOfInt(DB.ExecuteScalar(PSql, null, null));
int totaldays = (Edate - SDate).Days;
int count = 1;
if (days > 0)
{
count = totaldays / days;
}
contact.SetTotalInvoice(count);
//invoice Count end
contact.SetC_Project_ID(order.GetC_Project_ID());
// contact.SetPriceList(line.GetPriceList());
//contact.SetPriceActual(line.GetPriceActual());
contact.SetC_UOM_ID(line.GetC_UOM_ID());
contact.SetM_Product_ID(line.GetM_Product_ID());
// contact.SetPriceEntered(line.GetPriceEntered());
//contact.SetQtyEntered(line.GetQtyEntered());
// contact.SetDiscount(line.GetDiscount());
contact.SetC_Tax_ID(line.GetC_Tax_ID());
contact.SetC_Campaign_ID(order.GetC_Campaign_ID());
sql = "select rate from c_tax where c_tax_id = " + line.GetC_Tax_ID();
Decimal?rate = Util.GetNullableDecimal(DB.ExecuteScalar(sql, null, null));
Decimal?amt = Decimal.Multiply(pp.GetPriceStd(), (Decimal.Divide(rate.Value, 100)));
amt = Decimal.Round(amt.Value, 2, MidpointRounding.AwayFromZero);
Decimal?taxAmt = Decimal.Multiply(amt.Value, line.GetQtyPerCycle());
contact.SetTaxAmt(taxAmt);
contact.SetGrandTotal(Decimal.Add(Decimal.Multiply(line.GetQtyPerCycle(), pp.GetPriceStd()), taxAmt.Value));
contact.SetLineNetAmt(Decimal.Multiply(line.GetQtyPerCycle(), pp.GetPriceStd()));
contact.SetDocStatus("DR");
contact.SetRenewContract("N");
if (contact.Save())
{
line.SetC_Contract_ID(contact.GetC_Contract_ID());
if (line.Save())
{
}
}
C_Contract_ID = contact.GetC_Contract_ID();
}
//order.SetCreateServiceContract("Y");
//if (!order.Save())
//{
//}
return(Msg.GetMsg(GetCtx(), "ServiceContractGenerationDone"));
}
/// <summary>
///
/// </summary>
/// <param name="tLine"></param>
private int GenerateInvoice(VAdvantage.Model.X_S_TimeExpenseLine tLine, VAdvantage.Model.X_S_TimeExpense tExp)
{
int C_PaymentTerm_ID = 0;
VAdvantage.Model.X_C_Order ord = null;
if (tLine.GetC_Order_ID() != 0)
{
ord = new VAdvantage.Model.X_C_Order(GetCtx(), tLine.GetC_Order_ID(), null);
}
//sql = "select s_resource_id from s_resource where c_bpartner_id = " + tLine.GetC_BPartner_ID()
// + " and ad_user_id = " + tExp.GetAD_User_ID() + " and m_product_id = " + tLine.GetM_Product_ID() + " and isactive = 'Y'";
//int S_Resource_ID = Util.GetValueOfInt(DB.ExecuteScalar(sql, null, null));
int S_Resource_ID = Util.GetValueOfInt(tLine.GetS_Resource_ID());
int C_Currency_ID = 0;
int C_BPartner_ID = 0;
if (S_Resource_ID != 0)
{
sql = "select C_Currency_ID from s_resource where s_resource_id = " + S_Resource_ID;
C_Currency_ID = Util.GetValueOfInt(DB.ExecuteScalar(sql, null, null));
sql = "select C_BPartner_ID from s_resource where s_resource_id = " + S_Resource_ID;
C_BPartner_ID = Util.GetValueOfInt(DB.ExecuteScalar(sql, null, null));
}
else
{
sql = "select C_Currency_ID from m_pricelist where isactive = 'Y' and m_pricelist_id = " + tExp.GetM_PriceList_ID();
C_Currency_ID = Util.GetValueOfInt(DB.ExecuteScalar(sql, null, null));
}
sql = "select C_DocType_ID from c_doctype where docbasetype = 'API' and ad_client_id = " + GetCtx().GetAD_Client_ID();
int C_DocType_ID = Util.GetValueOfInt(DB.ExecuteScalar(sql, null, null));
sql = "select C_BPartner_Location_ID from c_Bpartner_Location where c_bpartner_ID = " + C_BPartner_ID;
int C_BPartner_Location_ID = Util.GetValueOfInt(DB.ExecuteScalar(sql, null, null));
VAdvantage.Model.X_C_Invoice inv = new VAdvantage.Model.X_C_Invoice(GetCtx(), 0, null);
inv.SetAD_Client_ID(GetCtx().GetAD_Client_ID());
inv.SetAD_Org_ID(GetCtx().GetAD_Org_ID());
inv.SetAD_User_ID(tExp.GetAD_User_ID());
inv.SetC_BPartner_ID(C_BPartner_ID);
inv.SetC_BPartner_Location_ID(C_BPartner_Location_ID);
inv.SetC_Currency_ID(C_Currency_ID);
inv.SetC_DocType_ID(C_DocType_ID);
inv.SetC_DocTypeTarget_ID(C_DocType_ID);
inv.SetDateInvoiced(System.DateTime.Now);
inv.SetM_PriceList_ID(tExp.GetM_PriceList_ID());
inv.SetDateAcct(System.DateTime.Now);
inv.SetIsApproved(true);
//inv.SetPaymentRule();
inv.SetIsSOTrx(false);
//inv.SetSalesRep_ID();
inv.SetDocAction("CO");
inv.SetDocStatus("DR");
if (ord != null)
{
inv.SetC_PaymentTerm_ID(ord.GetC_PaymentTerm_ID());
inv.SetSalesRep_ID(ord.GetSalesRep_ID());
// inv.SetC_Order_ID(ord.GetC_Order_ID());
// inv.SetM_PriceList_ID(ord.GetM_PriceList_ID());
}
else
{
sql = " select c_paymentterm_id from c_bpartner where c_bpartner_id = " + tLine.GetC_BPartner_ID();
C_PaymentTerm_ID = Util.GetValueOfInt(DB.ExecuteScalar(sql, null, null));
if (C_PaymentTerm_ID == 0)
{
sql = "select c_paymentterm_id from c_paymentterm where isdefault = 'Y' and ad_client_id= " + GetCtx().GetAD_Client_ID();
C_PaymentTerm_ID = Util.GetValueOfInt(DB.ExecuteScalar(sql, null, null));
}
inv.SetC_PaymentTerm_ID(C_PaymentTerm_ID);
inv.SetSalesRep_ID(tExp.GetSalesRep_ID());
}
if (!inv.Save())
{
log.SaveError("InvoiceNotSaved", "InvoiceNotSaved");
return(0);
}
return(inv.GetC_Invoice_ID());
}
