/**
* Get BPartner
* @return bp or null
*/
public MBPartner GetBPartner()
{
if (GetC_BPartner_ID() == 0)
{
_bp = null;
}
else if (_bp == null ||
_bp.GetC_BPartner_ID() != GetC_BPartner_ID())
{
_bp = new MBPartner(GetCtx(), GetC_BPartner_ID(), Get_TrxName());
}
return(_bp);
}
/**
* BP Parent Constructor
* @param bp partner
*/
public MBPartnerLocation(MBPartner bp)
: this(bp.GetCtx(), 0, bp.Get_TrxName())
{
SetClientOrg(bp);
// may (still) be 0
Set_ValueNoCheck("C_BPartner_ID", (int)(bp.GetC_BPartner_ID()));
}
/// <summary>
/// Parent Constructor
/// </summary>
/// <param name="rfq">rfq</param>
/// <param name="partner">web response</param>
public MRfQResponse(MRfQ rfq, MBPartner partner)
: this(rfq, null,
partner.GetC_BPartner_ID(),
partner.GetPrimaryC_BPartner_Location_ID(),
partner.GetPrimaryAD_User_ID())
{
}
/**
* Constructor
* @param ctx context
* @param bp BP
* @param bpc BP Contact
* @param location Location
*/
public MBPBankAccount(Ctx ctx, MBPartner bp, MUser bpc, MLocation location)
: this(ctx, 0, bp.Get_TrxName())
{
SetIsACH(false);
//
SetC_BPartner_ID(bp.GetC_BPartner_ID());
//
SetA_Name(bpc.GetName());
SetA_EMail(bpc.GetEMail());
//
SetA_Street(location.GetAddress1());
SetA_City(location.GetCity());
SetA_Zip(location.GetPostal());
SetA_State(location.GetRegionName(true));
SetA_Country(location.GetCountryName());
}
/// <summary>
/// Set BPartner
/// </summary>
/// <param name="bp">partner</param>
/// <param name="isSOTrx">SO</param>
public void SetBPartner(MBPartner bp, bool isSOTrx)
{
SetC_BPartner_ID(bp.GetC_BPartner_ID());
MBPartnerLocation[] locations = bp.GetLocations(false);
// Location
if (locations.Length == 1)
{
SetC_BPartner_Location_ID(locations[0].GetC_BPartner_Location_ID());
}
else
{
for (int i = 0; i < locations.Length; i++)
{
MBPartnerLocation location = locations[i];
if (!location.IsActive())
{
continue;
}
if ((location.IsPayFrom() && isSOTrx) ||
(location.IsRemitTo() && !isSOTrx))
{
SetC_BPartner_Location_ID(location.GetC_BPartner_Location_ID());
break;
}
}
}
if (GetC_BPartner_Location_ID() == 0)
{
String msg = "@C_BPartner_ID@ " + bp.GetName();
if (isSOTrx)
{
msg += " @No@ @IsPayFrom@";
}
else
{
msg += " @No@ @IsRemitTo@";
}
throw new ArgumentException(msg);
}
// User with location
MUser[] users = MUser.GetOfBPartner(GetCtx(), bp.GetC_BPartner_ID());
if (users.Length == 1)
{
SetAD_User_ID(users[0].GetAD_User_ID());
}
else
{
for (int i = 0; i < users.Length; i++)
{
MUser user = users[i];
if (user.GetC_BPartner_Location_ID() == GetC_BPartner_Location_ID())
{
SetAD_User_ID(users[i].GetAD_User_ID());
break;
}
}
}
//
int SalesRep_ID = bp.GetSalesRep_ID();
if (SalesRep_ID != 0)
{
SetSalesRep_ID(SalesRep_ID);
}
}
/// <summary>
/// Set BPartner
/// </summary>
/// <param name="bp">partner</param>
/// <param name="isSOTrx">SO</param>
public void SetBPartner(MBPartner bp, bool isSOTrx)
{
SetC_BPartner_ID(bp.GetC_BPartner_ID());
MBPartnerLocation[] locations = GetLocations();
// Location
for (int i = 0; i < locations.Length; i++)
{
MBPartnerLocation location = locations[i];
if (!location.IsActive())
{
continue;
}
if ((location.IsPayFrom() && isSOTrx) ||
(location.IsRemitTo() && !isSOTrx))
{
SetC_BPartner_Location_ID(location.GetC_BPartner_Location_ID());
break;
}
}
//}
if (GetC_BPartner_Location_ID() == 0)
{
String msg = "@C_BPartner_ID@ " + bp.GetName();
if (isSOTrx)
{
msg += " @No@ @IsPayFrom@";
}
else
{
msg += " @No@ @IsRemitTo@";
}
//throw new ArgumentException(msg);
log.SaveInfo("", msg);
return;
}
// User with location
// Change done by mohit to pick users sorted by date updated. 7 May 2019.
MUser[] users = GetOfBPartner(GetCtx(), bp.GetC_BPartner_ID());
if (users.Length == 1)
{
if (users[0].IsEmail() || users[0].GetNotificationType() == MUser.NOTIFICATIONTYPE_EMail ||
users[0].GetNotificationType() == MUser.NOTIFICATIONTYPE_EMailPlusNotice || users[0].GetNotificationType() == MUser.NOTIFICATIONTYPE_EMailPlusFaxEMail)
{
SetAD_User_ID(users[0].GetAD_User_ID());
}
}
else
{
for (int i = 0; i < users.Length; i++)
{
MUser user = users[i];
if (user.GetC_BPartner_Location_ID() == GetC_BPartner_Location_ID() && (user.IsEmail() || user.GetNotificationType() == MUser.NOTIFICATIONTYPE_EMail ||
user.GetNotificationType() == MUser.NOTIFICATIONTYPE_EMailPlusNotice || user.GetNotificationType() == MUser.NOTIFICATIONTYPE_EMailPlusFaxEMail))
{
SetAD_User_ID(users[i].GetAD_User_ID());
break;
}
}
}
//
int SalesRep_ID = bp.GetSalesRep_ID();
if (SalesRep_ID != 0)
{
SetSalesRep_ID(SalesRep_ID);
}
}
/**
* 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);
}