public response ExportExcel(string _sort, string _order, string _filter, string _limit)
{
try
{
try
{
string newFilter = Filtering.GenerateFilterFromJsonObject(typeof(Proces), _filter, authenticatedUserId, connectionString);
_filter = String.IsNullOrWhiteSpace(newFilter) && !_filter.IsValidJson() ? _filter : String.IsNullOrWhiteSpace(newFilter) ? null : newFilter;
}
catch { }
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "PROCESEsp_export_excel", new object[] {
new MySqlParameter("_SORT", _sort),
new MySqlParameter("_ORDER", _order),
new MySqlParameter("_FILTER", _filter),
new MySqlParameter("_LIMIT", _limit)
});
DataTable toReturn = new DataTable();
MySqlDataReader r = da.ExecuteSelectQuery();
toReturn.Load(r);
r.Close(); r.Dispose(); da.CloseConnection();
return(new response(true, JsonConvert.SerializeObject(toReturn, CommonFunctions.JsonSerializerSettings), toReturn, null, null));
}
catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.ToString(), null, null, new List <Error>()
{
new Error(exp)
})); }
}
public response GetFilteredExtended(string _sort, string _order, string _filter, string _limit)
{
try
{
try
{
string newFilter = Filtering.GenerateFilterFromJsonObject(typeof(Proces), _filter, authenticatedUserId, connectionString);
_filter = String.IsNullOrWhiteSpace(newFilter) && !_filter.IsValidJson() ? _filter : String.IsNullOrWhiteSpace(newFilter) ? null : newFilter;
}
catch { }
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "PROCESEsp_select", new object[] {
new MySqlParameter("_SORT", _sort),
new MySqlParameter("_ORDER", _order),
new MySqlParameter("_FILTER", _filter),
new MySqlParameter("_LIMIT", _limit)
});
List <ProcesExtended> aList = new List <ProcesExtended>();
MySqlDataReader r = da.ExecuteSelectQuery();
while (r.Read())
{
/*
* ProcesExtended pe = new ProcesExtended(new Proces(authenticatedUserId, connectionString, (IDataRecord)r));
* aList.Add(pe);
*/
aList.Add(new ProcesExtended(new Proces(authenticatedUserId, connectionString, r)));
}
r.Close(); r.Dispose(); da.CloseConnection();
return(new response(true, JsonConvert.SerializeObject(aList.ToArray(), CommonFunctions.JsonSerializerSettings), aList.ToArray(), null, null));
}
catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.ToString(), null, null, new List <Error>()
{
new Error(exp)
})); }
}
public response GetFiltered(string _sort, string _order, string _filter, string _limit)
{
try
{
try
{
string newFilter = Filtering.GenerateFilterFromJsonObject(typeof(SedintaPortal), _filter, authenticatedUserId, connectionString);
_filter = newFilter == null ? _filter : newFilter;
}
catch { }
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "SEDINTE_PORTALsp_select", new object[] {
new MySqlParameter("_SORT", _sort),
new MySqlParameter("_ORDER", _order),
new MySqlParameter("_FILTER", _filter),
new MySqlParameter("_LIMIT", _limit)
});
List <SedintaPortal> aList = new List <SedintaPortal>();
MySqlDataReader r = da.ExecuteSelectQuery();
while (r.Read())
{
SedintaPortal a = new SedintaPortal(authenticatedUserId, connectionString, (IDataRecord)r);
aList.Add(a);
}
r.Close(); r.Dispose(); da.CloseConnection();
return(new response(true, JsonConvert.SerializeObject(aList.ToArray(), CommonFunctions.JsonSerializerSettings), aList.ToArray(), null, null));
}
catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.ToString(), null, null, new System.Collections.Generic.List <Error>()
{
new Error(exp)
})); }
}
public response GetFiltered(string _sort, string _order, string _filter, string _limit)
{
try
{
try
{
string newFilter = Filtering.GenerateFilterFromJsonObject(typeof(UtilizatorSetare), _filter, authenticatedUserId, connectionString);
_filter = newFilter == null ? _filter : newFilter;
}
catch { }
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "UTILIZATORI_SETARIsp_select", new object[] {
new MySqlParameter("_SORT", _sort),
new MySqlParameter("_ORDER", _order),
new MySqlParameter("_FILTER", _filter),
new MySqlParameter("_LIMIT", _limit)
});
/*
* ArrayList aList = new ArrayList();
* MySqlDataReader r = da.ExecuteSelectQuery();
* while (r.Read())
* {
* UtilizatorSetare a = new UtilizatorSetare(authenticatedUserId, connectionString, (IDataRecord)r);
* aList.Add(a);
* }
* r.Close(); r.Dispose(); da.CloseConnection();
* UtilizatorSetare[] toReturn = new UtilizatorSetare[aList.Count];
* for (int i = 0; i < aList.Count; i++)
* toReturn[i] = (UtilizatorSetare)aList[i];
* return new response(true, JsonConvert.SerializeObject(toReturn, CommonFunctions.JsonSerializerSettings), toReturn, null, null);
*/
List <UtilizatorSetare> aList = new List <UtilizatorSetare>();
MySqlDataReader r = da.ExecuteSelectQuery();
while (r.Read())
{
UtilizatorSetare a = new UtilizatorSetare(authenticatedUserId, connectionString, (IDataRecord)r);
aList.Add(a);
}
r.Close(); r.Dispose(); da.CloseConnection();
return(new response(true, JsonConvert.SerializeObject(aList.ToArray(), CommonFunctions.JsonSerializerSettings), aList.ToArray(), null, null));
}
catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.ToString(), null, null, new System.Collections.Generic.List <Error>()
{
new Error(exp)
})); }
}
public response CountFiltered(string _sort, string _order, string _filter, string _limit)
{
try
{
try
{
string newFilter = Filtering.GenerateFilterFromJsonObject(typeof(Proces), _filter, authenticatedUserId, connectionString);
_filter = (newFilter == null || newFilter.Trim() == "") && !_filter.IsValidJson() ? _filter : String.IsNullOrWhiteSpace(newFilter) ? null : newFilter;
}
catch { }
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "PROCESEsp_CountFiltered", new object[] {
new MySqlParameter("_SORT", _sort),
new MySqlParameter("_ORDER", _order),
new MySqlParameter("_FILTER", _filter),
new MySqlParameter("_LIMIT", _limit)
});
return(da.ExecuteScalarQuery());
}
catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.ToString(), null, null, new List <Error>()
{
new Error(exp)
})); }
}
public response GetFiltered(string _sort, string _order, string _filter, string _limit)
{
try
{
try
{
string newFilter = Filtering.GenerateFilterFromJsonObject(typeof(Intervenient), _filter, authenticatedUserId, connectionString);
_filter = newFilter == null ? _filter : newFilter;
}
catch { }
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "INTERVENIENTISsp_select", new object[] {
new MySqlParameter("_SORT", _sort),
new MySqlParameter("_ORDER", _order),
new MySqlParameter("_FILTER", _filter),
new MySqlParameter("_LIMIT", _limit)
});
ArrayList aList = new ArrayList();
MySqlDataReader r = da.ExecuteSelectQuery();
while (r.Read())
{
Intervenient a = new Intervenient(authenticatedUserId, connectionString, (IDataRecord)r);
aList.Add(a);
}
r.Close(); r.Dispose();
Intervenient[] toReturn = new Intervenient[aList.Count];
for (int i = 0; i < aList.Count; i++)
{
toReturn[i] = (Intervenient)aList[i];
}
return(new response(true, JsonConvert.SerializeObject(toReturn, CommonFunctions.JsonSerializerSettings), toReturn, null, null));
}
catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.ToString(), null, null, new System.Collections.Generic.List <Error>()
{
new Error(exp)
})); }
}
public string GenerateFilterFromJsonObject()
{
return(Filtering.GenerateFilterFromJsonObject(this));
}
public response GetFiltered(string _sort, string _order, string _filter, string _limit)
{
try
{
#region -- initial --
/*
* string newFilter = null;
* try
* {
* try
* {
* Action x = Newtonsoft.Json.JsonConvert.DeserializeObject<Action>(_filter);
* newFilter = x.GenerateFilterFromJsonObject();
* }
* catch
* {
* try
* {
* dynamic jObj = Newtonsoft.Json.JsonConvert.DeserializeObject(_filter);
* Action x = new Action(authenticatedUserId, connectionString);
* PropertyInfo[] pisX = x.GetType().GetProperties();
* PropertyInfo[] pisJObj = jObj.GetType().GetProperties();
* foreach (PropertyInfo piX in pisX)
* {
* foreach (PropertyInfo piJObj in pisJObj)
* {
* if (piX.Name == piJObj.Name)
* {
* piX.SetValue(x, piJObj.GetValue(jObj));
* break;
* }
* }
* }
* newFilter = x.GenerateFilterFromJsonObject();
* }
* catch { }
* }
* }
* catch { }
* if (newFilter != null) _filter = newFilter;
*/
#endregion
try
{
string newFilter = Filtering.GenerateFilterFromJsonObject(typeof(TipDocument), _filter, authenticatedUserId, connectionString);
_filter = newFilter == null ? _filter : newFilter;
}
catch { }
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "TIP_DOCUMENTsp_select", new object[] {
new MySqlParameter("_SORT", _sort),
new MySqlParameter("_ORDER", _order),
new MySqlParameter("_FILTER", _filter),
new MySqlParameter("_LIMIT", _limit)
});
ArrayList aList = new ArrayList();
MySqlDataReader r = da.ExecuteSelectQuery();
while (r.Read())
{
TipDocument a = new TipDocument(authenticatedUserId, connectionString, (IDataRecord)r);
aList.Add(a);
}
r.Close(); r.Dispose();
TipDocument[] toReturn = new TipDocument[aList.Count];
for (int i = 0; i < aList.Count; i++)
{
toReturn[i] = (TipDocument)aList[i];
}
return(new response(true, JsonConvert.SerializeObject(toReturn, CommonFunctions.JsonSerializerSettings), toReturn, null, null));
}
catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.ToString(), null, null, new System.Collections.Generic.List <Error>()
{
new Error(exp)
})); }
}
public response GetFiltered(string _sort, string _order, string _filter, string _limit)
{
try
{
#region -- initial --
/*
* string newFilter = null;
* try
* {
* try
* {
* EmailNotification x = Newtonsoft.Json.JsonConvert.DeserializeObject<EmailNotification>(_filter);
* newFilter = x.GenerateFilterFromJsonObject();
* }
* catch
* {
* try
* {
* dynamic jObj = Newtonsoft.Json.JsonConvert.DeserializeObject(_filter);
* EmailNotification x = new EmailNotification(authenticatedUserId, connectionString);
* PropertyInfo[] pisX = x.GetType().GetProperties();
* PropertyInfo[] pisJObj = jObj.GetType().GetProperties();
* foreach (PropertyInfo piX in pisX)
* {
* foreach (PropertyInfo piJObj in pisJObj)
* {
* if (piX.Name == piJObj.Name)
* {
* piX.SetValue(x, piJObj.GetValue(jObj));
* break;
* }
* }
* }
* newFilter = x.GenerateFilterFromJsonObject();
* }
* catch { }
* }
* }
* catch { }
* if (newFilter != null) _filter = newFilter;
*/
#endregion
try
{
string newFilter = Filtering.GenerateFilterFromJsonObject(typeof(EmailNotification), _filter, authenticatedUserId, connectionString);
_filter = (newFilter == null || newFilter.Trim() == "") && !_filter.IsValidJson() ? _filter : String.IsNullOrWhiteSpace(newFilter) ? null : newFilter;
}
catch { }
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "EMAIL_NOTIFICATIONS_NEWsp_select", new object[] {
new MySqlParameter("_SORT", _sort),
new MySqlParameter("_ORDER", _order),
new MySqlParameter("_FILTER", _filter),
new MySqlParameter("_LIMIT", _limit)
});
/*
* ArrayList aList = new ArrayList();
* MySqlDataReader r = da.ExecuteSelectQuery();
* while (r.Read())
* {
* EmailNotification a = new EmailNotification(authenticatedUserId, connectionString, (IDataRecord)r);
* aList.Add(a);
* }
* r.Close(); r.Dispose(); da.CloseConnection();
* EmailNotification[] toReturn = new EmailNotification[aList.Count];
* for (int i = 0; i < aList.Count; i++)
* toReturn[i] = (EmailNotification)aList[i];
* return new response(true, JsonConvert.SerializeObject(toReturn, CommonFunctions.JsonSerializerSettings), toReturn, null, null);
*/
List <EmailNotification> aList = new List <EmailNotification>();
MySqlDataReader r = da.ExecuteSelectQuery();
while (r.Read())
{
EmailNotification a = new EmailNotification(authenticatedUserId, connectionString, (IDataRecord)r);
aList.Add(a);
}
r.Close(); r.Dispose(); da.CloseConnection();
return(new response(true, JsonConvert.SerializeObject(aList.ToArray(), CommonFunctions.JsonSerializerSettings), aList.ToArray(), null, null));
}
catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.ToString(), null, null, new System.Collections.Generic.List <Error>()
{
new Error(exp)
})); }
}
