protected override String DoIt()
{
string Sql = "Select C_Lead_ID From C_Lead where SalesRep_ID=" + FromSalesRep_ID + " and isactive='Y' and Ad_Org_id=" + GetCtx().GetAD_Org_ID();
IDataReader dr = DB.ExecuteReader(Sql);
try
{
while (dr.Read())
{
VAdvantage.Model.X_C_Lead lead = new VAdvantage.Model.X_C_Lead(GetCtx(), Util.GetValueOfInt(dr[0]), null);
lead.SetSalesRep_ID(ToSalesRep_ID);
lead.Save();
{
}
}
dr.Close();
Sql = "Select C_Project_ID From C_Project where SalesRep_ID=" + FromSalesRep_ID + " and isactive='Y' and Ad_Org_id=" + GetCtx().GetAD_Org_ID();
dr = DB.ExecuteReader(Sql);
while (dr.Read())
{
VAdvantage.Model.X_C_Project Project = new VAdvantage.Model.X_C_Project(GetCtx(), Util.GetValueOfInt(dr[0]), null);
Project.SetSalesRep_ID(ToSalesRep_ID);
Project.Save();
{
}
}
dr.Close();
Sql = "Select C_BPartner_ID From C_BPartner where SalesRep_ID=" + FromSalesRep_ID + " and isactive='Y' and Ad_Org_id=" + GetCtx().GetAD_Org_ID();
dr = DB.ExecuteReader(Sql);
while (dr.Read())
{
VAdvantage.Model.X_C_BPartner BP = new VAdvantage.Model.X_C_BPartner(GetCtx(), Util.GetValueOfInt(dr[0]), null);
BP.SetSalesRep_ID(ToSalesRep_ID);
BP.Save();
{
}
}
dr.Close();
return(Msg.GetMsg(GetCtx(), "RecordsTransferedSuccessfully"));;
}
catch
{
if (dr != null)
{
dr.Close();
}
return(Msg.GetMsg(GetCtx(), "RecordsnotTransfered"));;
}
}
protected override String DoIt()
{
string sql = "Select ad_table_id from ad_table where tablename='C_Lead'";
int leadTable_ID = Util.GetValueOfInt(DB.ExecuteScalar(sql));
sql = "Select ad_table_id from ad_table where tablename='C_BPartner'";
int BPartnerTable_ID = Util.GetValueOfInt(DB.ExecuteScalar(sql));
VAdvantage.Model.X_C_TargetList TList = new VAdvantage.Model.X_C_TargetList(GetCtx(), 0, null);
if (Table_id == leadTable_ID)// C_Lead
{
VAdvantage.Model.X_C_Lead lead = new VAdvantage.Model.X_C_Lead(GetCtx(), Record_ID, null);
TList.Set_ValueNoCheck("C_MasterTargetList_ID", Campaign_id);
// TList.SetC_MasterTargetList_ID(Campaign_id);
TList.SetC_Lead_ID(Record_ID);
TList.SetAddress1(lead.GetAddress1());
TList.SetAddress2(lead.GetAddress2());
TList.SetC_City_ID(lead.GetC_City_ID());
TList.SetCity(lead.GetCity());
TList.SetC_Region_ID(lead.GetC_Region_ID());
TList.SetRegionName(lead.GetRegionName());
TList.SetC_Country_ID(lead.GetC_Country_ID());
TList.SetPostal(lead.GetPostal());
if (TList.Save())
{
return(Msg.GetMsg(GetCtx(), "TargetListCreate"));
}
return(Msg.GetMsg(GetCtx(), "TargetListNotCreate"));
}
if (Table_id == BPartnerTable_ID) // C_BPartner
{
string Query = "select isprospect from c_bpartner where c_bpartner_id=" + Record_ID;
string P = Util.GetValueOfString(DB.ExecuteScalar(Query));
if (P == "Y")
{
// TList.SetC_MasterTargetList_ID(Campaign_id);
TList.Set_ValueNoCheck("C_MasterTargetList_ID", Campaign_id);
TList.SetRef_BPartner_ID(Record_ID);
sql = "Select C_Location_id from c_bpartner_Location where c_bpartner_id=" + Record_ID;
object locID = DB.ExecuteScalar(sql);
TList.SetC_Location_ID(Util.GetValueOfInt(locID));
}
else
{
Query = "select iscustomer from c_bpartner where c_bpartner_id=" + Record_ID;
P = Util.GetValueOfString(DB.ExecuteScalar(Query));
if (P == "Y")
{
//TList.SetC_MasterTargetList_ID(Campaign_id);
TList.Set_ValueNoCheck("C_MasterTargetList_ID", Campaign_id);
TList.SetC_BPartner_ID(Record_ID);
sql = "Select C_Location_id from c_bpartner_Location where c_bpartner_id=" + Record_ID;
object locID = DB.ExecuteScalar(sql);
TList.SetC_Location_ID(Util.GetValueOfInt(locID));
}
else
{
return(Msg.GetMsg(GetCtx(), "TargetListNotCreate"));
}
}
if (TList.Save())
{
return(Msg.GetMsg(GetCtx(), "TargetListCreate"));
}
return(Msg.GetMsg(GetCtx(), "TargetListNotCreate"));
}
return(Msg.GetMsg(GetCtx(), "TargetListCreate"));
}
protected override String DoIt()
{
VAdvantage.Model.X_C_Lead lead = new VAdvantage.Model.X_C_Lead(GetCtx(), _C_Lead_ID, Get_Trx());
if (!(R_InterestArea_ID > 0))
{
return(Msg.GetMsg(GetCtx(), "NoInterestAreaIsSelected"));
}
if (lead.GetC_BPartner_ID() != 0)
{
VAdvantage.Model.X_R_ContactInterest customer = new VAdvantage.Model.X_R_ContactInterest(GetCtx(), 0, Get_Trx());
customer.SetR_InterestArea_ID(R_InterestArea_ID);
customer.SetC_BPartner_ID(lead.GetC_BPartner_ID());
String query = "Select ad_user_id from ad_user where c_bpartner_id= " + lead.GetC_BPartner_ID();
int UserId = Util.GetValueOfInt(DB.ExecuteScalar(query));
customer.SetAD_User_ID(UserId);
query = "Select C_BPartner_Location_id from C_BPartner_Location where c_bpartner_id= " + lead.GetC_BPartner_ID();
int Id = Util.GetValueOfInt(DB.ExecuteScalar(query));
VAdvantage.Model.X_C_BPartner_Location loc = new VAdvantage.Model.X_C_BPartner_Location(GetCtx(), Id, Get_Trx());
customer.SetC_BPartner_Location_ID(Id);
customer.SetPhone(loc.GetPhone());
customer.SetFax(loc.GetFax());
VAdvantage.Model.X_AD_User us = new VAdvantage.Model.X_AD_User(GetCtx(), UserId, Get_Trx());
customer.SetC_Job_ID(us.GetC_Job_ID());
customer.SetSubscribeDate(DateTime.Today);
query = "Select Email from ad_user where ad_user_id= " + UserId;
String mail = Util.GetValueOfString(DB.ExecuteScalar(query));
customer.SetEMail(mail);
if (!customer.Save())
{
return(Msg.GetMsg(GetCtx(), "NotSubscribed"));
}
lead.SetR_InterestArea_ID(customer.GetR_InterestArea_ID());
if (lead.Save())
{
}
return(Msg.GetMsg(GetCtx(), "SubscribedDone"));
}
else if (lead.GetRef_BPartner_ID() != 0)
{
VAdvantage.Model.X_R_ContactInterest Prospect = new VAdvantage.Model.X_R_ContactInterest(GetCtx(), 0, Get_Trx());
Prospect.SetR_InterestArea_ID(R_InterestArea_ID);
Prospect.SetC_BPartner_ID(lead.GetRef_BPartner_ID());
String query = "Select ad_user_id from ad_user where c_bpartner_id= " + lead.GetRef_BPartner_ID();
int UserId = Util.GetValueOfInt(DB.ExecuteScalar(query));
Prospect.SetAD_User_ID(UserId);
query = "Select C_BPartner_Location_id from C_BPartner_Location where c_bpartner_id= " + lead.GetRef_BPartner_ID();
int Id = Util.GetValueOfInt(DB.ExecuteScalar(query));
VAdvantage.Model.X_C_BPartner_Location loc = new VAdvantage.Model.X_C_BPartner_Location(GetCtx(), Id, Get_Trx());
Prospect.SetC_BPartner_Location_ID(Id);
Prospect.SetPhone(loc.GetPhone());
Prospect.SetFax(loc.GetFax());
VAdvantage.Model.X_AD_User us = new VAdvantage.Model.X_AD_User(GetCtx(), UserId, Get_Trx());
Prospect.SetC_Job_ID(us.GetC_Job_ID());
Prospect.SetSubscribeDate(DateTime.Today);
query = "Select Email from ad_user where ad_user_id= " + UserId;
String mail = Util.GetValueOfString(DB.ExecuteScalar(query));
Prospect.SetEMail(mail);
if (!Prospect.Save())
{
return(Msg.GetMsg(GetCtx(), "NotSubscribed"));
}
lead.SetR_InterestArea_ID(Prospect.GetR_InterestArea_ID());
if (lead.Save())
{
}
return(Msg.GetMsg(GetCtx(), "SubscribedDone"));
}
else
{
VAdvantage.Model.X_vss_lead_interestarea Ilead = new VAdvantage.Model.X_vss_lead_interestarea(GetCtx(), 0, Get_Trx());
Ilead.SetC_Lead_ID(lead.GetC_Lead_ID());
Ilead.SetR_InterestArea_ID(R_InterestArea_ID);
Ilead.SetAD_User_ID(lead.GetAD_User_ID());
Ilead.SetBPName(lead.GetBPName());
Ilead.SetEMail(lead.GetEMail());
Ilead.SetPhone(lead.GetPhone());
Ilead.SetFax(lead.GetFax());
Ilead.SetAddress1(lead.GetAddress1());
Ilead.SetAddress2(lead.GetAddress2());
Ilead.SetC_City_ID(lead.GetC_City_ID());
Ilead.SetCity(lead.GetCity());
Ilead.SetC_Region_ID(lead.GetC_Region_ID());
Ilead.SetRegionName(lead.GetRegionName());
Ilead.SetC_Country_ID(lead.GetC_Country_ID());
Ilead.SetPostal(lead.GetPostal());
Ilead.SetSubscribeDate(DateTime.Today);
if (!Ilead.Save())
{
return(Msg.GetMsg(GetCtx(), "NotSubscribed"));
}
lead.SetR_InterestArea_ID(Ilead.GetR_InterestArea_ID());
if (lead.Save())
{
}
return(Msg.GetMsg(GetCtx(), "SubscribedDone"));
}
}
protected override String DoIt()
{
string query = "Select C_CampaignTargetList_id from C_CampaignTargetList where C_Campaign_id=" + GetRecord_ID() + " and ad_client_id = " + GetCtx().GetAD_Client_ID();
IDataReader MainDr = DB.ExecuteReader(query, null, Get_Trx());
IDataReader dr = null;
try
{
query = "Delete From C_InviteeList where C_Campaign_id=" + GetRecord_ID();
int value = DB.ExecuteQuery(query);
while (MainDr.Read())
{
query = "Delete From C_InviteeList where ";
int id = Util.GetValueOfInt(MainDr[0]);
VAdvantage.Model.X_C_CampaignTargetList MCapTarget = new VAdvantage.Model.X_C_CampaignTargetList(GetCtx(), id, null);
if (MCapTarget.GetC_MasterTargetList_ID() != 0)
{
query = "Select C_BPartner_ID from C_TargetList where C_MasterTargetList_ID=" + MCapTarget.GetC_MasterTargetList_ID() + " and C_BPartner_ID is not null";
dr = DB.ExecuteReader(query, null, Get_Trx());
while (dr.Read())
{
invitee(Util.GetValueOfInt(dr[0]));
}
dr.Close();
query = "Select Ref_BPartner_ID from C_TargetList where C_MasterTargetList_ID=" + MCapTarget.GetC_MasterTargetList_ID() + " and Ref_BPartner_ID is not null";
dr = DB.ExecuteReader(query, null, Get_Trx());
while (dr.Read())
{
invitee(Util.GetValueOfInt(dr[0]));
}
dr.Close();
query = "Select C_Lead_ID from C_TargetList where C_MasterTargetList_ID=" + MCapTarget.GetC_MasterTargetList_ID() + " and C_Lead_ID is not null";
dr = DB.ExecuteReader(query, null, Get_Trx());
while (dr.Read())
{
string sql = "Select C_InviteeList_id from C_InviteeList where C_Lead_id=" + Util.GetValueOfInt(dr[0]);
object Leadid = DB.ExecuteScalar(sql, null, Get_Trx());
if (Util.GetValueOfInt(Leadid) == 0)
{
VAdvantage.Model.X_C_Lead lead = new VAdvantage.Model.X_C_Lead(GetCtx(), Util.GetValueOfInt(dr[0]), Get_Trx());
if (lead.GetC_BPartner_ID() != 0)
{
invitee(lead.GetC_BPartner_ID());
}
else if (lead.GetRef_BPartner_ID() != 0)
{
invitee(lead.GetRef_BPartner_ID());
}
else if (lead.GetContactName() != null)
{
VAdvantage.Model.X_C_InviteeList Invt = new VAdvantage.Model.X_C_InviteeList(GetCtx(), 0, Get_Trx());
//Invt.SetC_TargetList_ID(Util.GetValueOfInt(dr[0]));
Invt.SetC_Campaign_ID(GetRecord_ID());
Invt.SetName(lead.GetContactName());
Invt.SetEMail(lead.GetEMail());
Invt.SetPhone(lead.GetPhone());
Invt.SetC_Lead_ID(lead.GetC_Lead_ID());
Invt.SetAddress1(lead.GetAddress1());
Invt.SetAddress1(lead.GetAddress2());
Invt.SetC_City_ID(lead.GetC_City_ID());
Invt.SetCity(lead.GetCity());
Invt.SetC_Region_ID(lead.GetC_Region_ID());
Invt.SetRegionName(lead.GetRegionName());
Invt.SetC_Country_ID(lead.GetC_Country_ID());
Invt.SetPostal(lead.GetPostal());
// Invt.SetURL(url);
if (!Invt.Save())
{
Msg.GetMsg(GetCtx(), "InviteeCteationNotDone");
}
string ID = Invt.GetC_InviteeList_ID().ToString();
string encrypt = FormsAuthentication.HashPasswordForStoringInConfigFile(ID, "SHA1");
string urlFinal = "";
urlFinal = url + "?" + encrypt;
sql = "update c_inviteelist set url = '" + urlFinal + "' where c_inviteelist_id = " + Invt.GetC_InviteeList_ID();
int res = Util.GetValueOfInt(DB.ExecuteQuery(sql, null, Get_Trx()));
//Random rand = new Random();
//String s = "";
//for (int i = 0; i < 9; i++)
// s = String.Concat(s, rand.Next(10).ToString());
//string urlFinal = "";
//// urlFinal = url + "?" + Invt.GetC_InviteeList_ID().ToString();
//urlFinal = url + "?" + s;
////string urlFinal = "";
////urlFinal = url + "?" + Invt.GetC_InviteeList_ID().ToString();
//Invt.SetURL(urlFinal);
//if (!Invt.Save(Get_Trx()))
//{
// Msg.GetMsg(GetCtx(), "InviteeCteationNotDone");
//}
}
}
}
dr.Close();
}
if (MCapTarget.GetR_InterestArea_ID() != 0)
{
query = "Select C_BPartner_ID from R_ContactInterest where R_InterestArea_ID=" + MCapTarget.GetR_InterestArea_ID() + " and C_BPartner_ID is not null";
dr = DB.ExecuteReader(query, null, Get_Trx());
while (dr.Read())
{
invitee(Util.GetValueOfInt(dr[0]));
}
dr.Close();
//query = "Select C_BPartner_ID from C_TargetList where R_InterestArea_ID=" + MCapTarget.GetR_InterestArea_ID();
//dr = DB.ExecuteReader(query);
//while (dr.Read())
//{
// invitee(Util.GetValueOfInt(dr[0]));
//}
//dr.Close();
query = "Select C_Lead_ID from vss_lead_interestarea where R_InterestArea_ID=" + MCapTarget.GetR_InterestArea_ID() + " and C_Lead_ID is not null";
dr = DB.ExecuteReader(query, null, Get_Trx());
while (dr.Read())
{
string sql = "Select C_InviteeList_id from C_InviteeList where C_Lead_id=" + Util.GetValueOfInt(dr[0]);
object Leadid = DB.ExecuteScalar(sql, null, Get_Trx());
if (Util.GetValueOfInt(Leadid) == 0)
{
VAdvantage.Model.X_C_Lead lead = new VAdvantage.Model.X_C_Lead(GetCtx(), Util.GetValueOfInt(dr[0]), Get_Trx());
if (lead.GetC_BPartner_ID() != 0)
{
invitee(lead.GetC_BPartner_ID());
}
else if (lead.GetRef_BPartner_ID() != 0)
{
invitee(lead.GetRef_BPartner_ID());
}
else if (lead.GetContactName() != null)
{
VAdvantage.Model.X_C_InviteeList Invt = new VAdvantage.Model.X_C_InviteeList(GetCtx(), 0, Get_Trx());
//Invt.SetC_TargetList_ID(Util.GetValueOfInt(dr[0]));
Invt.SetC_Campaign_ID(GetRecord_ID());
Invt.SetName(lead.GetContactName());
Invt.SetEMail(lead.GetEMail());
Invt.SetPhone(lead.GetPhone());
Invt.SetC_Lead_ID(lead.GetC_Lead_ID());
Invt.SetAddress1(lead.GetAddress1());
Invt.SetAddress1(lead.GetAddress2());
Invt.SetC_City_ID(lead.GetC_City_ID());
Invt.SetCity(lead.GetCity());
Invt.SetC_Region_ID(lead.GetC_Region_ID());
Invt.SetRegionName(lead.GetRegionName());
Invt.SetC_Country_ID(lead.GetC_Country_ID());
Invt.SetPostal(lead.GetPostal());
//Invt.SetURL(url);
if (!Invt.Save(Get_Trx()))
{
Msg.GetMsg(GetCtx(), "InviteeCteationNotDone");
}
string ID = Invt.GetC_InviteeList_ID().ToString();
string encrypt = FormsAuthentication.HashPasswordForStoringInConfigFile(ID, "SHA1");
string urlFinal = "";
urlFinal = url + "?" + encrypt;
sql = "update c_inviteelist set url = '" + urlFinal + "' where c_inviteelist_id = " + Invt.GetC_InviteeList_ID();
int res = Util.GetValueOfInt(DB.ExecuteQuery(sql, null, Get_Trx()));
//Random rand = new Random();
//String s = "";
//for (int i = 0; i < 9; i++)
// s = String.Concat(s, rand.Next(10).ToString());
//string urlFinal = "";
//urlFinal = url + "?" + s;
////string urlFinal = "";
////urlFinal = url + "?" + Invt.GetC_InviteeList_ID().ToString();
//Invt.SetURL(urlFinal);
//if (!Invt.Save(Get_Trx()))
//{
// Msg.GetMsg(GetCtx(), "InviteeCteationNotDone");
//}
}
}
}
dr.Close();
}
}
MainDr.Close();
}
catch
{
if (MainDr != null)
{
MainDr.Close();
MainDr = null;
}
if (dr != null)
{
dr.Close();
dr = null;
}
}
return(Msg.GetMsg(GetCtx(), "InviteeCteationDone"));
}
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_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_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("");
}
