public List<AccountBase> FillAccountBaseFromSql() { var Accounts= new List<AccountBase>(); using(var myConnection = new SqlConnection(Connect.sTalismanConStr)) { myConnection.Open(); string sSql = "Select top 1 * from existing_clients"; var Reader = new SqlCommand(sSql, myConnection).ExecuteReader(); while (Reader.Read()) { var AccountBase = new AccountBase(); AccountBase.sAccountName = Reader["sName"].ToString(); AccountBase.sAddressLine1 = Reader["sAddressLine1"].ToString(); AccountBase.sAddressLine2 = Reader["sAddressLine2"].ToString(); AccountBase.sAddressLine3 = Reader["sAddressLine3"].ToString(); AccountBase.sCustomerNumber = Reader["sClientNumber"].ToString(); AccountBase.sEmail = Reader["sEmail"].ToString(); AccountBase.sPostCode = Reader["sPostalCode"].ToString(); AccountBase.sTelephone = Reader["sTelephone"].ToString(); //MessageBox.Show(AccountBase.sAccountName); //MessageBox.Show(AccountBase.sTelephone); Accounts.Add(AccountBase); } Reader.Close(); myConnection.Close(); } return Accounts; }
public void addTaskToUser(Marketer myMarketer, AccountBase myAccount, IOrganizationService myCRMService) { //myMarketer.sCrmEntityName = "user"; //myMarketer.sCrmEntityGuidFieldName = "systemuserid"; //myMarketer.sCrmAttributeName = "domainname"; myMarketer.sCrmFilterAttributeValue = myMarketer.sCrmUsername; myMarketer.FindGuidForObject(myCRMService); //myAccount.sCrmEntityName = "account"; //myAccount.sCrmEntityName = "accountid"; //myAccount.sCrmAttributeName = "accountnumber"; myAccount.sCrmFilterAttributeValue = myAccount.sCustomerNumber; myAccount.FindGuidForObject(myCRMService); var newTask = new Entity("task"); newTask["ownerid"] = myMarketer.crmGuidId; newTask["regardingobjectid"] = myAccount.crmGuidId; newTask["description"] = sMessage; newTask["scheduledend"] = sDuedate; newTask["subject"] = myAccount.sAccountName; myCRMService.Create(newTask); }