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)); }