public response GetAll()
{
try
{
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "DOSARE_STADII_SENTINTEsp_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())
{
DosarStadiuSentinta a = new DosarStadiuSentinta(authenticatedUserId, connectionString, (IDataRecord)r);
aList.Add(a);
}
r.Close(); r.Dispose();
DosarStadiuSentinta[] toReturn = new DosarStadiuSentinta[aList.Count];
for (int i = 0; i < aList.Count; i++)
{
toReturn[i] = (DosarStadiuSentinta)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(string fieldValueCollection)
{
DosarStadiuSentinta tmpItem = JsonConvert.DeserializeObject <DosarStadiuSentinta>(fieldValueCollection); // sa vedem daca merge asa sau trebuie cu JObject
//return JsonConvert.DeserializeObject<DosarStadiuSentinta>(Find(Convert.ToInt32(tmpItem.ID)).Message).Update(fieldValueCollection);
return(((DosarStadiuSentinta)(Find(Convert.ToInt32(tmpItem.ID)).Result)).Update(fieldValueCollection));
}
public response Insert(int _ID_DOSAR_STADIU)
{
response toReturn = Insert();
if (toReturn.Status)
{
this.ID = toReturn.InsertedId;
DosarStadiuSentinta dssj = new DosarStadiuSentinta();
dssj.ID_DOSAR_STADIU = _ID_DOSAR_STADIU;
dssj.ID_SENTINTA = Convert.ToInt32(this.ID);
dssj.Insert();
}
/*
* if (this.Solutie != null)
* {
* response toReturnS = Solutie.Insert();
* if (toReturnS.Status && toReturnS.InsertedId != null)
* {
* this.ID_SOLUTIE = toReturnS.InsertedId;
* //this.UpdateSentinta();
* }
* }
*/
return(toReturn);
}
public response Update(int id, string fieldValueCollection)
{
//DosarStadiuSentinta item = JsonConvert.DeserializeObject<DosarStadiuSentinta>(Find(id).Message);
DosarStadiuSentinta item = (DosarStadiuSentinta)(Find(id).Result);
return(item.Update(fieldValueCollection));
}
/// <summary>
/// Metoda pentru stergerea relatiei Dosare-stadii curente
/// </summary>
/// <returns>SOCISA.response = new object(bool = status, string = error message, int = id-ul cheie returnat)</returns>
public response Delete()
{
response toReturn = new response(false, "", null, null, new List <Error>());;
Sentinta[] sentinte = (Sentinta[])this.GetSentinte().Result;
try
{
foreach (Sentinta sj in sentinte)
{
DosarStadiuSentinta dssj = new DosarStadiuSentinta();
dssj.ID_DOSAR_STADIU = Convert.ToInt32(this.ID);
dssj.ID_SENTINTA = Convert.ToInt32(sj.ID);
dssj.Delete();
sj.Delete();
}
}
catch { }
ArrayList _parameters = new ArrayList();
_parameters.Add(new MySqlParameter("_ID", this.ID));
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "DOSARE_STADIIsp_soft_delete", _parameters.ToArray());
toReturn = da.ExecuteDeleteQuery();
return(toReturn);
}
public response Find(int _id)
{
try
{
DosarStadiuSentinta item = new DosarStadiuSentinta(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 Delete(int _ID_DOSAR_STADIU)
{
response toReturn = new response(true, "", null, null, new List <Error>());;
DosarStadiuSentinta dssj = new DosarStadiuSentinta();
dssj.ID_DOSAR_STADIU = _ID_DOSAR_STADIU;
dssj.ID_SENTINTA = Convert.ToInt32(this.ID);
toReturn = dssj.Delete();
if (toReturn.Status)
{
toReturn = Delete();
/* this.Solutie.Delete(); */
}
return(toReturn);
}
public response GetChildren(DosarStadiuSentinta item, string tableName, int childrenId)
{
return(item.GetChildren(tableName, childrenId));
}
public response GetChildrens(DosarStadiuSentinta item, string tableName)
{
return(item.GetChildrens(tableName));
}
public response Delete(DosarStadiuSentinta item)
{
return(item.Delete());
}
public response Update(DosarStadiuSentinta item)
{
return(item.Update());
}
public response Insert(DosarStadiuSentinta item)
{
return(item.Insert());
}