public response Update(string fieldValueCollection)
{
Mesaj tmpItem = JsonConvert.DeserializeObject <Mesaj>(fieldValueCollection); // sa vedem daca merge asa sau trebuie cu JObject
//return JsonConvert.DeserializeObject<Mesaj>(Find(Convert.ToInt32(tmpItem.ID)).Message).Update(fieldValueCollection);
return(((Mesaj)(Find(Convert.ToInt32(tmpItem.ID)).Result)).Update(fieldValueCollection));
}
public response GetAll()
{
try
{
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "MESAJEsp_select", new object[] {
new MySqlParameter("_SORT", null),
new MySqlParameter("_ORDER", null),
new MySqlParameter("_FILTER", null),
new MySqlParameter("_LIMIT", null)
});
ArrayList aList = new ArrayList();
MySqlDataReader r = da.ExecuteSelectQuery();
while (r.Read())
{
Mesaj a = new Mesaj(authenticatedUserId, connectionString, (IDataRecord)r);
aList.Add(a);
}
r.Close(); r.Dispose();
Mesaj[] toReturn = new Mesaj[aList.Count];
for (int i = 0; i < aList.Count; i++)
{
toReturn[i] = (Mesaj)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 Update(int id, string fieldValueCollection)
{
//Mesaj item = JsonConvert.DeserializeObject<Mesaj>(Find(id).Message);
Mesaj item = (Mesaj)(Find(id).Result);
return(item.Update(fieldValueCollection));
}
public MesajExtended(Mesaj m, bool _selected)
{
this.Mesaj = m;
this.TipMesaj = (Nomenclator)m.GetTipMesaj().Result;
this.Sender = (Utilizator)m.GetSender().Result;
this.Receivers = (Utilizator[])m.GetReceivers().Result;
this.Dosar = (Dosar)m.GetDosar().Result;
this.selected = _selected;
}
public response GenerateAndSendMessage(int?IdDosar, DateTime Data, string Subiect, string Body, string TipMesaj, int IdSender, int Importanta)
{
Mesaj mesaj = new Mesaj(authenticatedUserId, connectionString, IdDosar, Data, Subiect, Body, TipMesaj, IdSender, Importanta);
response r = mesaj.Insert();
if (r.Status && r.InsertedId != null)
{
mesaj.ID = r.InsertedId;
r.AddResponse(mesaj.SendToInvolvedParties());
}
return(r);
}
public response Find(int _id)
{
try
{
Mesaj item = new Mesaj(authenticatedUserId, connectionString, _id);
return(new response(true, JsonConvert.SerializeObject(item, CommonFunctions.JsonSerializerSettings), item, 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(Mesaj), _filter, authenticatedUserId, connectionString);
_filter = newFilter == null ? _filter : newFilter;
}
catch { }
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "MESAJEsp_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())
* {
* Mesaj a = new Mesaj(authenticatedUserId, connectionString, (IDataRecord)r);
* aList.Add(a);
* }
* r.Close(); r.Dispose(); da.CloseConnection();
* Mesaj[] toReturn = new Mesaj[aList.Count];
* for (int i = 0; i < aList.Count; i++)
* toReturn[i] = (Mesaj)aList[i];
* return new response(true, JsonConvert.SerializeObject(toReturn, CommonFunctions.JsonSerializerSettings), toReturn, null, null);
*/
List <Mesaj> aList = new List <Mesaj>();
MySqlDataReader r = da.ExecuteSelectQuery();
while (r.Read())
{
Mesaj a = new Mesaj(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 GetDosar(Mesaj item)
{
return(item.GetDosar());
}
public response SendToInvolvedParties(Mesaj item)
{
return(item.SendToInvolvedParties());
}
public response GetReceiversByIdDosar(Mesaj item)
{
return(item.GetReceiversByIdDosar());
}
public response GetChildren(Mesaj item, string tableName, int childrenId)
{
return(item.GetChildren(tableName, childrenId));
}
public response GetReceivers(Mesaj item)
{
return(item.GetReceivers());
}
public response Update(Mesaj item)
{
return(item.Update());
}
public response Insert(Mesaj item)
{
return(item.Insert());
}
public response GetTipMesaj(Mesaj item)
{
return(item.GetTipMesaj());
}
public response SetMessageReadDate(Mesaj item, int idUtilizator, DateTime ReadDate)
{
return(item.SetMessageReadDate(idUtilizator, ReadDate));
}
public response Delete(Mesaj item)
{
return(item.Delete());
}
public response GetSender(Mesaj item)
{
return(item.GetSender());
}
public response GetChildrens(Mesaj item, string tableName)
{
return(item.GetChildrens(tableName));
}
