/// <summary> /// Save account /// </summary> /// <param name="ctx"></param> /// <param name="AD_Client_ID"></param> /// <param name="AD_Org_ID"></param> /// <param name="C_AcctSchema_ID"></param> /// <param name="AD_Account_ID"></param> /// <param name="C_SubAcct_ID"></param> /// <param name="M_Product_ID"></param> /// <param name="C_BPartner_ID"></param> /// <param name="AD_OrgTrx_ID"></param> /// <param name="C_LocFrom_ID"></param> /// <param name="C_LocTo_ID"></param> /// <param name="C_SRegion_ID"></param> /// <param name="C_Project_ID"></param> /// <param name="C_Campaign_ID"></param> /// <param name="C_Activity_ID"></param> /// <param name="User1_ID"></param> /// <param name="User2_ID"></param> /// <param name="Alias"></param> /// <returns></returns> public AccountingObjects SaveAccount(Ctx ctx, int AD_Client_ID, int AD_Org_ID, int C_AcctSchema_ID, int AD_Account_ID, int C_SubAcct_ID, int M_Product_ID, int C_BPartner_ID, int AD_OrgTrx_ID, int C_LocFrom_ID, int C_LocTo_ID, int C_SRegion_ID, int C_Project_ID, int C_Campaign_ID, int C_Activity_ID, int User1_ID, int User2_ID, string Alias) { AccountingObjects obj = new AccountingObjects(); MAccount acct = MAccount.Get(ctx, AD_Client_ID, AD_Org_ID, C_AcctSchema_ID, AD_Account_ID, C_SubAcct_ID, M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID, C_LocTo_ID, C_SRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, 0, 0); if (acct != null && acct.Get_ID() == 0) { acct.Save(); } // Show Info if (acct == null || acct.Get_ID() == 0) { obj = LoadInfo(0, 0); } else { // Update Account with optional Alias bool found = false; if (Alias.Length > 0) { String sql1 = "SELECT COUNT(*) FROM C_ValidCombination WHERE Alias='" + Alias + "'"; int ii = DB.GetSQLValue(null, sql1); if (ii != 0) { found = true; } else { acct.SetAlias(Alias); acct.Save(); } } if (found) { obj.ErrorMsg = "DuplicateAlias"; } else { //obj = LoadInfo(acct.Get_ID(), C_AcctSchema_ID); obj.C_ValidCombination_ID = acct.Get_ID(); obj.C_AcctSchema_ID = C_AcctSchema_ID; } } return(obj); }
/// <summary> /// Load info for control sttting to return into form /// </summary> /// <param name="C_ValidCombination_ID"></param> /// <param name="C_AcctSchema_ID"></param> /// <returns></returns> private AccountingObjects LoadInfo(int C_ValidCombination_ID, int C_AcctSchema_ID) { AccountingObjects obj = new AccountingObjects(); //log.Fine("C_ValidCombination_ID=" + C_ValidCombination_ID); String sql = "SELECT * FROM C_ValidCombination WHERE C_ValidCombination_ID=" + C_ValidCombination_ID + " AND C_AcctSchema_ID=" + C_AcctSchema_ID; IDataReader dr = null; dr = DB.ExecuteReader(sql); try { if (dr.Read()) { //obj.Alias = Convert.ToString(dr["Alias"]); //obj.Combination = Convert.ToString(dr["Combination"]); //obj.AD_Org_ID = Convert.ToInt32(dr["AD_Org_ID"]); //obj.Account_ID = Convert.ToInt32(dr["Account_ID"]); //obj.C_SubAcct_ID = Convert.ToInt32(dr["C_SubAcct_ID"]); //obj.M_Product_ID = Convert.ToInt32(dr["M_Product_ID"]); //obj.C_BPartner_ID = Convert.ToInt32(dr["C_BPartner_ID"]); //obj.C_Campaign_ID = Convert.ToInt32(dr["C_Campaign_ID"]); //obj.C_LocFrom_ID = Convert.ToInt32(dr["C_LocFrom_ID"]); //obj.C_LocTo_ID = Convert.ToInt32(dr["C_LocTo_ID"]); //obj.C_Project_ID = Convert.ToInt32(dr["C_Project_ID"]); //obj.C_SalesRegion_ID = Convert.ToInt32(dr["C_SalesRegion_ID"]); //obj.AD_OrgTrx_ID = Convert.ToInt32(dr["AD_OrgTrx_ID"]); //obj.C_Activity_ID = Convert.ToInt32(dr["C_Activity_ID"]); //obj.User1_ID = Convert.ToInt32(dr["User1_ID"]); //obj.User2_ID = Convert.ToInt32(dr["User2_ID"]); //obj.Description = Convert.ToString(dr["Description"]); } dr.Close(); dr = null; } catch (Exception) { // log.Log(Level.SEVERE, sql, e); if (dr != null) { dr.Close(); dr = null; } } return(obj); }
/// <summary> /// Save account /// </summary> /// <param name="ctx"></param> /// <param name="AD_Client_ID"></param> /// <param name="AD_Org_ID"></param> /// <param name="C_AcctSchema_ID"></param> /// <param name="AD_Account_ID"></param> /// <param name="C_SubAcct_ID"></param> /// <param name="M_Product_ID"></param> /// <param name="C_BPartner_ID"></param> /// <param name="AD_OrgTrx_ID"></param> /// <param name="C_LocFrom_ID"></param> /// <param name="C_LocTo_ID"></param> /// <param name="C_SRegion_ID"></param> /// <param name="C_Project_ID"></param> /// <param name="C_Campaign_ID"></param> /// <param name="C_Activity_ID"></param> /// <param name="User1_ID"></param> /// <param name="User2_ID"></param> /// <param name="Alias"></param> /// <returns></returns> public AccountingObjects SaveAccount(Ctx ctx, int AD_Client_ID, int AD_Org_ID, int C_AcctSchema_ID, int AD_Account_ID, int C_SubAcct_ID, int M_Product_ID, int C_BPartner_ID, int AD_OrgTrx_ID, int C_LocFrom_ID, int C_LocTo_ID, int C_SRegion_ID, int C_Project_ID, int C_Campaign_ID, int C_Activity_ID, int User1_ID, int User2_ID, int UserElement1_ID, int UserElement2_ID, int UserElement3_ID, int UserElement4_ID, int UserElement5_ID, int UserElement6_ID, int UserElement7_ID, int UserElement8_ID, int UserElement9_ID, string Alias) { AccountingObjects obj = new AccountingObjects(); MAccount acct = null; string qry = "SELECT Count(*) FROM AD_Column WHERE ColumnName = 'UserElement3_ID' AND AD_Table_ID = 176"; if (Util.GetValueOfInt(DBase.DB.ExecuteScalar(qry, null, null)) > 0) { acct = MAccount.Get(ctx, AD_Client_ID, AD_Org_ID, C_AcctSchema_ID, AD_Account_ID, C_SubAcct_ID, M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID, C_LocTo_ID, C_SRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, UserElement1_ID, UserElement2_ID, UserElement3_ID, UserElement4_ID, UserElement5_ID, UserElement6_ID, UserElement7_ID, UserElement8_ID, UserElement9_ID); } else { acct = MAccount.Get(ctx, AD_Client_ID, AD_Org_ID, C_AcctSchema_ID, AD_Account_ID, C_SubAcct_ID, M_Product_ID, C_BPartner_ID, AD_OrgTrx_ID, C_LocFrom_ID, C_LocTo_ID, C_SRegion_ID, C_Project_ID, C_Campaign_ID, C_Activity_ID, User1_ID, User2_ID, UserElement1_ID, UserElement2_ID); } if (acct != null && acct.Get_ID() == 0) { acct.Save(); } // Show Info if (acct == null || acct.Get_ID() == 0) { obj = LoadInfo(0, 0); } else { // Update Account with optional Alias bool found = false; if (Alias.Length > 0) { String sql1 = "SELECT COUNT(*) FROM C_ValidCombination WHERE Alias='" + Alias + "'"; int ii = DB.GetSQLValue(null, sql1); if (ii != 0) { found = true; } else { acct.SetAlias(Alias); acct.Save(); } } if (found) { obj.ErrorMsg = "DuplicateAlias"; } else { //obj = LoadInfo(acct.Get_ID(), C_AcctSchema_ID); obj.C_ValidCombination_ID = acct.Get_ID(); obj.C_AcctSchema_ID = C_AcctSchema_ID; } } return(obj); }