public void InsertOrUpdateFileImportRow(FileImportRowModel row)
{
FileImportRow tempRow = null;
if (row.Id != 0)
{
tempRow = db.FindFileImportRow(row.CompanyId, row.UserId, row.Id);
if (tempRow == null)
{
row.Id = 0;
}
}
if (row.Id == 0)
{
// New row
tempRow = new FileImportRow {
CompanyId = row.CompanyId,
UserId = row.UserId,
ProductId = row.ProductId,
SupplierId = row.SupplierId
};
db.InsertOrUpdateFileImportRow(tempRow);
row.Id = tempRow.Id;
foreach (var field in row.Fields)
{
var tempField = new FileImportField {
CompanyId = row.CompanyId,
FileImportRowId = tempRow.Id,
Value = field.Value
};
db.InsertOrUpdateFileImportField(tempField, false);
}
db.SaveChanges();
}
else
{
// Update existing row
tempRow.ErrorMessage = row.ErrorMessage;
tempRow.ProductId = row.ProductId;
tempRow.SupplierId = row.SupplierId;
db.InsertOrUpdateFileImportRow(tempRow);
int fldNo = 0;
foreach (var field in tempRow.FileImportFields)
{
field.Value = row.Fields[fldNo].Value;
fldNo++;
}
db.InsertOrUpdateFileImportRow(tempRow);
}
}
private FileImportField getField(FileImportRow row, string fieldName)
{
FileImportField result = null;
var fields = row.FileImportFields.Cast <FileImportField>().ToList();
int idx = findField(row, fieldName);
if (idx != -1)
{
result = fields[idx];
}
return(result);
}
private int findField(FileImportRow row, string fieldName)
{
int rc = -1;
for (int i = 0; i < _headings.Count() && rc == -1; i++)
{
if (_headings[i].ToLower() == fieldName.ToLower())
{
rc = i;
}
}
return(rc);
}
private FileImportField getField(FileImportRow row, string fieldName)
{
FileImportField result = null;
var fields = row.FileImportFields.Cast <FileImportField>().ToList();
for (int i = 0; i < _headings.Count(); i++)
{
if (_headings[i].ToLower() == fieldName.ToLower())
{
result = fields[i];
i = _headings.Count();
}
}
return(result);
}
private string getFieldValue(FileImportRow row, string fieldName)
{
var field = getField(row, fieldName);
return(field == null ? "" : field.Value);
}
