예제 #1
0
        /**
         *  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);
        }