public decimal Update(Other_MasterInfo pInfo)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_other_master.proc_other_master_update",
new OracleParameter("p_id", OracleDbType.Decimal, pInfo.Id, ParameterDirection.Input),
new OracleParameter("p_app_header_id", OracleDbType.Decimal, pInfo.App_Header_Id, ParameterDirection.Input),
new OracleParameter("p_case_code", OracleDbType.Varchar2, pInfo.Case_Code, ParameterDirection.Input),
new OracleParameter("p_master_name", OracleDbType.Varchar2, pInfo.Master_Name, ParameterDirection.Input),
new OracleParameter("p_master_address", OracleDbType.Varchar2, pInfo.Master_Address, ParameterDirection.Input),
new OracleParameter("p_master_phone", OracleDbType.Varchar2, pInfo.PhoBan, ParameterDirection.Input),
new OracleParameter("p_master_fax", OracleDbType.Varchar2, pInfo.Master_Fax, ParameterDirection.Input),
new OracleParameter("p_master_email", OracleDbType.Varchar2, pInfo.Master_Email, ParameterDirection.Input),
new OracleParameter("p_tacgiadongthoi", OracleDbType.Varchar2, pInfo.TacGiaDongThoi, ParameterDirection.Input),
new OracleParameter("p_phoban", OracleDbType.Varchar2, pInfo.PhoBan, ParameterDirection.Input),
new OracleParameter("p_country_nationality", OracleDbType.Decimal, pInfo.Country_Nationality, ParameterDirection.Input),
new OracleParameter("p_country_residence", OracleDbType.Decimal, pInfo.Country_Residence, ParameterDirection.Input),
new OracleParameter("p_country_incorporation", OracleDbType.Decimal, pInfo.Country_Incorporation, ParameterDirection.Input),
paramReturn);
var result = Convert.ToDecimal(paramReturn.Value.ToString());
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
public decimal Update(Other_MasterInfo pInfo)
{
try
{
Other_Master_DA _obj_da = new Other_Master_DA();
return(_obj_da.Update(pInfo));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
