public bool importfrxml(string FileName)
{
myvariable.errcount = 0;
string regdate = xml.importtext(FileName, "RegistrationDate", false);
DateTime nulldate = Convert.ToDateTime("01/01/90");
if (regdate != "" && Convert.ToDateTime(regdate) > Convert.ToDateTime("01/01/90"))
{
statuscomboBox.SelectedIndex = 0;
regdatePicker.SelectedDate = Convert.ToDateTime(regdate);
if (!DateTime.TryParse(xml.importtext(FileName, "LeaseDuration", false), out nulldate))
{
myvariable.errcount++;
MessageBox.Show((string)Application.Current.Resources["m_badleasedate"]);
}
termleasedatePicker.SelectedDate = nulldate;
}
else
{
statuscomboBox.SelectedIndex = 1;
regdatePicker.SelectedDate = nulldate;
termleasedatePicker.SelectedDate = nulldate;
}
string typeGrantor = xml.importtext(FileName, "typeGrantor", false);
if (typeGrantor != "")
{
if (typeGrantor == "NaturalPerson")
{
fizoryurcomboBox.SelectedIndex = 0;
lessortextBox.Text = xml.importcontractorinf(FileName, "NaturalPerson_FullName", "Grantor", false);
inntextBox.Text = xml.importcontractorinf(FileName, "NaturalPerson_TaxNumber", "Grantor", false);
passporttextBox.Text = xml.importcontractorinf(FileName, "NaturalPerson_Passport", "Grantor", false);
if (!DateTime.TryParse(xml.importcontractorinf(FileName, "NaturalPerson_PassportIssuedDate", "Grantor", false), out nulldate))
{
MessageBox.Show("неверный формат PassportIssuedDate");
}
vidandatePicker.SelectedDate = nulldate;
kemvidantextBox.Text = xml.importcontractorinf(FileName, "NaturalPerson_IssuanceAuthority", "Grantor", false);
adresstextBox.Text = xml.importcontractorinf(FileName, "NaturalPerson_Address", "Grantor", false);
}
else if (typeGrantor == "LegalEntity")
{
fizoryurcomboBox.SelectedIndex = 1;
lessortextBox.Text = xml.importcontractorinf(FileName, "LegalEntity_Name", "Grantor", false);
kodpredtextBox.Text = xml.importcontractorinf(FileName, "LegalEntity_EDRPOU", "Grantor", false);
adresstextBox.Text = xml.importcontractorinf(FileName, "LegalEntity_Address", "Grantor", false);
}
}
string typeGrantee = xml.importtext(FileName, "typeGrantee", false);
if (typeGrantee != "")
{
if (typeGrantee == "NaturalPerson")
{
leaserfizoryurcomboBox.SelectedIndex = 0;
leasertextBox.Text = xml.importcontractorinf(FileName, "NaturalPerson_FullName", "Grantee", false);
leaserinntextBox.Text = xml.importcontractorinf(FileName, "NaturalPerson_TaxNumber", "Grantee", false);
leaserpassporttextBox.Text = xml.importcontractorinf(FileName, "NaturalPerson_Passport", "Grantee", false);
if (xml.importcontractorinf(FileName, "NaturalPerson_PassportIssuedDate", "Grantee", false) != "")
{
leaservidandatePicker.SelectedDate = Convert.ToDateTime(xml.importcontractorinf(FileName, "NaturalPerson_PassportIssuedDate", "Grantee", false));
}
else
{
leaservidandatePicker.SelectedDate = Convert.ToDateTime("01/01/53");
}
leaserkemvidantextBox.Text = xml.importcontractorinf(FileName, "NaturalPerson_IssuanceAuthority", "Grantee", false);
leaseradresstextBox.Text = xml.importcontractorinf(FileName, "NaturalPerson_Address", "Grantee", false);
}
else if (typeGrantee == "LegalEntity")
{
leaserfizoryurcomboBox.SelectedIndex = 1;
leasertextBox.Text = xml.importcontractorinf(FileName, "LegalEntity_Name", "Grantee", false);
leaserkodpredtextBox.Text = xml.importcontractorinf(FileName, "LegalEntity_EDRPOU", "Grantee", false);
leaseradresstextBox.Text = xml.importcontractorinf(FileName, "LegalEntity_Address", "Grantee", false);
}
}
cadnumtextBox.Text = xml.importtext(FileName, "CadastralCode", false);
sqtextBox.Text = xml.importtext(FileName, "Size", false);
koatuutextBox.Text = xml.importtext(FileName, "KOATUU", false);
formownercomboBox.SelectedIndex = xml.importint(FileName, "OwnershipInfo", false);
formusecomboBox.SelectedIndex = xml.importint(FileName, "CategoryPurposeInfo", false);
formunitcomboBox.SelectedIndex = xml.importint(FileName, "LandCode", false);
ck63.Clear();
wgs84.Clear();
ck63 = xml.importcoords(FileName, false);
if (ck63 != null)
{
newcoords = true;
ck63Entities.Reset(ck63);
ck63View = (ListCollectionView)CollectionViewSource.GetDefaultView(ck63Entities);
for (int i = 0; i < ck63.Count; i++)
{
double[] x = { Convert.ToDouble(ck63[i].y.ToString().Replace(".", ",")) };
double[] y = { Convert.ToDouble(ck63[i].x.ToString().Replace(".", ",")) };
Projection src = new Projection(IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "CK63", "z" + x[0].ToString()[0]));
Projection dst = new Projection(@"+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs");
Projection.Transform(src, dst, x, y, null);
wgs84.Add(new coordsformat()
{
x = y[0].ToString().Replace(",", "."), y = x[0].ToString().Replace(",", "."), rank = ck63[i].rank
});
}
wgs84Entities.Reset(wgs84);
wgs84View = (ListCollectionView)CollectionViewSource.GetDefaultView(wgs84Entities);
}
if (myvariable.errcount > 0)
{
return(false);
}
return(true);
}
public bool importfrxml(string FileName)
{
myvariable.errcount = 0;
myvariable.errstr = "";
string regdate = xml.importtext(FileName, "RegistrationDate", true);
DateTime nulldate = Convert.ToDateTime("01/01/90");
if (regdate != "" && Convert.ToDateTime(regdate) > Convert.ToDateTime("01/01/90"))
{
statuscomboBoxSelectedIndex = 0;
regdatePickerSelectedDate = Convert.ToDateTime(regdate);
if (!DateTime.TryParse(xml.importtext(FileName, "LeaseDuration", true), out nulldate))
{
}
termleasedatePickerSelectedDate = nulldate;
}
else
{
statuscomboBoxSelectedIndex = 1;
regdatePickerSelectedDate = nulldate;
termleasedatePickerSelectedDate = nulldate;
}
string typeGrantor = xml.importtext(FileName, "typeGrantor", true);
if (typeGrantor != "")
{
if (typeGrantor == "NaturalPerson")
{
fizoryurcomboBoxSelectedIndex = 0;
lessortextBoxText = xml.importcontractorinf(FileName, "NaturalPerson_FullName", "Grantor", true);
inntextBoxText = xml.importcontractorinf(FileName, "NaturalPerson_TaxNumber", "Grantor", true);
passporttextBoxText = xml.importcontractorinf(FileName, "NaturalPerson_Passport", "Grantor", true);
if (!DateTime.TryParse(xml.importcontractorinf(FileName, "NaturalPerson_PassportIssuedDate", "Grantor", true), out nulldate))
{
myvariable.errcount++;
}
vidandatePickerSelectedDate = nulldate;
kemvidantextBoxText = xml.importcontractorinf(FileName, "NaturalPerson_IssuanceAuthority", "Grantor", true);
adresstextBoxText = xml.importcontractorinf(FileName, "NaturalPerson_Address", "Grantor", true);
}
else if (typeGrantor == "LegalEntity")
{
fizoryurcomboBoxSelectedIndex = 1;
lessortextBoxText = xml.importcontractorinf(FileName, "LegalEntity_Name", "Grantor", true);
kodpredtextBoxText = xml.importcontractorinf(FileName, "LegalEntity_EDRPOU", "Grantor", true);
adresstextBoxText = xml.importcontractorinf(FileName, "LegalEntity_Address", "Grantor", true);
}
}
string typeGrantee = xml.importtext(FileName, "typeGrantee", true);
if (typeGrantee != "")
{
if (typeGrantee == "NaturalPerson")
{
leaserfizoryurcomboBoxSelectedIndex = 0;
leasertextBoxText = xml.importcontractorinf(FileName, "NaturalPerson_FullName", "Grantee", true);
leaserinntextBoxText = xml.importcontractorinf(FileName, "NaturalPerson_TaxNumber", "Grantee", true);
leaserpassporttextBoxText = xml.importcontractorinf(FileName, "NaturalPerson_Passport", "Grantee", true);
if (xml.importcontractorinf(FileName, "NaturalPerson_PassportIssuedDate", "Grantee", true) != "")
{
leaservidandatePickerSelectedDate = Convert.ToDateTime(xml.importcontractorinf(FileName, "NaturalPerson_PassportIssuedDate", "Grantee", true));
}
else
{
leaservidandatePickerSelectedDate = Convert.ToDateTime("01/01/53");
}
leaserkemvidantextBoxText = xml.importcontractorinf(FileName, "NaturalPerson_IssuanceAuthority", "Grantee", true);
leaseradresstextBoxText = xml.importcontractorinf(FileName, "NaturalPerson_Address", "Grantee", true);
}
else if (typeGrantee == "LegalEntity")
{
leaserfizoryurcomboBoxSelectedIndex = 1;
leasertextBoxText = xml.importcontractorinf(FileName, "LegalEntity_Name", "Grantee", true);
leaserkodpredtextBoxText = xml.importcontractorinf(FileName, "LegalEntity_EDRPOU", "Grantee", true);
leaseradresstextBoxText = xml.importcontractorinf(FileName, "LegalEntity_Address", "Grantee", true);
}
}
cadnumtextBoxText = xml.importtext(FileName, "CadastralCode", true);
sqtextBoxText = xml.importtext(FileName, "Size", true);
koatuutextBoxText = xml.importtext(FileName, "KOATUU", true);
formownercomboBoxSelectedIndex = xml.importint(FileName, "OwnershipInfo", true);
formusecomboBoxSelectedIndex = xml.importint(FileName, "CategoryPurposeInfo", true);
formunitcomboBoxSelectedIndex = xml.importint(FileName, "LandCode", true);
ck63.Clear();
wgs84.Clear();
ck63 = xml.importcoords(FileName, true);
if (ck63 != null)
{
for (int i = 0; i < ck63.Count; i++)
{
double[] x = { Convert.ToDouble(ck63[i].y.ToString().Replace(".", ",")) };
double[] y = { Convert.ToDouble(ck63[i].x.ToString().Replace(".", ",")) };
Projection src = new Projection(IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "CK63", "z" + x[0].ToString()[0]));
Projection dst = new Projection(@"+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs");
Projection.Transform(src, dst, x, y, null);
wgs84.Add(new coordsformat()
{
x = y[0].ToString().Replace(",", "."), y = x[0].ToString().Replace(",", "."), rank = ck63[i].rank
});
}
}
string[] errstrs = myvariable.errstr.Split(':');
if (myvariable.errcount > 0)
{
if (errstrs != null)
{
int res = 0;
foreach (string param in errstrs)
{
if (IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "errlvl", param) != "0" && param != "")
{
res++;
}
}
if (res > 0)
{
return(false);
}
else
{
return(true);
}
}
return(false);
}
return(true);
}
public static ArrayList maxid()
{
try
{
using (var conn = new NpgsqlConnection("Server=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "server") + ";Port=" +
IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "port") + ";User Id=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "user") +
";Password="******"\settings.ini", "DB", "pass") + ";Database=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "database") + ";"))
{
conn.Open();
using (NpgsqlCommand comm = new NpgsqlCommand("SELECT MAX(ID) FROM contracts", conn))
{
using (var reader = comm.ExecuteReader())
{
ArrayList lstSelect = new ArrayList();
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
lstSelect.Add(reader[i]);
}
}
conn.Close();
return(lstSelect);
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Errr on maxid!");
return(null);
}
}
public static void update(string SQL)
{
try
{
using (var conn = new NpgsqlConnection("Server=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "server") + ";Port=" +
IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "port") + ";User Id=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "user") +
";Password="******"\settings.ini", "DB", "pass") + ";Database=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "database") + ";"))
{
conn.Open();
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = SQL;
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Errr on update!");
}
}
public static List <coordsformat> selcoords(List <string> id, string table)
{
try
{
using (var conn = new NpgsqlConnection("Server=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "server") + ";Port=" +
IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "port") + ";User Id=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "user") +
";Password="******"\settings.ini", "DB", "pass") + ";Database=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "database") + ";"))
{
conn.Open();
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = conn;
List <coordsformat> lstSelect = new List <coordsformat>();
if (id.Count > 1)
{
cmd.CommandText = "SELECT* FROM " + table + " WHERE ID = '";
for (int l = 0; l < id.Count; l++)
{
if (l > 0)
{
cmd.CommandText = cmd.CommandText + "' or ID='" + id[l];
}
else
{
cmd.CommandText = cmd.CommandText + id[l];
}
}
cmd.CommandText = cmd.CommandText + "';";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount / 4; i += 4)
{
lstSelect.Add(new coordsformat()
{
id = Convert.ToInt32(reader[i]), x = reader[i + 1].ToString(), y = reader[i + 2].ToString(), rank = Convert.ToInt32(reader[i + 3])
});
}
}
}
conn.Close();
}
else
{
cmd.CommandText = "SELECT * FROM " + table + " WHERE ID='" + id[0] + "';";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount / 4; i += 4)
{
lstSelect.Add(new coordsformat()
{
id = Convert.ToInt32(reader[i]), x = reader[i + 1].ToString(), y = reader[i + 2].ToString(), rank = Convert.ToInt32(reader[i + 3])
});
}
}
conn.Close();
}
}
return(lstSelect);
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Errr on select coords!");
return(null);
}
}
public static ArrayList select(string SQL)
{
try
{
using (var conn = new NpgsqlConnection("Server=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "server") + ";Port=" +
IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "port") + ";User Id=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "user") +
";Password="******"\settings.ini", "DB", "pass") + ";Database=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "database") + ";"))
{
conn.Open();
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = SQL;
using (var reader = cmd.ExecuteReader())
{
ArrayList lstSelect = new ArrayList();
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
lstSelect.Add(reader[i]);
}
}
conn.Close();
return(lstSelect);
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Errr on select!");
return(null);
}
}
public static List <contract> selcontr()
{
try
{
using (var conn = new NpgsqlConnection("Server=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "server") + ";Port=" +
IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "port") + ";User Id=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "user") +
";Password="******"\settings.ini", "DB", "pass") + ";Database=" + IniFile.Read(AppDomain.CurrentDomain.BaseDirectory + @"\settings.ini", "DB", "database") + ";"))
{
conn.Open();
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = conn;
cmd.CommandText = "select * from contracts";
using (var reader = cmd.ExecuteReader())
{
List <contract> contracts = new List <contract>();
while (reader.Read())
{
contracts.Add(new contract
{
id = Convert.ToInt32(reader[0]),
contract_number = Convert.ToString(reader[1]),
date_contract = Convert.ToString(reader[2]),
lessor = Convert.ToString(reader[3]),
cadastral_number = Convert.ToString(reader[4]),
square = Convert.ToString(reader[5]),
term_lease = Convert.ToString(reader[6]),
registration_date = Convert.ToString(reader[7]),
contract_status = Convert.ToString(reader[8]),
unit_number = Convert.ToString(reader[9]),
notes = Convert.ToString(reader[10]),
type_contract = Convert.ToString(reader[11]),
area_number = Convert.ToString(reader[12]),
form_owner = Convert.ToString(reader[13]),
form_use = Convert.ToString(reader[14]),
form_unit = Convert.ToString(reader[15]),
koatuu = Convert.ToString(reader[16]),
leaser = Convert.ToString(reader[17]),
contractortype = Convert.ToString(reader[18])
});
}
conn.Close();
return(contracts);
}
}
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Errr on select contract!");
return(null);
}
}