public decimal Insert(List <UTienInfo> pInfo)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExcuteBatchNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_app_don_uu_tien.Proc_App_Don_Uu_Tien_Insert", pInfo.Count,
new OracleParameter("p_id", OracleDbType.Decimal, pInfo.Select(o => o.Id).ToArray(), ParameterDirection.Input),
new OracleParameter("p_app_header_id", OracleDbType.Decimal, pInfo.Select(o => o.App_Header_Id).ToArray(), ParameterDirection.Input),
new OracleParameter("p_case_code", OracleDbType.Varchar2, pInfo.Select(o => o.Case_Code).ToArray(), ParameterDirection.Input),
new OracleParameter("p_ut_sodon", OracleDbType.Varchar2, pInfo.Select(o => o.UT_SoDon).ToArray(), ParameterDirection.Input),
new OracleParameter("p_ut_ngaynopdon", OracleDbType.Date, pInfo.Select(o => o.UT_NgayNopDon).ToArray(), ParameterDirection.Input),
new OracleParameter("p_ut_quocgia", OracleDbType.Decimal, pInfo.Select(o => o.UT_QuocGia).ToArray(), ParameterDirection.Input),
new OracleParameter("p_ut_type", OracleDbType.Varchar2, pInfo.Select(o => o.UT_Type).ToArray(), ParameterDirection.Input),
new OracleParameter("p_ut_thoathuankhac", OracleDbType.Varchar2, pInfo.Select(o => o.UT_ThoaThuanKhac).ToArray(), ParameterDirection.Input),
paramReturn);
Oracle.DataAccess.Types.OracleDecimal[] totalReturn = (Oracle.DataAccess.Types.OracleDecimal[])paramReturn.Value;
foreach (Oracle.DataAccess.Types.OracleDecimal _item in totalReturn)
{
if (Convert.ToDecimal(_item.Value.ToString()) < 0)
{
return(Convert.ToDecimal(_item.Value.ToString()));
}
}
return(1);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
public int Billing_Detail_InsertBatch(List <Billing_Detail_Info> pInfo, decimal _billing_id)
{
try
{
int numberRecord = pInfo.Count;
decimal[] p_billing_id = new decimal[numberRecord];
string[] p_biling_detail_name = new string[numberRecord];
string[] p_biling_detail_name_en = new string[numberRecord];
decimal[] p_ref_id = new decimal[numberRecord];
decimal[] p_type = new decimal[numberRecord];
decimal[] p_nation_fee = new decimal[numberRecord];
decimal[] p_represent_fee = new decimal[numberRecord];
decimal[] p_service_fee = new decimal[numberRecord];
for (int i = 0; i < pInfo.Count; i++)
{
p_billing_id[i] = _billing_id;
p_biling_detail_name[i] = pInfo[i].Biling_Detail_Name;
p_biling_detail_name_en[i] = pInfo[i].Biling_Detail_Name_EN;
p_ref_id[i] = pInfo[i].Ref_Id;
p_type[i] = pInfo[i].Type;
p_nation_fee[i] = pInfo[i].Nation_Fee;
p_represent_fee[i] = pInfo[i].Represent_Fee;
p_service_fee[i] = pInfo[i].Service_Fee;
}
var paramReturn = new OracleParameter("p_return", OracleDbType.Int32, ParameterDirection.Output);
OracleHelper.ExcuteBatchNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_billing.Proc_Billing_Detail_Insert", numberRecord,
new OracleParameter("p_billing_id", OracleDbType.Decimal, p_billing_id, ParameterDirection.Input),
new OracleParameter("p_biling_detail_name", OracleDbType.Varchar2, p_biling_detail_name, ParameterDirection.Input),
new OracleParameter("p_biling_detail_name_en", OracleDbType.Varchar2, p_biling_detail_name_en, ParameterDirection.Input),
new OracleParameter("p_ref_id", OracleDbType.Decimal, p_ref_id, ParameterDirection.Input),
new OracleParameter("p_type", OracleDbType.Decimal, p_type, ParameterDirection.Input),
new OracleParameter("p_nation_fee", OracleDbType.Decimal, p_nation_fee, ParameterDirection.Input),
new OracleParameter("p_represent_fee", OracleDbType.Decimal, p_represent_fee, ParameterDirection.Input),
new OracleParameter("p_service_fee", OracleDbType.Decimal, p_service_fee, ParameterDirection.Input),
paramReturn);
var result = -1;
Oracle.DataAccess.Types.OracleDecimal[] _ArrReturn = (Oracle.DataAccess.Types.OracleDecimal[])paramReturn.Value;
foreach (Oracle.DataAccess.Types.OracleDecimal _item in _ArrReturn)
{
if (Convert.ToInt32(_item.ToString()) < 0)
{
result = Convert.ToInt32(_item.ToString());
break;
}
else
{
result = 1;
}
}
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public decimal Insert(List <AuthorsInfo> pInfo)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExcuteBatchNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_authors.Proc_Authors_Insert", pInfo.Count,
new OracleParameter("p_author_id", OracleDbType.Decimal, pInfo.Select(o => o.Author_Id).ToArray(), ParameterDirection.Input),
new OracleParameter("p_app_header_id", OracleDbType.Decimal, pInfo.Select(o => o.App_Header_Id).ToArray(), ParameterDirection.Input),
new OracleParameter("p_case_code", OracleDbType.Varchar2, pInfo.Select(o => o.Case_Code).ToArray(), ParameterDirection.Input),
new OracleParameter("p_author_name", OracleDbType.Varchar2, pInfo.Select(o => o.Author_Name).ToArray(), ParameterDirection.Input),
new OracleParameter("p_author_address", OracleDbType.Varchar2, pInfo.Select(o => o.Author_Address).ToArray(), ParameterDirection.Input),
new OracleParameter("p_author_phone", OracleDbType.Varchar2, pInfo.Select(o => o.Author_Phone).ToArray(), ParameterDirection.Input),
new OracleParameter("p_author_fax", OracleDbType.Varchar2, pInfo.Select(o => o.Author_Fax).ToArray(), ParameterDirection.Input),
new OracleParameter("p_author_email", OracleDbType.Varchar2, pInfo.Select(o => o.Author_Email).ToArray(), ParameterDirection.Input),
new OracleParameter("p_author_country", OracleDbType.Decimal, pInfo.Select(o => o.Author_Country).ToArray(), ParameterDirection.Input),
paramReturn);
Oracle.DataAccess.Types.OracleDecimal[] totalReturn = (Oracle.DataAccess.Types.OracleDecimal[])paramReturn.Value;
foreach (Oracle.DataAccess.Types.OracleDecimal _item in totalReturn)
{
if (Convert.ToDecimal(_item.Value.ToString()) < 0)
{
return(Convert.ToDecimal(_item.Value.ToString()));
}
}
return(1);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
// class
public int SearchClass_InsertBatch(List <Search_Class_Info> pInfo, decimal p_seach_id, string pLanguage)
{
try
{
int numberRecord = pInfo.Count;
if (numberRecord < 1)
{
return(0);
}
string[] TextInput = new string[numberRecord];
decimal[] _seach_id = new decimal[numberRecord];
string[] Code = new string[numberRecord];
string[] Language = new string[numberRecord];
DateTime[] Document_Filling_Date = new DateTime[numberRecord];
for (int i = 0; i < pInfo.Count; i++)
{
_seach_id[i] = p_seach_id;
TextInput[i] = pInfo[i].Textinput;
Code[i] = pInfo[i].Code;
Language[i] = pLanguage;
}
var paramReturn = new OracleParameter("P_RETURN", OracleDbType.Int32, ParameterDirection.Output);
paramReturn.Size = 10;
OracleHelper.ExcuteBatchNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_search_class_detail.proc_insert", numberRecord,
new OracleParameter("p_textinput", OracleDbType.Varchar2, TextInput, ParameterDirection.Input),
new OracleParameter("p_code", OracleDbType.Varchar2, Code, ParameterDirection.Input),
new OracleParameter("p_seach_id", OracleDbType.Decimal, _seach_id, ParameterDirection.Input),
new OracleParameter("p_language_code", OracleDbType.Varchar2, Language, ParameterDirection.Input),
paramReturn);
var result = ErrorCode.Error;
Oracle.DataAccess.Types.OracleDecimal[] _ArrReturn = (Oracle.DataAccess.Types.OracleDecimal[])paramReturn.Value;
foreach (Oracle.DataAccess.Types.OracleDecimal _item in _ArrReturn)
{
if (Convert.ToInt32(_item.ToString()) < 0)
{
result = Convert.ToInt32(_item.ToString());
break;
}
else
{
result = ErrorCode.Success;
}
}
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
public bool Update_Todo_Email(List <B_Todos_Info> p_lst)
{
try
{
OracleHelper.ExcuteBatchNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_todos.pro_update_status_sendmail", p_lst.Count,
new OracleParameter("p_id", OracleDbType.Decimal, p_lst.Select(o => o.TODO_ID).ToArray(), ParameterDirection.Input));
return(true);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(false);
}
}
public decimal SEARCH_DETAIL_INSERT(List <SearchObject_Detail_Info> P_SearchDetails)
{
try
{
int _totalrec = P_SearchDetails.Count;
decimal[] P_SEARCH_ID = new decimal[_totalrec];
decimal[] P_SEARCH_OBJECT = new decimal[_totalrec];
decimal[] P_SEARCH_TYPE = new decimal[_totalrec];
int _count = 0;
foreach (SearchObject_Detail_Info item in P_SearchDetails)
{
P_SEARCH_ID[_count] = item.SEARCH_ID;
P_SEARCH_TYPE[_count] = item.SEARCH_TYPE;
P_SEARCH_OBJECT[_count] = item.SEARCH_OBJECT;
_count++;
}
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
paramReturn.Size = 10;
OracleHelper.ExcuteBatchNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "PKG_SEARCH_OBJECTS.PROC_SEARCH_DETAIL_INSERT", _totalrec,
new OracleParameter("P_SEARCH_ID", OracleDbType.Decimal, P_SEARCH_ID, ParameterDirection.Input),
new OracleParameter("P_SEARCH_OBJECT", OracleDbType.Varchar2, P_SEARCH_OBJECT, ParameterDirection.Input),
new OracleParameter("P_SEARCH_TYPE", OracleDbType.Varchar2, P_SEARCH_TYPE, ParameterDirection.Input),
paramReturn);
var result = ErrorCode.Error;
Oracle.DataAccess.Types.OracleDecimal[] _ArrReturn = (Oracle.DataAccess.Types.OracleDecimal[])paramReturn.Value;
foreach (Oracle.DataAccess.Types.OracleDecimal _item in _ArrReturn)
{
if (Convert.ToInt32(_item.ToString()) < 0)
{
result = Convert.ToInt32(_item.ToString());
break;
}
else
{
result = ErrorCode.Success;
}
}
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public decimal App_Translate_Insert(List <App_Translate_Info> pInfo)
{
try
{
OracleHelper.ExcuteBatchNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_app_translate.Proc_App_Translate_Insert", pInfo.Count,
new OracleParameter("p_app_header_id", OracleDbType.Decimal, pInfo.Select(o => o.App_Header_Id).ToArray(), ParameterDirection.Input),
new OracleParameter("p_case_code", OracleDbType.Varchar2, pInfo.Select(o => o.Case_Code).ToArray(), ParameterDirection.Input),
new OracleParameter("p_object_name", OracleDbType.Varchar2, pInfo.Select(o => o.Object_Name).ToArray(), ParameterDirection.Input),
new OracleParameter("p_value_old", OracleDbType.Varchar2, pInfo.Select(o => o.Value_Old).ToArray(), ParameterDirection.Input),
new OracleParameter("p_value_translate", OracleDbType.Varchar2, pInfo.Select(o => o.Value_Translate).ToArray(), ParameterDirection.Input),
new OracleParameter("p_type", OracleDbType.Varchar2, pInfo.Select(o => o.Type).ToArray(), ParameterDirection.Input),
new OracleParameter("p_language", OracleDbType.Varchar2, pInfo.Select(o => o.Language).ToArray(), ParameterDirection.Input));
return(0);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(-1);
}
}
public decimal Insert(List <Other_MasterInfo> pInfo)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExcuteBatchNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_other_master.Proc_Other_Master_Insert", pInfo.Count,
new OracleParameter("p_id", OracleDbType.Decimal, pInfo.Select(o => o.Id).ToArray(), ParameterDirection.Input),
new OracleParameter("p_app_header_id", OracleDbType.Decimal, pInfo.Select(o => o.App_Header_Id).ToArray(), ParameterDirection.Input),
new OracleParameter("p_case_code", OracleDbType.Varchar2, pInfo.Select(o => o.Case_Code).ToArray(), ParameterDirection.Input),
new OracleParameter("p_app_header_id", OracleDbType.Decimal, pInfo.Select(o => o.App_Header_Id).ToArray(), ParameterDirection.Input),
new OracleParameter("p_master_name", OracleDbType.Varchar2, pInfo.Select(o => o.Master_Name).ToArray(), ParameterDirection.Input),
new OracleParameter("p_master_address", OracleDbType.Varchar2, pInfo.Select(o => o.Master_Address).ToArray(), ParameterDirection.Input),
new OracleParameter("p_master_phone", OracleDbType.Varchar2, pInfo.Select(o => o.Master_Phone).ToArray(), ParameterDirection.Input),
new OracleParameter("p_master_fax", OracleDbType.Varchar2, pInfo.Select(o => o.Master_Fax).ToArray(), ParameterDirection.Input),
new OracleParameter("p_master_email", OracleDbType.Varchar2, pInfo.Select(o => o.Master_Email).ToArray(), ParameterDirection.Input),
new OracleParameter("p_tacgiadongthoi", OracleDbType.Varchar2, pInfo.Select(o => o.TacGiaDongThoi).ToArray(), ParameterDirection.Input),
new OracleParameter("p_phoban", OracleDbType.Varchar2, pInfo.Select(o => o.PhoBan).ToArray(), ParameterDirection.Input),
new OracleParameter("p_country_nationality", OracleDbType.Decimal, pInfo.Select(o => o.Country_Nationality).ToArray(), ParameterDirection.Input),
new OracleParameter("p_country_residence", OracleDbType.Decimal, pInfo.Select(o => o.Country_Residence).ToArray(), ParameterDirection.Input),
new OracleParameter("p_country_incorporation", OracleDbType.Decimal, pInfo.Select(o => o.Country_Incorporation).ToArray(), ParameterDirection.Input),
paramReturn);
Oracle.DataAccess.Types.OracleDecimal[] totalReturn = (Oracle.DataAccess.Types.OracleDecimal[])paramReturn.Value;
foreach (Oracle.DataAccess.Types.OracleDecimal _item in totalReturn)
{
if (Convert.ToDecimal(_item.Value.ToString()) < 0)
{
return(Convert.ToDecimal(_item.Value.ToString()));
}
}
return(1);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
// fee
public int Search_Fee_InsertBatch(List <Search_Fix_Info> pInfo, decimal p_search_id, string pLanguage)
{
try
{
int numberRecord = pInfo.Count;
if (numberRecord < 1)
{
return(0);
}
decimal[] _search_id = new decimal[numberRecord];
decimal[] p_country_id = new decimal[numberRecord];
decimal[] p_search_object = new decimal[numberRecord];
decimal[] p_search_type = new decimal[numberRecord];
decimal[] p_number_of_class = new decimal[numberRecord];
decimal[] p_amount = new decimal[numberRecord];
decimal[] p_amount_usd = new decimal[numberRecord];
for (int i = 0; i < pInfo.Count; i++)
{
_search_id[i] = p_search_id;
p_country_id[i] = pInfo[i].Country_Id;
p_search_object[i] = pInfo[i].Search_Object;
p_search_type[i] = pInfo[i].Search_Type;
p_number_of_class[i] = pInfo[i].Number_Of_Class;
p_amount[i] = pInfo[i].Amount;
p_amount_usd[i] = pInfo[i].Amount_usd;
}
var paramReturn = new OracleParameter("p_return", OracleDbType.Int32, ParameterDirection.Output);
paramReturn.Size = 10;
OracleHelper.ExcuteBatchNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "pkg_search_fee.proc_insert", numberRecord,
new OracleParameter("p_search_id", OracleDbType.Decimal, _search_id, ParameterDirection.Input),
new OracleParameter("p_country_id", OracleDbType.Decimal, p_country_id, ParameterDirection.Input),
new OracleParameter("p_search_object", OracleDbType.Decimal, p_search_object, ParameterDirection.Input),
new OracleParameter("p_search_type", OracleDbType.Decimal, p_search_type, ParameterDirection.Input),
new OracleParameter("p_number_of_class", OracleDbType.Decimal, p_number_of_class, ParameterDirection.Input),
new OracleParameter("p_amount", OracleDbType.Decimal, p_amount, ParameterDirection.Input),
new OracleParameter("p_amount_usd", OracleDbType.Decimal, p_amount_usd, ParameterDirection.Input),
paramReturn);
var result = ErrorCode.Error;
Oracle.DataAccess.Types.OracleDecimal[] _ArrReturn = (Oracle.DataAccess.Types.OracleDecimal[])paramReturn.Value;
foreach (Oracle.DataAccess.Types.OracleDecimal _item in _ArrReturn)
{
if (Convert.ToInt32(_item.ToString()) < 0)
{
result = Convert.ToInt32(_item.ToString());
break;
}
else
{
result = ErrorCode.Success;
}
}
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}