private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex == -1)
{
MessageBox.Show("حدد اسم المريض");
return;
}
try
{
conn.OpenConection();
query = @"INSERT INTO Visit_Payment(visit_ID, type, value, date, User_code) VALUES(@visit_ID, @type, @value,@date, @User_code)";
string[] Parameters = new string[] { "@visit_ID", "@type", "@value", "@date", "@User_code" };
string[] Values = new string[] { label7.Text, "1", label3.Text, DateTime.Now.ToString(), User_ID.ToString() };
conn.ExecuteStoredProcQueries(query, Parameters, Values);
query = "UPDATE Visit_Bill SET value_payment = (Visit_Bill.patient_service_amount + Visit_Bill.patient_residence_amount + Visit_Bill.patient_medicine_amount - Visit_Bill.discount_amount) WHERE visit_ID=@visit_ID";
Parameters = new string[] { "@visit_ID" };
Values = new string[] { label7.Text };
conn.ExecuteStoredProcQueries(query, Parameters, Values);
conn.CloseConnection();
comboBox1.SelectedIndex = -1;
comboBox1.Text = "";
fill_Visit();
MessageBox.Show("تم رد المبلغ بنجاح");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (VISIT_ID == "" || VISIT_ID == null)
{
MessageBox.Show("حدد الفاتورة من زر بحث");
return;
}
int value = 0;
if (textBox2.Text == "")
{
MessageBox.Show("ادخل المبلغ");
return;
}
value = Convert.ToInt32(textBox2.Text);
if (value <= 0)
{
MessageBox.Show("ادخل المبلغ بطريقة صحيحة");
return;
}
if (textBox1.Text == "")
{
MessageBox.Show("ادخل سبب الخصم");
return;
}
try
{
conn.OpenConection();
query = "SELECT * FROM Visit_Discount WHERE visit_id=" + VISIT_ID + "";
dr = conn.DataReader(query);
if (dr.Read())
{
conn.CloseConnection();
clear();
MessageBox.Show("لقد قمت بعمل خصم على نفس الفاتورة من قبل");
return;
}
dr.Close();
query = @"INSERT INTO Visit_Discount (visit_ID, reason, User_code) VALUES (@visit_ID, @reason, @User_code)";
string[] Parameters = new string[] { "@visit_ID", "@reason", "@User_code" };
string[] Values = new string[] { VISIT_ID, textBox1.Text, User_ID.ToString() };
conn.ExecuteStoredProcQueries(query, Parameters, Values);
query = "UPDATE Visit_Bill SET discount_amount =@discount_amount WHERE visit_ID=@visit_ID";
Parameters = new string[] { "@discount_amount", "@visit_ID" };
Values = new string[] { value.ToString(), VISIT_ID };
conn.ExecuteStoredProcQueries(query, Parameters, Values);
conn.CloseConnection();
clear();
MessageBox.Show("تم عمل الخصم بنجاح ");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
int value = 0;
if (textBox2.Text == "")
{
MessageBox.Show("ادخل المبلغ");
return;
}
value = Convert.ToInt32(textBox2.Text);
if (value <= 0)
{
MessageBox.Show("ادخل المبلغ بطريقة صحيحة");
return;
}
if (VISIT_ID == "" || VISIT_ID == null)
{
MessageBox.Show("حدد الزيارة من زر بحث");
return;
}
try
{
conn.OpenConection();
query = @"INSERT INTO Visit_Payment(visit_ID, type, value, date, User_code) VALUES(@visit_ID, @type, @value,@date, @User_code)";
string[] Parameters = new string[] { "@visit_ID", "@type", "@value", "@date", "@User_code" };
string[] Values = new string[] { label6.Text, "0", textBox2.Text, DateTime.Now.ToString(), User_ID.ToString() };
conn.ExecuteStoredProcQueries(query, Parameters, Values);
query = " SELECT (SELECT ISNULL(SUM(value),0) FROM Visit_Payment WHERE type=0 AND visit_id=" + label6.Text + ")-(SELECT ISNULL(SUM(value),0) FROM Visit_Payment WHERE type=1 AND visit_id=" + label6.Text + ")";
dr = conn.DataReader(query);
if (dr.Read())
{
label18.Text = dr[0].ToString();
}
dr.Close();
query = "UPDATE Visit_Bill SET value_payment =@value_payment WHERE visit_ID=@visit_ID";
Parameters = new string[] { "@value_payment", "@visit_ID" };
Values = new string[] { label18.Text, label6.Text };
conn.ExecuteStoredProcQueries(query, Parameters, Values);
conn.CloseConnection();
clear();
fill_data();
MessageBox.Show("تم سدد المبلغ بنجاح");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
if (VISIT_ID == "" || VISIT_ID == null)
{
MessageBox.Show("حدد الفاتورة من زر بحث");
return;
}
if (textBox1.Text == "")
{
MessageBox.Show("ادخل سبب الالغاء");
return;
}
try
{
var dialogResult = MessageBox.Show(" هل تريد الغاء الفاتورة ؟", string.Empty, MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
try
{
conn.OpenConection();
query = @"INSERT INTO Visit_Delete (visit_ID, reason, User_code) VALUES (@visit_ID, @reason, @User_code)";
string[] Parameters = new string[] { "@visit_ID", "@reason", "@User_code" };
string[] Values = new string[] { VISIT_ID, textBox1.Text, User_ID.ToString() };
conn.ExecuteStoredProcQueries(query, Parameters, Values);
query = @"DELETE FROM Visit_Bill WHERE visit_ID=" + VISIT_ID + @";
DELETE FROM Visit_Discount WHERE visit_ID=" + VISIT_ID + @";
DELETE FROM Visit_Medicine_Temp WHERE visit_ID=" + VISIT_ID + @";
DELETE FROM Visit_Residence_Temp WHERE visit_ID=" + VISIT_ID + @";
DELETE FROM Visit_Services_Temp WHERE visit_ID=" + VISIT_ID + @";
DELETE FROM Visit_Payment WHERE visit_ID=" + VISIT_ID + ";";
conn.ExecuteQueries(query);
conn.CloseConnection();
clear();
MessageBox.Show("تم الغاء الفاتورة بنجاح ");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
if (dialogResult == DialogResult.No)
{
return;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button3_Click(object sender, EventArgs e)
{
if (VISIT_ID == "" || VISIT_ID == null)
{
return;
}
try
{
conn.OpenConection();
string[] Parameters;
string[] Values;
int c = 0;
double temp_price = 0;
c = dataGridView1.Rows.Count;
for (int i = 0; i < c; i++)
{
query = @"UPDATE Visit_Services_Temp SET price_before_discount=@price_before_discount, price_after_discount=@price_after_discount WHERE ID=@ID";
temp_price = Convert.ToDouble(dataGridView1.Rows[i].Cells[2].Value);
Parameters = new string[3];
Values = new string[3];
Parameters[0] = "@price_before_discount";
Values[0] = temp_price.ToString();
Parameters[1] = "@price_after_discount";
Values[1] = (Patient_service_percentage * temp_price / 100).ToString();
Parameters[2] = "@ID";
Values[2] = dataGridView1.Rows[i].Cells[0].Value.ToString();
conn.ExecuteStoredProcQueries(query, Parameters, Values);
}
c = dataGridView2.Rows.Count;
for (int i = 0; i < c; i++)
{
query = @"UPDATE Visit_Residence_Temp SET number_of_days=@number_of_days,price_before_discount=@price_before_discount, price_after_discount=@price_after_discount WHERE ID=@ID";
temp_price = Convert.ToDouble(dataGridView2.Rows[i].Cells[3].Value);
Parameters = new string[4];
Values = new string[4];
Parameters[0] = "@number_of_days";
Values[0] = dataGridView2.Rows[i].Cells[6].Value.ToString();
Parameters[1] = "@price_before_discount";
Values[1] = temp_price.ToString();
Parameters[2] = "@price_after_discount";
Values[2] = (Patient_residence_percentage * temp_price / 100).ToString();
Parameters[3] = "@ID";
Values[3] = dataGridView2.Rows[i].Cells[0].Value.ToString();
conn.ExecuteStoredProcQueries(query, Parameters, Values);
}
c = dataGridView3.Rows.Count;
for (int i = 0; i < c; i++)
{
query = @"UPDATE Visit_Medicine_Temp SET price_before_discount=@price_before_discount, price_after_discount=@price_after_discount WHERE ID=@ID";
temp_price = Convert.ToDouble(dataGridView3.Rows[i].Cells[3].Value);
Parameters = new string[3];
Values = new string[3];
Parameters[0] = "@price_before_discount";
Values[0] = temp_price.ToString();
Parameters[1] = "@price_after_discount";
Values[1] = (Patient_medicine_percentage * temp_price / 100).ToString();
Parameters[2] = "@ID";
Values[2] = dataGridView3.Rows[i].Cells[0].Value.ToString();
conn.ExecuteStoredProcQueries(query, Parameters, Values);
}
///////////////////////////////////////////
query = @"INSERT INTO Visit_Bill (visit_ID,CE_Id,EB_id,EC_id, total_service, total_residence, total_medicine, patient_service_amount, patient_residence_amount, patient_medicine_amount,value_payment,date, User_code)
VALUES (@visit_ID,@CE_Id,@EB_id,@EC_id,@total_service,@total_residence,@total_medicine,@patient_service_amount,@patient_residence_amount,@patient_medicine_amount,@value_payment,@date,@User_code)";
Parameters = new string[] { "@visit_ID", "@CE_Id", "@EB_id", "@EC_id", "@total_service", "@total_residence", "@total_medicine", "@patient_service_amount", "@patient_residence_amount", "@patient_medicine_amount", "@value_payment", "@date", "@User_code" };
Values = new string[] { label6.Text, EntityID, BranchEntityID, GroupID, label11.Text, label2.Text, label9.Text, label27.Text, label24.Text, label30.Text, label18.Text, DateTime.Now.ToString(), User_ID.ToString() };
conn.ExecuteStoredProcQueries(query, Parameters, Values);
query = "UPDATE entranceoffice_visit SET state_of_visit =1 WHERE visit_id=" + VISIT_ID + "";
conn.ExecuteQueries(query);
/////////////////////////////////////
query = @"SELECT Visit_Bill.ID, Visit_Bill.visit_ID, Registeration_patientRegisteration.patient_name, employee.name, Visit_Bill.date, Visit_Bill.total_service, Visit_Bill.total_residence, Visit_Bill.total_medicine, Visit_Bill.discount_amount,
(Visit_Bill.total_service + Visit_Bill.total_residence + Visit_Bill.total_medicine)as total1,
Visit_Bill.patient_service_amount, Visit_Bill.patient_residence_amount, Visit_Bill.patient_medicine_amount,(Visit_Bill.patient_service_amount + Visit_Bill.patient_residence_amount + Visit_Bill.patient_medicine_amount) as total2,
value_payment, (Visit_Bill.patient_service_amount + Visit_Bill.patient_residence_amount + Visit_Bill.patient_medicine_amount - Visit_Bill.value_payment - Visit_Bill.discount_amount)as value_requested, tb_Contracting_Entities.CE_AName, tb_Entities_Branches.EB_Aname,
tb_Entities_Category.EC_Aname,(tb_Contracting_Entities.CE_AName+' - '+ tb_Entities_Branches.EB_Aname +' - '+ tb_Entities_Category.EC_Aname)as full_name
FROM employee INNER JOIN
Users ON employee.emp_id = Users.emp_id INNER JOIN
Visit_Bill ON Users.User_Code = Visit_Bill.User_code INNER JOIN
Registeration_patientRegisteration INNER JOIN
entranceoffice_visit ON Registeration_patientRegisteration.patient_id = entranceoffice_visit.pat_id INNER JOIN
tb_Entities_Branches INNER JOIN
tb_Contracting_Entities ON tb_Entities_Branches.EB_CE_id = tb_Contracting_Entities.CE_Id INNER JOIN
tb_Entities_Category ON tb_Entities_Branches.EB_id = tb_Entities_Category.EC_EB_id ON entranceoffice_visit.EC_id = tb_Entities_Category.EC_id ON Visit_Bill.visit_ID = entranceoffice_visit.visit_id AND
Visit_Bill.EB_id = tb_Entities_Branches.EB_id AND Visit_Bill.EB_id = tb_Entities_Branches.EB_id AND Visit_Bill.CE_Id = tb_Contracting_Entities.CE_Id AND Visit_Bill.visit_ID=" + VISIT_ID + "";
dt.Clear();
dt = (DataTable)conn.ShowDataInGridView(query);
c = dt.Rows.Count;
conn.CloseConnection();
if (c == 0)
{
MessageBox.Show("error");
}
clear();
Run();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
