} // mergeTable
/// <summary>
/// Post Merge
/// </summary>
/// <param name="ColumnName">column name</param>
/// <param name="to_ID">ID</param>
private void PostMerge(String ColumnName, int to_ID)
{
if (ColumnName.Equals(AD_ORG_ID))
{
}
else if (ColumnName.Equals(AD_USER_ID))
{
}
else if (ColumnName.Equals(C_BPARTNER_ID))
{
MBPartner bp = new MBPartner(GetCtx(), to_ID, Get_TrxName());
if (bp.Get_ID() != 0)
{
MPayment[] payments = MPayment.GetOfBPartner(GetCtx(), bp.GetC_BPartner_ID(), Get_TrxName());
for (int i = 0; i < payments.Length; i++)
{
MPayment payment = payments[i];
if (payment.TestAllocation())
{
payment.Save();
}
}
MInvoice[] invoices = MInvoice.GetOfBPartner(GetCtx(), bp.GetC_BPartner_ID(), Get_TrxName());
for (int i = 0; i < invoices.Length; i++)
{
MInvoice invoice = invoices[i];
if (invoice.TestAllocation())
{
invoice.Save();
}
}
bp.SetTotalOpenBalance();
bp.SetActualLifeTimeValue();
bp.Save();
}
}
else if (ColumnName.Equals(M_PRODUCT_ID))
{
}
} // postMerge
} // checkPayments
/// <summary>
/// Check Invoices
/// </summary>
/// <param name="bp">bp business partner</param>
private void CheckInvoices(MBPartner bp)
{
// See also VMerge.postMerge
int changed = 0;
MInvoice[] invoices = MInvoice.GetOfBPartner(GetCtx(), bp.GetC_BPartner_ID(), Get_Trx());
for (int i = 0; i < invoices.Length; i++)
{
MInvoice invoice = invoices[i];
if (invoice.TestAllocation())
{
invoice.Save();
changed++;
}
}
if (changed != 0)
{
AddLog(0, null, new Decimal(invoices.Length),
Msg.GetElement(GetCtx(), "C_Invoice_ID") + " - #" + changed);
}
} // checkInvoices
} // checkBP
/// <summary>
/// Check Payments
/// </summary>
/// <param name="bp">bp business partner</param>
private void CheckPayments(MBPartner bp)
{
// See also VMerge.postMerge
int changed = 0;
MPayment[] payments = MPayment.GetOfBPartner(GetCtx(), bp.GetC_BPartner_ID(), Get_Trx());
for (int i = 0; i < payments.Length; i++)
{
MPayment payment = payments[i];
if (payment.TestAllocation())
{
payment.Save();
changed++;
}
}
if (changed != 0)
{
AddLog(0, null, new Decimal(payments.Length),
Msg.GetElement(GetCtx(), "C_Payment_ID") + " - #" + changed);
}
} // checkPayments
/// <summary>
/// Create new Order
/// </summary>
/// <param name="rLine">request line</param>
private void NewOrder(MRequisitionLine rLine, int C_BPartner_ID)
{
if (_order != null)
{
CloseOrder();
}
// BPartner
if (_m_bpartner == null || C_BPartner_ID != _m_bpartner.GetC_BPartner_ID())
{
_m_bpartner = new MBPartner(GetCtx(), C_BPartner_ID, null);
}
// Order
_order = new MOrder(GetCtx(), 0, Get_TrxName());
_order.SetIsSOTrx(false);
_order.SetC_DocTypeTarget_ID();
_order.SetBPartner(_m_bpartner);
// default po document type
if (!_ConsolidateDocument)
{
_order.SetDescription(Msg.GetElement(GetCtx(), "M_Requisition_ID")
+ ": " + rLine.GetParent().GetDocumentNo());
}
// Prepare Save
_m_M_Requisition_ID = rLine.GetM_Requisition_ID();
if (!_order.Save())
{
throw new Exception("Cannot save Order");
}
else
{
if (String.IsNullOrEmpty(createdPO))
{
createdPO = _order.GetDocumentNo();
}
else
{
createdPO += " , " + _order.GetDocumentNo();
}
}
}
} // prepare
/// <summary>
/// Perform Process.
/// </summary>
/// <returns>Message (clear text)</returns>
protected override String DoIt()
{
int index = 1;
StringBuilder sql = new StringBuilder("SELECT * "
+ "FROM S_TimeExpense e "
+ "WHERE e.Processed='Y'"
+ " AND e.AD_Client_ID=@param1"); // #1
if (_C_BPartner_ID != 0 && _C_BPartner_ID != -1)
{
index++;
sql.Append(" AND e.C_BPartner_ID=@param2"); // #2
}
if (_DateFrom != null)
{
index++;
sql.Append(" AND e.DateReport >=@param3"); // #3
}
if (_DateTo != null)
{
index++;
sql.Append(" AND e.DateReport <=@param4"); // #4
}
// JID_0868
// chanegs done by Bharat on 12 September 2018 to handle the case if invoice is created with an expense for the selected Business Partner
sql.Append(" AND EXISTS (SELECT * FROM S_TimeExpenseLine el "
+ "WHERE e.S_TimeExpense_ID=el.S_TimeExpense_ID"
+ " AND el.C_InvoiceLine_ID IS NULL"
+ " AND el.ConvertedAmt<>0) "
+ "ORDER BY e.C_BPartner_ID, e.S_TimeExpense_ID");
//
int old_BPartner_ID = -1;
MInvoice invoice = null;
MTimeExpense te = null;
//
//PreparedStatement pstmt = null;
SqlParameter[] param = new SqlParameter[index];
IDataReader idr = null;
DataTable dt = null;
try
{
//pstmt = DataBase.prepareStatement (sql.toString (), get_TrxName());
int par = 0;
//pstmt.setInt(par++, getAD_Client_ID());
param[0] = new SqlParameter("@param1", GetAD_Client_ID());
if (_C_BPartner_ID != 0 && _C_BPartner_ID != -1)
{
par++;
//pstmt.setInt (par++, _C_BPartner_ID);
param[par] = new SqlParameter("@param2", _C_BPartner_ID);
}
if (_DateFrom != null)
{
par++;
//pstmt.setTimestamp (par++, _DateFrom);
param[par] = new SqlParameter("@param3", _DateFrom);
}
if (_DateTo != null)
{
par++;
//pstmt.setTimestamp (par++, _DateTo);
param[par] = new SqlParameter("@param4", _DateTo);
}
//ResultSet rs = pstmt.executeQuery ();
idr = DataBase.DB.ExecuteReader(sql.ToString(), param, Get_TrxName());
dt = new DataTable();
dt.Load(idr);
idr.Close();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
// ********* Expense Line Loop
{
te = new MTimeExpense(GetCtx(), dr, Get_TrxName());
// New BPartner - New Order
//
if (te.GetC_BPartner_ID() != old_BPartner_ID)
{
CompleteInvoice(invoice, te);
MBPartner bp = new MBPartner(GetCtx(), te.GetC_BPartner_ID(), Get_TrxName());
log.Info("New Invoice for " + bp);
invoice = new MInvoice(GetCtx(), 0, Get_TrxName());
invoice.SetBPartner(bp);
if (invoice.GetC_BPartner_Location_ID() == 0)
{
log.Log(Level.SEVERE, "No BP Location: " + bp);
AddLog(0, te.GetDateReport(),
null, "No Location: " + te.GetDocumentNo() + " " + bp.GetName());
invoice = null;
break;
}
// Siddheshwar: added a code to check for payment method if null
if (bp.GetVA009_PO_PaymentMethod_ID() <= 0)
{
paymethod = GetPaymentMethod(te);
if (paymethod <= 0)
{
if (!noPayMethEmp.Contains(bp.GetC_BPartner_ID()))
{
noPayMethEmp.Add(bp.GetC_BPartner_ID());
if (string.IsNullOrEmpty(bpNameNoPM))
{
bpNameNoPM = bp.GetName();
}
else
{
bpNameNoPM += bp.GetName() + ", ";
}
return(Msg.GetMsg(GetCtx(), "NoPayMethEmp") + bpNameNoPM);
}
}
else
{
invoice.SetVA009_PaymentMethod_ID(paymethod);
}
}
else
{
//JID_1783_1 if active paymentMethod not found ,then dont create the invoice.
if (Util.GetValueOfString(DB.ExecuteScalar("SELECT IsActive FROM VA009_PaymentMethod WHERE VA009_PaymentMethod_ID=" + bp.GetVA009_PO_PaymentMethod_ID(), null, Get_Trx())).Equals("Y"))
{
invoice.SetVA009_PaymentMethod_ID(bp.GetVA009_PO_PaymentMethod_ID());
}
else
{
return(Msg.GetMsg(GetCtx(), "IsActivePaymentMethodInv"));;
}
}
// Checking payment term
if (bp.GetPO_PaymentTerm_ID() <= 0)
{
payterm = GetPaymentTerm(te);
if (payterm <= 0)
{
if (!PayTermEmp.Contains(bp.GetC_BPartner_ID()))
{
PayTermEmp.Add(bp.GetC_BPartner_ID());
if (string.IsNullOrEmpty(bpNamePT))
{
bpNamePT = bp.GetName();
}
else
{
bpNamePT += bp.GetName() + ", ";
}
return(Msg.GetMsg(GetCtx(), "NoPayTerm") + bpNamePT);
}
}
else
{
invoice.SetC_PaymentTerm_ID(payterm);
}
}
else
{
//JID_1783_1 if active paymentTerm not found ,then dont create the invoice.
if (Util.GetValueOfString(DB.ExecuteScalar("SELECT IsActive FROM C_PaymentTerm WHERE C_PaymentTerm_ID=" + bp.GetPO_PaymentTerm_ID(), null, Get_Trx())).Equals("Y"))
{
invoice.SetC_PaymentTerm_ID(bp.GetPO_PaymentTerm_ID());
}
else
{
return(Msg.GetMsg(GetCtx(), "IsActivePaymentTermInv"));
}
}
invoice.SetIsExpenseInvoice(true); //added by arpit asked by Surya Sir on DEC 28,2015
invoice.SetClientOrg(te.GetAD_Client_ID(), te.GetAD_Org_ID());
//invoice.SetVA009_PaymentMethod_ID(bp.GetVA009_PO_PaymentMethod_ID());
// JID_0868
// chanegs done by Bharat on 12 September 2018 to set the document type where Expense Invoice checkbox is true.
// String qry = "SELECT C_DocType_ID FROM C_DocType "
//+ "WHERE AD_Client_ID=@param1 AND DocBaseType=@param2"
//+ " AND IsActive='Y' AND IsExpenseInvoice = 'Y' "
//+ "ORDER BY C_DocType_ID DESC , IsDefault DESC";
String qry = "SELECT C_DocType_ID FROM C_DocType "
+ "WHERE AD_Client_ID=" + GetAD_Client_ID() + @" AND DocBaseType='" + MDocBaseType.DOCBASETYPE_APINVOICE + @"'"
+ " AND IsActive='Y' AND IsExpenseInvoice = 'Y' AND AD_Org_ID IN(0," + te.GetAD_Org_ID() + ") "
+ " ORDER BY AD_Org_ID Desc, C_DocType_ID DESC , IsDefault DESC";
//int C_DocType_ID = DB.GetSQLValue(null, qry, GetAD_Client_ID(), MDocBaseType.DOCBASETYPE_APINVOICE);
int C_DocType_ID = Util.GetValueOfInt(DB.ExecuteScalar(qry));
if (C_DocType_ID <= 0)
{
log.Log(Level.SEVERE, "Not found for AC_Client_ID="
+ GetAD_Client_ID() + " - " + MDocBaseType.DOCBASETYPE_APINVOICE);
return(Msg.GetMsg(GetCtx(), "NoDocTypeExpInvoice"));
}
else
{
log.Fine(MDocBaseType.DOCBASETYPE_APINVOICE);
}
invoice.SetC_DocTypeTarget_ID(C_DocType_ID);
//invoice.SetC_DocTypeTarget_ID(MDocBaseType.DOCBASETYPE_APINVOICE); // API
//commented by Arpit on Jan 4,2015 Mentis issue no. 0000310
//invoice.SetDocumentNo(te.GetDocumentNo());
//
invoice.SetM_PriceList_ID(te.GetM_PriceList_ID());
invoice.SetSalesRep_ID(te.GetDoc_User_ID());
String descr = Msg.Translate(GetCtx(), "S_TimeExpense_ID")
+ ": " + te.GetDocumentNo() + " "
+ DisplayType.GetDateFormat(DisplayType.Date).Format(te.GetDateReport());
invoice.SetDescription(descr);
if (!invoice.Save())
{
return(GetRetrievedError(invoice, "Cannot save Invoice"));
// new Exception("Cannot save Invoice");
}
//added by arpit asked by Surya Sir on 29/12/2015*******
else
{
old_BPartner_ID = bp.GetC_BPartner_ID();
}
//end***************
}
// JID_0868
//Description include all document numbers which is come from Time And Expense Recording window to expense invoice in case of multiple records
else if (old_BPartner_ID > 0)
{
String descr = invoice.GetDescription() + "\n" + Msg.Translate(GetCtx(), "S_TimeExpense_ID")
+ ": " + te.GetDocumentNo() + " "
+ DisplayType.GetDateFormat(DisplayType.Date).Format(te.GetDateReport());
invoice.SetDescription(descr);
}
MTimeExpenseLine[] tel = te.GetLines(false);
for (int i = 0; i < tel.Length; i++)
{
MTimeExpenseLine line = tel[i];
// Already Invoiced or nothing to be reimbursed
if (line.GetC_InvoiceLine_ID() != 0 ||
Env.ZERO.CompareTo(line.GetQtyReimbursed()) == 0 ||
Env.ZERO.CompareTo(line.GetPriceReimbursed()) == 0)
{
continue;
}
// Update Header info
if (line.GetC_Activity_ID() != 0 && line.GetC_Activity_ID() != invoice.GetC_Activity_ID())
{
invoice.SetC_Activity_ID(line.GetC_Activity_ID());
}
if (line.GetC_Campaign_ID() != 0 && line.GetC_Campaign_ID() != invoice.GetC_Campaign_ID())
{
invoice.SetC_Campaign_ID(line.GetC_Campaign_ID());
}
if (line.GetC_Project_ID() != 0 && line.GetC_Project_ID() != invoice.GetC_Project_ID())
{
invoice.SetC_Project_ID(line.GetC_Project_ID());
}
if (!invoice.Save())
{
return(GetRetrievedError(invoice, "Cannot save Invoice"));
//new Exception("Cannot save Invoice");
}
// Create OrderLine
MInvoiceLine il = new MInvoiceLine(invoice);
//
if (line.GetM_Product_ID() != 0)
{
il.SetM_Product_ID(line.GetM_Product_ID(), true);
}
//added by arpit asked by Surya Sir on 28/12/2015_____***************************
if (line.GetC_Charge_ID() != 0)
{
il.SetC_Charge_ID(line.GetC_Charge_ID());
}
//end here *****************************
il.SetQty(line.GetQtyReimbursed()); // Entered/Invoiced
il.SetDescription(line.GetDescription());
//
il.SetC_Project_ID(line.GetC_Project_ID());
il.SetC_ProjectPhase_ID(line.GetC_ProjectPhase_ID());
il.SetC_ProjectTask_ID(line.GetC_ProjectTask_ID());
il.SetC_Activity_ID(line.GetC_Activity_ID());
il.SetC_Campaign_ID(line.GetC_Campaign_ID());
//
// il.setPrice(); // not really a list/limit price for reimbursements
il.SetPrice(line.GetPriceReimbursed()); //
il.SetC_UOM_ID(line.GetC_UOM_ID());
// JID_0868
// chanegs done by Bharat on 12 September 2018 to set the Amount in List price column.
il.SetPriceList(line.GetPriceReimbursed());
il.SetTax();
if (!il.Save())
{
return(GetRetrievedError(il, "Cannot save Invoice"));
//new Exception("Cannot save Invoice Line");
}
// Update TEL
line.SetC_InvoiceLine_ID(il.GetC_InvoiceLine_ID());
line.SetIsInvoiced(true);
line.Save();
} // for all expense lines
}
}
else
{
message = Msg.GetMsg(GetCtx(), "NoRecForInv");
}
// ********* Expense Line Loop
dt = null;
//dt.Clear();
}
catch (Exception e)
{
if (dt != null)
{
dt = null;
}
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, sql.ToString(), e);
}
finally
{
if (dt != null)
{
dt = null;
}
if (idr != null)
{
idr.Close();
}
}
CompleteInvoice(invoice, te);
//if (_noInvoices == 0)
//{
// message = " @No Record Found for Invoice Creation@";
//}
//Code for Showing Message when PaymentTerm is null
if (!string.IsNullOrEmpty(bpNamePT))
{
message += Msg.GetMsg(GetCtx(), "NoPayTerm") + bpNamePT + "\n";
}
//code for showing Error Message when Invoice is not completed
if (!string.IsNullOrEmpty(bpNameInvoice))
{
message += Msg.GetMsg(GetCtx(), "NoInvoiceCreated") + bpNameInvoice + "\n";
}
if (!string.IsNullOrEmpty(bpNameNoPM))
{
message = Msg.GetMsg(GetCtx(), "NoPayMethEmp") + bpNameNoPM + "\n";
}
if (_noInvoices > 0)
{
message += "" + _noInvoices + " " + Msg.GetMsg(GetCtx(), "VIS_InvGenerated");
}
//return "" + _noInvoices + " @Invoices Generated Successfully@";
return(message);
} // doIt
} // prepare
/// <summary>
/// Perform Process.
/// </summary>
/// <returns>Message to be translated</returns>
protected override String DoIt()
{
int index = 1;
StringBuilder sql = new StringBuilder("SELECT * FROM S_TimeExpenseLine el "
+ "WHERE el.AD_Client_ID=@param1" // #1
+ " AND el.C_BPartner_ID>0 AND el.IsInvoiced='Y'" // Business Partner && to be invoiced
+ " AND el.C_OrderLine_ID IS NULL" // not invoiced yet
+ " AND EXISTS (SELECT * FROM S_TimeExpense e " // processed only
+ "WHERE el.S_TimeExpense_ID=e.S_TimeExpense_ID AND e.Processed='Y')");
if (_C_BPartner_ID != 0 && _C_BPartner_ID != -1)
{
index++;
sql.Append(" AND el.C_BPartner_ID=@param2"); // #2
}
if (_DateFrom != null || _DateTo != null)
{
sql.Append(" AND EXISTS (SELECT * FROM S_TimeExpense e "
+ "WHERE el.S_TimeExpense_ID=e.S_TimeExpense_ID");
if (_DateFrom != null)
{
index++;
sql.Append(" AND e.DateReport >= @param3"); // #3
}
if (_DateTo != null)
{
index++;
sql.Append(" AND e.DateReport <= @param4"); // #4
}
sql.Append(")");
}
sql.Append(" ORDER BY el.C_BPartner_ID, el.C_Project_ID, el.S_TimeExpense_ID, el.Line");
//
MBPartner oldBPartner = null;
int old_Project_ID = -1;
MTimeExpense te = null;
//
SqlParameter[] param = new SqlParameter[index];
IDataReader idr = null;
DataTable dt = null;
try
{
//pstmt = DataBase.prepareStatement(sql.toString(), get_TrxName());
int par = 0;
//pstmt.setInt(par++, getAD_Client_ID());
param[par] = new SqlParameter("@param1", GetAD_Client_ID());
if (_C_BPartner_ID != 0 && _C_BPartner_ID != -1)
{
//pstmt.setInt(par++, _C_BPartner_ID);
par++;
param[par] = new SqlParameter("@param2", _C_BPartner_ID);
}
if (_DateFrom != null)
{
par++;
//pstmt.setTimestamp(par++, _DateFrom);
param[par] = new SqlParameter("@param3", _DateFrom);
}
if (_DateTo != null)
{
//pstmt.setTimestamp(par++, _DateTo);
par++;
param[par] = new SqlParameter("@param4", _DateTo);
}
//ResultSet rs = pstmt.executeQuery();
idr = DataBase.DB.ExecuteReader(sql.ToString(), param, Get_TrxName());
dt = new DataTable();
dt.Load(idr);
idr.Close();
foreach (DataRow dr in dt.Rows) // ********* Expense Line Loop
{
MTimeExpenseLine tel = new MTimeExpenseLine(GetCtx(), dr, Get_TrxName());
if (!tel.IsInvoiced())
{
continue;
}
// New BPartner - New Order
if (oldBPartner == null ||
oldBPartner.GetC_BPartner_ID() != tel.GetC_BPartner_ID())
{
CompleteOrder();
oldBPartner = new MBPartner(GetCtx(), tel.GetC_BPartner_ID(), Get_TrxName());
}
// New Project - New Order
if (old_Project_ID != tel.GetC_Project_ID())
{
CompleteOrder();
old_Project_ID = tel.GetC_Project_ID();
}
if (te == null || te.GetS_TimeExpense_ID() != tel.GetS_TimeExpense_ID())
{
te = new MTimeExpense(GetCtx(), tel.GetS_TimeExpense_ID(), Get_TrxName());
}
//
ProcessLine(te, tel, oldBPartner);
}
// ********* Expense Line Loop
dt = null;
// dt.Clear();
}
catch (Exception e)
{
if (dt != null)
{
dt = null;
}
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, sql.ToString(), e);
}
finally
{
if (dt != null)
{
dt = null;
}
if (idr != null)
{
idr.Close();
}
}
CompleteOrder();
return("" + _noOrders + "@Invoices Generated Successfully@");
} // doIt
private void InitBPartner(int WinNo, int bPartnerID, string bpType)
{
C_BPartner_ID = bPartnerID;
bool ro = false;
DataSet ds = null;
log.Config("C_BPartner_ID=" + bPartnerID);
// New bpartner
if (bPartnerID == 0)
{
_partner = null;
_pLocation = null;
_user = null;
_bprelation = null;
_bpLocation = null;
_bpGroup = null;
//return true;
}
_partner = new MBPartner(Env.GetCtx(), bPartnerID, null);
if (_partner.Get_ID() != 0)
{
// Contact - Load values
_pLocation = _partner.GetLocation(
Env.GetCtx().GetContextAsInt(WinNo, "C_BPartner_Location_ID"));
_user = _partner.GetContact(
Env.GetCtx().GetContextAsInt(WinNo, "AD_User_ID"));
}
isCustomer = _partner.IsCustomer();
isVendor = _partner.IsVendor();
isEmployee = _partner.IsEmployee();
_readOnly = !MRole.GetDefault(Env.GetCtx()).CanUpdate(
Env.GetCtx().GetAD_Client_ID(), Env.GetCtx().GetAD_Org_ID(),
MBPartner.Table_ID, 0, false);
log.Info("R/O=" + _readOnly);
// Get Data
_greeting = FillGreeting();
/************************************/
_bpGroup = FillBPGroup();
_bpRelation = FillBPRelation();
_bpLocation = FillBPLocation(0, ctx);
/************************************/
ro = _readOnly;
if (!ro)
{
ro = !MRole.GetDefault(Env.GetCtx()).CanUpdate(
Env.GetCtx().GetAD_Client_ID(), Env.GetCtx().GetAD_Org_ID(),
MBPartnerLocation.Table_ID, 0, false);
}
if (!ro)
{
ro = !MRole.GetDefault(Env.GetCtx()).CanUpdate(
Env.GetCtx().GetAD_Client_ID(), Env.GetCtx().GetAD_Org_ID(),
MLocation.Table_ID, 0, false);
}
ds = DB.ExecuteDataset("Select C_BPartnerRelation_ID, c_bpartnerrelation_location_id from C_BP_Relation where c_bpartner_id=" + _partner.GetC_BPartner_ID());
LoadBPartner(C_BPartner_ID, ds);
}
/// <summary>
/// Add Or Update Business Partner
/// </summary>
/// <param name="searchKey"></param>
/// <param name="name"></param>
/// <param name="name2"></param>
/// <param name="greeting"></param>
/// <param name="bpGroup"></param>
/// <param name="bpRelation"></param>
/// <param name="bpLocation"></param>
/// <param name="contact"></param>
/// <param name="greeting1"></param>
/// <param name="title"></param>
/// <param name="email"></param>
/// <param name="address"></param>
/// <param name="phoneNo"></param>
/// <param name="phoneNo2"></param>
/// <param name="fax"></param>
/// <param name="ctx"></param>
/// <param name="_windowNo"></param>
/// <param name="BPtype"></param>
/// <param name="C_BPartner_ID"></param>
/// <returns></returns>
public string AddBPartner(string searchKey, string name, string name2, string greeting, string bpGroup, string bpRelation, string bpLocation, string contact, string greeting1, string title, string email, string address, string phoneNo, string phoneNo2, string fax, Ctx ctx, int _windowNo, string BPtype, int C_BPartner_ID, bool isCustomer, bool isVendor, bool isProspect, string fileUrl, string umobile, string webUrl, bool isEmployee)
{
StringBuilder strError = new StringBuilder();
int AD_Client_ID = ctx.GetAD_Client_ID();
if (C_BPartner_ID > 0)
{
_partner = new MBPartner(ctx, C_BPartner_ID, null);
}
else
{
_partner = MBPartner.GetTemplate(ctx, AD_Client_ID);
}
bool isSOTrx = ctx.IsSOTrx(_windowNo);
_partner.SetIsCustomer(isSOTrx);
_partner.SetIsVendor(!isSOTrx);
// JID_1197 IN Business partner updating Createdby,Updatedby,Created,Updated fields as per changed date
_partner.Set_ValueNoCheck("CreatedBy", ctx.GetAD_User_ID());
_partner.Set_ValueNoCheck("Created", DateTime.Now);
_partner.Set_ValueNoCheck("Updated", DateTime.Now);
_partner.Set_ValueNoCheck("UpdatedBy", ctx.GetAD_User_ID());
if (BPtype != null && (!isCustomer && !isVendor))
{
if (BPtype.Contains("Customer"))
{
_partner.SetIsCustomer(true);
}
if (BPtype.Contains("Employee"))
{
_partner.SetIsEmployee(true);
}
if (BPtype.Contains("Vendor"))
{
_partner.SetIsVendor(true);
}
if (BPtype.Contains("Prospect"))
{
_partner.SetIsProspect(true);
}
/*
* if (BPtype == "Customer")
* {
* _partner.SetIsCustomer(true);
* }
* else if (BPtype == "Employee")
* {
* _partner.SetIsEmployee(true);
* }
* else if (BPtype == "Vendor")
* {
* _partner.SetIsVendor(true);
* }
* else if (BPtype == "Prospect")
* {
* _partner.SetIsProspect(true);
* }*/
}
if (isCustomer)
{
_partner.SetIsCustomer(true);
}
else
{
_partner.SetIsCustomer(false);
}
if (isVendor)
{
_partner.SetIsVendor(true);
}
else
{
_partner.SetIsVendor(false);
}
if (isProspect)
{
_partner.SetIsProspect(true);
}
else
{
_partner.SetIsProspect(false);
}
if (isEmployee)
{
_partner.SetIsEmployee(true);
}
else
{
_partner.SetIsEmployee(false);
}
if (searchKey == null || searchKey.Length == 0)
{
// get Table Documet No
searchKey = MSequence.GetDocumentNo(ctx.GetAD_Client_ID(), "C_BPartner", null, ctx);
//Dispatcher.BeginInvoke(() => { txtValue.Text = value; });
}
_partner.SetValue(searchKey);
//
_partner.SetName(name);
_partner.SetURL(webUrl);
// _partner.SetName2(name2);
//KeyNamePair p = (KeyNamePair)cmbGreetingBP.SelectedItem;
//if (greeting >0)
//{
// _partner.SetC_Greeting_ID(greeting);
//}
//else
//{
// _partner.SetC_Greeting_ID(0);
//}
if (greeting != string.Empty)
{
_partner.SetC_Greeting_ID(Convert.ToInt32(greeting));
}
else
{
_partner.SetC_Greeting_ID(0);
}
/***************************************************/
_partner.SetC_BP_Group_ID(Util.GetValueOfInt(bpGroup));
/***************************************************/
if (_partner.Save())
{
log.Fine("C_BPartner_ID=" + _partner.GetC_BPartner_ID());
}
else
{
// Classes.ShowMessage.Error("SearchKeyExist", null);
strError.Append("SearchKeyExist");
//this.Cursor = Cursors.Arrow;
return(strError.ToString());
}
// ***** Business Partner - Location *****
if (_pLocation == null)
{
if (C_BPartner_ID > 0)
{
_pLocation = new MBPartnerLocation(ctx, GetBPartnerLocationID(_partner.Get_ID()), null);
if (_pLocation.Get_ID() <= 0)
{
_pLocation = new MBPartnerLocation(_partner);
}
}
else
{
_pLocation = new MBPartnerLocation(_partner);
}
}
if (address != string.Empty)
{
_pLocation.SetC_Location_ID(Convert.ToInt32(address));
}
//
_pLocation.SetPhone(phoneNo);
// _pLocation.SetPhone2(phoneNo2);
_pLocation.SetFax(fax);
if (_pLocation.Save())
{
log.Fine("C_BPartner_Location_ID=" + _pLocation.GetC_BPartner_Location_ID());
}
else
{
// ADialog.error(m_WindowNo, this, "BPartnerNotSaved", Msg.translate(Env.getCtx(), "C_BPartner_Location_ID"));
// Classes.ShowMessage.Error("BPartnerNotSaved", null);
//this.Cursor = Cursors.Arrow;
strError.Append("BPartnerNotSaved");
return(strError.ToString());
}
// ***** Business Partner - User *****
//String contact = txtContact.Text;
//String email = txtEMail.Text;
if (_user == null && (contact.Length > 0 || email.Length > 0))
{
if (C_BPartner_ID > 0)
{
_user = new MUser(ctx, GetUserID(_partner.Get_ID()), null);
}
else
{
_user = new MUser(_partner);
}
}
if (_user != null)
{
if (contact.Length == 0)
{
contact = name;
}
_user.SetName(contact);
_user.SetEMail(email);
_user.SetTitle(title);
_user.SetC_Location_ID(Convert.ToInt32(address));
// = (KeyNamePair)cmbGreetingC.SelectedItem;
//if (greeting1 >0)
// _user.SetC_Greeting_ID(greeting1);
if (greeting1 != string.Empty)
{
_user.SetC_Greeting_ID(Convert.ToInt32(greeting1));
}
else
{
_user.SetC_Greeting_ID(0);
}
//
_user.SetPhone(phoneNo);
// _user.SetPhone2(phoneNo2);
_user.SetMobile(umobile);
_user.SetFax(fax);
_user.SetC_BPartner_Location_ID(_pLocation.GetC_BPartner_Location_ID());
if (_user.Save())
{
if (fileUrl != null && fileUrl != string.Empty)
{
_user.SetAD_Image_ID(SaveUserImage(ctx, fileUrl, _user.GetAD_User_ID()));
}
if (_user.Save())
{
log.Fine("AD_User_ID(AD_Image_ID)=" + _user.GetAD_User_ID() + "(" + _user.GetAD_Image_ID() + ")");
}
log.Fine("AD_User_ID=" + _user.GetAD_User_ID());
}
else
{
//Classes.ShowMessage.Error("BPartnerNotSaved", null);
//this.Cursor = Cursors.Arrow;
strError.Append("BPartnerNotSaved");
return(strError.ToString());
}
/*************************************************/
if ((bpRelation != null && bpLocation != null) && (bpRelation != string.Empty && bpLocation != string.Empty))
{
if (bpRelation.ToString().Trim() == "" || bpLocation.ToString().Trim() == "")
{
int dele = DB.ExecuteQuery("DELETE from C_BP_Relation where c_bpartner_id=" + _partner.GetC_BPartner_ID(), null, null);
if (dele == -1)
{
log.SaveError("C_BP_RelationNotDeleted", "c_bpartner_id=" + _partner.GetC_BPartner_ID());
}
}
else
{
//Business Partner Relation
if (C_BPartner_ID > 0)
{
_bprelation = new X_C_BP_Relation(ctx, GetBPRelationID(_partner.Get_ID()), null);
}
else
{
_bprelation = new X_C_BP_Relation(ctx, 0, null);
}
_bprelation.SetAD_Client_ID(_partner.GetAD_Client_ID());
_bprelation.SetAD_Org_ID(_partner.GetAD_Org_ID());
_bprelation.SetName(_partner.GetName());
_bprelation.SetDescription(_partner.GetDescription());
_bprelation.SetC_BPartner_ID(_partner.GetC_BPartner_ID());
_bprelation.SetC_BPartner_Location_ID(_pLocation.GetC_BPartner_Location_ID());
_bprelation.SetC_BP_Relation_ID(Util.GetValueOfInt(bpRelation));
_bprelation.SetC_BPartnerRelation_ID(Util.GetValueOfInt(bpRelation));
_bprelation.SetC_BPartnerRelation_Location_ID(Util.GetValueOfInt(bpLocation));
_bprelation.SetIsBillTo(true);
if (_bprelation.Save())
{
log.Fine("C_BP_Relation_ID=" + _bprelation.GetC_BP_Relation_ID());
}
else
{
//Classes.ShowMessage.Error("BPRelationNotSaved", null);
//this.Cursor = Cursors.Arrow;
strError.Append("BPRelationNotSaved");
return(strError.ToString());
}
}
}
/*************************************************/
}
return(strError.ToString());
}
} // prepare
/// <summary>
/// Perform Process.
/// </summary>
/// <returns>Message (clear text)</returns>
protected override String DoIt()
{
int index = 1;
StringBuilder sql = new StringBuilder("SELECT * "
+ "FROM S_TimeExpense e "
+ "WHERE e.Processed='Y'"
+ " AND e.AD_Client_ID=@param1"); // #1
if (_C_BPartner_ID != 0 && _C_BPartner_ID != -1)
{
index++;
sql.Append(" AND e.C_BPartner_ID=@param2"); // #2
}
if (_DateFrom != null)
{
index++;
sql.Append(" AND e.DateReport >=@param3"); // #3
}
if (_DateTo != null)
{
index++;
sql.Append(" AND e.DateReport <=@param4"); // #4
}
// JID_0868
// chanegs done by Bharat on 12 September 2018 to handle the case if invoice is created with an expense for the selected Business Partner
sql.Append(" AND EXISTS (SELECT * FROM S_TimeExpenseLine el "
+ "WHERE e.S_TimeExpense_ID=el.S_TimeExpense_ID"
+ " AND el.C_InvoiceLine_ID IS NULL"
+ " AND el.ConvertedAmt<>0) "
+ "ORDER BY e.C_BPartner_ID, e.S_TimeExpense_ID");
//
int old_BPartner_ID = -1;
MInvoice invoice = null;
//
//PreparedStatement pstmt = null;
SqlParameter[] param = new SqlParameter[index];
IDataReader idr = null;
DataTable dt = null;
try
{
//pstmt = DataBase.prepareStatement (sql.toString (), get_TrxName());
int par = 0;
//pstmt.setInt(par++, getAD_Client_ID());
param[0] = new SqlParameter("@param1", GetAD_Client_ID());
if (_C_BPartner_ID != 0 && _C_BPartner_ID != -1)
{
par++;
//pstmt.setInt (par++, _C_BPartner_ID);
param[par] = new SqlParameter("@param2", _C_BPartner_ID);
}
if (_DateFrom != null)
{
par++;
//pstmt.setTimestamp (par++, _DateFrom);
param[par] = new SqlParameter("@param3", _DateFrom);
}
if (_DateTo != null)
{
par++;
//pstmt.setTimestamp (par++, _DateTo);
param[par] = new SqlParameter("@param4", _DateTo);
}
//ResultSet rs = pstmt.executeQuery ();
idr = DataBase.DB.ExecuteReader(sql.ToString(), param, Get_TrxName());
dt = new DataTable();
dt.Load(idr);
idr.Close();
foreach (DataRow dr in dt.Rows)
// ********* Expense Line Loop
{
MTimeExpense te = new MTimeExpense(GetCtx(), dr, Get_TrxName());
// New BPartner - New Order
if (te.GetC_BPartner_ID() != old_BPartner_ID)
{
CompleteInvoice(invoice);
MBPartner bp = new MBPartner(GetCtx(), te.GetC_BPartner_ID(), Get_TrxName());
//
log.Info("New Invoice for " + bp);
invoice = new MInvoice(GetCtx(), 0, null);
invoice.SetIsExpenseInvoice(true); //added by arpit asked by Surya Sir on DEC 28,2015
invoice.SetClientOrg(te.GetAD_Client_ID(), te.GetAD_Org_ID());
// JID_0868
// chanegs done by Bharat on 12 September 2018 to set the document type where Expense Invoice checkbox is true.
String qry = "SELECT C_DocType_ID FROM C_DocType "
+ "WHERE AD_Client_ID=@param1 AND DocBaseType=@param2"
+ " AND IsActive='Y' AND IsExpenseInvoice = 'Y' "
+ "ORDER BY C_DocType_ID DESC , IsDefault DESC";
int C_DocType_ID = DB.GetSQLValue(null, qry, GetAD_Client_ID(), MDocBaseType.DOCBASETYPE_APINVOICE);
if (C_DocType_ID <= 0)
{
log.Log(Level.SEVERE, "Not found for AC_Client_ID="
+ GetAD_Client_ID() + " - " + MDocBaseType.DOCBASETYPE_APINVOICE);
}
else
{
log.Fine(MDocBaseType.DOCBASETYPE_APINVOICE);
}
invoice.SetC_DocTypeTarget_ID(C_DocType_ID);
//invoice.SetC_DocTypeTarget_ID(MDocBaseType.DOCBASETYPE_APINVOICE); // API
//commented by Arpit on Jan 4,2015 Mentis issue no. 0000310
//invoice.SetDocumentNo(te.GetDocumentNo());
//
invoice.SetBPartner(bp);
if (invoice.GetC_BPartner_Location_ID() == 0)
{
log.Log(Level.SEVERE, "No BP Location: " + bp);
AddLog(0, te.GetDateReport(),
null, "No Location: " + te.GetDocumentNo() + " " + bp.GetName());
invoice = null;
break;
}
invoice.SetM_PriceList_ID(te.GetM_PriceList_ID());
invoice.SetSalesRep_ID(te.GetDoc_User_ID());
String descr = Msg.Translate(GetCtx(), "S_TimeExpense_ID")
+ ": " + te.GetDocumentNo() + " "
+ DisplayType.GetDateFormat(DisplayType.Date).Format(te.GetDateReport());
invoice.SetDescription(descr);
if (!invoice.Save())
{
//return GetReterivedError(invoice, "Cannot save Invoice");
new Exception("Cannot save Invoice");
}
//added by arpit asked by Surya Sir on 29/12/2015*******
else
{
old_BPartner_ID = bp.GetC_BPartner_ID();
}
//end***************
}
// JID_0868
//Description include all document numbers which is come from Time And Expense Recording window to expense invoice in case of multiple records
else if (old_BPartner_ID > 0)
{
String descr = invoice.GetDescription() + "\n" + Msg.Translate(GetCtx(), "S_TimeExpense_ID")
+ ": " + te.GetDocumentNo() + " "
+ DisplayType.GetDateFormat(DisplayType.Date).Format(te.GetDateReport());
invoice.SetDescription(descr);
}
MTimeExpenseLine[] tel = te.GetLines(false);
for (int i = 0; i < tel.Length; i++)
{
MTimeExpenseLine line = tel[i];
// Already Invoiced or nothing to be reimbursed
if (line.GetC_InvoiceLine_ID() != 0 ||
Env.ZERO.CompareTo(line.GetQtyReimbursed()) == 0 ||
Env.ZERO.CompareTo(line.GetPriceReimbursed()) == 0)
{
continue;
}
// Update Header info
if (line.GetC_Activity_ID() != 0 && line.GetC_Activity_ID() != invoice.GetC_Activity_ID())
{
invoice.SetC_Activity_ID(line.GetC_Activity_ID());
}
if (line.GetC_Campaign_ID() != 0 && line.GetC_Campaign_ID() != invoice.GetC_Campaign_ID())
{
invoice.SetC_Campaign_ID(line.GetC_Campaign_ID());
}
if (line.GetC_Project_ID() != 0 && line.GetC_Project_ID() != invoice.GetC_Project_ID())
{
invoice.SetC_Project_ID(line.GetC_Project_ID());
}
if (!invoice.Save())
{
//return GetReterivedError(invoice, "Cannot save Invoice");
new Exception("Cannot save Invoice");
}
// Create OrderLine
MInvoiceLine il = new MInvoiceLine(invoice);
//
if (line.GetM_Product_ID() != 0)
{
il.SetM_Product_ID(line.GetM_Product_ID(), true);
}
//added by arpit asked by Surya Sir on 28/12/2015_____***************************
if (line.GetC_Charge_ID() != 0)
{
il.SetC_Charge_ID(line.GetC_Charge_ID());
}
//end here *****************************
il.SetQty(line.GetQtyReimbursed()); // Entered/Invoiced
il.SetDescription(line.GetDescription());
//
il.SetC_Project_ID(line.GetC_Project_ID());
il.SetC_ProjectPhase_ID(line.GetC_ProjectPhase_ID());
il.SetC_ProjectTask_ID(line.GetC_ProjectTask_ID());
il.SetC_Activity_ID(line.GetC_Activity_ID());
il.SetC_Campaign_ID(line.GetC_Campaign_ID());
//
// il.setPrice(); // not really a list/limit price for reimbursements
il.SetPrice(line.GetPriceReimbursed()); //
// JID_0868
// chanegs done by Bharat on 12 September 2018 to set the Amount in List price column.
il.SetPriceList(line.GetPriceReimbursed());
il.SetTax();
if (!il.Save())
{
//return GetReterivedError(il, "Cannot save Invoice");
new Exception("Cannot save Invoice Line");
}
// Update TEL
line.SetC_InvoiceLine_ID(il.GetC_InvoiceLine_ID());
line.SetIsInvoiced(true);
line.Save();
} // for all expense lines
} // ********* Expense Line Loop
dt = null;
//dt.Clear();
}
catch (Exception e)
{
if (dt != null)
{
dt = null;
}
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, sql.ToString(), e);
}
finally
{
if (dt != null)
{
dt = null;
}
if (idr != null)
{
idr.Close();
}
}
CompleteInvoice(invoice);
if (_noInvoices == 0)
{
return(" @No Record Found for Invoice Creation@");
}
return("" + _noInvoices + " @Invoices Generated Successfully@");
} // doIt
} // doIt
/// <summary>
/// impoert process
/// </summary>
/// <param name="imp">import</param>
/// <returns>true if processed</returns>
private bool Process(X_I_Contact imp)
{
if (imp.GetEMail() == null || imp.GetEMail().Length == 0)
{
return(ProcessFail(imp, "No EMail"));
}
MUser user = MUser.Get(GetCtx(), imp.GetEMail(), Get_TrxName());
// New User
if (user == null || user.GetAD_User_ID() == 0)
{
if (imp.IsEMailBounced())
{
return(ProcessFail(imp, "No User found with email - cannou set Bounced flag"));
}
if (imp.GetContactName() == null || imp.GetContactName().Length == 0)
{
return(ProcessFail(imp, "No Name for User/Contact"));
}
user = new MUser(GetCtx(), 0, Get_TrxName());
user.SetName(imp.GetContactName());
user.SetDescription(imp.GetContactDescription());
user.SetEMail(imp.GetEMail());
}
// Existing User
else
{
if (imp.IsEMailBounced())
{
user.SetIsEMailBounced(true);
user.SetBouncedInfo(imp.GetBouncedInfo());
}
}
if (!user.Save())
{
return(ProcessFail(imp, "Cannot save User"));
}
// Create BP
if (imp.IsCreateBP())
{
if (user.GetC_BPartner_ID() == 0)
{
MBPartner bp = new MBPartner(GetCtx(), 0, Get_TrxName());
bp.SetName(user.GetName());
if (!bp.Save())
{
return(ProcessFail(imp, "Cannot create BPartner"));
}
else
{
user.SetC_BPartner_ID(bp.GetC_BPartner_ID());
if (!user.Save())
{
return(ProcessFail(imp, "Cannot update User"));
}
}
}
imp.SetC_BPartner_ID(user.GetC_BPartner_ID());
}
// Create Lead
if (imp.IsCreateLead())
{
MLead lead = new MLead(GetCtx(), 0, Get_TrxName());
lead.SetName(imp.GetContactName());
lead.SetDescription(imp.GetContactDescription());
lead.SetAD_User_ID(user.GetAD_User_ID());
lead.SetC_BPartner_ID(user.GetC_BPartner_ID());
lead.Save();
imp.SetC_Lead_ID(lead.GetC_Lead_ID());
}
// Interest Area
if (imp.GetR_InterestArea_ID() != 0 && user != null)
{
MContactInterest ci = MContactInterest.Get(GetCtx(),
imp.GetR_InterestArea_ID(), user.GetAD_User_ID(),
true, Get_TrxName());
ci.Save(); // don't subscribe or re-activate
}
imp.SetAD_User_ID(user.GetAD_User_ID());
imp.SetI_IsImported(true);
imp.SetI_ErrorMsg(null);
imp.Save();
return(true);
} // process
} // prepare
/// <summary>
/// Perrform Process.
/// </summary>
/// <returns>message</returns>
protected override String DoIt()
{
StringBuilder sql = null;
int no = 0;
String clientCheck = " AND AD_Client_ID=" + _AD_Client_ID;
// **** Prepare ****
// Delete Old Imported
if (_deleteOldImported)
{
sql = new StringBuilder("DELETE FROM I_BPartner "
+ "WHERE I_IsImported='Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Delete Old Impored =" + no);
}
// Set Client, Org, IsActive, Created/Updated
sql = new StringBuilder("UPDATE I_BPartner "
+ "SET AD_Client_ID = COALESCE (AD_Client_ID, ").Append(_AD_Client_ID).Append("),"
+ " AD_Org_ID = COALESCE (AD_Org_ID, 0),"
+ " IsActive = COALESCE (IsActive, 'Y'),"
+ " Created = COALESCE (Created, SysDate),"
+ " CreatedBy = COALESCE (CreatedBy, 0),"
+ " Updated = COALESCE (Updated, SysDate),"
+ " UpdatedBy = COALESCE (UpdatedBy, 0),"
+ " I_ErrorMsg = NULL,"
+ " I_IsImported = 'N' "
+ "WHERE I_IsImported<>'Y' OR I_IsImported IS NULL");
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Reset=" + no);
// Set BP_Group
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET GroupValue=(SELECT MAX(Value) FROM C_BP_Group g WHERE g.IsDefault='Y'"
+ " AND g.AD_Client_ID=i.AD_Client_ID) ");
sql.Append("WHERE GroupValue IS NULL AND C_BP_Group_ID IS NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Set Group Default=" + no);
//
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET C_BP_Group_ID=(SELECT C_BP_Group_ID FROM C_BP_Group g"
+ " WHERE i.GroupValue=g.Value AND g.AD_Client_ID=i.AD_Client_ID) "
+ "WHERE C_BP_Group_ID IS NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Set Group=" + no);
//
String ts = DataBase.DB.IsPostgreSQL() ? "COALESCE(I_ErrorMsg,'')" : "I_ErrorMsg"; //java bug, it could not be used directly
sql = new StringBuilder("UPDATE I_BPartner "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||'ERR=Invalid Group, ' "
+ "WHERE C_BP_Group_ID IS NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Config("Invalid Group=" + no);
// Set Country
/**
* sql = new StringBuilder ("UPDATE I_BPartner i "
+ "SET CountryCode=(SELECT CountryCode FROM C_Country c WHERE c.IsDefault='Y'"
+ " AND c.AD_Client_ID IN (0, i.AD_Client_ID) AND ROWNUM=1) "
+ "WHERE CountryCode IS NULL AND C_Country_ID IS NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
+ no = DataBase.DB.ExecuteQuery(sql.ToString(),null, Get_TrxName());
+ log.Fine("Set Country Default=" + no);
**/
//
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET C_Country_ID=(SELECT C_Country_ID FROM C_Country c"
+ " WHERE i.CountryCode=c.CountryCode AND c.IsSummary='N' AND c.AD_Client_ID IN (0, i.AD_Client_ID)) "
+ "WHERE C_Country_ID IS NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Set Country=" + no);
//
sql = new StringBuilder("UPDATE I_BPartner "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||'ERR=Invalid Country, ' "
+ "WHERE C_Country_ID IS NULL AND (City IS NOT NULL OR Address1 IS NOT NULL)"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Config("Invalid Country=" + no);
// Set Region
sql = new StringBuilder("UPDATE I_BPartner i "
+ "Set RegionName=(SELECT Name FROM C_Region r"
+ " WHERE r.IsDefault='Y' AND r.C_Country_ID=i.C_Country_ID"
+ " AND r.AD_Client_ID IN (0, i.AD_Client_ID)) ");
/*
* if (DataBase.isOracle()) //jz
* {
* sql.Append(" AND ROWNUM=1) ");
* }
* else
* sql.Append(" AND r.UPDATED IN (SELECT MAX(UPDATED) FROM C_Region r1"
+ " WHERE r1.IsDefault='Y' AND r1.C_Country_ID=i.C_Country_ID"
+ " AND r1.AD_Client_ID IN (0, i.AD_Client_ID) ");
*/
sql.Append("WHERE RegionName IS NULL AND C_Region_ID IS NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Set Region Default=" + no);
//
sql = new StringBuilder("UPDATE I_BPartner i "
+ "Set C_Region_ID=(SELECT C_Region_ID FROM C_Region r"
+ " WHERE r.Name=i.RegionName AND r.C_Country_ID=i.C_Country_ID"
+ " AND r.AD_Client_ID IN (0, i.AD_Client_ID)) "
+ "WHERE C_Region_ID IS NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Set Region=" + no);
//
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||'ERR=Invalid Region, ' "
+ "WHERE C_Region_ID IS NULL "
+ " AND EXISTS (SELECT * FROM C_Country c"
+ " WHERE c.C_Country_ID=i.C_Country_ID AND c.HasRegion='Y')"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Config("Invalid Region=" + no);
// Set Greeting
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET C_Greeting_ID=(SELECT C_Greeting_ID FROM C_Greeting g"
+ " WHERE i.BPContactGreeting=g.Name AND g.AD_Client_ID IN (0, i.AD_Client_ID)) "
+ "WHERE C_Greeting_ID IS NULL AND BPContactGreeting IS NOT NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Set Greeting=" + no);
//
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||'ERR=Invalid Greeting, ' "
+ "WHERE C_Greeting_ID IS NULL AND BPContactGreeting IS NOT NULL"
+ " AND I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Config("Invalid Greeting=" + no);
// Existing User ?
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET (C_BPartner_ID,AD_User_ID)="
+ "(SELECT C_BPartner_ID,AD_User_ID FROM AD_User u "
+ "WHERE i.EMail=u.EMail AND u.AD_Client_ID=i.AD_Client_ID) "
+ "WHERE i.EMail IS NOT NULL AND I_IsImported='N'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Found EMail User="******"UPDATE I_BPartner i "
+ "SET C_BPartner_ID=(SELECT C_BPartner_ID FROM C_BPartner p"
+ " WHERE i.Value=p.Value AND p.AD_Client_ID=i.AD_Client_ID) "
+ "WHERE C_BPartner_ID IS NULL AND Value IS NOT NULL"
+ " AND I_IsImported='N'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Found BPartner=" + no);
// Existing Contact ? Match Name
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET AD_User_ID=(SELECT AD_User_ID FROM AD_User c"
+ " WHERE i.ContactName=c.Name AND i.C_BPartner_ID=c.C_BPartner_ID AND c.AD_Client_ID=i.AD_Client_ID) "
+ "WHERE C_BPartner_ID IS NOT NULL AND AD_User_ID IS NULL AND ContactName IS NOT NULL"
+ " AND I_IsImported='N'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Found Contact=" + no);
// Existing Location ? Exact Match
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET C_BPartner_Location_ID=(SELECT C_BPartner_Location_ID"
+ " FROM C_BPartner_Location bpl INNER JOIN C_Location l ON (bpl.C_Location_ID=l.C_Location_ID)"
+ " WHERE i.C_BPartner_ID=bpl.C_BPartner_ID AND bpl.AD_Client_ID=i.AD_Client_ID"
+ " AND DUMP(i.Address1)=DUMP(l.Address1) AND DUMP(i.Address2)=DUMP(l.Address2)"
+ " AND DUMP(i.City)=DUMP(l.City) AND DUMP(i.Postal)=DUMP(l.Postal) AND DUMP(i.Postal_Add)=DUMP(l.Postal_Add)"
+ " AND DUMP(i.C_Region_ID)=DUMP(l.C_Region_ID) AND DUMP(i.C_Country_ID)=DUMP(l.C_Country_ID)) "
+ "WHERE C_BPartner_ID IS NOT NULL AND C_BPartner_Location_ID IS NULL"
+ " AND I_IsImported='N'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Found Location=" + no);
// Interest Area
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET R_InterestArea_ID=(SELECT R_InterestArea_ID FROM R_InterestArea ia "
+ "WHERE i.InterestAreaName=ia.Name AND ia.AD_Client_ID=i.AD_Client_ID) "
+ "WHERE R_InterestArea_ID IS NULL AND InterestAreaName IS NOT NULL"
+ " AND I_IsImported='N'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
log.Fine("Set Interest Area=" + no);
Commit();
// -------------------------------------------------------------------
int noInsert = 0;
int noUpdate = 0;
IDataReader idr = null;
// Go through Records
sql = new StringBuilder("SELECT * FROM I_BPartner "
+ "WHERE I_IsImported='N'").Append(clientCheck);
try
{
//PreparedStatement pstmt = DataBase.prepareStatement(sql.ToString(), Get_TrxName());
//ResultSet rs = pstmt.executeQuery();
idr = DataBase.DB.ExecuteReader(sql.ToString(), null, Get_TrxName());
while (idr.Read())
{
X_I_BPartner impBP = new X_I_BPartner(GetCtx(), idr, Get_TrxName());
log.Fine("I_BPartner_ID=" + impBP.GetI_BPartner_ID()
+ ", C_BPartner_ID=" + impBP.GetC_BPartner_ID()
+ ", C_BPartner_Location_ID=" + impBP.GetC_BPartner_Location_ID()
+ ", AD_User_ID=" + impBP.GetAD_User_ID());
// **** Create/Update BPartner ****
MBPartner bp = null;
if (impBP.GetC_BPartner_ID() == 0) // Insert new BPartner
{
bp = new MBPartner(impBP);
if (bp.Save())
{
impBP.SetC_BPartner_ID(bp.GetC_BPartner_ID());
log.Finest("Insert BPartner - " + bp.GetC_BPartner_ID());
noInsert++;
}
else
{
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||")
.Append("Cannot Insert BPartner")
.Append("WHERE I_BPartner_ID=").Append(impBP.GetI_BPartner_ID());
DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
continue;
}
}
else // Update existing BPartner
{
bp = new MBPartner(GetCtx(), impBP.GetC_BPartner_ID(), Get_TrxName());
// if (impBP.getValue() != null) // not to overwite
// bp.setValue(impBP.getValue());
if (impBP.GetName() != null)
{
bp.SetName(impBP.GetName());
bp.SetName2(impBP.GetName2());
}
if (impBP.GetDUNS() != null)
{
bp.SetDUNS(impBP.GetDUNS());
}
if (impBP.GetTaxID() != null)
{
bp.SetTaxID(impBP.GetTaxID());
}
if (impBP.GetNAICS() != null)
{
bp.SetNAICS(impBP.GetNAICS());
}
if (impBP.GetC_BP_Group_ID() != 0)
{
bp.SetC_BP_Group_ID(impBP.GetC_BP_Group_ID());
}
if (impBP.GetDescription() != null)
{
bp.SetDescription(impBP.GetDescription());
}
//
if (bp.Save())
{
log.Finest("Update BPartner - " + bp.GetC_BPartner_ID());
noUpdate++;
}
else
{
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||")
.Append("' Cannot Update BPartner' ") //jz
.Append("WHERE I_BPartner_ID=").Append(impBP.GetI_BPartner_ID());
DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
continue;
}
}
// **** Create/Update BPartner Location ****
MBPartnerLocation bpl = null;
if (impBP.GetC_BPartner_Location_ID() != 0) // Update Location
{
bpl = new MBPartnerLocation(GetCtx(), impBP.GetC_BPartner_Location_ID(), Get_TrxName());
MLocation location = new MLocation(GetCtx(), bpl.GetC_Location_ID(), Get_TrxName());
location.SetC_Country_ID(impBP.GetC_Country_ID());
location.SetC_Region_ID(impBP.GetC_Region_ID());
location.SetCity(impBP.GetCity());
location.SetAddress1(impBP.GetAddress1());
location.SetAddress2(impBP.GetAddress2());
location.SetPostal(impBP.GetPostal());
location.SetPostal_Add(impBP.GetPostal_Add());
location.SetRegionName(impBP.GetRegionName());
if (!location.Save())
{
log.Warning("Location not updated");
}
else
{
bpl.SetC_Location_ID(location.GetC_Location_ID());
}
if (impBP.GetPhone() != null)
{
bpl.SetPhone(impBP.GetPhone());
}
if (impBP.GetPhone2() != null)
{
bpl.SetPhone2(impBP.GetPhone2());
}
if (impBP.GetFax() != null)
{
bpl.SetFax(impBP.GetFax());
}
bpl.Save();
}
else // New Location
if (impBP.GetC_Country_ID() != 0 &&
impBP.GetAddress1() != null &&
impBP.GetCity() != null)
{
MLocation location = new MLocation(GetCtx(), impBP.GetC_Country_ID(),
impBP.GetC_Region_ID(), impBP.GetCity(), Get_TrxName());
location.SetAddress1(impBP.GetAddress1());
location.SetAddress2(impBP.GetAddress2());
location.SetPostal(impBP.GetPostal());
location.SetPostal_Add(impBP.GetPostal_Add());
location.SetRegionName(impBP.GetRegionName());
if (location.Save())
{
log.Finest("Insert Location - " + location.GetC_Location_ID());
}
else
{
Rollback();
noInsert--;
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||")
.Append("Cannot Insert Location")
.Append("WHERE I_BPartner_ID=").Append(impBP.GetI_BPartner_ID());
DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
continue;
}
//
bpl = new MBPartnerLocation(bp);
bpl.SetC_Location_ID(location.GetC_Location_ID());
bpl.SetPhone(impBP.GetPhone());
bpl.SetPhone2(impBP.GetPhone2());
bpl.SetFax(impBP.GetFax());
if (bpl.Save())
{
log.Finest("Insert BP Location - " + bpl.GetC_BPartner_Location_ID());
impBP.SetC_BPartner_Location_ID(bpl.GetC_BPartner_Location_ID());
}
else
{
Rollback();
noInsert--;
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||")
.Append("Cannot Insert BPLocation")
.Append("WHERE I_BPartner_ID=").Append(impBP.GetI_BPartner_ID());
DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
continue;
}
}
// **** Create/Update Contact ****
MUser user = null;
if (impBP.GetAD_User_ID() != 0)
{
user = new MUser(GetCtx(), impBP.GetAD_User_ID(), Get_TrxName());
if (user.GetC_BPartner_ID() == 0)
{
user.SetC_BPartner_ID(bp.GetC_BPartner_ID());
}
else if (user.GetC_BPartner_ID() != bp.GetC_BPartner_ID())
{
Rollback();
noInsert--;
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||")
.Append("BP of User <> BP")
.Append("WHERE I_BPartner_ID=").Append(impBP.GetI_BPartner_ID());
DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
continue;
}
if (impBP.GetC_Greeting_ID() != 0)
{
user.SetC_Greeting_ID(impBP.GetC_Greeting_ID());
}
String name = impBP.GetContactName();
if (name == null || name.Length == 0)
{
name = impBP.GetEMail();
}
user.SetName(name);
if (impBP.GetTitle() != null)
{
user.SetTitle(impBP.GetTitle());
}
if (impBP.GetContactDescription() != null)
{
user.SetDescription(impBP.GetContactDescription());
}
if (impBP.GetComments() != null)
{
user.SetComments(impBP.GetComments());
}
if (impBP.GetPhone() != null)
{
user.SetPhone(impBP.GetPhone());
}
if (impBP.GetPhone2() != null)
{
user.SetPhone2(impBP.GetPhone2());
}
if (impBP.GetFax() != null)
{
user.SetFax(impBP.GetFax());
}
if (impBP.GetEMail() != null)
{
user.SetEMail(impBP.GetEMail());
}
if (impBP.GetBirthday() != null)
{
user.SetBirthday(impBP.GetBirthday());
}
if (bpl != null)
{
user.SetC_BPartner_Location_ID(bpl.GetC_BPartner_Location_ID());
}
if (user.Save())
{
log.Finest("Update BP Contact - " + user.GetAD_User_ID());
}
else
{
Rollback();
noInsert--;
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||")
.Append("Cannot Update BP Contact")
.Append("WHERE I_BPartner_ID=").Append(impBP.GetI_BPartner_ID());
DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
continue;
}
}
else // New Contact
if (impBP.GetContactName() != null || impBP.GetEMail() != null)
{
user = new MUser(bp);
if (impBP.GetC_Greeting_ID() != 0)
{
user.SetC_Greeting_ID(impBP.GetC_Greeting_ID());
}
String name = impBP.GetContactName();
if (name == null || name.Length == 0)
{
name = impBP.GetEMail();
}
user.SetName(name);
user.SetTitle(impBP.GetTitle());
user.SetDescription(impBP.GetContactDescription());
user.SetComments(impBP.GetComments());
user.SetPhone(impBP.GetPhone());
user.SetPhone2(impBP.GetPhone2());
user.SetFax(impBP.GetFax());
user.SetEMail(impBP.GetEMail());
user.SetBirthday(impBP.GetBirthday());
if (bpl != null)
{
user.SetC_BPartner_Location_ID(bpl.GetC_BPartner_Location_ID());
}
if (user.Save())
{
log.Finest("Insert BP Contact - " + user.GetAD_User_ID());
impBP.SetAD_User_ID(user.GetAD_User_ID());
}
else
{
Rollback();
noInsert--;
sql = new StringBuilder("UPDATE I_BPartner i "
+ "SET I_IsImported='E', I_ErrorMsg=" + ts + "||")
.Append("Cannot Insert BPContact")
.Append("WHERE I_BPartner_ID=").Append(impBP.GetI_BPartner_ID());
DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
continue;
}
}
// Interest Area
if (impBP.GetR_InterestArea_ID() != 0 && user != null)
{
MContactInterest ci = MContactInterest.Get(GetCtx(),
impBP.GetR_InterestArea_ID(), user.GetAD_User_ID(),
true, Get_TrxName());
ci.Save(); // don't subscribe or re-activate
}
//
impBP.SetI_IsImported(X_I_BPartner.I_ISIMPORTED_Yes);
impBP.SetProcessed(true);
impBP.SetProcessing(false);
impBP.Save();
Commit();
} // for all I_Product
idr.Close();
}
catch (Exception e)
{
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, "", e);
Rollback();
}
// Set Error to indicator to not imported
sql = new StringBuilder("UPDATE I_BPartner "
+ "SET I_IsImported='N', Updated=SysDate "
+ "WHERE I_IsImported<>'Y'").Append(clientCheck);
no = DataBase.DB.ExecuteQuery(sql.ToString(), null, Get_TrxName());
AddLog(0, null, Utility.Util.GetValueOfDecimal(no), "@Errors@");
AddLog(0, null, Utility.Util.GetValueOfDecimal(noInsert), "@C_BPartner_ID@: @Inserted@");
AddLog(0, null, Utility.Util.GetValueOfDecimal(noUpdate), "@C_BPartner_ID@: @Updated@");
return("");
} // doIt
} // prepare
/// <summary>
/// Perform Process.
/// </summary>
/// <returns>Message (clear text)</returns>
protected override String DoIt()
{
int index = 1;
StringBuilder sql = new StringBuilder("SELECT * "
+ "FROM S_TimeExpense e "
+ "WHERE e.Processed='Y'"
+ " AND e.AD_Client_ID=@param1"); // #1
if (_C_BPartner_ID != 0 && _C_BPartner_ID != -1)
{
index++;
sql.Append(" AND e.C_BPartner_ID=@param2"); // #2
}
if (_DateFrom != null)
{
index++;
sql.Append(" AND e.DateReport >=@param3"); // #3
}
if (_DateTo != null)
{
index++;
sql.Append(" AND e.DateReport <=@param4"); // #4
sql.Append(" AND EXISTS (SELECT * FROM S_TimeExpenseLine el "
+ "WHERE e.S_TimeExpense_ID=el.S_TimeExpense_ID"
+ " AND el.C_InvoiceLine_ID IS NULL"
+ " AND el.ConvertedAmt<>0) "
+ "ORDER BY e.C_BPartner_ID, e.S_TimeExpense_ID");
}
//
int old_BPartner_ID = -1;
MInvoice invoice = null;
//
//PreparedStatement pstmt = null;
SqlParameter[] param = new SqlParameter[index];
IDataReader idr = null;
DataTable dt = null;
try
{
//pstmt = DataBase.prepareStatement (sql.toString (), get_TrxName());
int par = 0;
//pstmt.setInt(par++, getAD_Client_ID());
param[0] = new SqlParameter("@param1", GetAD_Client_ID());
if (_C_BPartner_ID != 0 && _C_BPartner_ID != -1)
{
par++;
//pstmt.setInt (par++, _C_BPartner_ID);
param[par] = new SqlParameter("@param2", _C_BPartner_ID);
}
if (_DateFrom != null)
{
par++;
//pstmt.setTimestamp (par++, _DateFrom);
param[par] = new SqlParameter("@param3", _DateFrom);
}
if (_DateTo != null)
{
par++;
//pstmt.setTimestamp (par++, _DateTo);
param[par] = new SqlParameter("@param4", _DateTo);
}
//ResultSet rs = pstmt.executeQuery ();
idr = DataBase.DB.ExecuteReader(sql.ToString(), param, Get_TrxName());
dt = new DataTable();
dt.Load(idr);
idr.Close();
foreach (DataRow dr in dt.Rows)
// ********* Expense Line Loop
{
MTimeExpense te = new MTimeExpense(GetCtx(), dr, Get_TrxName());
// New BPartner - New Order
if (te.GetC_BPartner_ID() != old_BPartner_ID)
{
CompleteInvoice(invoice);
MBPartner bp = new MBPartner(GetCtx(), te.GetC_BPartner_ID(), Get_TrxName());
//
log.Info("New Invoice for " + bp);
invoice = new MInvoice(GetCtx(), 0, null);
invoice.SetClientOrg(te.GetAD_Client_ID(), te.GetAD_Org_ID());
invoice.SetC_DocTypeTarget_ID(MDocBaseType.DOCBASETYPE_APINVOICE); // API
invoice.SetDocumentNo(te.GetDocumentNo());
//
invoice.SetBPartner(bp);
if (invoice.GetC_BPartner_Location_ID() == 0)
{
log.Log(Level.SEVERE, "No BP Location: " + bp);
AddLog(0, te.GetDateReport(),
null, "No Location: " + te.GetDocumentNo() + " " + bp.GetName());
invoice = null;
break;
}
invoice.SetM_PriceList_ID(te.GetM_PriceList_ID());
invoice.SetSalesRep_ID(te.GetDoc_User_ID());
String descr = Msg.Translate(GetCtx(), "S_TimeExpense_ID")
+ ": " + te.GetDocumentNo() + " "
+ DisplayType.GetDateFormat(DisplayType.Date).Format(te.GetDateReport());
invoice.SetDescription(descr);
if (!invoice.Save())
{
new Exception("Cannot save Invoice");
}
old_BPartner_ID = bp.GetC_BPartner_ID();
}
MTimeExpenseLine[] tel = te.GetLines(false);
for (int i = 0; i < tel.Length; i++)
{
MTimeExpenseLine line = tel[i];
// Already Invoiced or nothing to be reimbursed
if (line.GetC_InvoiceLine_ID() != 0 ||
Env.ZERO.CompareTo(line.GetQtyReimbursed()) == 0 ||
Env.ZERO.CompareTo(line.GetPriceReimbursed()) == 0)
{
continue;
}
// Update Header info
if (line.GetC_Activity_ID() != 0 && line.GetC_Activity_ID() != invoice.GetC_Activity_ID())
{
invoice.SetC_Activity_ID(line.GetC_Activity_ID());
}
if (line.GetC_Campaign_ID() != 0 && line.GetC_Campaign_ID() != invoice.GetC_Campaign_ID())
{
invoice.SetC_Campaign_ID(line.GetC_Campaign_ID());
}
if (line.GetC_Project_ID() != 0 && line.GetC_Project_ID() != invoice.GetC_Project_ID())
{
invoice.SetC_Project_ID(line.GetC_Project_ID());
}
if (!invoice.Save())
{
new Exception("Cannot save Invoice");
}
// Create OrderLine
MInvoiceLine il = new MInvoiceLine(invoice);
//
if (line.GetM_Product_ID() != 0)
{
il.SetM_Product_ID(line.GetM_Product_ID(), true);
}
il.SetQty(line.GetQtyReimbursed()); // Entered/Invoiced
il.SetDescription(line.GetDescription());
//
il.SetC_Project_ID(line.GetC_Project_ID());
il.SetC_ProjectPhase_ID(line.GetC_ProjectPhase_ID());
il.SetC_ProjectTask_ID(line.GetC_ProjectTask_ID());
il.SetC_Activity_ID(line.GetC_Activity_ID());
il.SetC_Campaign_ID(line.GetC_Campaign_ID());
//
// il.setPrice(); // not really a list/limit price for reimbursements
il.SetPrice(line.GetPriceReimbursed()); //
il.SetTax();
if (!il.Save())
{
new Exception("Cannot save Invoice Line");
}
// Update TEL
line.SetC_InvoiceLine_ID(il.GetC_InvoiceLine_ID());
line.SetIsInvoiced(true);
line.Save();
} // for all expense lines
} // ********* Expense Line Loop
dt = null;
//dt.Clear();
}
catch (Exception e)
{
if (dt != null)
{
dt = null;
}
if (idr != null)
{
idr.Close();
}
log.Log(Level.SEVERE, sql.ToString(), e);
}
finally
{
if (dt != null)
{
dt = null;
}
if (idr != null)
{
idr.Close();
}
}
CompleteInvoice(invoice);
if (_noInvoices == 0)
{
return(" @No Record Found for Invoice Creation@");
}
return("" + _noInvoices + " @Invoices Generated Successfully@");
} // doIt
