public List <ClientVisit.UpdateResultData> ClientVisit_SetStatusesFromDbf(User CurrentUser, DateTime statusDate, string dbfFilePath)
{
try
{
List <ClientVisit.UpdateResultData> results = new List <ClientVisit.UpdateResultData>();
List <long> ids = ClientVisitReportDao.Instance.GetClientVisitIdsFromDbf(dbfFilePath, "RECID_PV");
if (ids.Count == 0)
{
List <long> recids = ClientVisitReportDao.Instance.GetClientVisitIdsFromDbf(dbfFilePath, "RECID");
ids = FundProcessingDao.Instance.ClientVisitId_GetByFundRequesetRecid(recids).Select(item => item.ClientVisitId).ToList();
}
foreach (var id in ids)
{
var clientVisit = ClientDao.Instance.ClientVisit_Get(id);
ClientVisit.UpdateResultData data = new ClientVisit.UpdateResultData();
data.Id = clientVisit.Id;
data.ClientId = clientVisit.ClientId;
data.ClientVisitGroupId = clientVisit.VisitGroupId;
data.Birthday = clientVisit.NewClientInfo.Birthday;
data.Firstname = clientVisit.NewClientInfo.Firstname;
data.Secondname = clientVisit.NewClientInfo.Secondname;
data.Lastname = clientVisit.NewClientInfo.Lastname;
data.UnifiedPolicyNumber = clientVisit.NewPolicy.UnifiedPolicyNumber;
if (clientVisit.Status.Id == ClientVisitStatuses.SubmitPending.Id ||
clientVisit.Status.Id == ClientVisitStatuses.Reconciliation.Id ||
clientVisit.Status.Id == ClientVisitStatuses.FundError.Id ||
clientVisit.Status.Id == ClientVisitStatuses.PolicyIssued.Id)
{
ClientDao.Instance.ClientVisit_SetStatus(
CurrentUser.Id,
id,
ClientVisitStatuses.AnswerPending.Id,
clientVisit.IsActual,
statusDate);
data.IsSuccess = true;
data.Status = ClientVisitStatuses.AnswerPending;
data.Message = string.Format("Статус изменен c {0} на {1}", clientVisit.Status.Name, data.Status.Name);
}
else
{
data.Status = clientVisit.Status;
data.Message = "Статус не изменен";
}
results.Add(data);
}
return(results);
}
finally
{
File.Delete(dbfFilePath);
}
}
public ClientVisitUpdateResultModel(ClientVisit.UpdateResultData data)
{
ClientId = data.ClientId;
UnifiedPolicyNumber = data.UnifiedPolicyNumber;
Lastname = data.Lastname;
Firstname = data.Firstname;
Secondname = data.Secondname;
Sex = data.Sex == 1 ? "Мужской" : "Женский";
Birthday = data.Birthday;
Status = data.Status == null || data.Status.Id == 0
? string.Empty
: ReferencesProvider.GetReferenceItems(Constants.ClientVisitStatusRef).FirstOrDefault(item => item.Id == data.Status.Id).Name;
IsSuccess = data.IsSuccess;
Message = data.Message;
}
protected override void Process(ISheet table)
{
table.FindCellByMacros(title).SetValue(string.Format("Отчет по загрузке файла {0}", reportTitle));
int rowNumber = 3;
for (int i = 0; i < reportItems.Count; i++)
{
ClientVisit.UpdateResultData reportItem = reportItems[i];
IRow row = table.CreateRow(rowNumber);
row.CreateCell(0).SetValue(GetNotNullString((i + 1).ToString()));
row.CreateCell(1).SetValue(GetNotNullString(reportItem.UnifiedPolicyNumber));
row.CreateCell(2).SetValue(GetNotNullString(reportItem.Lastname));
row.CreateCell(3).SetValue(GetNotNullString(reportItem.Firstname));
row.CreateCell(4).SetValue(GetNotNullString(reportItem.Secondname));
row.CreateCell(5).SetValue(GetDateString(reportItem.Birthday, "dd.MM.yyyy"));
row.CreateCell(6).SetValue(GetNotNullString(reportItem.Message));
row.CreateCell(7).SetValue(GetNotNullString(reportItem.Status != null ? reportItem.Status.Id.ToString() : string.Empty));
row.CreateCell(8).SetValue(GetNotNullString(reportItem.RECID.ToString()));
row.CreateCell(9).SetValue(GetNotNullString(reportItem.Id.ToString()));
row.CreateCell(10).SetValue(GetNotNullString(reportItem.ClientId.ToString()));
row.CreateCell(11).SetValue(GetNotNullString(reportItem.ClientVisitGroupId.ToString()));
rowNumber++;
}
}
