public string GetElements(int viewID, long viewStamp, int startIndex, int count) { try { UserRights userRights; AppData.CheckLoggedOn(out userRights); SchemeView schemeView = GetSchemeView(viewID, userRights); ElementsDTO dto = new ElementsDTO(count); dto.ViewStamp = schemeView.Stamp; if (viewStamp == 0 || viewStamp == dto.ViewStamp) { List <SchemeView.Element> srcElems = schemeView.ElementList; int srcCnt = srcElems.Count; dto.EndOfElements = startIndex + count >= srcCnt; for (int i = startIndex, j = 0; i < srcCnt && j < count; i++, j++) { dto.Elements.Add(srcElems[i]); } } return(JsSerializer.Serialize(dto)); } catch (Exception ex) { AppData.Log.WriteException(ex, Localization.UseRussian ? "Ошибка при получении элементов схемы с ид.={0}" : "Error getting the elements of the scheme with ID={0}", viewID); return(GetErrorDtoJs(ex)); } }
public static List <ElementsDTO> GetElements() { DataTable _dt = new DataTable(); List <ElementsDTO> elements = new List <ElementsDTO>(); try { using (MySqlConnection cn = new MySqlConnection(cs)) { cn.Open(); string query = "SELECT Id_element, partie_id, elementLibelle, elementsImg FROM t_elements"; using (MySqlDataAdapter da = new MySqlDataAdapter(query, cn)) { da.SelectCommand.CommandTimeout = 600; da.Fill(_dt); } cn.Close(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } foreach (DataRow row in _dt.Rows) { ElementsDTO element = new ElementsDTO(); element.ID = Convert.ToInt32(row["Id_element"]); element.PartieID = Convert.ToInt32(row["partie_id"]); element.Libelle = row["elementLibelle"].ToString(); element.Image = row["elementsImg"].ToString(); elements.Add(element); } return(elements); }