public static void GetPrimaryContactAddressStep( ICustevent custevent, out System.String result) { // TODO: Complete business rule implementation using (ISession session = new SessionScopeWrapper()) { string sql = "select top 1 a.address1 from sysdba.opportunity_contact oc left join sysdba.contact c on oc.contactid=c.contactid left join sysdba.address a on a.entityid=c.contactid where oc.isprimary='T' and a.isprimary='T' and opportunityid='"+custevent.Id.ToString()+"'"; string add1 = session.CreateSQLQuery(sql).UniqueResult<string>(); sql = "select top 1 a.address2 from sysdba.opportunity_contact oc left join sysdba.contact c on oc.contactid=c.contactid left join sysdba.address a on a.entityid=c.contactid where oc.isprimary='T' and a.isprimary='T' and opportunityid='"+custevent.Id.ToString()+"'"; string add2 = session.CreateSQLQuery(sql).UniqueResult<string>(); sql = "select top 1 a.city from sysdba.opportunity_contact oc left join sysdba.contact c on oc.contactid=c.contactid left join sysdba.address a on a.entityid=c.contactid where oc.isprimary='T' and a.isprimary='T' and opportunityid='"+custevent.Id.ToString()+"'"; string city = session.CreateSQLQuery(sql).UniqueResult<string>(); sql = "select top 1 a.state from sysdba.opportunity_contact oc left join sysdba.contact c on oc.contactid=c.contactid left join sysdba.address a on a.entityid=c.contactid where oc.isprimary='T' and a.isprimary='T' and opportunityid='"+custevent.Id.ToString()+"'"; string state = session.CreateSQLQuery(sql).UniqueResult<string>(); sql = "select top 1 a.postalcode from sysdba.opportunity_contact oc left join sysdba.contact c on oc.contactid=c.contactid left join sysdba.address a on a.entityid=c.contactid where oc.isprimary='T' and a.isprimary='T' and opportunityid='"+custevent.Id.ToString()+"'"; string pcode = session.CreateSQLQuery(sql).UniqueResult<string>(); sql = "select top 1 a.country from sysdba.opportunity_contact oc left join sysdba.contact c on oc.contactid=c.contactid left join sysdba.address a on a.entityid=c.contactid where oc.isprimary='T' and a.isprimary='T' and opportunityid='"+custevent.Id.ToString()+"'"; string country = session.CreateSQLQuery(sql).UniqueResult<string>(); string fswon = string.Concat(add1," ",add2," ",city,", ",state," ",pcode," ",country); result=fswon; } }
public static void GetWonServiceRevStep( ICustevent custevent, out System.Decimal result) { // TODO: Complete business rule implementation using (ISession session = new SessionScopeWrapper()) { string sql = "select sum(extendedprice) from opportunity_product where status='Execution' and opportunityid='"+custevent.Id.ToString()+"'"; decimal fswon = session.CreateSQLQuery(sql).UniqueResult<decimal>(); result=fswon; } }
public static void GetPrimaryContactPhoneStep2( ICustevent custevent, out System.String result) { // TODO: Complete business rule implementation using (ISession session = new SessionScopeWrapper()) { string sql = "select top 1 c.workphone from sysdba.opportunity_contact oc left join sysdba.contact c on oc.contactid=c.contactid where oc.isprimary='T' and opportunityid='"+custevent.Id.ToString()+"'"; string fswon = session.CreateSQLQuery(sql).UniqueResult<string>(); result=fswon; } }
public static void GetFirstServiceWonStep( ICustevent custevent, out System.DateTime result) { // TODO: Complete business rule implementation using (ISession session = new SessionScopeWrapper()) { string sql = "select min(actualclose) from opportunity_product where opportunityid='"+custevent.Id.ToString()+"'"; DateTime fswon = session.CreateSQLQuery(sql).UniqueResult<DateTime>(); result=fswon; } }
public static void GetInitialSalesRepStep( ICustevent custevent, out System.String result) { // TODO: Complete business rule implementation string fswon = string.Empty; try{ using (ISession session = new SessionScopeWrapper()) { string sql = "select username from userinfo where userid='"+custevent.Account.AccountConferon.InitialSalesRep.ToString()+"'"; fswon = session.CreateSQLQuery(sql).UniqueResult<string>(); } } catch(Exception){ } result=fswon; }