protected override String DoIt()
{
VAdvantage.Model.X_C_Lead lead = new VAdvantage.Model.X_C_Lead(GetCtx(), _C_Lead_ID, Get_TrxName());
// lead.GetRef_BPartner_ID()))
int ExCustomer = lead.GetC_BPartner_ID();
int Pospect = lead.GetRef_BPartner_ID();
if (ExCustomer != 0)
{
VAdvantage.Model.X_C_Project opp = new VAdvantage.Model.X_C_Project(GetCtx(), 0, Get_TrxName());
opp.SetAD_Client_ID(lead.GetAD_Client_ID());
opp.SetAD_Org_ID(lead.GetAD_Org_ID());
opp.SetC_Lead_ID(lead.GetC_Lead_ID());
opp.SetC_BPartner_ID(lead.GetC_BPartner_ID());
// Addde by Bharat on 19 Feb 2018 to set Ref Partner/Prospect
if (opp.Get_ColumnIndex("Ref_BPartner_ID") > 0)
{
opp.SetRef_BPartner_ID(lead.GetC_BPartner_ID());
}
opp.SetSalesRep_ID(lead.GetSalesRep_ID());
opp.SetDateContract(DateTime.Today);
opp.SetC_Campaign_ID(lead.GetC_Campaign_ID());
//opp.SetR_Source_ID (lead.GetR_Source_ID());
// opp.SetOpportunityStatus("N");
opp.SetAD_User_ID(lead.GetAD_User_ID());
VAdvantage.Model.X_C_BPartner bp = new VAdvantage.Model.X_C_BPartner(GetCtx(), ExCustomer, Get_TrxName());
//VAdvantage.Model.X_C_BPartner_Location loc=new VAdvantage.Model.X_C_BPartner_Location (GetCtx(),ExCustomer,Get_TrxName());
opp.SetName(bp.GetName());;
opp.SetC_BPartner_Location_ID(lead.GetC_BPartner_Location_ID());
opp.SetIsOpportunity(true);
/*Vivek*/
opp.SetC_EnquiryRdate(lead.GetC_EnquiryRdate());
if (lead.GetC_ProposalDdate() != null)
{
opp.SetC_ProposalDdate(Convert.ToDateTime(lead.GetC_ProposalDdate()).ToLocalTime());
}
else
{
opp.SetC_ProposalDdate(lead.GetC_ProposalDdate());
}
if (opp.Save())
{
lead.SetC_Project_ID(opp.GetC_Project_ID());
lead.Save();
return(Msg.GetMsg(GetCtx(), "OpprtunityGenerateDone"));
}
else
{
return(GetRetrievedError(opp, "OpprtunityGenerateNotDone"));
//return Msg.GetMsg(GetCtx(), "OpprtunityGenerateNotDone");
}
}
if (Pospect != 0)
{
VAdvantage.Model.X_C_Project opp = new VAdvantage.Model.X_C_Project(GetCtx(), 0, Get_TrxName());
opp.SetAD_Client_ID(lead.GetAD_Client_ID());
opp.SetAD_Org_ID(lead.GetAD_Org_ID());
opp.SetC_Lead_ID(lead.GetC_Lead_ID());
opp.SetC_BPartnerSR_ID(lead.GetRef_BPartner_ID());
// Addde by Bharat on 19 Feb 2018 to set Ref Partner/Prospect
if (opp.Get_ColumnIndex("Ref_BPartner_ID") > 0)
{
opp.SetRef_BPartner_ID(lead.GetRef_BPartner_ID());
}
opp.SetSalesRep_ID(lead.GetSalesRep_ID());
opp.SetDateContract(DateTime.Today);
opp.SetC_Campaign_ID(lead.GetC_Campaign_ID());
// opp.SetR_Source_ID (lead.GetR_Source_ID());
//opp.SetOpportunityStatus ("N");
// opp.SetAD_Client_ID(GetAD_Client_ID());
opp.SetAD_User_ID(lead.GetAD_User_ID());
VAdvantage.Model.X_C_BPartner bp = new VAdvantage.Model.X_C_BPartner(GetCtx(), Pospect, Get_TrxName());
//X_C_BPartner_Location loc = new X_C_BPartner_Location(GetCtx(), Pospect, Get_TrxName());
opp.SetName(bp.GetName());
opp.SetC_BPartner_Location_ID(lead.GetC_BPartner_Location_ID());
opp.SetIsOpportunity(true);
/*Vivek*/
opp.SetC_EnquiryRdate(lead.GetC_EnquiryRdate());
if (lead.GetC_ProposalDdate() != null)
{
opp.SetC_ProposalDdate(Convert.ToDateTime(lead.GetC_ProposalDdate()).ToLocalTime());
}
else
{
opp.SetC_ProposalDdate(lead.GetC_ProposalDdate());
}
if (opp.Save())
{
lead.SetC_Project_ID(opp.GetC_Project_ID());
lead.Save();
return(Msg.GetMsg(GetCtx(), "OpprtunityGenerateDone"));
}
else
{
return(GetRetrievedError(opp, "OpprtunityGenerateNotDone"));
//return Msg.GetMsg(GetCtx(), "OpprtunityGenerateNotDone");
}
}
if (ExCustomer == 0 && Pospect == 0)
{
//CallProcess(_C_Lead_ID);
if (lead.GetBPName() == null)
{
return(Msg.GetMsg(GetCtx(), "Company Name, Prospect or Bpartner is Mandatory to fill"));
}
callprospect();
return(DoIt());
}
return(Msg.GetMsg(GetCtx(), "OpprtunityGenerateNotDone"));
}
protected override String DoIt()
{
VAdvantage.Model.X_C_Lead lead = new VAdvantage.Model.X_C_Lead(GetCtx(), _C_Lead_ID, Get_TrxName());
// lead.GetRef_BPartner_ID()))
int ExCustomer = lead.GetC_BPartner_ID();
int Pospect = lead.GetRef_BPartner_ID();
if (ExCustomer != 0)
{
VAdvantage.Model.X_C_Project opp = new VAdvantage.Model.X_C_Project(GetCtx(), 0, Get_TrxName());
opp.SetC_Lead_ID(lead.GetC_Lead_ID());
opp.SetC_BPartner_ID(lead.GetC_BPartner_ID());
opp.SetSalesRep_ID(lead.GetSalesRep_ID());
opp.SetDateContract(DateTime.Today);
opp.SetC_Campaign_ID(lead.GetC_Campaign_ID());
//opp.SetR_Source_ID (lead.GetR_Source_ID());
// opp.SetOpportunityStatus("N");
opp.SetAD_User_ID(lead.GetAD_User_ID());
VAdvantage.Model.X_C_BPartner bp = new VAdvantage.Model.X_C_BPartner(GetCtx(), ExCustomer, Get_TrxName());
//VAdvantage.Model.X_C_BPartner_Location loc=new VAdvantage.Model.X_C_BPartner_Location (GetCtx(),ExCustomer,Get_TrxName());
opp.SetName(bp.GetName());;
opp.SetC_BPartner_Location_ID(lead.GetC_BPartner_Location_ID());
opp.SetIsOpportunity(true);
if (opp.Save())
{
lead.SetC_Project_ID(opp.GetC_Project_ID());
lead.Save();
return(Msg.GetMsg(GetCtx(), "OpprtunityGenerateDone"));
}
else
{
return(Msg.GetMsg(GetCtx(), "OpprtunityGenerateNotDone"));
}
}
if (Pospect != 0)
{
VAdvantage.Model.X_C_Project opp = new VAdvantage.Model.X_C_Project(GetCtx(), 0, Get_TrxName());
opp.SetC_Lead_ID(lead.GetC_Lead_ID());
opp.SetC_BPartnerSR_ID(lead.GetRef_BPartner_ID());
opp.SetSalesRep_ID(lead.GetSalesRep_ID());
opp.SetDateContract(DateTime.Today);
opp.SetC_Campaign_ID(lead.GetC_Campaign_ID());
// opp.SetR_Source_ID (lead.GetR_Source_ID());
//opp.SetOpportunityStatus ("N");
// opp.SetAD_Client_ID(GetAD_Client_ID());
opp.SetAD_User_ID(lead.GetAD_User_ID());
VAdvantage.Model.X_C_BPartner bp = new VAdvantage.Model.X_C_BPartner(GetCtx(), Pospect, Get_TrxName());
//X_C_BPartner_Location loc = new X_C_BPartner_Location(GetCtx(), Pospect, Get_TrxName());
opp.SetName(bp.GetName());
opp.SetC_BPartner_Location_ID(lead.GetC_BPartner_Location_ID());
opp.SetIsOpportunity(true);
if (opp.Save())
{
lead.SetC_Project_ID(opp.GetC_Project_ID());
lead.Save();
return(Msg.GetMsg(GetCtx(), "OpprtunityGenerateDone"));
}
else
{
return(Msg.GetMsg(GetCtx(), "OpprtunityGenerateNotDone"));
}
}
if (ExCustomer == 0 && Pospect == 0)
{
//CallProcess(_C_Lead_ID);
if (lead.GetBPName() == null)
{
return(Msg.GetMsg(GetCtx(), "Company Name, Prospect or Bpartner is Mandatory to fill"));
}
callprospect();
return(DoIt());
}
return(Msg.GetMsg(GetCtx(), "OpprtunityGenerateNotDone"));
}
protected override string DoIt()
{
VAdvantage.Model.X_C_BPartner partner = new VAdvantage.Model.X_C_BPartner(GetCtx(), GetRecord_ID(), null);
string _BPName = partner.GetName();
string _sql = "Select C_Lead_ID From C_Lead Where BPName='" + _BPName + "' AND IsActive = 'Y' AND AD_Client_ID = " + GetAD_Client_ID();
DataSet ds = new DataSet();
ds = DB.ExecuteDataset(_sql.ToString());
if (ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
_C_Lead_ID = Util.GetValueOfInt(ds.Tables[0].Rows[i]["C_Lead_ID"]);
VAdvantage.Model.X_C_Lead lead = new VAdvantage.Model.X_C_Lead(GetCtx(), _C_Lead_ID, Get_TrxName());
// lead.GetRef_BPartner_ID()))
//int ExCustomer = lead.GetC_BPartner_ID();
int Pospect = lead.GetRef_BPartner_ID();
if (Pospect != 0)
{
VAdvantage.Model.X_C_Project opp = new VAdvantage.Model.X_C_Project(GetCtx(), 0, Get_TrxName());
opp.SetC_Lead_ID(lead.GetC_Lead_ID());
opp.SetC_BPartnerSR_ID(lead.GetRef_BPartner_ID());
opp.SetSalesRep_ID(lead.GetSalesRep_ID());
opp.SetDateContract(DateTime.Today);
opp.SetC_Campaign_ID(lead.GetC_Campaign_ID());
// opp.SetR_Source_ID (lead.GetR_Source_ID());
//opp.SetOpportunityStatus ("N");
// opp.SetAD_Client_ID(GetAD_Client_ID());
opp.SetAD_User_ID(lead.GetAD_User_ID());
VAdvantage.Model.X_C_BPartner bp = new VAdvantage.Model.X_C_BPartner(GetCtx(), Pospect, Get_TrxName());
//X_C_BPartner_Location loc = new X_C_BPartner_Location(GetCtx(), Pospect, Get_TrxName());
opp.SetName(bp.GetName());
opp.SetC_BPartner_Location_ID(lead.GetC_BPartner_Location_ID());
opp.SetIsOpportunity(true);
if (opp.Save())
{
lead.SetC_Project_ID(opp.GetC_Project_ID());
lead.Save();
bp.SetCreateProject("Y");
if (bp.Save())
{
}
return(Msg.GetMsg(GetCtx(), "OpprtunityGenerateDone"));
}
else
{
return(Msg.GetMsg(GetCtx(), "OpprtunityGenerateNotDone"));
}
}
//if (ExCustomer != 0)
//{
// VAdvantage.Model.X_C_Project opp = new VAdvantage.Model.X_C_Project(GetCtx(), 0, Get_TrxName());
// opp.SetC_Lead_ID(lead.GetC_Lead_ID());
// opp.SetC_BPartner_ID(lead.GetC_BPartner_ID());
// opp.SetSalesRep_ID(lead.GetSalesRep_ID());
// opp.SetDateContract(DateTime.Today);
// opp.SetC_Campaign_ID(lead.GetC_Campaign_ID());
// opp.SetR_Source_ID(lead.GetR_Source_ID());
// opp.SetOpportunityStatus("N");
// opp.SetAD_User_ID(lead.GetAD_User_ID());
// VAdvantage.Model.X_C_BPartner bp = new VAdvantage.Model.X_C_BPartner(GetCtx(), ExCustomer, Get_TrxName());
// VAdvantage.Model.X_C_BPartner_Location loc = new VAdvantage.Model.X_C_BPartner_Location(GetCtx(), ExCustomer, Get_TrxName());
// opp.SetName(bp.GetName()); ;
// opp.SetC_BPartner_Location_ID(lead.GetC_BPartner_Location_ID());
// opp.SetIsOpportunity(true);
// if (opp.Save())
// {
// lead.SetC_Project_ID(opp.GetC_Project_ID());
// lead.Save();
// return Msg.GetMsg(GetCtx(), "OpprtunityGenerateDone");
// }
// else
// {
// return Msg.GetMsg(GetCtx(), "OpprtunityGenerateNotDone");
// }
//}
}
}
return("");
}
