protected void ActalizeButton_Click(object sender, EventArgs e)
{
var gus = db.GusDomain.FirstOrDefault(o => o.Nip == LabelNIP.Text && o.AddedDate == DateTime.Today);
if (gus == null)
{
gus = GusApiHelper.DataSearchSubjects(LabelNIP.Text);
db.GusDomain.Add(gus);
db.SaveChanges();
}
var mf = db.MfDomain.FirstOrDefault(o => o.Nip == LabelNIP.Text && o.AddedDate == DateTime.Today);
if (mf == null)
{
mf = MfApiHelper.SearchNip(LabelNIP.Text);
db.MfDomain.Add(mf);
db.SaveChanges();
}
// MF
LabelMF_AccountNumbers.Text = mf.AccountNumbersAsString.Replace(";", "<br />");
LabelMF_KRS.Text = mf.Krs;
LabelMF_Name.Text = mf.Name;
LabelMF_NIP.Text = mf.Nip;
LabelMF_PESEL.Text = mf.Pesel;
LabelMF_RegistrationDenialBasis.Text = mf.RegistrationDenialBasis;
LabelMF_RegistrationDenialDate.Text = mf.RegistrationDenialDate;
LabelMF_RegistrationLegalDate.Text = mf.RegistrationLegalDate;
LabelMF_REGON.Text = mf.Regon;
LabelMF_RemovalBasis.Text = mf.RemovalBasis;
LabelMF_RemovalDate.Text = mf.RemovalDate;
LabelMF_ResidenceAddress.Text = mf.ResidenceAddress;
LabelMF_RestorationBasis.Text = mf.RestorationBasis;
LabelMF_RestorationDate.Text = mf.RestorationDate;
LabelMF_StatusVAT.Text = mf.StatusVat;
LabelMF_WorkingAddress.Text = mf.WorkingAddress;
// GUS
LabelGUS_NIP.Text = gus.Nip;
LabelGUS_REGON.Text = gus.Regon;
LabelGUS_StatusNIP.Text = gus.StatusNip;
LabelGUS_ApartmentNr.Text = gus.NrLokalu;
LabelGUS_City.Text = gus.Miejscowosc;
LabelGUS_Commune.Text = gus.Gmina;
LabelGUS_District.Text = gus.Powiat;
LabelGUS_EndDate.Text = gus.DataZakonczeniaDzialalnosci;
LabelGUS_HouseNr.Text = gus.NrNieruchomosci;
LabelGUS_Name.Text = gus.Nazwa;
LabelGUS_PostCity.Text = gus.MiejscowoscPoczty;
LabelGUS_PostCode.Text = gus.KodPocztowy;
LabelGUS_Province.Text = gus.Wojewodztwo;
LabelGUS_Street.Text = gus.Ulica;
LabelGUS_Type.Text = gus.Typ;
HistoryDropDownList.DataBind();
ClientScript.RegisterStartupScript(GetType(), "Popup", "showDetails();", true);
}
protected void ButtonUpdate_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(TextBoxNIP.Text))
{
return;
}
var gus = db.GusDomain.FirstOrDefault(o => o.Nip == TextBoxNIP.Text && o.AddedDate == DateTime.Today);
if (gus == null)
{
gus = GusApiHelper.DataSearchSubjects(TextBoxNIP.Text);
db.GusDomain.Add(gus);
db.SaveChanges();
}
var mf = db.MfDomain.FirstOrDefault(o => o.Nip == TextBoxNIP.Text && o.AddedDate == DateTime.Today);
if (mf == null)
{
mf = MfApiHelper.SearchNip(TextBoxNIP.Text);
db.MfDomain.Add(mf);
db.SaveChanges();
}
if ((mf == null) || (gus == null))
{
string title = "Błąd";
string body = "Nie znaleziono kontrahenta.";
ClientScript.RegisterStartupScript(
GetType(),
"Popup", "showModalError('" + title + "', '" + body + "');",
true
);
return;
}
TextBoxName.Text = gus.Nazwa;
TextBoxPESEL.Text = mf.Pesel;
TextBoxCity.Text = gus.Miejscowosc;
TextBoxPostCode.Text = gus.KodPocztowy;
TextBoxNIP.Text = gus.Nip;
string nr = (string.IsNullOrEmpty(gus.NrNieruchomosci) ? gus.NrLokalu : gus.NrNieruchomosci);
TextBoxStreet.Text = string.IsNullOrEmpty(gus.Ulica) ? nr : (gus.Ulica + " " + nr);
TextBoxPostTown.Text = gus.MiejscowoscPoczty;
TextBoxName.Text = TextBoxName.Text;
TextBoxStreet.Text = TextBoxStreet.Text;
TextBoxCity.Text = TextBoxCity.Text;
TextBoxPostCode.Text = TextBoxPostCode.Text;
TextBoxPostTown.Text = TextBoxPostTown.Text;
TextBoxNIP.Text = TextBoxNIP.Text;
TextBoxPESEL.Text = TextBoxPESEL.Text;
}
protected void GridViewContractors_SelectedIndexChanged(object sender, EventArgs e)
{
if (!BaseConnection.openConnection())
{
return;
}
var query =
"select Name,Post_town,Post_code, City, Street, NIP, REGON, PESEL from Contractors where Id = " + GridViewContractors.DataKeys[GridViewContractors.SelectedIndex].Value;
var reader = BaseConnection.execReader(query);
while (reader.Read())
{
LabelName.Text = LabelTitle.Text = reader.GetString(0);
LabelPostTown.Text = reader.GetString(1);
LabelPostCode.Text = reader.GetString(2);
LabelCity.Text = reader.GetString(3);
LabelStreet.Text = reader.GetString(4);
if (!reader.IsDBNull(5))
{
LabelNIP.Text = reader.GetString(5);
}
if (!reader.IsDBNull(6))
{
LabelREGON.Text = reader.GetString(6);
}
}
BaseConnection.closeConnection();
if (!string.IsNullOrEmpty(LabelNIP.Text))
{
var gus = GusApiHelper.DataSearchSubjects(LabelNIP.Text);
var mf = MfApiHelper.SearchNip(LabelNIP.Text);
if (gus == null || mf == null)
{
ButtonDetails.Enabled = false;
}
else
{
ButtonDetails.Enabled = true;
}
}
else
{
ButtonDetails.Enabled = false;
}
ClientScript.RegisterStartupScript(GetType(), "Popup", "showInfo();", true);
}
protected void ButtonDetails_Click(object sender, EventArgs e)
{
var gus = GusApiHelper.DataSearchSubjects(LabelNIP.Text);
var mf = MfApiHelper.SearchNip(LabelNIP.Text);
if ((mf == null) || (gus == null))
{
string title = "Błąd";
string body = "Nie znaleziono kontrahenta.";
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "showModalError('" + title + "', '" + body + "');", true);
return;
}
// MF
LabelMF_AccountNumbers.Text = mf.AccountNumbersAsString.Replace(";", "<br />");
LabelMF_KRS.Text = mf.Krs;
LabelMF_Name.Text = mf.Name;
LabelMF_NIP.Text = mf.Nip;
LabelMF_PESEL.Text = mf.Pesel;
LabelMF_RegistrationDenialBasis.Text = mf.RegistrationDenialBasis;
LabelMF_RegistrationDenialDate.Text = mf.RegistrationDenialDate;
LabelMF_RegistrationLegalDate.Text = mf.RegistrationLegalDate;
LabelMF_REGON.Text = mf.Regon;
LabelMF_RemovalBasis.Text = mf.RemovalBasis;
LabelMF_RemovalDate.Text = mf.RemovalDate;
LabelMF_ResidenceAddress.Text = mf.ResidenceAddress;
LabelMF_RestorationBasis.Text = mf.RestorationBasis;
LabelMF_RestorationDate.Text = mf.RestorationDate;
LabelMF_StatusVAT.Text = mf.StatusVat;
LabelMF_WorkingAddress.Text = mf.WorkingAddress;
// GUS
LabelGUS_NIP.Text = gus.Nip;
LabelGUS_REGON.Text = gus.Regon;
LabelGUS_StatusNIP.Text = gus.StatusNip;
LabelGUS_ApartmentNr.Text = gus.NrLokalu;
LabelGUS_City.Text = gus.Miejscowosc;
LabelGUS_Commune.Text = gus.Gmina;
LabelGUS_District.Text = gus.Powiat;
LabelGUS_EndDate.Text = gus.DataZakonczeniaDzialalnosci;
LabelGUS_HouseNr.Text = gus.NrNieruchomosci;
LabelGUS_Name.Text = gus.Nazwa;
LabelGUS_PostCity.Text = gus.MiejscowoscPoczty;
LabelGUS_PostCode.Text = gus.KodPocztowy;
LabelGUS_Province.Text = gus.Wojewodztwo;
LabelGUS_Street.Text = gus.Ulica;
LabelGUS_Type.Text = gus.Typ;
ClientScript.RegisterStartupScript(GetType(), "Popup", "showDetails();", true);
}
public void SearchNip_NotValidNipNumber_RestNullObject()
{
var result = MfApiHelper.SearchNip("1111111111");
Assert.IsNull(result);
}
public void ButtonSearch_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(TextBoxSearchByNIP.Text))
{
return;
}
var gus = db.GusDomain.FirstOrDefault(o => o.Nip == TextBoxSearchByNIP.Text && o.AddedDate == DateTime.Today);
if (gus == null)
{
try
{
gus = GusApiHelper.DataSearchSubjects(TextBoxSearchByNIP.Text);
if (!String.IsNullOrEmpty(gus.Nazwa))
{
db.GusDomain.Add(gus);
db.SaveChanges();
}
else
{
gus = null;
}
}
catch (Exception)
{
gus = null;
}
}
var mf = db.MfDomain.FirstOrDefault(o => o.Nip == TextBoxSearchByNIP.Text && o.AddedDate == DateTime.Today);
if (mf == null)
{
try
{
mf = MfApiHelper.SearchNip(TextBoxSearchByNIP.Text);
if (mf != null)
{
db.MfDomain.Add(mf);
db.SaveChanges();
}
}
catch (Exception)
{
mf = null;
}
}
if ((mf == null) || (gus == null))
{
string title = "Błąd";
string body = "Nie znaleziono kontrahenta.";
ClientScript.RegisterStartupScript(
GetType(),
"Popup", "showModalError('" + title + "', '" + body + "');",
true
);
return;
}
// MF
LabelMF_AccountNumbers.Text = mf.AccountNumbersAsString.Replace(";", "<br />");
LabelMF_KRS.Text = mf.Krs;
LabelMF_Name.Text = mf.Name;
LabelMF_NIP.Text = mf.Nip;
LabelMF_PESEL.Text = mf.Pesel;
LabelMF_RegistrationDenialBasis.Text = mf.RegistrationDenialBasis;
LabelMF_RegistrationDenialDate.Text = mf.RegistrationDenialDate;
LabelMF_RegistrationLegalDate.Text = mf.RegistrationLegalDate;
LabelMF_REGON.Text = mf.Regon;
LabelMF_RemovalBasis.Text = mf.RemovalBasis;
LabelMF_RemovalDate.Text = mf.RemovalDate;
LabelMF_ResidenceAddress.Text = mf.ResidenceAddress;
LabelMF_RestorationBasis.Text = mf.RestorationBasis;
LabelMF_RestorationDate.Text = mf.RestorationDate;
LabelMF_StatusVAT.Text = mf.StatusVat;
LabelMF_WorkingAddress.Text = mf.WorkingAddress;
// GUS
LabelGUS_NIP.Text = gus.Nip;
LabelGUS_REGON.Text = gus.Regon;
LabelGUS_StatusNIP.Text = gus.StatusNip;
LabelGUS_ApartmentNr.Text = gus.NrLokalu;
LabelGUS_City.Text = gus.Miejscowosc;
LabelGUS_Commune.Text = gus.Gmina;
LabelGUS_District.Text = gus.Powiat;
LabelGUS_EndDate.Text = gus.DataZakonczeniaDzialalnosci;
LabelGUS_HouseNr.Text = gus.NrNieruchomosci;
LabelGUS_Name.Text = gus.Nazwa;
LabelGUS_PostCity.Text = gus.MiejscowoscPoczty;
LabelGUS_PostCode.Text = gus.KodPocztowy;
LabelGUS_Province.Text = gus.Wojewodztwo;
LabelGUS_Street.Text = gus.Ulica;
LabelGUS_Type.Text = gus.Typ;
LabelName.Text = gus.Nazwa;
LabelPESEL.Text = mf.Pesel;
LabelCity.Text = gus.Miejscowosc;
LabelPostCode.Text = gus.KodPocztowy;
LabelNIP.Text = gus.Nip;
string nr = (String.IsNullOrEmpty(gus.NrNieruchomosci) ? gus.NrLokalu : gus.NrNieruchomosci);
LabelStreet.Text = String.IsNullOrEmpty(gus.Ulica) ? nr : (gus.Ulica + " " + nr);
LabelPostTown.Text = gus.MiejscowoscPoczty;
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "showInfo();", true);
}
