protected override string DoIt()
{
// Int32 value = 0;
string msg = "";
log.Info("C_Project_ID=" + _C_Project_ID);
if (_C_Project_ID == 0)
{
throw new ArgumentException("C_Project_ID == 0");
}
VAdvantage.Model.MProject fromProject = new VAdvantage.Model.MProject(GetCtx(), _C_Project_ID, null);
if (fromProject.GetGenerate_Quotation() == null)
{
throw new ArgumentException("No Generate Quotation found on Project.");
}
if (fromProject.GetGenerate_Quotation().Trim() == "Y")
{
throw new ArgumentException("Sales Quotation already generated");
}
VAdvantage.Model.MOrder order = new VAdvantage.Model.MOrder(GetCtx(), 0, null);
C_Bpartner_id = fromProject.GetC_BPartner_ID();
C_Bpartner_Location_id = fromProject.GetC_BPartner_Location_ID();
C_BPartnerSR_ID = fromProject.GetC_BPartnerSR_ID();
//MBPartner bp = new MBPartner(GetCtx(), C_Bpartner_id, null);
VAdvantage.Model.MBPartnerLocation bpartnerloc = new VAdvantage.Model.MBPartnerLocation(GetCtx(), C_Bpartner_Location_id, null);
String currentdate = DateTime.Now.ToString();
String sqlprjln = " select c_projectline_id from c_projectline where c_project_id=" + _C_Project_ID + "";
C_ProjectLine_ID = VAdvantage.Utility.Util.GetValueOfInt(DB.ExecuteScalar(sqlprjln));
if (C_ProjectLine_ID != 0)
{
order.SetDateOrdered(Convert.ToDateTime(currentdate));
order.SetDatePromised(Convert.ToDateTime(currentdate));
if (C_Bpartner_id != 0)
{
order.SetC_BPartner_ID(fromProject.GetC_BPartner_ID());
if (bpartnerloc.IsShipTo() == true)
{
order.SetC_BPartner_Location_ID(fromProject.GetC_BPartner_Location_ID());
order.SetAD_User_ID(fromProject.GetAD_User_ID());
}
if (bpartnerloc.IsBillTo() == true)
{
order.SetBill_Location_ID(fromProject.GetC_BPartner_Location_ID());
order.SetBill_User_ID(fromProject.GetAD_User_ID());
}
}
if (C_BPartnerSR_ID != 0)
{
//String sqlcust = "update c_bpartner set iscustomer='Y', isprospect='N' where c_bpartner_id=" + C_BPartnerSR_ID + "";
//value = DB.ExecuteQuery(sqlcust, null, null);
//if (value == -1)
//{
//}
//bp.SetIsCustomer(true);
//bp.SetIsProspect(false);
order.SetC_BPartner_ID(fromProject.GetC_BPartnerSR_ID());
if (bpartnerloc.IsShipTo() == true)
{
order.SetC_BPartner_Location_ID(fromProject.GetC_BPartner_Location_ID());
order.SetAD_User_ID(fromProject.GetAD_User_ID());
}
if (bpartnerloc.IsBillTo() == true)
{
order.SetBill_Location_ID(fromProject.GetC_BPartner_Location_ID());
order.SetBill_User_ID(fromProject.GetAD_User_ID());
}
}
// String sql = "select c_doctype_id from c_doctype where docbasetype= 'SOO' and = 'Sales Quotation'";
String sql = "select c_doctype_id from c_doctype where docbasetype = 'SOO' and docsubtypeso = 'ON' and isreturntrx = 'N' and ad_client_id = " + GetCtx().GetAD_Client_ID();
int Doctype_id = VAdvantage.Utility.Util.GetValueOfInt(DB.ExecuteScalar(sql));
int MPriceList_id = Util.GetValueOfInt(fromProject.GetM_PriceList_ID());
order.SetM_PriceList_ID(MPriceList_id);
////String sqlmpricelist = "select m_pricelist_id from m_pricelist where name='Export'";
////int MPriceList_id = VAdvantage.Utility.Util.GetValueOfInt(DB.ExecuteScalar(sqlmpricelist));
//if (MPriceList_id == order.GetM_PriceList_ID())
//{
// String sqlconversiontype = "select c_conversiontype_id from c_conversiontype where value = 'C'";
// int C_ConversionType_id = VAdvantage.Utility.Util.GetValueOfInt(DB.ExecuteScalar(sqlconversiontype));
// order.SetC_ConversionType_ID(C_ConversionType_id);
//}
order.SetC_Project_ID(GetRecord_ID());
if (fromProject.GetSalesRep_ID() > 0)
{
order.SetSalesRep_ID(fromProject.GetSalesRep_ID());
}
order.SetC_Currency_ID(fromProject.GetC_Currency_ID());
if (C_Bpartner_id != 0)
{
VAdvantage.Model.MBPartner bp = new VAdvantage.Model.MBPartner(GetCtx(), C_Bpartner_id, null);
if (bp.GetC_Campaign_ID() == 0 && fromProject.GetC_Campaign_ID() > 0)
{
bp.SetC_Campaign_ID(fromProject.GetC_Campaign_ID());
}
bp.SetAD_Client_ID(fromProject.GetAD_Client_ID());
bp.SetAD_Org_ID(fromProject.GetAD_Org_ID());
if (bp.GetC_PaymentTerm_ID() != 0)
{
order.SetPaymentMethod(bp.GetPaymentRule());
order.SetC_PaymentTerm_ID(bp.GetC_PaymentTerm_ID());
}
if (!bp.Save())
{
log.SaveError("CampaignIDNotSaved", "");
return(Msg.GetMsg(GetCtx(), "CampaignIDtNotSaved"));
}
}
else
{
VAdvantage.Model.MBPartner bp = new VAdvantage.Model.MBPartner(GetCtx(), C_BPartnerSR_ID, null);
if (bp.GetC_Campaign_ID() == 0 && fromProject.GetC_Campaign_ID() > 0)
{
bp.SetC_Campaign_ID(fromProject.GetC_Campaign_ID());
}
bp.SetAD_Client_ID(fromProject.GetAD_Client_ID());
bp.SetAD_Org_ID(fromProject.GetAD_Org_ID());
if (bp.GetC_PaymentTerm_ID() != 0)
{
order.SetPaymentMethod(bp.GetPaymentRule());
order.SetC_PaymentTerm_ID(bp.GetC_PaymentTerm_ID());
}
if (!bp.Save())
{
log.SaveError("CampaignIDtNotSaved", "");
return(Msg.GetMsg(GetCtx(), "CampaignIDtNotSaved"));
}
}
//if (bp.GetC_PaymentTerm_ID() != 0)
//{
// order.SetPaymentMethod(bp.GetPaymentRule());
// order.SetC_PaymentTerm_ID(bp.GetC_PaymentTerm_ID());
//}
order.SetFreightCostRule("I");
if (order.GetC_Campaign_ID() == 0 && fromProject.GetC_Campaign_ID() > 0)
{
order.SetC_Campaign_ID(fromProject.GetC_Campaign_ID());
}
order.SetDocStatus("IP");
order.SetC_DocType_ID(Doctype_id);
order.SetC_DocTypeTarget_ID(Doctype_id);
order.SetIsSOTrx(true);
if (!order.Save())
{
log.SaveError("SaleOrdertNotSaved", "");
return(Msg.GetMsg(GetCtx(), "SaleOrdertNotSaved"));
}
//Order Lines
int count = 0;
VAdvantage.Model.MProjectLine[] lines = fromProject.GetLines();
for (int i = 0; i < lines.Length; i++)
{
VAdvantage.Model.MOrderLine ol = new VAdvantage.Model.MOrderLine(order);
ol.SetLine(lines[i].GetLine());
ol.SetDescription(lines[i].GetDescription());
ol.SetM_Product_ID(lines[i].GetM_Product_ID(), true);
ol.SetQtyEntered(lines[i].GetPlannedQty());
ol.SetQtyOrdered(lines[i].GetPlannedQty());
ol.SetPriceEntered(lines[i].GetPlannedPrice());
ol.SetPriceActual(lines[i].GetPlannedPrice());
ol.SetPriceList(lines[i].GetPriceList());
if (ol.Save())
{
count++;
}
}
fromProject.SetRef_Order_ID(order.GetC_Order_ID());
fromProject.SetGenerate_Quotation("Y");
if (!fromProject.Save())
{
log.SaveError("ProjectNotSaved", "");
return(Msg.GetMsg(GetCtx(), "ProjectNotSaved"));;
}
msg = Msg.GetMsg(GetCtx(), "QuotationGenerated");
}
else
{
msg = Msg.GetMsg(GetCtx(), "No Lines");
}
return(msg);
}