public ActionResult CheckEntitiesForImport(HttpPostedFileBase file, int campaignId)
{
try
{
int importedEntities = 0;
int validEntities = 0;
List <string> validVats = new List <string>();
int invalidEntities = 0;
List <string> invalidVats = new List <string>();
//string filepath = Path.Combine(Server.MapPath("~/ImportFiles"), "ImportAcquireEmail.xls");
//if(!create)
// file.SaveAs(filepath);
var wb = new ExcelPackage(file.InputStream);
var ws = wb.Workbook.Worksheets[1];
for (int i = ws.Dimension.Start.Row; i <= ws.Dimension.End.Row; i++)
{
object vat;
if ((vat = ws.Cells[i, 1].Value) != null)
{
string vatTemp = vat.ToString();
if (_db.Organizations.Any(o => (o.SubjectBusinessUnit == "" || o.SubjectBusinessUnit == "11" /*DHL hack/fix*/) && o.VAT == vatTemp))
{
validVats.Add(vatTemp);
ImportEntities(campaignId, vatTemp);
importedEntities++;
validEntities++;
}
else
{
invalidVats.Add(vatTemp);
invalidEntities++;
}
}
else
{
continue;
}
}
var model = new AcquireEmailCheckResults
{
CampaignId = campaignId,
ValidEntities = validEntities,
InvalidEntities = invalidEntities,
ImportedEntities = importedEntities,
ValidVATs = validVats,
InvalidVATs = invalidVats
};
//if(create)
// System.IO.File.Delete(filepath);
wb.Dispose();
return(View(model));
}
catch (COMException)
{
return(View("ErrorOldExcel"));
}
}
public ActionResult CheckEntitiesForImport(HttpPostedFileBase file, int campaignId)
{
try
{
int importedEntities = 0;
int validEntities = 0;
List <string> validVats = new List <string>();
int invalidEntities = 0;
List <string> invalidVats = new List <string>();
//string filepath = Path.Combine(Server.MapPath("~/ImportFiles"), "ImportAcquireEmail.xls");
//if(!create)
// file.SaveAs(filepath);
var wb = new ExcelPackage(file.InputStream);
var ws = wb.Workbook.Worksheets[1];
for (int i = ws.Dimension.Start.Row; i <= ws.Dimension.End.Row; i++)
{
object vat;
if ((vat = ws.Cells[i, 1].Value) != null)
{
string vatTemp = vat.ToString();
if (_db.Organizations.Any(o => (o.SubjectBusinessUnit == "" || o.SubjectBusinessUnit == "11" /*DHL hack/fix*/) && o.VAT == vatTemp))
{
validVats.Add(vatTemp);
ImportEntities(campaignId, vatTemp);
importedEntities++;
validEntities++;
}
else
{
invalidVats.Add(vatTemp);
invalidEntities++;
}
}
else
{
continue;
}
}
_acquireEmailMethodHelpers.SaveUnimportedVats(campaignId, invalidVats);
var model = new AcquireEmailCheckResults
{
CampaignId = campaignId,
ValidEntities = validEntities,
InvalidEntities = invalidEntities,
ImportedEntities = importedEntities,
ValidVATs = validVats,
InvalidVATs = invalidVats
};
//if(create)
// System.IO.File.Delete(filepath);
wb.Dispose();
return(View(model));
}
catch (COMException come)
{
_helper.LogError(@"AcquireEmail - CheckEntitiesForImport", "CampaignId: " + campaignId,
@"Prilikom učitavanja predmeta za obradu baza javila se greška: " + come.Message, come.InnerException.Message, string.Empty, User.Identity.Name);
var errorModel = new ErrorModelHelper()
{
ErrorTitle = @"Greška u datoteci",
ErrorDescription = @"Prilikom učitavanja predmeta za obradu baza javila se greška: " + come.Message,
ErrorArguments = string.Empty,
ErrorException = come,
ErrorSuggestedSolution = @"Molimo pokušajte učitati datoteku u .xlsx formatu!"
};
return(View("ErrorNew", errorModel));
}
}
