public static void spd_insert_tp(DataGridView dgv) { //TableStructure //pat_id | [tp_date] | [sd_id] | [charge_amount] | [discount_amount] | [total_amount] | [doc_name] | [paid_status] try { DataTable dt; con = new SqlConnection(connectionString); con.Open(); cmd = new SqlCommand("[dbo].[spd_insert_tp]", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter param = new SqlParameter(); param.ParameterName = "@tempTp"; dt = GlobalMethod.convertDGVtoDT(dgv); param.Value = dt; cmd.Parameters.Add(param); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception t) { GlobalMethod.HandleException("StoreProcedure / spd_insert_tp : " + t.Message); } }
public static void spd_insert_patient_md(DataGridView dgv) { //TableStructure //pat_id | md_id | md_name | md_description | md_status try { DataTable dt; con = new SqlConnection(connectionString); con.Open(); cmd = new SqlCommand("[dbo].[spd_insert_patientMd]", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter param = new SqlParameter(); param.ParameterName = "@tempMd"; dt = GlobalMethod.convertDGVtoDT(dgv); param.Value = dt; cmd.Parameters.Add(param); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception t) { GlobalMethod.HandleException("StoreProcedure / spd_insert_patient_diagnose : " + t.Message); } }