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); } }