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