private bool saveData() { bool blnResult = false; string strScript = string.Empty; cBudget_transfer oBudget_transfer = new cBudget_transfer(); DataSet ds = new DataSet(); try { #region set Data var budget_transfer_detail = new Budget_transfer_detail() { budget_transfer_detail_id = BudgetTransferDetailId, budget_transfer_doc = BudgetTransferDoc, budget_money_major_id_from = long.Parse(hddbudget_money_major_id_from.Value), budget_money_major_id_to = long.Parse(hddbudget_money_major_id_to.Value), budget_transfer_detail_amount = decimal.Parse(txtbudget_transfer_detail_amount.Value.ToString()), budget_transfer_detail_remark = txtbudget_transfer_detail_comment.Text.Trim(), c_created_by = Session["username"].ToString(), c_updated_by = Session["username"].ToString() }; #endregion if (ViewState["mode"].ToString().ToLower().Equals("edit")) { oBudget_transfer.SP_BUDGET_TRANSFER_DETAIL_UPD(budget_transfer_detail); } else { oBudget_transfer.SP_BUDGET_TRANSFER_DETAIL_INS(budget_transfer_detail); } oBudget_transfer.SP_BUDGET_TRANSFER_TOTAL_UPD(BudgetTransferDoc); 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_DETAIL_INS(Budget_transfer_detail budget_transfer_detail) { 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_DETAIL_INS"; SqlParameter oParambudget_transfer_detail_id = new SqlParameter("budget_transfer_detail_id", SqlDbType.BigInt) { Direction = ParameterDirection.Output, Value = budget_transfer_detail.budget_transfer_detail_id }; oCommand.Parameters.Add(oParambudget_transfer_detail_id); oCommand.Parameters.Add("budget_transfer_doc", SqlDbType.VarChar).Value = budget_transfer_detail.budget_transfer_doc; oCommand.Parameters.Add("budget_money_major_id_from", SqlDbType.BigInt).Value = budget_transfer_detail.budget_money_major_id_from; oCommand.Parameters.Add("budget_money_major_id_to", SqlDbType.BigInt).Value = budget_transfer_detail.budget_money_major_id_to; oCommand.Parameters.Add("budget_transfer_detail_amount", SqlDbType.Money).Value = budget_transfer_detail.budget_transfer_detail_amount; oCommand.Parameters.Add("budget_transfer_detail_remark", SqlDbType.VarChar).Value = budget_transfer_detail.budget_transfer_detail_remark; oCommand.Parameters.Add("c_created_by", SqlDbType.VarChar).Value = budget_transfer_detail.c_created_by; oCommand.ExecuteNonQuery(); budget_transfer_detail.budget_transfer_detail_id = long.Parse(oParambudget_transfer_detail_id.Value.ToString()); blnResult = true; } catch (Exception ex) { throw ex; } finally { oConn.Close(); oCommand.Dispose(); oConn.Dispose(); } return(blnResult); }