private void btnBuscar_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtCita.Text) == false)
{
MessageBox.Show("Ingrese el numero de cita");
return;
}
Base_de_datos most = new Base_de_datos();
if (most.BuscarReceta(txtCita.Text) == 0)
{
txtValorC.Enabled = false;
btnPagar.Enabled = false;
chkIngresar.Enabled = false;
dataGridView1.DataSource = null;
btnCancelar.Enabled = false;
}
else
{
most.BuscarReceta(txtCita.Text);
dataGridView1.DataSource = most.Mostrar_Resultados();
Base_de_datos.porcentaje_riesgo(txtCita.Text);
total = Base_de_datos.total_medicamentos(txtCita.Text);
descuento = total * (Base_de_datos.porcentaje_riesgo(txtCita.Text) / 100);
totalDescuento = total - descuento;
txtMedicamentos.Text = total.ToString();
txtDesc.Text = totalDescuento.ToString();
txtSubTotal.Text = descuento.ToString();
TotalFinal = descuento;
txtTotal.Text = TotalFinal.ToString();
txtValorC.Enabled = true;
btnPagar.Enabled = true;
chkIngresar.Enabled = true;
btnCancelar.Enabled = true;
}
}
private void txtCita_TextChanged(object sender, EventArgs e)
{
if (btnPagar.Enabled == true)
{
txtValorC.Enabled = false;
btnPagar.Enabled = false;
chkIngresar.Enabled = false;
txtIngresar.Enabled = false;
btnCancelar.Enabled = false;
chkIngresar.Checked = false;
dataGridView1.DataSource = null;
txtTotal.Text = "0";
txtIngresar.Text = "0";
txtValorC.Text = "0";
txtCita.Text = "";
txtDesc.Text = "0";
txtMedicamentos.Text = "0";
txtSubTotal.Text = "0";
txtConsulta.Text = "0";
txtCita.Focus();
}
if (!string.IsNullOrEmpty(txtCita.Text) == false)
{
return;
}
Base_de_datos most = new Base_de_datos();
if (most.BuscarReceta(txtCita.Text) == 0)
{
txtValorC.Enabled = false;
btnPagar.Enabled = false;
chkIngresar.Enabled = false;
dataGridView1.DataSource = null;
btnCancelar.Enabled = false;
}
else
{
most.BuscarReceta(txtCita.Text);
dataGridView1.DataSource = most.Mostrar_Resultados();
Base_de_datos.porcentaje_riesgo(txtCita.Text);
total = Base_de_datos.total_medicamentos(txtCita.Text);
descuento = total * (Base_de_datos.porcentaje_riesgo(txtCita.Text) / 100);
totalDescuento = total - descuento;
txtMedicamentos.Text = total.ToString();
txtDesc.Text = totalDescuento.ToString();
txtSubTotal.Text = descuento.ToString();
TotalFinal = descuento;
txtTotal.Text = TotalFinal.ToString();
txtValorC.Enabled = true;
btnPagar.Enabled = true;
chkIngresar.Enabled = true;
btnCancelar.Enabled = true;
}
}
private void btnPagar_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtValorC.Text) == false)
{
MessageBox.Show("Ingrease el valor de la consulta");
return;
}
if (!string.IsNullOrEmpty(txtValorC.Text) == false)
{
MessageBox.Show("Ingrease el valor de la consulta");
return;
}
if (!string.IsNullOrEmpty(txtIngresar.Text) == false)
{
MessageBox.Show("Ingrese el valor a pagar");
return;
}
int validar;
validar = Base_de_datos.ValidarFactura(txtCita.Text);
if (validar == 1)
{
MessageBox.Show("Esta factura ya esta pagada");
return;
}
if (chkIngresar.Checked)
{
String Titulo = "Dispensario Médico Hermana Nazaria";
String Titulo2 = "\nAguas del Padre, Siguatepeque, Comayagua\n";
String Head;
BaseFont bf = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
iTextSharp.text.Font font = new iTextSharp.text.Font(bf, 10, iTextSharp.text.Font.NORMAL);
String Fecha = "";
int Mes = DateTime.Now.Month;
switch (Mes)
{
case 1:
Fecha = (DateTime.Now.Day.ToString() + " Enero del " + DateTime.Now.Year.ToString());
break;
case 2:
Fecha = (DateTime.Now.Day.ToString() + " Febrero del " + DateTime.Now.Year.ToString());
break;
case 3:
Fecha = (DateTime.Now.Day.ToString() + " Marzo del " + DateTime.Now.Year.ToString());
break;
case 4:
Fecha = (DateTime.Now.Day.ToString() + " Abril del " + DateTime.Now.Year.ToString());
break;
case 5:
Fecha = (DateTime.Now.Day.ToString() + " Mayo del " + DateTime.Now.Year.ToString());
break;
case 6:
Fecha = (DateTime.Now.Day.ToString() + " Junio del " + DateTime.Now.Year.ToString());
break;
case 7:
Fecha = (DateTime.Now.Day.ToString() + " Julio del " + DateTime.Now.Year.ToString());
break;
case 8:
Fecha = (DateTime.Now.Day.ToString() + " Agosto del " + DateTime.Now.Year.ToString());
break;
case 9:
Fecha = (DateTime.Now.Day.ToString() + " Septiembre del " + DateTime.Now.Year.ToString());
break;
case 10:
Fecha = (DateTime.Now.Day.ToString() + " Octubre del " + DateTime.Now.Year.ToString());
break;
case 11:
Fecha = (DateTime.Now.Day.ToString() + " Noviembre del " + DateTime.Now.Year.ToString());
break;
case 12:
Fecha = (DateTime.Now.Day.ToString() + " Diciembre del " + DateTime.Now.Year.ToString());
break;
}
Head = (Titulo + Titulo2 + Fecha + "\n");
Document doc = new Document(PageSize.LETTER, 10, 10, 42, 35);
try
{
//Poner direccion bien y agregar fecha
Paragraph Parrafo = new Paragraph(Head);
Parrafo.Alignment = Element.ALIGN_CENTER;
Paragraph Espacio = new Paragraph(Espace);
//Creating iTextSharp Table from the DataTable data
PdfPTable pdfTable = new PdfPTable(dataGridView1.ColumnCount);
pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;
foreach (DataGridViewColumn column in dataGridView1.Columns)
{
PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText));
pdfTable.AddCell(cell);
}
int row = dataGridView1.Rows.Count;
int cell2 = dataGridView1.Rows[0].Cells.Count;
for (int x = 0; x < row; x++)
{
for (int j = 0; j < cell2; j++)
{
pdfTable.AddCell(dataGridView1.Rows[x].Cells[j].Value.ToString());
}
}
string Valor;
Valor = "Codigo Factura: " + txtCita.Text;
Paragraph Cod = new Paragraph(Valor);
Cod.Alignment = Element.ALIGN_JUSTIFIED;
Valor = "Valor de las medicinas: LPS. " + txtMedicamentos.Text;
Paragraph Med = new Paragraph(Valor);
Med.Alignment = Element.ALIGN_JUSTIFIED;
Valor = "Descuento: LPS. " + txtDesc.Text;
Paragraph Desc = new Paragraph(Valor);
Desc.Alignment = Element.ALIGN_JUSTIFIED;
Valor = "Sub-Total: LPS. " + txtSubTotal.Text;
Paragraph Sub = new Paragraph(Valor);
Sub.Alignment = Element.ALIGN_JUSTIFIED;
Valor = "Consulta: LPS. " + txtConsulta.Text;
Paragraph Consulta = new Paragraph(Valor);
Consulta.Alignment = Element.ALIGN_JUSTIFIED;
Valor = "Total: LPS. " + txtTotal.Text;
Paragraph Total = new Paragraph(Valor);
Total.Alignment = Element.ALIGN_JUSTIFIED;
//Exporting to PDF
string folderPath = @"C:\Facturas\";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
using (FileStream stream = new FileStream(folderPath + "Factura_" + txtCita.Text + ".pdf", FileMode.Create))
{
Document pdfDoc = new Document(PageSize.A4.Rotate(), 30f, 10f, 10f, 0f);
PdfWriter.GetInstance(pdfDoc, stream);
pdfDoc.Open();
pdfDoc.SetPageSize(iTextSharp.text.PageSize.A4.Rotate());
pdfDoc.Add(Parrafo);
pdfDoc.Add(Espacio);
pdfDoc.Add(pdfTable);
pdfDoc.Add(Espacio);
pdfDoc.Add(Med);
pdfDoc.Add(Desc);
pdfDoc.Add(Sub);
pdfDoc.Add(Consulta);
pdfDoc.Add(Total);
pdfDoc.Close();
stream.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
if (MessageBox.Show("Esta seguro desea ingresar la factura", "Confirmar", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Base_de_datos.Ingresar_factura(double.Parse(txtValorC.Text), double.Parse(txtIngresar.Text), int.Parse(txtCita.Text));
Base_de_datos most = new Base_de_datos();
DataTable a;
int i = 0;
int bb = Base_de_datos.numero;
most.BuscarReceta(txtCita.Text);
a = most.Mostrar_Resultados();
do
{
DataRow row = a.Rows[i];
Base_de_datos.validmedi(row["Codigo Medicamento"].ToString());
Base_de_datos.vencemedi(int.Parse(row["Codigo Medicamento"].ToString()), int.Parse(Base_de_datos.cant) - int.Parse(row["Cantidad"].ToString()));
i++;
}while (i < bb);
Process p = new Process();
p.StartInfo = new ProcessStartInfo()
{
CreateNoWindow = true,
Verb = "print",
FileName = @"C:\Facturas\Factura_" + txtCita.Text + ".pdf"
};
p.Start();
txtValorC.Enabled = false;
btnPagar.Enabled = false;
chkIngresar.Enabled = false;
txtIngresar.Enabled = false;
chkIngresar.Checked = false;
btnCancelar.Enabled = false;
dataGridView1.DataSource = null;
txtTotal.Text = "0";
txtIngresar.Text = "0";
txtCita.Text = "";
txtCita.Focus();
txtValorC.Text = "";
txtConsulta.Text = "0";
txtDesc.Text = "0";
txtMedicamentos.Text = "0";
txtSubTotal.Text = "0";
Base_de_datos.cita = "";
}
}
else
{
if (MessageBox.Show("Esta seguro desea ingresar la factura", "Confirmar", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
String Titulo = "Dispensario Médico Hermana Nazaria";
String Titulo2 = "\nAguas del Padre, Siguatepeque, Comayagua\n";
String Head;
BaseFont bf = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
iTextSharp.text.Font font = new iTextSharp.text.Font(bf, 10, iTextSharp.text.Font.NORMAL);
String Fecha = "";
int Mes = DateTime.Now.Month;
switch (Mes)
{
case 1:
Fecha = (DateTime.Now.Day.ToString() + " Enero del " + DateTime.Now.Year.ToString());
break;
case 2:
Fecha = (DateTime.Now.Day.ToString() + " Febrero del " + DateTime.Now.Year.ToString());
break;
case 3:
Fecha = (DateTime.Now.Day.ToString() + " Marzo del " + DateTime.Now.Year.ToString());
break;
case 4:
Fecha = (DateTime.Now.Day.ToString() + " Abril del " + DateTime.Now.Year.ToString());
break;
case 5:
Fecha = (DateTime.Now.Day.ToString() + " Mayo del " + DateTime.Now.Year.ToString());
break;
case 6:
Fecha = (DateTime.Now.Day.ToString() + " Junio del " + DateTime.Now.Year.ToString());
break;
case 7:
Fecha = (DateTime.Now.Day.ToString() + " Julio del " + DateTime.Now.Year.ToString());
break;
case 8:
Fecha = (DateTime.Now.Day.ToString() + " Agosto del " + DateTime.Now.Year.ToString());
break;
case 9:
Fecha = (DateTime.Now.Day.ToString() + " Septiembre del " + DateTime.Now.Year.ToString());
break;
case 10:
Fecha = (DateTime.Now.Day.ToString() + " Octubre del " + DateTime.Now.Year.ToString());
break;
case 11:
Fecha = (DateTime.Now.Day.ToString() + " Noviembre del " + DateTime.Now.Year.ToString());
break;
case 12:
Fecha = (DateTime.Now.Day.ToString() + " Diciembre del " + DateTime.Now.Year.ToString());
break;
}
Head = (Titulo + Titulo2 + Fecha + "\n");
Document doc = new Document(PageSize.LETTER, 10, 10, 42, 35);
try
{
//Poner direccion bien y agregar fecha
Paragraph Parrafo = new Paragraph(Head);
Parrafo.Alignment = Element.ALIGN_CENTER;
Paragraph Espacio = new Paragraph(Espace);
//Creating iTextSharp Table from the DataTable data
PdfPTable pdfTable = new PdfPTable(dataGridView1.ColumnCount);
pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;
foreach (DataGridViewColumn column in dataGridView1.Columns)
{
PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText));
pdfTable.AddCell(cell);
}
int row = dataGridView1.Rows.Count;
int cell2 = dataGridView1.Rows[0].Cells.Count;
for (int x = 0; x < row; x++)
{
for (int j = 0; j < cell2; j++)
{
pdfTable.AddCell(dataGridView1.Rows[x].Cells[j].Value.ToString());
}
}
string Valor;
Valor = "Codigo Factura: " + txtCita.Text;
Paragraph Cod = new Paragraph(Valor);
Cod.Alignment = Element.ALIGN_JUSTIFIED;
Valor = "Valor de las medicinas: LPS. " + txtMedicamentos.Text;
Paragraph Med = new Paragraph(Valor);
Med.Alignment = Element.ALIGN_JUSTIFIED;
Valor = "Descuento: LPS. " + txtDesc.Text;
Paragraph Desc = new Paragraph(Valor);
Desc.Alignment = Element.ALIGN_JUSTIFIED;
Valor = "Sub-Total: LPS. " + txtSubTotal.Text;
Paragraph Sub = new Paragraph(Valor);
Sub.Alignment = Element.ALIGN_JUSTIFIED;
Valor = "Consulta: LPS. " + txtConsulta.Text;
Paragraph Consulta = new Paragraph(Valor);
Consulta.Alignment = Element.ALIGN_JUSTIFIED;
Valor = "Total: LPS. " + txtTotal.Text;
Paragraph Total = new Paragraph(Valor);
Total.Alignment = Element.ALIGN_JUSTIFIED;
//Exporting to PDF
string folderPath = @"C:\Facturas\";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
using (FileStream stream = new FileStream(folderPath + "Factura_" + txtCita.Text + ".pdf", FileMode.Create))
{
Document pdfDoc = new Document(PageSize.A4.Rotate(), 30f, 10f, 10f, 0f);
PdfWriter.GetInstance(pdfDoc, stream);
pdfDoc.Open();
pdfDoc.SetPageSize(iTextSharp.text.PageSize.A4.Rotate());
pdfDoc.Add(Parrafo);
pdfDoc.Add(Espacio);
pdfDoc.Add(pdfTable);
pdfDoc.Add(Espacio);
pdfDoc.Add(Med);
pdfDoc.Add(Desc);
pdfDoc.Add(Sub);
pdfDoc.Add(Consulta);
pdfDoc.Add(Total);
pdfDoc.Close();
stream.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
Base_de_datos.Ingresar_factura(double.Parse(txtValorC.Text), double.Parse(txtTotal.Text), int.Parse(txtCita.Text));
Base_de_datos most = new Base_de_datos();
DataTable a;
int i = 0;
int bb = Base_de_datos.numero;
most.BuscarReceta(txtCita.Text);
a = most.Mostrar_Resultados();
do
{
DataRow row = a.Rows[i];
Base_de_datos.validmedi(row["Codigo Medicamento"].ToString());
Base_de_datos.vencemedi(int.Parse(row["Codigo Medicamento"].ToString()), int.Parse(Base_de_datos.cant) - int.Parse(row["Cantidad"].ToString()));
i++;
}while (i < bb);
txtValorC.Enabled = false;
btnPagar.Enabled = false;
chkIngresar.Enabled = false;
txtIngresar.Enabled = false;
chkIngresar.Checked = false;
btnCancelar.Enabled = false;
dataGridView1.DataSource = null;
txtTotal.Text = "0";
txtIngresar.Text = "0";
txtCita.Text = "";
txtCita.Focus();
txtValorC.Text = "";
txtConsulta.Text = "0";
txtDesc.Text = "0";
txtMedicamentos.Text = "0";
txtSubTotal.Text = "0";
Base_de_datos.cita = "";
MessageBox.Show("Factura registrada con exito!");
this.Hide();
}
}
}