public response GetFiltered(string _sort, string _order, string _filter, string _limit)
{
try
{
try
{
string newFilter = Filtering.GenerateFilterFromJsonObject(typeof(Utilizator), _filter, Convert.ToInt32(authenticatedUserId), connectionString);
_filter = newFilter == null ? _filter : newFilter;
}
catch { }
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "UTILIZATORIsp_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())
* {
* Utilizator a = new Utilizator(Convert.ToInt32(authenticatedUserId), connectionString, (IDataRecord)r);
* aList.Add(a);
* }
* r.Close(); r.Dispose(); da.CloseConnection();
* Utilizator[] toReturn = new Utilizator[aList.Count];
* for (int i = 0; i < aList.Count; i++)
* toReturn[i] = (Utilizator)aList[i];
* return new response(true, JsonConvert.SerializeObject(toReturn, CommonFunctions.JsonSerializerSettings), toReturn, null, null);
*/
List <Utilizator> aList = new List <Utilizator>();
MySqlDataReader r = da.ExecuteSelectQuery();
while (r.Read())
{
Utilizator a = new Utilizator(Convert.ToInt32(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 Login(string user_name, string password, string ip)
{
try
{
Utilizator u = null;
// singura metoda, impreuna cu Find(email), care nu foloseste DataAccess pt. ca nu avem authenticatedUserId
MD5 md5h = MD5.Create();
string md5p = CommonFunctions.GetMd5Hash(md5h, password);
MySqlConnection con = new MySqlConnection(connectionString);
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "LOGINsp";
cmd.Parameters.Add(new MySqlParameter("_username", user_name));
cmd.Parameters.Add(new MySqlParameter("_password", md5p));
cmd.Parameters.Add(new MySqlParameter("_ip", ip));
con.Open();
MySqlDataReader r = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (r.Read())
{
authenticatedUserId = Convert.ToInt32(r["ID"]);
u = new Utilizator(Convert.ToInt32(authenticatedUserId), connectionString, r);
break;
}
r.Close(); r.Dispose();
if (con != null && con.State == ConnectionState.Open)
{
con.Close();
con.Dispose();
}
if (u != null)
{
return(new response(true, JsonConvert.SerializeObject(u), u, null, null));
}
Error err = ErrorParser.ErrorMessage("unauthorisedUser");
return(new response(true, err.ERROR_MESSAGE, null, null, new System.Collections.Generic.List <Error>()
{
err
}));
}
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 Find(string email)
{
try
{
// singura metoda, impreuna cu Login, care nu foloseste DataAccess pt. ca nu avem authenticatedUserId
Utilizator u = null;
MySqlConnection con = new MySqlConnection(connectionString);
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UTILIZATORIsp_GetByEmail";
cmd.Parameters.Add(new MySqlParameter("_EMAIL", email));
con.Open();
MySqlDataReader r = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (r.Read())
{
authenticatedUserId = Convert.ToInt32(r["ID"]);
u = new Utilizator(Convert.ToInt32(authenticatedUserId), connectionString, r);
break;
}
r.Close(); r.Dispose();
if (u != null)
{
return(new response(true, JsonConvert.SerializeObject(u), u, null, null));
}
Error err = ErrorParser.ErrorMessage("unauthorisedUser");
return(new response(false, err.ERROR_MESSAGE, null, null, new List <Error>()
{
err
}));
}
catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.ToString(), null, null, new List <Error>()
{
new Error(exp)
})); }
}
/// <summary>
/// Metoda pt. popularea Destinatarilor mesajului
/// </summary>
/// <returns>vector de SOCISA.UtilizatoriJson</returns>
public response GetReceiversByIdDosar()
{
try
{
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "UTILIZATORIsp_GetByIdDosar", new object[] { new MySqlParameter("_ID_DOSAR", this.ID_DOSAR), new MySqlParameter("_ID_SENDER", this.ID_SENDER) });
IDataReader r = da.ExecuteSelectQuery();
/*
* ArrayList aList = new ArrayList();
* while (r.Read())
* {
* Utilizator a = new Utilizator(authenticatedUserId, connectionString, Convert.ToInt32(r["ID"]));
* aList.Add(a);
* }
* r.Close(); r.Dispose(); da.CloseConnection();
* Utilizator[] toReturn = new Utilizator[aList.Count];
* for (int i = 0; i < aList.Count; i++)
* {
* toReturn[i] = (Utilizator)aList[i];
* }
* return new response(true, Newtonsoft.Json.JsonConvert.SerializeObject(toReturn, CommonFunctions.JsonSerializerSettings), toReturn, null, null);
*/
List <Utilizator> aList = new List <Utilizator>();
while (r.Read())
{
Utilizator a = new Utilizator(authenticatedUserId, connectionString, Convert.ToInt32(r["ID"]));
aList.Add(a);
}
r.Close(); r.Dispose(); da.CloseConnection();
return(new response(true, Newtonsoft.Json.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 GetChildren(Utilizator item, string tableName, int childrenId)
{
return(item.GetChildren(tableName, childrenId));
}
public response GetChildrens(Utilizator item, string tableName)
{
return(item.GetChildrens(tableName));
}
public response SetPassword(Utilizator item, string password)
{
return(item.SetPassword(password));
}
public response Delete(Utilizator item)
{
return(item.Delete());
}
public response Update(Utilizator item)
{
return(item.Update());
}
public response Insert(Utilizator item)
{
return(item.Insert());
}
public response GetDosareNoi(int _id, int id_societate)
{
Utilizator item = new Utilizator(Convert.ToInt32(authenticatedUserId), connectionString, _id);
return(item.GetDosareNoi(id_societate));
}
public response GetDosareNoi(Utilizator item, int id_societate)
{
return(item.GetDosareNoi(id_societate));
}
