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);
}
