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