//public static MUserQuery[] Get(Context ctx, int AD_Tab_ID, int AD_Table_ID)
//{
// int AD_Client_ID = ctx.GetAD_Client_ID();
// string sqlQry = "SELECT * FROM AD_UserQuery WHERE"
// + " AD_Client_ID=" + AD_Client_ID + " AND IsActive='Y'"
// + " AND (AD_Tab_ID=" + AD_Tab_ID + " OR AD_Table_ID=" + AD_Table_ID + ")"
// + " ORDER BY Name";
// List<MUserQuery> list = new List<MUserQuery>();
// try
// {
// DataSet ds = ExecuteQuery.ExecuteDataset(sqlQry);
// int iTot = ds.Tables[0].Rows.Count;
// for (int iRow = 0; iRow < iTot; iRow++)
// {
// list.Add(new MUserQuery(ctx, ds.Tables[0].Rows[iRow], null));
// }
// }
// catch (Exception e)
// {
// _log.Log(Level.SEVERE, sql, e);
// }
// MUserQuery[] retValue = new MUserQuery[list.Count];
// //list.ToArray(retValue);
// retValue = list.ToArray();
// return retValue;
//}
//public static MUserQuery Get(Context ctx, int AD_Tab_ID, string name)
//{
// int AD_Client_ID = ctx.GetAD_Client_ID();
// if (name == null)
// name = "%";
// string sqlQry = "SELECT * FROM AD_UserQuery WHERE"
// + " AD_Client_ID=" + AD_Client_ID + " AND AD_Tab_ID=" + AD_Tab_ID + " AND"
// + " UPPER(Name) LIKE '" + name.ToUpper() + "' AND IsActive='Y'"
// + " ORDER BY Name";
// MUserQuery retValue = null;
// try
// {
// DataSet ds = ExecuteQuery.ExecuteDataset(sqlQry);
// int iTot = ds.Tables[0].Rows.Count;
// for (int iRow = 0; iRow < iTot; iRow++)
// {
// retValue = new MUserQuery(ctx, ds.Tables[0].Rows[iRow], null);
// }
// }
// catch (Exception e)
// {
// _log.Log(Level.SEVERE, sql, e);
// }
// return retValue;
//}
//public static List<string> GetSavedQueryNames(int AD_Client_ID, int AD_Tab_ID)
//{
// string sqlQry = "SELECT Name FROM AD_UserQuery WHERE"
// + " AD_Client_ID=" + AD_Client_ID + " AND AD_Tab_ID=" + AD_Tab_ID + " AND IsActive='Y'"
// + " ORDER BY Name";
// List<string> retValue = new List<string>();
// try
// {
// IDataReader dr = ExecuteQuery.ExecuteReader(sqlQry);
// while (dr.Read())
// {
// string name = dr[0].ToString();
// retValue.Add(name);
// }
// dr.Close();
// }
// catch (Exception e)
// {
// _log.Log(Level.SEVERE, sql, e);
// }
// return retValue;
//}
//public static List<string> GetSavedQueryNamesForUser(int AD_User_ID, int AD_Tab_ID)
//{
// string sqlQry = "SELECT Name FROM AD_UserQuery WHERE"
// + " AD_User_ID=" + AD_User_ID + " AND AD_Tab_ID=" + AD_Tab_ID + " AND IsActive='Y'"
// + " ORDER BY Name";
// List<string> retValue = new List<string>();
// try
// {
// IDataReader dr = ExecuteQuery.ExecuteReader(sqlQry);
// while (dr.Read())
// {
// string name = dr[0].ToString();
// retValue.Add(name);
// }
// dr.Close();
// }
// catch (Exception e)
// {
// _log.Log(Level.SEVERE, sql, e);
// }
// return retValue;
//}
//public static MUserQuery GetForUser(Context ctx, int AD_Tab_ID, string name)
//{
// int AD_User_ID = ctx.GetAD_User_ID();
// if (name == null)
// name = "%";
// string sqlQry = "SELECT * FROM AD_UserQuery WHERE"
// + " AD_User_ID=" + AD_User_ID + " AND AD_Tab_ID=" + AD_Tab_ID + " AND"
// + " UPPER(Name) LIKE '" + name.ToUpper() + "' AND IsActive='Y'"
// + " ORDER BY Name";
// MUserQuery retValue = null;
// try
// {
// DataSet ds = ExecuteQuery.ExecuteDataset(sqlQry);
// int iTot = ds.Tables[0].Rows.Count;
// for (int iRow = 0; iRow < iTot; iRow++)
// {
// retValue = new MUserQuery(ctx, ds.Tables[0].Rows[iRow], null);
// }
// }
// catch (Exception e)
// {
// _log.Log(Level.SEVERE, sql, e);
// }
// return retValue;
//}
//public MUserQueryLine[] GetLines(bool isReload)
//{
// if (_lines != null && !isReload)
// return _lines;
// List<MUserQueryLine> list = new List<MUserQueryLine>();
// string sqlQry = "SELECT * FROM AD_UserQueryLine WHERE AD_UserQuery_ID=" + GetAD_UserQuery_ID() + " ORDER BY SeqNo";
// try
// {
// //pstmt = DataBase.prepareStatement(sqlQry, get_TrxName());
// //pstmt.setInt(1, getAD_UserQuery_ID());
// //ResultSet rs = pstmt.executeQuery();
// //while (rs.next())
// // list.add(new MUserQueryLine(getCtx(), rs, get_TrxName()));
// //rs.close();
// //pstmt.close();
// //pstmt = null;
// DataSet ds = ExecuteQuery.ExecuteDataset(sqlQry);
// int iTot = ds.Tables[0].Rows.Count;
// for (int iRow = 0; iRow < iTot; iRow++)
// {
// list.Add(new MUserQueryLine(GetCtx(), ds.Tables[0].Rows[iRow], Get_Trx()));
// }
// }
// catch (Exception e)
// {
// log.Log(Level.SEVERE, sql, e);
// }
// //
// _lines = new MUserQueryLine[list.Count];
// _lines = list.ToArray();
// return _lines;
//}
#endregion
/// <summary>
/// Get query lines of a query
/// </summary>
/// <returns>Dataset</returns>
public DataSet GetQueryLines()
{
DataSet ds = null;
string sql = "SELECT KEYNAME,KEYVALUE,OPERATOR AS OPERATORNAME,VALUE1NAME," +
"VALUE1VALUE,VALUE2NAME,VALUE2VALUE,AD_USERQUERYLINE_ID FROM AD_UserQueryLine WHERE AD_UserQuery_ID=" +
GetAD_UserQuery_ID() + " ORDER BY SeqNo";
try
{
ds = DataBase.DB.ExecuteDataset(sql, null, null);
if (ds != null)
{
ds.Tables[0].Columns.Add("OPERATOR");
DataRow dr;
string optrName = "";
string optr = "";
for (int iRow = 0; iRow < ds.Tables[0].Rows.Count; iRow++)
{
dr = ds.Tables[0].Rows[iRow];
optrName = ds.Tables[0].Rows[iRow]["OPERATORNAME"].ToString();
for (int i = 0; i < Query.OPERATORS.Length; i++)
{
VAdvantage.Model.ValueNamePair pp = Query.OPERATORS[i];
if (pp.GetValue().Equals(optrName))
{
optr = pp.GetName();
break;
}
}
dr[8] = optr;
}
}
}
catch (Exception ex)
{
if (ds != null)
{
ds = null;
}
_log.Log(Level.SEVERE, sql, ex);
}
return(ds);
}
} // rollback
// To get last log error while saving any MClass Suggested by Mukesh Sir and written by Manjot
public virtual string GetRetrievedError(VAdvantage.Model.PO po, string defaultmsg)
{
VAdvantage.Model.ValueNamePair vp = VLogger.RetrieveError();
if (vp != null)
{
string tableName = string.Empty;
string val = vp.GetName();
string connectionName = DataBase.VConnection.Get().Db_uid.ToUpper();
if (val.Contains("."))
{
tableName = Util.GetValueOfString(DB.ExecuteScalar("SELECT Name FROM AD_Table WHERE AD_Table_ID =" + po.Get_Table_ID()));
val = val.Replace(connectionName, string.Empty).Replace(po.Get_TableName().ToUpper(), string.Empty).Replace('"', ' ').Trim();
val = val.Substring(val.IndexOf(":") + 1).Replace(".", string.Empty).Replace(@")(", string.Empty);
}
log.SaveError(Msg.GetMsg(GetCtx(), "VIS_Erroron") + tableName + " :- ", val);
return(Msg.GetMsg(GetCtx(), "VIS_Erroron") + tableName + " :-" + val);
}
log.SaveError(defaultmsg, "");
return(Msg.GetMsg(GetCtx(), defaultmsg));
}
