protected void GridViewInvoices_SelectedIndexChanged(object sender, EventArgs e)
{
if (!BaseConnection.openConnection())
{
return;
}
string query = "select main.Name, reciever.Name, Issue_date, Due_date, Payment_Method.Name from Invoices " +
"inner join Contractors as main on main.Id = Id_contractor left join Contractors as reciever on reciever.Id = Id_receiver " +
"inner join Payment_Method on Id_payment = Payment_Method.Id where Invoices.Id =" + GridViewInvoices.DataKeys[GridViewInvoices.SelectedIndex].Value.ToString();
SqlDataReader reader = BaseConnection.execReader(query);
while (reader.Read())
{
LabelContractor.Text = reader.GetString(0);
if (!reader.IsDBNull(1))
{
LabelReciever.Text = reader.GetString(1);
}
LabelIssueDate.Text = reader.GetDateTime(2).ToShortDateString();
LabelDueDate.Text = reader.GetDateTime(3).ToShortDateString();
LabelPayment.Text = reader.GetString(4);
}
BaseConnection.closeConnection();
LabelTitle.Text = (GridViewInvoices.Rows[GridViewInvoices.SelectedIndex].Cells[2].Controls[1] as Label).Text;
SqlDataSourceProducts.SelectCommand = "select Products.Name,Units.Name, Tax_rates.Name,Tax_rates.Value, Amount, Price from Invoice_Products " +
"inner join Tax_rates on Id_tax = Tax_rates.Id inner join Products on Id_product = Products.Id " +
"inner join Units on Products.Id_unit = Units.Id where Id_invoice=" + GridViewInvoices.DataKeys[GridViewInvoices.SelectedIndex].Value.ToString();
ClientScript.RegisterStartupScript(this.GetType(), "Popup", "showInfo();", true);
}
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 Page_Load(object sender, EventArgs e)
{
string id = Request.QueryString["id"];
if (string.IsNullOrEmpty(id))
{
Response.Redirect("Default.aspx");
}
if (IsPostBack)
{
return;
}
if (!BaseConnection.openConnection())
{
return;
}
string query = "select Name,Post_town,Post_code, City, Street, NIP, REGON, PESEL from Contractors where Id = " + id;
SqlDataReader reader = BaseConnection.execReader(query);
while (reader.Read())
{
TextBoxName.Text = reader.GetString(0);
TextBoxPostTown.Text = reader.GetString(1);
TextBoxPostCode.Text = reader.GetString(2);
TextBoxCity.Text = reader.GetString(3);
TextBoxStreet.Text = reader.GetString(4);
if (!reader.IsDBNull(5))
{
TextBoxNIP.Text = reader.GetString(5);
}
if (!reader.IsDBNull(6))
{
TextBoxREGON.Text = reader.GetString(6);
}
}
BaseConnection.closeConnection();
}
private void loadCompanyDetail()
{
if (!BaseConnection.openConnection())
{
return;
}
List <string> list = new List <string>();
string query = "SELECT [Name], [Post_town], [Post_code], [City], [Street], [NIP], [REGON], [Bank], [Bank_account] FROM [User_Detail] WHERE ([Id_user] =" + Session["User"] + ")";
SqlDataReader reader = BaseConnection.execReader(query);
while (reader.Read())
{
LabelName.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);
}
LabelBank.Text = reader.GetString(7);
LabelBankAccount.Text = reader.GetString(8);
/*for (int i = 0; i < reader.FieldCount; ++i)
* {
* System.Diagnostics.Debug.WriteLine(reader.GetString(i));
* }*/
}
BaseConnection.closeConnection();
}
public void head()
{
string issueDate = "", dueDate = "", type = "Oryginał";
if (!BaseConnection.openConnection())
{
return;
}
string query = "select Issue_date, Due_date , Payment_Method.Name from Invoices " +
"inner join Payment_Method on Invoices.Id_payment = Payment_Method.Id where Invoices.Id=" + _idInvoice;
type = "Oryginał";
SqlDataReader reader = BaseConnection.execReader(query);
while (reader.Read())
{
issueDate = reader.GetDateTime(0).ToShortDateString();
dueDate = reader.GetDateTime(1).ToShortDateString();
_payment = reader.GetString(2);
}
BaseConnection.closeConnection();
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "row");
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "h-25");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // open div row h-25
{
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "col-6");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // open div col-6
{
_writer.AddAttribute(HtmlTextWriterAttribute.Style, "width: 50%; height: 90%");
//_writer.AddAttribute(HtmlTextWriterAttribute.Class, "p-2");
//_writer.AddAttribute(HtmlTextWriterAttribute.Src, "file:\\" + HttpContext.Current.Server.MapPath( "Images/Logo.jpg"));
//_writer.AddAttribute(HtmlTextWriterAttribute.Src, IronPdf.Util.ImageToDataUri(System.Drawing.Image.FromFile(HttpContext.Current.Server.MapPath("Images/Logo.jpg"))));
_writer.RenderBeginTag(HtmlTextWriterTag.Img); // img logo
_writer.RenderEndTag();
}
_writer.RenderEndTag(); // close div col-6
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "col-6");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // open div col-6
{
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "table");
_writer.RenderBeginTag(HtmlTextWriterTag.Table); // open table
{
_writer.RenderBeginTag(HtmlTextWriterTag.Tbody); // open tbody
{
_writer.RenderBeginTag(HtmlTextWriterTag.Tr); //open tr
{
_writer.RenderBeginTag(HtmlTextWriterTag.Td); //Invoice
_writer.Write("Faktura");
_writer.RenderEndTag();
_writer.RenderBeginTag(HtmlTextWriterTag.Td); // Invoice nr
_writer.Write(_nr);
_writer.RenderEndTag();
}
_writer.RenderEndTag(); // close tr
_writer.RenderBeginTag(HtmlTextWriterTag.Tr); //open tr
{
_writer.RenderBeginTag(HtmlTextWriterTag.Td); //Issue date
_writer.Write("Data wystawienia:");
_writer.RenderEndTag();
_writer.RenderBeginTag(HtmlTextWriterTag.Td);
_writer.Write(issueDate);
_writer.RenderEndTag();
}
_writer.RenderEndTag(); // close tr
_writer.RenderBeginTag(HtmlTextWriterTag.Tr); //open tr
{
_writer.RenderBeginTag(HtmlTextWriterTag.Td); //Due date
_writer.Write("Termin zapłaty:");
_writer.RenderEndTag();
_writer.RenderBeginTag(HtmlTextWriterTag.Td);
_writer.Write(dueDate);
_writer.RenderEndTag();
}
_writer.RenderEndTag(); // close tr
_writer.RenderBeginTag(HtmlTextWriterTag.Tr); //open tr
{
_writer.RenderBeginTag(HtmlTextWriterTag.Td); //Payment
_writer.Write("Metoda płatności:");
_writer.RenderEndTag();
_writer.RenderBeginTag(HtmlTextWriterTag.Td);
_writer.Write(_payment);
_writer.RenderEndTag();
}
_writer.RenderEndTag(); // close tr
_writer.RenderBeginTag(HtmlTextWriterTag.Tr); //open tr
{
_writer.RenderBeginTag(HtmlTextWriterTag.Td); //Payment
_writer.Write("Typ dokumentu:");
_writer.RenderEndTag();
_writer.RenderBeginTag(HtmlTextWriterTag.Td);
_writer.Write(type);
_writer.RenderEndTag();
}
_writer.RenderEndTag(); // close tr
}
_writer.RenderEndTag(); //close tbody
}
_writer.RenderEndTag(); //close table
}
_writer.RenderEndTag(); // close div col-6
}
_writer.RenderEndTag(); // close div row h-25
_writer.AddAttribute(HtmlTextWriterAttribute.Style, "color: black; height: 2px; background-color:black;"); //hr
_writer.RenderBeginTag(HtmlTextWriterTag.Hr);
_writer.RenderEndTag();
_writer.RenderBeginTag(HtmlTextWriterTag.Br); //br
_writer.RenderEndTag();
}
public void products()
{
if (!BaseConnection.openConnection())
{
return;
}
string query = "select Products.Name, Units.Name, Invoice_Products.Amount, Tax_rates.Name, Tax_rates.Value, Invoice_Products.Price " +
"from Invoice_Products inner join Invoices on Invoice_Products.Id_invoice = Invoices.Id " +
"inner join Products on Invoice_Products.Id_product = Products.Id " +
"inner join Units on Units.Id = Products.Id_unit inner join Tax_rates on Tax_rates.Id = Invoice_Products.Id_tax " +
"where Invoices.Id = " + _idInvoice;
decimal sum = 0;
List <ProductRow> productsList = new List <ProductRow>();
SqlDataReader reader = BaseConnection.execReader(query);
while (reader.Read())
{
ProductRow productRow = new ProductRow();
productRow.name = reader.GetString(0);
productRow.unit = reader.GetString(1);
productRow.amount = reader.GetInt32(2);
productRow.taxRate = reader.GetString(3);
productRow.taxRateValue = reader.GetDecimal(4);
productRow.price = reader.GetDecimal(5);
productsList.Add(productRow);
}
BaseConnection.closeConnection();
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "table");
_writer.RenderBeginTag(HtmlTextWriterTag.Table); // open table
{
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "thead-dark");
_writer.RenderBeginTag(HtmlTextWriterTag.Thead); // open thead
{
_writer.RenderBeginTag(HtmlTextWriterTag.Tr); //open tr
{
_writer.AddAttribute(HtmlTextWriterAttribute.Scope, "col");
_writer.RenderBeginTag(HtmlTextWriterTag.Th); //Product
_writer.Write("Produkt");
_writer.RenderEndTag();
_writer.AddAttribute(HtmlTextWriterAttribute.Scope, "col");
_writer.RenderBeginTag(HtmlTextWriterTag.Th); //Unit
_writer.Write("Jedn.");
_writer.RenderEndTag();
_writer.AddAttribute(HtmlTextWriterAttribute.Scope, "col");
_writer.RenderBeginTag(HtmlTextWriterTag.Th); //Amount
_writer.Write("Ilość");
_writer.RenderEndTag();
_writer.AddAttribute(HtmlTextWriterAttribute.Scope, "col");
_writer.RenderBeginTag(HtmlTextWriterTag.Th); //Vat
_writer.Write("Stawka");
_writer.RenderEndTag();
_writer.AddAttribute(HtmlTextWriterAttribute.Scope, "col");
_writer.RenderBeginTag(HtmlTextWriterTag.Th); //Price netto
_writer.Write("Cena netto");
_writer.RenderEndTag();
_writer.AddAttribute(HtmlTextWriterAttribute.Scope, "col");
_writer.RenderBeginTag(HtmlTextWriterTag.Th); //Price brutto
_writer.Write("Cena brutto");
_writer.RenderEndTag();
}
_writer.RenderEndTag(); // close tr
}
_writer.RenderEndTag(); //close thead
_writer.RenderBeginTag(HtmlTextWriterTag.Tbody); // open tbody
{
foreach (var ele in productsList)
{
_writer.RenderBeginTag(HtmlTextWriterTag.Tr); //open tr
{
_writer.RenderBeginTag(HtmlTextWriterTag.Td); // Product
_writer.Write(ele.name);
_writer.RenderEndTag();
_writer.RenderBeginTag(HtmlTextWriterTag.Td); // Unit
_writer.Write(ele.unit);
_writer.RenderEndTag();
_writer.RenderBeginTag(HtmlTextWriterTag.Td); // Amount
_writer.Write(ele.amount);
_writer.RenderEndTag();
_writer.RenderBeginTag(HtmlTextWriterTag.Td); // VAT
_writer.Write(ele.taxRate);
_writer.RenderEndTag();
_writer.RenderBeginTag(HtmlTextWriterTag.Td); // Price netto
_writer.Write(ele.price.ToString("0.##"));
_writer.RenderEndTag();
decimal brutto = Math.Round(ele.price * (ele.taxRateValue + 1), 2);
sum += (brutto * ele.amount);
_writer.RenderBeginTag(HtmlTextWriterTag.Td); // Price brutto
_writer.Write(brutto);
_writer.RenderEndTag();
}
_writer.RenderEndTag(); // close tr
}
}
_writer.RenderEndTag(); //close tbody
}
_writer.RenderEndTag(); //close table
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "text-right w-100 font-weight-bold bg-light");
_writer.RenderBeginTag(HtmlTextWriterTag.H3); //open h3
_writer.Write("Razem do zapłaty (brutto): " + sum + " zł");
_writer.RenderEndTag(); //close h3
}
public void persons()
{
if (!BaseConnection.openConnection())
{
return;
}
string query = "select * from User_Detail where Id_user ="******"", postTown = "", postCode = "", city = "", street = "", nip = "", regon = "", bank = "", bankAccount = "";
SqlDataReader reader = BaseConnection.execReader(query);
while (reader.Read())
{
id = reader.GetInt32(0);
name = reader.GetString(1);
postTown = reader.GetString(2);
postCode = reader.GetString(3);
city = reader.GetString(4);
street = reader.GetString(5);
if (!reader.IsDBNull(6))
{
nip = reader.GetString(6);
}
if (!reader.IsDBNull(7))
{
regon = reader.GetString(7);
}
if (!reader.IsDBNull(8))
{
bank = reader.GetString(8);
}
if (!reader.IsDBNull(9))
{
bankAccount = reader.GetString(9);
}
}
reader.Close();
BaseConnection.closeConnection();
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "row h-auto align-items-center");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // open div row h-auto align-items-center
{
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "col-6");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // open div col-6 seller
{
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "mt-2");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // title
_writer.Write("Sprzedawca:");
_writer.RenderEndTag();
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "mt-2");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // name
_writer.Write(name);
_writer.RenderEndTag();
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "mt-2");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // address
_writer.Write(city + " " + street);
_writer.RenderEndTag();
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "mt-2");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // post
_writer.Write(postCode + " " + postTown);
_writer.RenderEndTag();
if (nip != "")
{
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "mt-2");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // nip
_writer.Write("NIP: " + nip);
_writer.RenderEndTag();
}
if ((_payment == "Przelew") && (bank != "") && (bankAccount != ""))
{
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "mt-2");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // bank
_writer.Write(bank + " " + bankAccount);
_writer.RenderEndTag();
}
}
_writer.RenderEndTag(); // close div col-6 seller
if (!BaseConnection.openConnection())
{
return;
}
query = "select Contractors.* from Contractors inner join Invoices on Contractors.Id=Invoices.Id_contractor where Invoices.Id =" + _idInvoice;
string pesel = "";
reader = BaseConnection.execReader(query);
while (reader.Read())
{
id = reader.GetInt32(0);
id = reader.GetInt32(1);
name = reader.GetString(2);
postTown = reader.GetString(3);
postCode = reader.GetString(4);
city = reader.GetString(5);
street = reader.GetString(6);
if (!reader.IsDBNull(7))
{
nip = reader.GetString(7);
}
if (!reader.IsDBNull(8))
{
regon = reader.GetString(8);
}
if (!reader.IsDBNull(9))
{
pesel = reader.GetString(9);
}
}
BaseConnection.closeConnection();
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "col-6");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // open div col-6 buyer
{
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "mt-2");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // title
_writer.Write("Kupujący:");
_writer.RenderEndTag();
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "mt-2");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // name
_writer.Write(name);
_writer.RenderEndTag();
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "mt-2");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // address
_writer.Write(city + " " + street);
_writer.RenderEndTag();
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "mt-2");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // post
_writer.Write(postCode + " " + postTown);
_writer.RenderEndTag();
if (nip != "")
{
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "mt-2");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // nip
_writer.Write("NIP: " + nip);
_writer.RenderEndTag();
}
if (pesel != "")
{
_writer.AddAttribute(HtmlTextWriterAttribute.Class, "mt-2");
_writer.RenderBeginTag(HtmlTextWriterTag.Div); // pesel
_writer.Write("PESEL: " + pesel);
_writer.RenderEndTag();
}
}
_writer.RenderEndTag(); // close div col-6 buyer
}
_writer.RenderEndTag(); // close div row h-auto align-items-center
_writer.AddAttribute(HtmlTextWriterAttribute.Style, "color: black; height: 2px; background-color:black;"); //hr
_writer.RenderBeginTag(HtmlTextWriterTag.Hr);
_writer.RenderEndTag();
_writer.RenderBeginTag(HtmlTextWriterTag.Br); //br
_writer.RenderEndTag();
}