public bool SP_DEDUCT_HEAD_INS(Deduct_head deduct_head) { bool blnResult = false; SqlConnection oConn = new SqlConnection(); SqlCommand oCommand = new SqlCommand(); SqlDataAdapter oAdapter = new SqlDataAdapter(); try { oConn.ConnectionString = _strConn; oConn.Open(); oCommand.Connection = oConn; oCommand.CommandType = CommandType.StoredProcedure; oCommand.CommandText = "sp_DEDUCT_HEAD_INS"; SqlParameter oParamdeduct_doc = new SqlParameter("deduct_doc_no", SqlDbType.VarChar, 10) { Direction = ParameterDirection.Output, Value = deduct_head.deduct_doc_no }; oCommand.Parameters.Add(oParamdeduct_doc); oCommand.Parameters.Add("deduct_year", SqlDbType.VarChar).Value = deduct_head.deduct_year; oCommand.Parameters.Add("deduct_date", SqlDbType.DateTime).Value = deduct_head.deduct_date; oCommand.Parameters.Add("budget_money_doc", SqlDbType.VarChar).Value = deduct_head.budget_money_doc; oCommand.Parameters.Add("budget_receive_doc", SqlDbType.VarChar).Value = deduct_head.budget_receive_doc; oCommand.Parameters.Add("major_code", SqlDbType.VarChar).Value = deduct_head.major_code; oCommand.Parameters.Add("degree_code", SqlDbType.VarChar).Value = deduct_head.degree_code; oCommand.Parameters.Add("recv_doc_no", SqlDbType.VarChar).Value = deduct_head.recv_doc_no; oCommand.Parameters.Add("recv_total_amount", SqlDbType.Money).Value = deduct_head.recv_total_amount; oCommand.Parameters.Add("deduct_total_reduce", SqlDbType.Money).Value = deduct_head.deduct_total_reduce; oCommand.Parameters.Add("deduct_total_reduce_director", SqlDbType.Money).Value = deduct_head.deduct_total_reduce_director; oCommand.Parameters.Add("deduct_total_remain", SqlDbType.Money).Value = deduct_head.deduct_total_remain; oCommand.Parameters.Add("budget_plan_code", SqlDbType.VarChar).Value = deduct_head.budget_plan_code; oCommand.Parameters.Add("deduct_remark", SqlDbType.VarChar).Value = deduct_head.deduct_remark; oCommand.Parameters.Add("item_group_detail_id", SqlDbType.Int).Value = deduct_head.item_group_detail_id; oCommand.Parameters.Add("approve_head_status", SqlDbType.Int).Value = deduct_head.@approve_head_status; oCommand.Parameters.Add("c_created_by", SqlDbType.VarChar).Value = deduct_head.c_created_by; oCommand.ExecuteNonQuery(); deduct_head.deduct_doc_no = oParamdeduct_doc.Value.ToString(); blnResult = true; } catch (Exception ex) { throw ex; } finally { oConn.Close(); oCommand.Dispose(); oConn.Dispose(); } return(blnResult); }
private bool saveData() { bool blnResult = false; Deduct_head deduct_head = new Deduct_head(); cDeduct oDeduct = new cDeduct(); try { #region set Data deduct_head.deduct_doc_no = txtdeduct_doc.Text; deduct_head.deduct_year = cboYear.SelectedValue; deduct_head.deduct_date = cCommon.GetDate(txtdeduct_date.Text); deduct_head.budget_money_doc = txtbudget_money_doc.Text; deduct_head.budget_receive_doc = txtbudget_receive_doc.Text; deduct_head.major_code = cboMajor.SelectedValue; deduct_head.degree_code = cboDegree.SelectedValue; deduct_head.recv_doc_no = txtrecv_doc_no.Text; deduct_head.recv_total_amount = decimal.Parse(txtrecv_total_amount.Value.ToString()); deduct_head.deduct_total_reduce = decimal.Parse(txtdeduct_total_reduce.Value.ToString()); deduct_head.deduct_total_reduce_director = decimal.Parse(txtdeduct_total_reduce_director.Value.ToString()); deduct_head.deduct_total_remain = decimal.Parse(txtdeduct_total_remain.Value.ToString()); deduct_head.budget_plan_code = txtbudget_plan_code.Text; deduct_head.deduct_remark = txtcomment.Text.Trim(); deduct_head.item_group_detail_id = int.Parse(cboItem_group_detail.SelectedValue); deduct_head.c_created_by = Session["username"].ToString(); deduct_head.c_updated_by = Session["username"].ToString(); #endregion if (ViewState["mode"].ToString().ToLower().Equals("edit")) { if (oDeduct.SP_DEDUCT_HEAD_UPD(deduct_head)) { SaveDetail(); saveBudgetReceive(); } } else { oDeduct.SP_DEDUCT_HEAD_INS(deduct_head); ViewState["deduct_doc"] = deduct_head.deduct_doc_no; saveBudgetReceive(); deduct_head.budget_receive_doc = txtbudget_receive_doc.Text; oDeduct.SP_DEDUCT_HEAD_UPD(deduct_head); } blnResult = true; } catch (Exception ex) { if (ex.Message.Contains("duplicate key")) { MsgBox("ข้อมูลซ้ำโปรดตรวจสอบ"); } else { //lblError.Text = ex.Message.ToString(); } } finally { oDeduct.Dispose(); } return(blnResult); }