private static void WritePinsToFile(RecordToInsert record)
{
SetCtlFile();
File.WriteAllText("Imp.csv", String.Empty);
if (DataToGenerate.RegList.Count > 0)
{
string query = GetQuery(14) + GetRegsStr() + ")";
// "SELECT t.business_n FROM SUVD.PROJECTS t WHERE t.dogovor_id in ( " + GetRegsStr() + ")";
OracleDataReader reader = _con.GetReader(query);
List <RecordToInsert> recList = new List <RecordToInsert>();
while (reader.Read())
{
RecordToInsert rec = new RecordToInsert {
DealId = reader[0].ToString(), TemplateId = record.TemplateId, AdrType = record.AdrType
};
recList.Add(rec);
}
reader.Close();
AddPinFromFile(recList);
}
else
{
InsertToDbByBatFile();
}
}
private void button_remove_reg_Click(object sender, EventArgs e)
{
string reg = comboBox_ready_regs.SelectedItem.ToString();
decimal id = -1;
if (CheckIsRegNameCorrect(ref reg, ref id))
{
comboBox_ready_regs.Items.Remove(reg);
RecordToInsert rec = new RecordToInsert();
rec.Reestr = new Reg();
rec.Reestr.Id = id;
LetterManager.ChangeRegForGenerate(rec, Operation.Remove);
// RefreshToolStripPin();
comboBox_regs.Items.Add(reg);
comboBox_ready_regs.Text = "";
button_remove_reg.Enabled = false;
}
}
private void button_load_file_Click(object sender, EventArgs e)
{
comboBox_creditors.Enabled = false;
Stream myStream = null;
OpenFileDialog ofd = new OpenFileDialog();
ofd.Title = "Open Text File";
ofd.Filter = "TXT files|*.txt";
ofd.InitialDirectory = @"C:\";
if (ofd.ShowDialog() == DialogResult.OK)
{
try
{
if ((myStream = ofd.OpenFile()) != null)
{
if (!CheckReadyToLoadData())
{
MessageBox.Show("Не указан тип адреса или шаблон письма.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
string template = comboBox_template.SelectedItem.ToString();
AdressType adrtype = (AdressType)comboBox_adr.SelectedIndex;
List<RecordToInsert> recList = new List<RecordToInsert>();
using (myStream)
{
var lines = File.ReadLines(ofd.FileName);
foreach (var line in lines)
{
RecordToInsert rec = new RecordToInsert { DealId = line, TemplateId = template, AdrType = adrtype };
recList.Add(rec);
}
}
LetterManager.AddPinFromFile(recList);
}
else
{
comboBox_creditors.Enabled = true;
}
}
catch (Exception ex)
{
MessageBox.Show("Не удается прочитать файл. " + ex.Message);
}
}
}
static public void ChangeRegForGenerate(RecordToInsert record, Operation operation)
{
List <Reg> list = _creditorRegsList.Where(r => r.Id == record.Reestr.Id).ToList();
if (list.Count > 0)
{
if (operation == Operation.Insert)
{
DataToGenerate.RegList.Add(list[0]);
}
else
{
DataToGenerate.RegList.Remove(list[0]);
}
WritePinsToFile(record);
}
else
{
MessageBox.Show("Некорректный номер реестра.");
}
}
private void button_add_reg_Click(object sender, EventArgs e)
{
decimal id = -1;
string regName = comboBox_regs.SelectedItem.ToString();
if (CheckIsRegNameCorrect(ref regName, ref id))
{
if (!CheckReadyToLoadData())
{
MessageBox.Show("Не указан тип адреса или шаблон письма.", "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
string template = comboBox_template.SelectedItem.ToString();
AdressType adrtype = (AdressType)comboBox_adr.SelectedIndex;
RecordToInsert record = new RecordToInsert();
record.Reestr = new Reg();
record.Reestr.Id = id;
record.AdrType = adrtype;
record.TemplateId = template;
LetterManager.ChangeRegForGenerate(record, Operation.Insert);
comboBox_ready_regs.Items.Add(regName);
comboBox_regs.Items.Remove(regName);
comboBox_regs.Text = "";
button_add_reg.Enabled = false;
}
}
