void WriteSettings(Datashit recviz, Bank bank)
{
if (shemes)
{
Properties.Settings.Default.name = recviz.name;
Properties.Settings.Default.platNumber = recviz.platNumber;
Properties.Settings.Default.mfo = recviz.mfo;
Properties.Settings.Default.rahunok = recviz.rahunok;
Properties.Settings.Default.datePayment = recviz.datePayment;
Properties.Settings.Default.clientBankCode = recviz.cliBankCode;
Properties.Settings.Default.recivePayNum = recviz.recivPayNum;
Properties.Settings.Default.state1 = recviz.state;
Properties.Settings.Default.Save();
//Xml.editXml(xmlConfig, bank);
}
else
{
Properties.Settings.Default.name2 = recviz.name2;
Properties.Settings.Default.platNumber2 = recviz.platNumber2;
Properties.Settings.Default.rahunok2 = recviz.rahunok2;
Properties.Settings.Default.edrpou = recviz.edrpou;
Properties.Settings.Default.state1 = recviz.state;
//Xml.CreteConfig(xmlConfig, bank);
Properties.Settings.Default.Save();
}
}
void WriteIni(Datashit recviz, Bank bank)
{
if (shemes)
{
bank.name = recviz.name;
bank.platNumber = recviz.platNumber;
bank.mfo = recviz.mfo;
bank.rahunok = recviz.rahunok;
bank.datePayment = recviz.datePayment;
bank.cliBankCode = recviz.cliBankCode;
bank.recivPayNum = recviz.recivPayNum;
bank.state = recviz.state;
}
else
{
bank.name = recviz.name2;
bank.platNumber = recviz.platNumber2;
bank.rahunok = recviz.rahunok2;
bank.edrpou = recviz.edrpou;
bank.state = recviz.state;
}
////Bank
//myIni.Write("Bank", recviz.name);
//myIni.Write("PlatNumber", recviz.platNumber.ToString());
//myIni.Write("Mfo", recviz.mfo);
//myIni.Write("Rahunok", recviz.rahunok);
//myIni.Write("Paydate", recviz.datePayment.ToString());
//myIni.Write("Bankclentnum", recviz.cliBankCode);
//myIni.Write("PlatReciver", recviz.recivPayNum);
////Bank2
//myIni.Write("Bank2", recviz.name2);
//myIni.Write("Platnumber2", recviz.platNumber2.ToString());
//myIni.Write("Edrpou", recviz.edrpou);
//myIni.Write("Rahunok2", recviz.rahunok2);
//myIni.Write("State", recviz.state.ToString());
}
public static Datashit IniRead(Datashit recviz, IniFile myIni)
{
string[] recvizs = { };
string path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"config.ini");
try
{
// config.Text = myIni.Read("bank Aval");
recviz.name = myIni.Read("Bank");
recviz.platNumber = Int64.Parse(myIni.Read("PlatNumber"));
recviz.mfo = myIni.Read("Mfo");
recviz.rahunok = myIni.Read("Rahunok");
recviz.datePayment = Convert.ToInt32(myIni.Read("Paydate"));
recviz.recivPayNum = myIni.Read("PlatReciver");
recviz.cliBankCode = myIni.Read("bankclentnum");
// config.Text = myIni.Read("bank2 UkrGaz");
recviz.name2 = myIni.Read("Bank2");
recviz.platNumber2 = Int64.Parse(myIni.Read("PlatNumber2"));
recviz.edrpou = myIni.Read("Edrpou");
recviz.rahunok2 = myIni.Read("Rahunok2");
//recviz.state = Int32.Parse(myIni.Read("State"));
recvizs = File.ReadAllLines(path, Encoding.Default);
}
catch (Exception e)
{
Console.WriteLine(e);
}
// try
// {
// if (recvizs.Length >= 5)
// {
// recviz.name = string.IsNullOrEmpty(recvizs[0]) ? "" : recvizs[0];
// recviz.platNumber = string.IsNullOrEmpty(recvizs[1]) ? 0 : Convert.ToInt32(recvizs[1]);
// recviz.mfo = string.IsNullOrEmpty(recvizs[2]) ? 0 : Convert.ToInt32(recvizs[2]);
// recviz.rahunok = string.IsNullOrEmpty(recvizs[3]) ? "0" : (recvizs[3]);
// recviz.datePayment = string.IsNullOrEmpty(recvizs[4]) ? 0 : Convert.ToInt32(recvizs[4]);
// }
// }
// catch (Exception e)
// {
//
// }
// try
// {
// if (recvizs.Length >= 9)
// {
// recviz.name2 = myIni.Read("Bank2");
// recviz.platNumber2 = Int32.Parse(myIni.Read("PlatNumber2"));
// recviz.edrpou = myIni.Read("Edrpou");
// recviz.rahunok2 = recviz.rahunok = myIni.Read("Rahunok2");
// }
// }
// catch (Exception e)
// {
//
// }
return(recviz);
}
public static void saveExcel(SaveFileDialog saveDialog, DataGridView dataGridView1, Datashit recviz)
{
long numDoc = recviz.platNumber2;
string senderRah = recviz.rahunok2;
string edrpou = recviz.ToString();
// Creating a Excel object.
Microsoft.Office.Interop.Excel._Application excel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel._Workbook workbook = excel.Workbooks.Add(Type.Missing);
Microsoft.Office.Interop.Excel._Worksheet worksheet = null;
//worksheet.Cells.Style;
try
{
worksheet = workbook.ActiveSheet;
worksheet.Name = "ExportedFromDatGrid";
int cellRowIndex = 1;
int cellColumnIndex = 1;
//Loop through each row and read value from each column.
// worksheet.Cells["D:D"].NumberFormat = "@";
for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
{
for (int j = 0; j < dataGridView1.Columns.Count; j++)
{
// Excel index starts from 1,1. As first Row would have the Column headers, adding a condition check.
switch (cellColumnIndex)
{
case 6:
if (cellRowIndex == 1)
{
worksheet.Cells[cellRowIndex, cellColumnIndex] = dataGridView1.Columns[j + 1].HeaderText;
}
else
{
worksheet.Cells[cellRowIndex, cellColumnIndex] = dataGridView1.Rows[i].Cells[j + 1].Value.ToString();
}
break;
case 7:
if (cellRowIndex == 1)
{
worksheet.Cells[cellRowIndex, cellColumnIndex] = "Номер платежу";
}
else
{
worksheet.Cells[cellRowIndex, cellColumnIndex] = numDoc++;
}
break;
case 8:
if (cellRowIndex == 1)
{
worksheet.Cells[cellRowIndex, cellColumnIndex].NumberFormat = "@";
worksheet.Cells[cellRowIndex, cellColumnIndex] = "ЄРДПО платника";
}
else
{
worksheet.Cells[cellRowIndex, cellColumnIndex] = recviz.edrpou;
}
break;
case 9:
if (cellRowIndex == 1)
{
worksheet.Cells[cellRowIndex, cellColumnIndex] = "Рахунок платника";
worksheet.Cells[cellRowIndex, cellColumnIndex].NumberFormat = "@";
}
else
{
worksheet.Cells[cellRowIndex, cellColumnIndex] = recviz.rahunok2;
}
break;
case 10:
case 11:
break;
default:
if (cellRowIndex == 1)
{
worksheet.Cells[cellRowIndex, cellColumnIndex] = dataGridView1.Columns[j].HeaderText;
}
else
{
worksheet.Cells[cellRowIndex, cellColumnIndex].NumberFormat = "@";
worksheet.Cells[cellRowIndex, cellColumnIndex] = dataGridView1.Rows[i].Cells[j].Value.ToString();
}
break;
}
cellColumnIndex++;
}
cellColumnIndex = 1;
cellRowIndex++;
}
// SaveFileDialog saveDialog = new SaveFileDialog();
// saveDialog.Filter = "Excel files(2003)| *.xls|Excel Files(2007+)|*.xlsx"; ;
// saveDialog.FilterIndex = 2;
//if (saveDialog.ShowDialog() == DialogResult.OK)
{
workbook.SaveAs(saveDialog.FileName);
MessageBox.Show("Експорт завершено");
}
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
excel.Quit();
workbook = null;
excel = null;
}
}
