private void processinvoice_Click(object sender, EventArgs e)
{
if (idonsys.Text == "")
{
string query = "insert Into [transaction] (ref, madebytran, reasontran, datetran, origin, entry, expenses) values ('" + nobill.Text + "', '" + nameprovider.Text + "', '" + reasonbill.Text + "', '" + datebill.Text + "', '" + paymeth.Text + "', '0.00', '" + qty.Text + "')";
c.command(query);
this.Close();
}
else if (idonsys.Text != "")
{
string query = "update [transaction] set ref = '" + nobill.Text + "', madebytran = '" + nameprovider.Text + "', reasontran = '" + reasonbill.Text + "', datetran = '" + datebill.Text + "', origin = '" + paymeth.Text + "', expenses = '" + qty.Text + "'";
c.command(query);
this.Close();
}
}
private void delateprocedure_btn_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Seguro que desea eliminar este Procedimiento?", "Eliminar procedimiento", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
DBManager c = new DBManager();
try
{
string comando = "DELETE FROM [procedure] WHERE idprocedure = '" + idprocedure_txt.Text + "'";
c.command(comando);
if (c.valor == "si")
{
Close();
}
else
{
MessageBox.Show("Algo fue mal");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
finally
{
}
}
else if (result == DialogResult.No)
{
}
}
private void button1_Click_1(object sender, EventArgs e)
{
DBManager c = new DBManager();
try
{
DialogResult result = MessageBox.Show("Seguro que desea pasar a ser un procedimientoRegular?", "Pasar a Procedimiento Regular", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
string query = "UPDATE [procedure] set ptype = 'Regular'";
c.command(query);
if (c.valor == "si")
{
Close();
}
else
{
MessageBox.Show("Algo fallo!!!");
}
}
else if (result == DialogResult.No)
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
finally
{
}
}
private void updateinsurance_btn_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Seguro que desea Actualizar?", "Actualizar datos", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
string query = "UPDATE insurances set nameinsurance = '" + pnameinsurance_txt.Text + "', telinsurance = '" + ptelinsurance_txt.Text + "', emailinsurance = '" + pmailinsurance_txt.Text + "', contractinsurance = '" + pcontractinsurance_txt.Text + "', pssinsurance = '" + ppssinsurance_txt.Text + "' WHERE idinsurance = '" + pidinsurance_txt.Text + "'";
DBManager c = new DBManager();
c.command(query);
Close();
//SQLiteConnection cnx = new SQLiteConnection("Data Source=C:\\syspandemic\\db\\syspandemic.db;Version=3;");
//cnx.Open();
//DialogResult result = MessageBox.Show("Seguro que desea Actualizar?", "Actualizar datos", MessageBoxButtons.YesNo);
//if (result == DialogResult.Yes)
//{
// string comando = "UPDATE insurances set nameinsurance = '" + pnameinsurance_txt.Text + "', telinsurance = '" + ptelinsurance_txt.Text + "', emailinsurance = '" + pmailinsurance_txt.Text + "', contractinsurance = '" + pcontractinsurance_txt.Text + "', pssinsurance = '" + ppssinsurance_txt.Text + "' WHERE idinsurance = '" + pidinsurance_txt.Text + "'";
// SQLiteCommand insertion = new SQLiteCommand(comando, cnx);
// if (insertion.ExecuteNonQuery() > 0)
// {
// MessageBox.Show("Se ha actualizado!");
// Close();
// }
// else
// {
// MessageBox.Show("Algo fallo!!!");
// }
}
}
private void vn_addnotes_txt_Click(object sender, EventArgs e)
{
if (vn_idnote_txt.Text == "")
{
string query = "insert into procedurenotes (idprocedure, note) values ('" + vn_idpro_txt.Text + "', '" + vn_note_txt.Text + "')";
c.command(query);
load();
vn_note_txt.Clear();
}
else
{
string query = "update procedurenotes set note = '" + vn_note_txt.Text + "' where idnote = '" + vn_idnote_txt.Text + "'";
c.command(query);
load();
vn_idnote_txt.Clear();
vn_note_txt.Clear();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (reasondesc_txt.Text.Length < 1)
{
MessageBox.Show("Debe de digitar la razon antes de guardar", "Error");
reasondesc_txt.Focus();
}
else
{
if (allpay_rbtn.Checked)
{
if (doctorpay_txt.Text.Length > 1 && pdoctorpay_txt.Text.Length < 1)
{
decimal doctordesc = Convert.ToDecimal(doctorpay_txt.Text) * -1;
string querry = "Insert into [payrolldoctors]([iddoctor], reason, qty, date) values ('" + iddoctors.Text + "', '" + reasondesc_txt.Text + "','" + doctordesc + "','" + datedesc_dtp.Text + "')";
c.command(querry);
}
else
{
MessageBox.Show("Algo no va como debe, verifique que solo el campo de texto MONTO A PAGAR DOCTOR tenga numeros", "Error");
}
}
else if (porcent_rbtn.Checked)
{
if (doctorpay_txt.Text.Length > 1 && pdoctorpay_txt.Text.Length > 1)
{
decimal doctordesc = Convert.ToDecimal(doctorpay_txt.Text) * -1;
decimal pdoctordesc = Convert.ToDecimal(pdoctorpay_txt.Text) * -1;
string querry = "Insert into [payrolldoctors]([iddoctor], reason, qty, date) values ('" + iddoctors.Text + "', '" + reasondesc_txt.Text + "','" + doctordesc + "','" + datedesc_dtp.Text + "')";
c.command3(querry);
querry = "Insert into [payrolldoctors]([iddoctor], reason, qty, date) values ('1', '" + reasondesc_txt.Text + "','" + pdoctordesc + "','" + datedesc_dtp.Text + "')";
c.command(querry);
}
else
{
MessageBox.Show("Algo no va como debe, verifique que los campo de texto MONTO A PAGAR DOCTOR y MONTO A PAGAR PRIN DOCTOR tenga numeros", "Error");
}
}
}
}
private void btnguardar_Click(object sender, EventArgs e)
{
string query0 = "Select * from datem where date = '" + dtpfecha.Text + "' and time = '" + dtphora.Text + "' and iddoctor = '" + txtiddo.Text + "'";
c.validation(query0);
if (c.valor == "si")
{
MessageBox.Show("NO se puede agregar, debido a que ya hay una cita a esa hora");
c.valor = "";
}
else if (c.valor == "no")
{
string query = "INSERT INTO datem(idpatient,namepa,iddoctor,namedoctor,assist,date,time) values('" + txtidpa.Text + "','" + txtpaciente.Text + "','" + txtiddo.Text + "','" + txtdoct.Text + "','Pendiente','" + dtpfecha.Text + "','" + dtphora.Text + "')";
c.command(query);
txtidpa.Clear();
txtpaciente.Clear();
txtdoct.Clear();
txtiddo.Clear();
c.valor = "";
}
}
private void updateprocedure_btn_Click(object sender, EventArgs e)
{
DBManager c = new DBManager();
if (string.IsNullOrEmpty(gaindoctor_txt.Text) == false)
{
if (string.IsNullOrEmpty(piddoctor_txt.Text) == false)
{
if (string.IsNullOrEmpty(tooth_txt.Text) == false)
{
if (string.IsNullOrEmpty(procedure_txt.Text) == false)
{
DialogResult result = MessageBox.Show("Seguro que desea Actualizar?", "Actualizar datos del Procedimiento", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
string comando = "UPDATE [procedure] set iddoctor = '" + piddoctor_txt.Text + "', namedoctor = '" + pnamedoctor_txt.Text + "', [procedure] = '" + procedure_txt.Text + "', realprice = '" + realpay_txt.Text + "', iscoverage = '" + iscoverage_txt.Text + "', pricepay = '" + pricepay_txt.Text + "', tooth = '" + tooth_txt.Text + "' , dateprocedure = '" + dateprocedure_dtp.Text + "', gaindoctor = '" + gaindoctor_txt.Text + "' WHERE idprocedure = '" + idprocedure_txt.Text + "'";
c.command(comando);
if (c.valor == "si")
{
Close();
c.valor = "";
}
else
{
MessageBox.Show("Algo fallo!!!");
}
}
else if (result == DialogResult.No)
{
}
}
else
{
MessageBox.Show("No ha escrito el titulo del procedimiento, favor revise.", "Falta informacion.");
}
}
else
{
MessageBox.Show("No ha asignado el diente de trabajo, favor revise.", "Falta informacion.");
}
}
else
{
MessageBox.Show("No ha ingresado un Doctor, favor revise.", "Falta informacion.");
}
}
else
{
MessageBox.Show("Debe de digitar la ganancia del doctor antes de guardar", "Error");
}
}
private void savepwi_btn_Click(object sender, EventArgs e)
{
if (process_txt.Text.Length < 1)
{
MessageBox.Show("Debe de introducir la informacion requerida.", "Error");
}
else
{
string idinsurance = "0";
string insurance = "NO SEGURO";
string query = "INSERT INTO detailsinsurance(pinsurance, tariff, coverage, difference, idinsurance) VALUES('" + process_txt.Text + "', '" + priceprocess_txt.Text + "', '00', '" + priceprocess_txt.Text + "', '1004');";
DBManager c = new DBManager();
c.command(query);
process_txt.Clear();
priceprocess_txt.Clear();
process_txt.Focus();
}
//if (process_txt.Text.Length < 1)
//{
// MessageBox.Show("Debe de introducir la informacion requerida.", "Error");
//}
//else
//{
// SQLiteConnection cnx = new SQLiteConnection("Data Source=C:\\syspandemic\\db\\syspandemic.db;Version=3;");
// try
// {
// cnx.Open();
// string idinsurance = "0";
// string insurance = "NO SEGURO";
// string comando = "INSERT INTO detailsinsurance(pinsurance, tariff, coverage, difference, idinsurance, insurance) VALUES('" + process_txt.Text + "', '" + priceprocess_txt.Text + "', '00', '"+ priceprocess_txt.Text +"', '" + idinsurance + "', '" + insurance + "');";
// SQLiteCommand insertion = new SQLiteCommand(comando, cnx);
// if (insertion.ExecuteNonQuery() > 0)
// {
// MessageBox.Show("Se agrego correctamente");
// process_txt.Clear();
// priceprocess_txt.Clear();
// process_txt.Focus();
// cnx.Close();
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message, "Error");
// }
//}
}
private void deletepwi_btn_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Seguro que desea eliminar este proceso?", "Eliminar proceso", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
string query = "DELETE FROM detailsinsurance WHERE id = '" + idprocess_txt.Text + "'";
DBManager c = new DBManager();
c.command(query);
Close();
}
else if (result == DialogResult.No)
{
}
//DialogResult result = MessageBox.Show("Seguro que desea eliminar este proceso?", "Eliminar proceso", MessageBoxButtons.YesNo);
//if (result == DialogResult.Yes)
//{
// SQLiteConnection cnx = new SQLiteConnection("Data Source=C:\\syspandemic\\db\\syspandemic.db;Version=3;");
// try
// {
// cnx.Open();
// string comando = "DELETE FROM detailsinsurance WHERE id = '" + idprocess_txt.Text + "'";
// SQLiteCommand insertion = new SQLiteCommand(comando, cnx);
// if (insertion.ExecuteNonQuery() > 0)
// {
// MessageBox.Show("Se ha eliminado!");
// Close();
// }
// else
// {
// MessageBox.Show("Algo fue mal");
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message, "Error");
// }
//}
//else if (result == DialogResult.No)
//{
//}
}
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
DBManager c = new DBManager();
DataGridViewRow act = dataGridView1.Rows[e.RowIndex];
string id = act.Cells["ID"].Value.ToString();
string procedure = act.Cells["SubProceso"].Value.ToString();
string diente = act.Cells["Diente"].Value.ToString();
DialogResult result = MessageBox.Show("Desea convertir el procedimiento '" + procedure + "' en el diente '" + diente + "' como realizado?", "Sub Proceso realizado", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
string query = "update subprocedure set status = 'Realizado' where id = '" + id + "' ";
c.command(query);
cargarDGV();
}
}
private void ep_delete_btn_Click(object sender, EventArgs e)
{
try
{
DialogResult result = MessageBox.Show("Seguro que desea Borrar?", "Borrar Sub-Procedimiento", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
string query = "DELETE FROM subprocedure WHERE id = '" + ep_id_txt.Text + "'";
c.command(query);
this.Close();
}
else if (result == DialogResult.No)
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
}
private void addsubpro_btn_Click(object sender, EventArgs e)
{
DBManager c = new DBManager();
c.valor = "";
string status = "Sin Realizar";
string query = "select idprocedure, subprocedure, tooth from subprocedure where idprocedure = '" + vsp_idprocedure_txt.Text + "' and subprocedure = '" + vsp_activity_txt.Text + "' and tooth = '" + vsp_tooth_txt.Text + "'";
c.validation(query);
if (c.valor == "si")
{
MessageBox.Show("No puede agregar el mismo sub-procedimiento al mismo diente dos veces.", "Error al agregar");
c.valor = "";
}
else
{
string query2 = "INSERT INTO subprocedure(idprocedure, codeinsurance, subprocedure, tariff, coverage, difference, status, insurance, tooth) VALUES('" + vsp_idprocedure_txt.Text + "', '" + vsp_codeinsu_txt.Text + "','" + vsp_activity_txt.Text + "','" + vsp_tariff_txt.Text + "', '" + vsp_coverage_txt.Text + "', '" + vsp_difference_txt.Text + "', '" + status + "', '" + vsp_insurance_txt.Text + "', '" + vsp_tooth_txt.Text + "')";
c.command(query2);
}
}
private void deleteinsurance_txt_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Seguro que desea Borrar?", "Borrar datos", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
string query = "DELETE FROM insurances WHERE idinsurance = '" + pidinsurance_txt.Text + "'";
DBManager c = new DBManager();
c.command(query);
Close();
}
//DialogResult result = MessageBox.Show("Seguro que desea Borrar?", "Borrar datos", MessageBoxButtons.YesNo);
//if (result == DialogResult.Yes)
//{
// try
// {
// SQLiteConnection cnx = new SQLiteConnection("Data Source=C:\\syspandemic\\db\\syspandemic.db;Version=3;");
// cnx.Open();
// string comando = "DELETE FROM insurances WHERE idinsurance = '" + pidinsurance_txt.Text + "'";
// SQLiteCommand insertion = new SQLiteCommand(comando, cnx);
// if (insertion.ExecuteNonQuery() > 0)
// {
// MessageBox.Show("Se ha actualizado!");
// Close();
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message, "Error");
// }
//}
//else
//{
//}
}
private void updatepwi_btn_Click(object sender, EventArgs e)
{
string query = "UPDATE detailsinsurance set pinsurance = '" + process_txt.Text + "', tariff = '" + priceprocess_txt.Text + "' where id= '" + idprocess_txt.Text + "'";
DBManager c = new DBManager();
c.command(query);
seepwi frm = new seepwi();
frm.loaddgv();
Close();
//try
//{
// SQLiteConnection cnx = new SQLiteConnection("Data Source=C:\\syspandemic\\db\\syspandemic.db;Version=3;");
// cnx.Open();
// string comando = "UPDATE detailsinsurance set pinsurance = '" + process_txt.Text + "', tariff = '" + priceprocess_txt.Text + "' where id= '" +idprocess_txt.Text+"'";
// SQLiteCommand insertion = new SQLiteCommand(comando, cnx);
// if (insertion.ExecuteNonQuery() > 0)
// {
// cnx.Close();
// seepwi frm = new seepwi();
// frm.loaddgv();
// MessageBox.Show("Se ha actualizado!");
// Close();
// }
// else
// {
// MessageBox.Show("No se consiguio");
// }
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message, "Error");
//}
}
private void saveprocedure_btn_Click(object sender, EventArgs e)
{
DBManager c = new DBManager();
if (string.IsNullOrEmpty(gaindoctor_txt.Text) == false)
{
if (string.IsNullOrEmpty(pidpatient_txt.Text) == false)
{
if (string.IsNullOrEmpty(piddoctor_txt.Text) == false)
{
if (string.IsNullOrEmpty(tooth_txt.Text) == false)
{
if (string.IsNullOrEmpty(procedure_txt.Text) == false)
{
if (string.IsNullOrEmpty(pricepay_txt.Text) == false)
{
try
{
DialogResult result = MessageBox.Show("Seguro que desea Guardar?", "Guardar datos del Procedimiento", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
string query = "UPDATE [procedure] set idpatient = '" + pidpatient_txt.Text + "', namepatient = '" + pnamepatient_txt.Text + "', iddoctor = '" + piddoctor_txt.Text + "', namedoctor = '" + pnamedoctor_txt.Text + "', [procedure] = '" + procedure_txt.Text + "', realprice = '" + realpay_txt.Text + "', iscoverage = '" + iscoverage_txt.Text + "', pricepay = '" + pricepay_txt.Text + "', dateprocedure = '" + dateprocedure_dtp.Text + "', tooth = '" + tooth_txt.Text + "', gaindoctor = '" + gaindoctor_txt.Text + "' WHERE idprocedure = '" + idprocedure_txt.Text + "'";
c.command(query);
if (c.valor == "si")
{
Close();
}
else
{
MessageBox.Show("Algo fallo!!!");
}
}
else if (result == DialogResult.No)
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
finally
{
}
}
else
{
MessageBox.Show("Al parecer no ha asignado Sub-Procesos a este procedimiento, favor revise.", "Falta informacion.");
}
}
else
{
MessageBox.Show("No ha escrito el titulo del procedimiento, favor revise.", "Falta informacion.");
}
}
else
{
MessageBox.Show("No ha asignado el diente de trabajo, favor revise.", "Falta informacion.");
}
}
else
{
MessageBox.Show("No ha ingresado un Doctor, favor revise.", "Falta informacion.");
}
}
else
{
MessageBox.Show("No ha ingresado un Paciente, favor revise.", "Falta informacion.");
}
}
else
{
MessageBox.Show("Debe de digitar la ganancia del doctor");
}
}
private void adddetail_Click(object sender, EventArgs e)
{
string query;
if (procedure_txt.Text.Length == 0)
{
MessageBox.Show("Debe de introducir la informacion requerida.", "Error");
}
else
{
if (id_txt.Text == "")
{
query = "INSERT INTO detailsinsurance(Code, pinsurance, tariff, coverage, difference, idinsurance, insurance) VALUES('" + code_txt.Text + "', '" + procedure_txt.Text + "','" + tariff_txt.Text + "', '" + coverage_txt.Text + "', '" + difference_txt.Text + "', '" + pidinsurance_txt.Text + "', '" + pnameinsurance_txt.Text + "')";
DBManager c = new DBManager();
c.command(query);
code_txt.Clear();
procedure_txt.Clear();
tariff_txt.Clear();
coverage_txt.Clear();
difference_txt.Clear();
loadDGV();
}
else
{
DialogResult result = MessageBox.Show("Seguro que desea Actualizar?", "Actualizar datos", MessageBoxButtons.YesNo);
if (result == DialogResult.Yes)
{
query = "UPDATE detailsinsurance set code = '" + code_txt.Text + "', pinsurance = '" + procedure_txt.Text + "', tariff = '" + tariff_txt.Text + "', coverage = '" + coverage_txt.Text + "', difference = '" + difference_txt.Text + "' WHERE id = '" + id_txt.Text + "'";
DBManager c = new DBManager();
c.command(query);
id_txt.Clear();
code_txt.Clear();
procedure_txt.Clear();
tariff_txt.Clear();
coverage_txt.Clear();
difference_txt.Clear();
loadDGV();
}
else
{
MessageBox.Show("Algo fallo!!!");
}
}
}
//if (procedure_txt.Text.Length == 0)
//{
// MessageBox.Show("Debe de introducir la informacion requerida.", "Error");
//}
//else {
// SQLiteConnection cnx = new SQLiteConnection("Data Source=C:\\syspandemic\\db\\syspandemic.db;Version=3;");
//try
//{
// if (id_txt.Text == "")
// {
// cnx.Open();
// string comando = "INSERT INTO detailsinsurance(Code, pinsurance, tariff, coverage, difference, idinsurance, insurance) VALUES('" + code_txt.Text + "', '" + procedure_txt.Text + "','" + tariff_txt.Text + "', '" + coverage_txt.Text + "', '" + difference_txt.Text + "', '" + pidinsurance_txt.Text + "', '" + pnameinsurance_txt.Text + "');";
// SQLiteCommand insertion = new SQLiteCommand(comando, cnx);
// if (insertion.ExecuteNonQuery() > 0)
// {
// MessageBox.Show("Se agrego correctamente");
// code_txt.Clear();
// procedure_txt.Clear();
// tariff_txt.Clear();
// coverage_txt.Clear();
// difference_txt.Clear();
// loadDGV();
// }
// }
// else
// {
// cnx.Open();
// DialogResult result = MessageBox.Show("Seguro que desea Actualizar?", "Actualizar datos", MessageBoxButtons.YesNo);
// if (result == DialogResult.Yes)
// {
// string comando = "UPDATE detailsinsurance set code = '" + code_txt.Text + "', pinsurance = '" + procedure_txt.Text + "', tariff = '" + tariff_txt.Text + "', coverage = '" + coverage_txt.Text + "', difference = '" + difference_txt.Text + "' WHERE id = '" + id_txt.Text + "'";
// SQLiteCommand insertion = new SQLiteCommand(comando, cnx);
// if (insertion.ExecuteNonQuery() > 0)
// {
// MessageBox.Show("Se ha actualizado!");
// id_txt.Clear();
// code_txt.Clear();
// procedure_txt.Clear();
// tariff_txt.Clear();
// coverage_txt.Clear();
// difference_txt.Clear();
// loadDGV();
// }
// else
// {
// MessageBox.Show("Algo fallo!!!");
// }
// }
// }
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message, "Error");
//}
//}
}
private void deletedetail_btn_Click(object sender, EventArgs e)
{
try
{
if (id_txt.Text == "")
{
MessageBox.Show("No puede borrar este registro; no ha seleccionado uno de los del visor para esto.", "Error");
}
else
{
string query = "DELETE FROM detailsinsurance WHERE id = '" + id_txt.Text + "'";
DBManager c = new DBManager();
c.command(query);
id_txt.Clear();
code_txt.Clear();
procedure_txt.Clear();
tariff_txt.Clear();
coverage_txt.Clear();
difference_txt.Clear();
loadDGV();
}
//try
//{
// if (id_txt.Text == "")
// {
// MessageBox.Show("No puede borrar este registro; no ha seleccionado uno de los del visor para esto.", "Error");
// }
// else{
// try
// {
// SQLiteConnection cnx = new SQLiteConnection("Data Source=C:\\syspandemic\\db\\syspandemic.db;Version=3;");
// cnx.Open();
// string comando = "DELETE FROM detailsinsurance WHERE id = '" + id_txt.Text + "'";
// SQLiteCommand insertion = new SQLiteCommand(comando, cnx);
// if (insertion.ExecuteNonQuery() > 0)
// {
// MessageBox.Show("Se ha Borrado!");
// id_txt.Clear();
// code_txt.Clear();
// procedure_txt.Clear();
// tariff_txt.Clear();
// coverage_txt.Clear();
// difference_txt.Clear();
// loadDGV();
// }
// else
// {
// MessageBox.Show("Algo fallo!!!");
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message, "Errror");
// }
// }
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
}
private void addpay_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(typepay.Text))
{
MessageBox.Show("Debe de elegir un metodo de pago.", "Error");
}
else
{
if (string.IsNullOrEmpty(qtypay.Text))
{
MessageBox.Show("Debe de elegir una cantidad de pago.", "Error");
}
else
{
DBManager c = new DBManager();
string query = "INSERT INTO [transaction](ref, madebytran, reasontran, datetran, origin, entry, expenses) values('" + idsubprocedure_txt.Text + "', '" + spnamepatient_txt.Text + "', '" + sprocedure_txt.Text + "', '" + datepay.Text + "', '" + typepay.Text + "', '" + qtypay.Text + "', '0')";
decimal ppay = Convert.ToDecimal(sppricepay_txt.Text);
decimal qty = Convert.ToDecimal(qtypay.Text);
if (string.IsNullOrEmpty(nowpay_txt.Text))
{
if (ppay >= qty)
{
c.command(query);
//insertar en la tabla de pago a los doctores;
if (Convert.ToInt32(iddoctor_txt.Text) == 1)
{
string querry2 = "Insert into [payrolldoctors](iddoctor, idpatient, namepatient, idprocedure, reason, qty, date) values ('" + iddoctor_txt.Text + "', '" + sidpatient.Text + "', '" + spnamepatient_txt.Text + "', '" + idsubprocedure_txt.Text + "', '" + sprocedure_txt.Text + "', '" + qtypay.Text + "', '" + datepay.Text + "')";
c.command3(querry2);
}
else
{
decimal gaindoctor = Convert.ToDecimal(gaindoctor_txt.Text) / 100;
decimal gainfulldoctor = 1 - gaindoctor;
decimal paygaindoctor = Convert.ToDecimal(qtypay.Text) * gaindoctor;
decimal payfulldoctor = Convert.ToDecimal(qtypay.Text) * gainfulldoctor;
string querry2 = "Insert into [payrolldoctors](iddoctor, idpatient, namepatient, idprocedure, reason, qty, date) values ('" + iddoctor_txt.Text + "', '" + sidpatient.Text + "', '" + spnamepatient_txt.Text + "', '" + idsubprocedure_txt.Text + "', '" + sprocedure_txt.Text + "', '" + paygaindoctor + "', '" + datepay.Text + "')";
c.command3(querry2);
string querry3 = "Insert into [payrolldoctors](iddoctor, idpatient, namepatient, idprocedure, reason, qty, date) values ('1', '" + sidpatient.Text + "', '" + spnamepatient_txt.Text + "', '" + idsubprocedure_txt.Text + "', '" + sprocedure_txt.Text + "', '" + payfulldoctor + "', '" + datepay.Text + "')";
c.command3(querry3);
}
//Insertar en la tabla del historico del paciente
string hquery = "insert into patienthistory(idpatient, tooth, activity, qtypay, date) values('" + sidpatient.Text + "', '" + stooth_txt.Text + "', '" + sactivity_txt.Text + "', '" + qtypay.Text + "', '" + datepay.Text + "')";
c.command3(hquery);
loadbill();
string query2 = "Select top 1 * from [transaction] order by idtransactions desc";
string tablename = "entrybill";
string xml = "entrybill.xml";
string report = "entrybill.rpt";
c.printreport(query2, tablename, xml, report);
sactivity_txt.Clear();
qtypay.Clear();
typepay.Text = "";
}
else
{
MessageBox.Show("El monto ha abonar mas lo ya abonado sobrepasa el precio del procedimiento, favor verifique y reintente");
}
}
else
{
decimal nowpay = Convert.ToDecimal(nowpay_txt.Text);
if (ppay > nowpay)
{
if (ppay >= (nowpay + qty))
{
c.command(query);
//insertar en la tabla de pago a los doctores;
if (Convert.ToInt32(iddoctor_txt.Text) == 1)
{
string querry2 = "Insert into [payrolldoctors](iddoctor, idpatient, namepatient, idprocedure, reason, qty, date) values ('" + iddoctor_txt.Text + "', '" + sidpatient.Text + "', '" + spnamepatient_txt.Text + "', '" + idsubprocedure_txt.Text + "', '" + sprocedure_txt.Text + "', '" + qtypay.Text + "', '" + datepay.Text + "')";
c.command3(querry2);
}
else
{
decimal gaindoctor = Convert.ToDecimal(gaindoctor_txt.Text) / 100;
decimal gainfulldoctor = 1 - gaindoctor;
decimal paygaindoctor = Convert.ToDecimal(qtypay.Text) * gaindoctor;
decimal payfulldoctor = Convert.ToDecimal(qtypay.Text) * gainfulldoctor;
string querry2 = "Insert into [payrolldoctors](iddoctor, idpatient, namepatient, idprocedure, reason, qty, date) values ('" + iddoctor_txt.Text + "', '" + sidpatient.Text + "', '" + spnamepatient_txt.Text + "', '" + idsubprocedure_txt.Text + "', '" + sprocedure_txt.Text + "', '" + paygaindoctor + "', '" + datepay.Text + "')";
c.command3(querry2);
string querry3 = "Insert into [payrolldoctors](iddoctor, idpatient, namepatient, idprocedure, reason, qty, date) values ('1', '" + sidpatient.Text + "', '" + spnamepatient_txt.Text + "', '" + idsubprocedure_txt.Text + "', '" + sprocedure_txt.Text + "', '" + payfulldoctor + "', '" + datepay.Text + "')";
c.command3(querry3);
}
loadbill();
//Insertar en la tabla del historico del paciente
string hquery = "insert into patienthistory(idpatient, tooth, activity, qtypay, date) values('" + sidpatient.Text + "', '" + stooth_txt.Text + "', '" + sactivity_txt.Text + "', '" + qtypay.Text + "', '" + datepay.Text + "')";
c.command3(hquery);
string query3 = "Select top 1 * from [transaction] order by idtransactions desc";
string tablename = "entrybill";
string xml = "entrybill.xml";
string report = "entrybill.rpt";
c.printreport(query3, tablename, xml, report);
sactivity_txt.Clear();
qtypay.Clear();
typepay.Text = "";
}
else
{
MessageBox.Show("El monto ha abonar mas lo ya abonado sobrepasa el precio del procedimiento, favor verifique y reintente");
}
}
else
{
MessageBox.Show("NO puede abonar, debido a que el procedimiento ya esta pagado.");
}
}
}
}
}
