protected override void OnProcess(Cell cell, Cell nextCell, RegistrationInfo info)
{
var cellText = cell.Range.Text;
if (nextCell != null && cellText.Contains(PHONE))
{
nextCell.Range.Text = info.Phone;
}
if (nextCell != null && cellText.Contains(EMAIL))
{
nextCell.Range.Text = info.Email;
}
if (cellText.Contains(DATE))
{
cell.Range.Text = string.Format(CultureInfo.InvariantCulture, "{0} {1}",
cell.Range.Text.TrimEnd('\a').TrimEnd('\r'),
DateTime.Now.ToString(DateFormat));
}
}
protected override void OnProcess(Cell cell, Cell nextCell, RegistrationInfo info)
{
var cellText = cell.Range.Text;
if (cellText.Contains(DATE))
{
cell.Range.Text = string.Format(CultureInfo.InvariantCulture, "{0} {1}",
cell.Range.Text.TrimEnd('\a').TrimEnd('\r'),
DateTime.Now.ToString(DateFormat));
}
if (cellText.Contains(PHONE))
{
cell.Range.Text = string.Format(CultureInfo.InvariantCulture, "{0} {1}",
cell.Range.Text.TrimEnd('\a').TrimEnd('\r'), info.Phone);
}
if (cellText.Contains(EMAIL))
{
cell.Range.Text = string.Format(CultureInfo.InvariantCulture, "{0} {1}",
cell.Range.Text.TrimEnd('\a').TrimEnd('\r'), info.Email);
}
if (cellText.Contains(info.Class) && nextCell != null)
{
nextCell.Range.Text = "X";
}
if (cellText.Contains("САС ВСЕХ ПОРОД") && nextCell != null)
{
nextCell.Range.Text = "X";
}
if (cellText.Contains(info.Mono))
{
cell.Range.Text = string.Format(CultureInfo.InvariantCulture, "{0}\tX",
cell.Range.Text.TrimEnd('\a').TrimEnd('\r'));
}
}
public void Process(RegistrationInfo regInfo)
{
foreach (Word.Table table in document.Tables)
{
for (int r = 1; r <= table.Rows.Count; r++)
{
for (int c = 1; c <= table.Columns.Count; c++)
{
try
{
var cellText = table.Cell(r, c).Range.Text;
Word.Cell nextCell = null;
try
{
nextCell = table.Cell(r, c + 1);
}
catch (Exception)
{
}
if (nextCell != null)
{
if (cellText.Contains("Breed") || cellText.Contains("Порода"))
{
nextCell.Range.Text = regInfo.Breed;
}
if (cellText.Contains("Sex") || cellText.Contains("Пол"))
{
nextCell.Range.Text = regInfo.Sex;
}
if (cellText.Contains("Color") || cellText.Contains("Цвет"))
{
nextCell.Range.Text = regInfo.Color;
}
if (cellText.Contains("birth") || cellText.Contains("рожд"))
{
nextCell.Range.Text = regInfo.DOB.ToString(DateFormat);
}
if (cellText.Contains("of the dog") || cellText.Contains("Кличка"))
{
nextCell.Range.Text = regInfo.Name;
}
if (cellText.Contains("Pedigree") || cellText.Contains("родос"))
{
nextCell.Range.Text = regInfo.Pedigree;
}
if (cellText.Contains("Father") || cellText.Contains("Отец"))
{
nextCell.Range.Text = regInfo.Father;
}
if (cellText.Contains("Mother") || cellText.Contains("Мать"))
{
nextCell.Range.Text = regInfo.Mother;
}
if (cellText.Contains("Breeder") || cellText.Contains("Заводчик"))
{
nextCell.Range.Text = regInfo.Breeder;
}
if (cellText.Contains("Owner") || cellText.Contains("Владелец"))
{
nextCell.Range.Text = regInfo.Owner;
}
if (cellText.Contains("Клуб регистрации"))
{
nextCell.Range.Text = regInfo.Club;
}
if (cellText.Contains("Address") || cellText.Contains("Адрес"))
{
nextCell.Range.Text = regInfo.Address;
}
if (cellText.Contains(regInfo.Class))
{
nextCell.Range.Text = "X";
}
}
OnProcess(table.Cell(r, c), nextCell, regInfo);
}
catch (Exception)
{
//break;
}
}
}
}
document.Save();
wordApp.Visible = true;
}
protected abstract void OnProcess(Word.Cell cell, Word.Cell nextCell, RegistrationInfo info);
