public response GetPlatiFromLog(DateTime?data) { try { List <object[]> toReturnList = new List <object[]>(); DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "IMPORT_LOG_PLATIsp_GetPlati", new object[] { new MySqlParameter("_DATA_IMPORT", data) }); IDataReader dr = da.ExecuteSelectQuery(); while (dr.Read()) { try { response r = new response(); r.Status = Convert.ToBoolean(dr["STATUS"]); r.Message = dr["MESSAGE"].ToString(); r.InsertedId = Convert.ToInt32(dr["INSERTED_ID"]); r.Error = JsonConvert.DeserializeObject <List <Error> >(dr["ERRORS"].ToString(), CommonFunctions.JsonDeserializerSettings); Plata plata = r.Status ? new Plata(authenticatedUserId, connectionString, Convert.ToInt32(r.InsertedId)) : new Plata(authenticatedUserId, connectionString, Convert.ToInt32(r.InsertedId), true); PlataExtended pe = new PlataExtended(plata); toReturnList.Add(new object[] { r, pe }); } catch (Exception exp) { LogWriter.Log(exp); } } dr.Close(); dr.Dispose(); return(new response(true, JsonConvert.SerializeObject(toReturnList.ToArray(), CommonFunctions.JsonSerializerSettings), toReturnList.ToArray(), null, null)); } catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.Message, null, null, new List <Error>() { new Error(exp) })); } }
public response ImportAll(response responsesPlati, DateTime _date, int _import_type) { try { List <object[]> toReturnList = new List <object[]>(); foreach (object[] responsePlata in (object[])responsesPlati.Result) { PlataExtended plataExtended = (PlataExtended)responsePlata[1]; response response = (response)responsePlata[0]; response r = new response(); if (response.Status) { r = plataExtended.Plata.Insert(); if (!r.Status) { response.Status = false; } } else { r = plataExtended.Plata.InsertWithErrors(); response.Status = false; } response.InsertedId = r.InsertedId; plataExtended.Plata.Log(response, _date, _import_type); toReturnList.Add(new object[] { response, plataExtended }); } return(new response(true, JsonConvert.SerializeObject(toReturnList.ToArray(), CommonFunctions.JsonSerializerSettings), toReturnList.ToArray(), null, null)); } catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.Message, null, null, new List <Error>() { new Error(exp) })); } }