protected override String DoIt()
{
if (!(R_InterestArea_ID > 0))
{
return(Msg.GetMsg(GetCtx(), "NoInterestAreaIsSelected"));
}
else
{
X_R_ContactInterest customer = new X_R_ContactInterest(GetCtx(), 0, Get_TrxName());
customer.SetR_InterestArea_ID(R_InterestArea_ID);
customer.SetC_BPartner_ID(_C_BPartner_ID);
String query = "Select ad_user_id from ad_user where c_bpartner_id= " + _C_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= " + _C_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_TrxName());
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_TrxName());
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"));
}
return(Msg.GetMsg(GetCtx(), "SubscribedDone"));
}
}
/**
* Create BP, Contact, Location from Lead
* @return error message
*/
public String CreateBP()
{
if (GetC_BPartner_ID() != 0 && GetAD_User_ID() != 0 && GetC_BPartner_Location_ID() == 0)
{
return("@AlreadyExists@: @C_BPartner_ID@ (ID=" + GetC_BPartner_ID() + ")");
}
// BPartner
if (GetC_BPartner_ID() == 0 &&
(GetBPName() != null && GetBPName().Length > 0))
{
// Existing User
_user = GetUser();
if (_user != null)
{
if (_user.GetC_BPartner_ID() != 0)
{
SetRef_BPartner_ID(_user.GetC_BPartner_ID());
log.Info("Set to BPartner of User - " + _user);
return(CreateBPLocation());
}
}
//
_bp = new MBPartner(GetCtx(), Get_TrxName()); // Template
_bp.SetAD_Org_ID(GetAD_Org_ID());
//_bp.SetValue(GetBPName());
_bp.SetName(GetBPName());
_bp.SetIsCustomer(false);
_bp.SetIsProspect(true);
_bp.SetSOCreditStatus("O");
// Check Removed as per Surya Sir's Decision BY Lokesh
//_bp.SetC_Campaign_ID(GetC_Campaign_ID());
//
if (GetC_BP_Group_ID() == 0)
{
// ShowMessage.Info("First Select Customer Group Then process again", true, null, null);
return(null);
}
else
{
_bp.SetC_BP_Group_ID(GetC_BP_Group_ID());
}
MBPGroup gp = new MBPGroup(GetCtx(), GetC_BP_Group_ID(), Get_TrxName());
_bp.SetM_PriceList_ID(gp.GetM_PriceList_ID());
if (GetC_BP_Size_ID() != 0)
{
_bp.SetC_BP_Size_ID(GetC_BP_Size_ID());
}
if (GetURL() != null)
{
_bp.SetURL(GetURL());
}
if (GetC_BP_Status_ID() != 0)
{
_bp.SetC_BP_Status_ID(GetC_BP_Status_ID());
}
if (GetC_IndustryCode_ID() != 0)
{
_bp.SetC_IndustryCode_ID(GetC_IndustryCode_ID());
}
if (GetNAICS() != null)
{
_bp.SetNAICS(GetNAICS());
}
if (GetDUNS() != null)
{
_bp.SetDUNS(GetDUNS());
}
if (GetNumberEmployees() != 0)
{
_bp.SetNumberEmployees(GetNumberEmployees());
}
if (GetSalesVolume() != 0)
{
_bp.SetSalesVolume(GetSalesVolume());
}
if (GetSalesRep_ID() != 0)
{
_bp.SetSalesRep_ID(GetSalesRep_ID());
}
if (GetC_Campaign_ID() != 0)
{
_bp.SetC_Campaign_ID(GetC_Campaign_ID());
}
if (!_bp.Save())
{
return("@SaveError@");
}
// Update User
if (_user != null && _user.GetC_BPartner_ID() == 0)
{
_user.SetC_BPartner_ID(_bp.GetC_BPartner_ID());
_user.Save();
}
// Save BP
SetRef_BPartner_ID(_bp.GetC_BPartner_ID());
}
String error = CreateBPContact();
if (error != null && error.Length > 0)
{
return(error);
}
CreateBPLocation();
try
{
int id = _bp.GetC_BPartner_ID();
string qry = "Update c_bpartner set Description='' where c_bpartner_id=" + id;
int check = DB.ExecuteQuery(qry, null, Get_TrxName());
string val = _bp.GetValue();
qry = "Update c_bpartner set Value='" + val + GetBPName() + "' where c_bpartner_id=" + id;
check = DB.ExecuteQuery(qry, null, Get_TrxName());
if (GetR_InterestArea_ID() != 0)
{
string sql = "Select R_InterestArea_ID from vss_lead_interestarea where C_Lead_ID=" + GetC_Lead_ID();
IDataReader dr = DB.ExecuteReader(sql, null, Get_TrxName());
while (dr.Read())
{
X_R_ContactInterest Prospect = new X_R_ContactInterest(GetCtx(), 0, Get_TrxName());
Prospect.SetR_InterestArea_ID(Util.GetValueOfInt(dr[0]));
Prospect.SetC_BPartner_ID(GetRef_BPartner_ID());
String query = "Select ad_user_id from ad_user where c_bpartner_id= " + GetRef_BPartner_ID();
int UserId = Util.GetValueOfInt(DB.ExecuteScalar(query, null, Get_TrxName()));
Prospect.SetAD_User_ID(UserId);
query = "Select C_BPartner_Location_id from C_BPartner_Location where c_bpartner_id= " + GetRef_BPartner_ID();
int Id = Util.GetValueOfInt(DB.ExecuteScalar(query, null, Get_TrxName()));
X_C_BPartner_Location loc = new X_C_BPartner_Location(GetCtx(), Id, Get_TrxName());
Prospect.SetC_BPartner_Location_ID(Id);
Prospect.SetPhone(loc.GetPhone());
Prospect.SetFax(loc.GetFax());
X_AD_User us = new X_AD_User(GetCtx(), UserId, Get_TrxName());
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, null, Get_TrxName()));
Prospect.SetEMail(mail);
if (Prospect.Save())
{
}
}
dr.Close();
}
}
catch
{
}
return(null);
}
