private bool saveData()
{
bool blnResult = false;
Budget_transfer_head budget_transfer_head = new Budget_transfer_head();
cBudget_transfer oBudget_transfer = new cBudget_transfer();
try
{
#region set Data
budget_transfer_head.budget_transfer_doc = txtbudget_transfer_doc.Text;
budget_transfer_head.budget_doc_no = txtbudget_doc_no.Text;
budget_transfer_head.budget_transfer_year = cboYear.SelectedValue;
budget_transfer_head.budget_transfer_date = cCommon.GetDate(txtbudget_transfer_date.Text);
budget_transfer_head.budget_type = cboBudget_type.SelectedValue;
budget_transfer_head.degree_code_from = cboDegree_from.SelectedValue;
budget_transfer_head.major_code_from = cboMajor_from.SelectedValue;
budget_transfer_head.budget_plan_code_from = txtbudget_plan_code_from.Text;
budget_transfer_head.degree_code_to = cboDegree_to.SelectedValue;
budget_transfer_head.major_code_to = cboMajor_to.SelectedValue;
budget_transfer_head.budget_plan_code_to = txtbudget_plan_code_to.Text;
budget_transfer_head.budget_transfer_remark = txtbudget_transfer_remark.Text;
budget_transfer_head.c_created_by = Session["username"].ToString();
budget_transfer_head.c_updated_by = Session["username"].ToString();
#endregion
if (ViewState["mode"].ToString().ToLower().Equals("edit"))
{
oBudget_transfer.SP_BUDGET_TRANSFER_HEAD_UPD(budget_transfer_head);
}
else
{
oBudget_transfer.SP_BUDGET_TRANSFER_HEAD_INS(budget_transfer_head);
ViewState["budget_transfer_doc"] = budget_transfer_head.budget_transfer_doc;
}
blnResult = true;
}
catch (Exception ex)
{
if (ex.Message.Contains("duplicate key"))
{
MsgBox("ข้อมูลซ้ำโปรดตรวจสอบ");
}
else
{
lblError.Text = ex.Message.ToString();
}
}
finally
{
oBudget_transfer.Dispose();
}
return(blnResult);
}
public bool SP_BUDGET_TRANSFER_HEAD_INS(Budget_transfer_head budget_transfer_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_BUDGET_TRANSFER_HEAD_INS";
SqlParameter oParambudget_transfer_doc = new SqlParameter("budget_transfer_doc", SqlDbType.VarChar, 10)
{
Direction = ParameterDirection.Output,
Value = budget_transfer_head.budget_transfer_doc
};
oCommand.Parameters.Add(oParambudget_transfer_doc);
oCommand.Parameters.Add("budget_doc_no", SqlDbType.VarChar).Value = budget_transfer_head.budget_doc_no;
oCommand.Parameters.Add("budget_transfer_year", SqlDbType.VarChar).Value = budget_transfer_head.budget_transfer_year;
oCommand.Parameters.Add("budget_transfer_date", SqlDbType.DateTime).Value = budget_transfer_head.budget_transfer_date;
oCommand.Parameters.Add("budget_type", SqlDbType.VarChar).Value = budget_transfer_head.budget_type;
oCommand.Parameters.Add("degree_code_from", SqlDbType.VarChar).Value = budget_transfer_head.degree_code_from;
oCommand.Parameters.Add("major_code_from", SqlDbType.VarChar).Value = budget_transfer_head.major_code_from;
oCommand.Parameters.Add("budget_plan_code_from", SqlDbType.VarChar).Value = budget_transfer_head.budget_plan_code_from;
oCommand.Parameters.Add("degree_code_to", SqlDbType.VarChar).Value = budget_transfer_head.degree_code_to;
oCommand.Parameters.Add("major_code_to", SqlDbType.VarChar).Value = budget_transfer_head.major_code_to;
oCommand.Parameters.Add("budget_plan_code_to", SqlDbType.VarChar).Value = budget_transfer_head.budget_plan_code_to;
oCommand.Parameters.Add("budget_transfer_remark", SqlDbType.VarChar).Value = budget_transfer_head.budget_transfer_remark;
oCommand.Parameters.Add("budget_transfer_amount", SqlDbType.Money).Value = budget_transfer_head.budget_transfer_amount;
oCommand.Parameters.Add("c_created_by", SqlDbType.VarChar).Value = budget_transfer_head.c_created_by;
oCommand.ExecuteNonQuery();
budget_transfer_head.budget_transfer_doc = oParambudget_transfer_doc.Value.ToString();
blnResult = true;
}
catch (Exception ex)
{
throw ex;
}
finally
{
oConn.Close();
oCommand.Dispose();
oConn.Dispose();
}
return(blnResult);
}
