private void ImportOpportunityData(DaoFactory _daoFactory)
{
var allUsers = ASC.Core.CoreContext.UserManager.GetUsers(EmployeeStatus.All).ToList();
using (var CSVFileStream = _dataStore.GetReadStream("temp", _CSVFileURI))
using (CsvReader csv = ImportFromCSV.CreateCsvReaderInstance(CSVFileStream, _importSettings))
{
int currentIndex = 0;
var customFieldDao = _daoFactory.CustomFieldDao;
var contactDao = _daoFactory.ContactDao;
var tagDao = _daoFactory.TagDao;
var dealDao = _daoFactory.DealDao;
var dealMilestoneDao = _daoFactory.DealMilestoneDao;
var findedTags = new Dictionary <int, List <String> >();
var findedCustomField = new List <CustomField>();
var findedDeals = new List <Deal>();
var findedDealMembers = new Dictionary <int, List <int> >();
var dealMilestones = dealMilestoneDao.GetAll();
while (csv.ReadNextRecord())
{
_columns = csv.GetCurrentRowFields(false);
var obj = new Deal();
obj.ID = currentIndex;
obj.Title = GetPropertyValue("title");
if (String.IsNullOrEmpty(obj.Title))
{
continue;
}
obj.Description = GetPropertyValue("description");
var csvResponsibleValue = GetPropertyValue("responsible");
var responsible = allUsers.Where(n => n.DisplayUserName().Equals(csvResponsibleValue)).FirstOrDefault();
if (responsible != null)
{
obj.ResponsibleID = responsible.ID;
}
else
{
obj.ResponsibleID = Constants.LostUser.ID;
}
DateTime actualCloseDate;
DateTime expectedCloseDate;
if (DateTime.TryParse(GetPropertyValue("actual_close_date"), out actualCloseDate))
{
obj.ActualCloseDate = actualCloseDate;
}
if (DateTime.TryParse(GetPropertyValue("expected_close_date"), out expectedCloseDate))
{
obj.ExpectedCloseDate = expectedCloseDate;
}
var currency = CurrencyProvider.Get(GetPropertyValue("bid_currency"));
if (currency != null)
{
obj.BidCurrency = currency.Abbreviation;
}
else
{
obj.BidCurrency = Global.TenantSettings.DefaultCurrency.Abbreviation;
}
decimal bidValue;
var bidValueStr = GetPropertyValue("bid_amount");
if (Decimal.TryParse(bidValueStr, NumberStyles.Number, CultureInfo.InvariantCulture, out bidValue))
{
obj.BidValue = bidValue;
}
else
{
obj.BidValue = 0;
}
var bidTypeStr = GetPropertyValue("bid_type");
BidType bidType = BidType.FixedBid;
if (!String.IsNullOrEmpty(bidTypeStr))
{
if (String.Compare(CRMDealResource.BidType_FixedBid, bidTypeStr, true) == 0)
{
bidType = BidType.FixedBid;
}
else if (String.Compare(CRMDealResource.BidType_PerDay, bidTypeStr, true) == 0)
{
bidType = BidType.PerDay;
}
else if (String.Compare(CRMDealResource.BidType_PerHour, bidTypeStr, true) == 0)
{
bidType = BidType.PerHour;
}
else if (String.Compare(CRMDealResource.BidType_PerMonth, bidTypeStr, true) == 0)
{
bidType = BidType.PerMonth;
}
else if (String.Compare(CRMDealResource.BidType_PerWeek, bidTypeStr, true) == 0)
{
bidType = BidType.PerWeek;
}
else if (String.Compare(CRMDealResource.BidType_PerYear, bidTypeStr, true) == 0)
{
bidType = BidType.PerYear;
}
}
obj.BidType = bidType;
if (obj.BidType != BidType.FixedBid)
{
int perPeriodValue;
if (int.TryParse(GetPropertyValue("per_period_value"), out perPeriodValue))
{
obj.PerPeriodValue = perPeriodValue;
}
}
int probabilityOfWinning;
if (int.TryParse(GetPropertyValue("probability_of_winning"), out probabilityOfWinning))
{
obj.DealMilestoneProbability = probabilityOfWinning;
}
var dealMilestoneTitle = GetPropertyValue("deal_milestone");
var tag = GetPropertyValue("tag");
if (!String.IsNullOrEmpty(tag))
{
var tagList = tag.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToList();
tagList.AddRange(_importSettings.Tags);
tagList = tagList.Distinct().ToList();
findedTags.Add(obj.ID, tagList);
}
else if (_importSettings.Tags.Count != 0)
{
findedTags.Add(obj.ID, _importSettings.Tags);
}
if (String.IsNullOrEmpty(dealMilestoneTitle))
{
obj.DealMilestoneID = dealMilestones[0].ID;
}
else
{
var dealMilestone = dealMilestones.Find(item => String.Compare(item.Title, dealMilestoneTitle, true) == 0);
if (dealMilestone == null)
{
obj.DealMilestoneID = dealMilestones[0].ID;
}
else
{
obj.DealMilestoneID = dealMilestone.ID;
}
}
var contactName = GetPropertyValue("client");
var localMembersDeal = new List <int>();
if (!String.IsNullOrEmpty(contactName))
{
var contacts = contactDao.GetContactsByName(contactName, true);
if (contacts.Count > 0)
{
obj.ContactID = contacts[0].ID;
localMembersDeal.Add(obj.ContactID);
}
else
{
contacts = contactDao.GetContactsByName(contactName, false);
if (contacts.Count > 0)
{
obj.ContactID = contacts[0].ID;
localMembersDeal.Add(obj.ContactID);
}
}
}
var members = GetPropertyValue("member");
if (!String.IsNullOrEmpty(members))
{
var membersList = members.Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var item in membersList)
{
var findedMember = contactDao.GetContactsByName(item, true);
if (findedMember.Count > 0)
{
localMembersDeal.Add(findedMember[0].ID);
}
else
{
findedMember = _daoFactory.ContactDao.GetContactsByName(item, false);
if (findedMember.Count > 0)
{
localMembersDeal.Add(findedMember[0].ID);
}
}
}
}
if (localMembersDeal.Count > 0)
{
findedDealMembers.Add(obj.ID, localMembersDeal);
}
foreach (JProperty jToken in _importSettings.ColumnMapping.Children())
{
var propertyValue = GetPropertyValue(jToken.Name);
if (String.IsNullOrEmpty(propertyValue))
{
continue;
}
if (!jToken.Name.StartsWith("customField_"))
{
continue;
}
var fieldID = Convert.ToInt32(jToken.Name.Split(new[] { '_' })[1]);
var field = customFieldDao.GetFieldDescription(fieldID);
if (field != null)
{
findedCustomField.Add(new CustomField
{
EntityID = obj.ID,
EntityType = EntityType.Opportunity,
ID = fieldID,
Value = field.FieldType == CustomFieldType.CheckBox ? (propertyValue == "on" || propertyValue == "true" ? "true" : "false") : propertyValue
});
}
}
Percentage += 1.0 * 100 / (ImportFromCSV.MaxRoxCount * 2);
if (ImportDataCache.CheckCancelFlag(EntityType.Opportunity))
{
ImportDataCache.ResetAll(EntityType.Opportunity);
throw new OperationCanceledException();
}
ImportDataCache.Insert(EntityType.Opportunity, (ImportDataOperation)Clone());
findedDeals.Add(obj);
if (currentIndex + 1 > ImportFromCSV.MaxRoxCount)
{
break;
}
currentIndex++;
}
Percentage = 50;
if (ImportDataCache.CheckCancelFlag(EntityType.Opportunity))
{
ImportDataCache.ResetAll(EntityType.Opportunity);
throw new OperationCanceledException();
}
ImportDataCache.Insert(EntityType.Opportunity, (ImportDataOperation)Clone());
var newDealIDs = dealDao.SaveDealList(findedDeals);
findedDeals.ForEach(d => d.ID = newDealIDs[d.ID]);
Percentage += 12.5;
if (ImportDataCache.CheckCancelFlag(EntityType.Opportunity))
{
ImportDataCache.ResetAll(EntityType.Opportunity);
throw new OperationCanceledException();
}
ImportDataCache.Insert(EntityType.Opportunity, (ImportDataOperation)Clone());
findedCustomField.ForEach(item => item.EntityID = newDealIDs[item.EntityID]);
customFieldDao.SaveList(findedCustomField);
Percentage += 12.5;
if (ImportDataCache.CheckCancelFlag(EntityType.Opportunity))
{
ImportDataCache.ResetAll(EntityType.Opportunity);
throw new OperationCanceledException();
}
ImportDataCache.Insert(EntityType.Opportunity, (ImportDataOperation)Clone());
foreach (var findedDealMemberKey in findedDealMembers.Keys)
{
dealDao.SetMembers(newDealIDs[findedDealMemberKey], findedDealMembers[findedDealMemberKey].ToArray());
}
Percentage += 12.5;
if (ImportDataCache.CheckCancelFlag(EntityType.Opportunity))
{
ImportDataCache.ResetAll(EntityType.Opportunity);
throw new OperationCanceledException();
}
ImportDataCache.Insert(EntityType.Opportunity, (ImportDataOperation)Clone());
foreach (var findedTagKey in findedTags.Keys)
{
tagDao.SetTagToEntity(EntityType.Opportunity, newDealIDs[findedTagKey], findedTags[findedTagKey].ToArray());
}
if (_importSettings.IsPrivate)
{
findedDeals.ForEach(dealItem => CRMSecurity.SetAccessTo(dealItem, _importSettings.AccessList));
}
Percentage += 12.5;
if (ImportDataCache.CheckCancelFlag(EntityType.Opportunity))
{
ImportDataCache.ResetAll(EntityType.Opportunity);
throw new OperationCanceledException();
}
ImportDataCache.Insert(EntityType.Opportunity, (ImportDataOperation)Clone());
}
Complete();
}
public static void DataContactActionView(BasePage page, Contact targetContact, List <CustomField> data, List <ContactInfo> networks)
{
var daoFactory = page.DaoFactory;
var tags = targetContact != null?daoFactory.TagDao.GetEntityTags(EntityType.Contact, targetContact.ID) : new string[]
{
};
var availableTags = daoFactory.TagDao.GetAllTags(EntityType.Contact).Where(item => !tags.Contains(item));
String json;
using (var stream = new MemoryStream())
{
var serializer = new DataContractJsonSerializer(data.GetType());
serializer.WriteObject(stream, data);
json = Encoding.UTF8.GetString(stream.ToArray());
}
var listItems = daoFactory.ListItemDao.GetItems(ListType.ContactType);
var presetCompanyForPersonJson = "";
if (targetContact != null && targetContact is Person && ((Person)targetContact).CompanyID > 0)
{
var company = daoFactory.ContactDao.GetByID(((Person)targetContact).CompanyID);
if (company == null)
{
LogManager.GetLogger("ASC.CRM").ErrorFormat("Can't find parent company (CompanyID = {0}) for person with ID = {1}", ((Person)targetContact).CompanyID, targetContact.ID);
}
else
{
presetCompanyForPersonJson = JsonConvert.SerializeObject(new
{
id = company.ID,
displayName = company.GetTitle().HtmlEncode().ReplaceSingleQuote().Replace(@"\", @"\\"),
smallFotoUrl = ContactPhotoManager.GetSmallSizePhoto(company.ID, true)
});
}
}
var presetPersonsForCompanyJson = "";
if (targetContact != null && targetContact is Company)
{
var people = daoFactory.ContactDao.GetMembers(targetContact.ID);
if (people.Count != 0)
{
presetPersonsForCompanyJson = JsonConvert.SerializeObject(people.ConvertAll(item => new
{
id = item.ID,
displayName = item.GetTitle().HtmlEncode().ReplaceSingleQuote().Replace(@"\", @"\\"),
smallFotoUrl = ContactPhotoManager.GetSmallSizePhoto(item.ID, false)
}));
}
}
var script = String.Format(@"
var customFieldList = {0};
var contactNetworks = {1};
var contactActionTags = {2};
var contactActionAvailableTags = {3};
var contactAvailableTypes = {4};
var presetCompanyForPersonJson = '{5}';
var presetPersonsForCompanyJson = '{6}';
var twitterSearchEnabled = {7};
var contactActionCurrencies = {8};",
json,
JsonConvert.SerializeObject(networks),
JsonConvert.SerializeObject(tags.ToList().ConvertAll(t => t.HtmlEncode())),
JsonConvert.SerializeObject(availableTags.ToList().ConvertAll(t => t.HtmlEncode())),
JsonConvert.SerializeObject(
listItems.ConvertAll(n => new
{
id = n.ID,
title = n.Title.HtmlEncode()
})),
presetCompanyForPersonJson,
presetPersonsForCompanyJson,
IsTwitterSearchEnabled.ToString().ToLower(),
JsonConvert.SerializeObject(CurrencyProvider.GetAll())
);
page.RegisterInlineScript(script, onReady: false);
}
