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