public void createGJ(GJ oGJ)
{
string sCons = string.Empty;
try
{
string query = MapeoQuerySql.ObtenerPorId("AdminGeneralJournal.createGJ");
sCons = string.Format(query
, oGJ.ID, oGJ.GJ_DATE, oGJ.DESCRIPTION, oGJ.POSTING_DATE, oGJ.TOTAL_DR_AMOUNT
, oGJ.TOTAL_CR_AMOUNT, oGJ.SELL_RATE, oGJ.BUY_RATE, oGJ.SITE_ID, oGJ.CREATE_DATE
, oGJ.USER_ID, oGJ.CURRENCY_ID, oGJ.POST_ALL_TRACKING, oGJ.POST_AS_NATIVE, oGJ.USER_EXCH_RATE, oGJ.POSTING_CANDIDATE);
_trace.AppendLine(sCons);
_oSQL.EjecutarDML(sCons);
}
catch (Exception ex)
{
if (ex.Message.Contains("Violation of PRIMARY KEY constraint 'PK_GJ'"))
{
createGJ_cont_exSQL += 1;
oGJ.getNext_ID(oGJ.SITE_ID, createGJ_cont_exSQL);
if (createGJ_cont_exSQL < 10)
{
createGJ(oGJ);
}
}
else
{
throw new Exception("Error al insertar en GJ. Detalle: " + ex.Message);
}
}
if (createGJ_cont_exSQL != 0)
{
createGJ_cont_exSQL = 0;
}
}
public GJ getGJ()
{
GJ oGJ = new GJ();
oGJ.ID = ID;
oGJ.GJ_DATE = GJ_DATE;
oGJ.DESCRIPTION = DESCRIPTION;
oGJ.POSTING_DATE = POSTING_DATE;
oGJ.TOTAL_DR_AMOUNT = TOTAL_DR_AMOUNT;
oGJ.TOTAL_CR_AMOUNT = TOTAL_CR_AMOUNT;
oGJ.SELL_RATE = SELL_RATE;
oGJ.BUY_RATE = BUY_RATE;
oGJ.ENTITY_ID = ENTITY_ID;
oGJ.CREATE_DATE = CREATE_DATE;
oGJ.USER_ID = USER_ID;
oGJ.CURRENCY_ID = CURRENCY_ID;
oGJ.POST_ALL_TRACKING = POST_ALL_TRACKING;
oGJ.POST_AS_NATIVE = POST_AS_NATIVE;
oGJ.USER_EXCH_RATE = USER_EXCH_RATE;
oGJ.POSTING_CANDIDATE = POSTING_CANDIDATE;
return(oGJ);
}
public GJ getGJ()
{
GJ oGJ = new GJ();
oGJ.ID = _ID;
oGJ.GJ_DATE = _GJ_Date;
oGJ.DESCRIPTION = _Description;
oGJ.POSTING_DATE = _PostingDate;
oGJ.TOTAL_DR_AMOUNT = _Total_DR_Amount;
oGJ.TOTAL_CR_AMOUNT = _Total_CR_Amount;
oGJ.SELL_RATE = _Sell_Rate;
oGJ.BUY_RATE = _Buy_Rate;
oGJ.ENTITY_ID = _EntityID;
oGJ.CREATE_DATE = _Create_Date;
oGJ.USER_ID = _UserID;
oGJ.CURRENCY_ID = _CurrencyID;
oGJ.POST_ALL_TRACKING = _Post_All_Tracking;
oGJ.POST_AS_NATIVE = _Post_As_Native;
oGJ.USER_EXCH_RATE = _User_Exch_Rate;
oGJ.POSTING_CANDIDATE = _Posting_Candidate;
return(oGJ);
}