private void ImportCredentials(int rowIndex, int accountId)
{
for (int credentialIndex = 0; credentialIndex < ExtractCredentials(rowIndex).Length; credentialIndex++)
{
string credentialValue = ExtractCredentials(rowIndex)[credentialIndex].Trim();
try
{
string fieldName = ExtractFieldNames()[credentialIndex].Trim();
CredentialService.Update(accountId, FieldService.GetFieldByName(this.DestinationCategoryId, fieldName).Id,
credentialValue);
Log(" " + fieldName + ": '" + credentialValue + "'");
}
catch (IndexOutOfRangeException)
{
Log(" '" + credentialValue + "' does not belong to a field and was not added.");
}
}
}
public static int AddNewWithBlankCredentials(Account account)
{
using (var context = new ShedEntities())
{
context.Accounts.InsertOnSubmit(account);
context.SubmitChanges();
var credentials = new List <Credential>();
foreach (var field in context.Fields.Where(f => f.CategoryId == account.CategoryId))
{
credentials.Add(new Credential {
AccountId = account.Id, FieldId = field.Id, Created = DateTime.Now
});
}
CredentialService.AddNew(context, credentials);
context.SubmitChanges();
}
return(account.Id);
}