public Stage_N getStageNData()
{
Stage_N stage_n = new Stage_N();
stage_n.Stage_Type = cmb_stage_basis.Text;
stage_n.Stage_n_name = txt_box_stage_name.Text;
stage_n.Stage_n_desc = txt_box_stage_desc.Text;
stage_n.Stage_n_disease_id = "N/A";
return(stage_n);
}
public static void Insert(Stage_N stage_n)
{
SqlParameter[] param = new SqlParameter[5];
param[0] = new SqlParameter("@stage_n_id", SqlDbType.NVarChar, 15);
param[0].Direction = ParameterDirection.Output;
param[1] = new SqlParameter("@stage_n_name", stage_n.Stage_n_name);
param[2] = new SqlParameter("@stage_n_desc", stage_n.Stage_n_desc);
param[3] = new SqlParameter("@stage_n_disease_id", stage_n.Stage_n_disease_id);
param[4] = new SqlParameter("@stage_type", stage_n.Stage_Type);
try
{
stage_n.Stage_n_id = DBHelper.ExecuteReturnIDStoredProcedure("insert_stage_n", param);
}
catch (Exception ex)
{
throw ex;
}
}
