public static SListResponse <T> ListResponse <T>(DataSet data, SListRequest request, bool include_underscores = false) where T : new() { SListResponse <T> lst = new SListResponse <T>(); if (data.Tables[1].Rows.Count == 0) { lst.data = new List <T>(); return(lst); } lst.item_count = data.Tables[1].Rows.Count; lst.items_per_page = request.items_per_page; lst.items_total = int.Parse(data.Tables[0].Rows[0][0].ToString()); lst.page_current = request.current_page; lst.page_count = (int)Math.Ceiling((double)lst.items_total / lst.items_per_page); lst.success = true; lst.data = new List <T>(); foreach (DataRow dr in data.Tables[1].Rows) { T item = new T(); GDataTypeConverter.ObjectFromDataRow(item, dr, include_underscores); lst.data.Add(item); item = default(T); } return(lst); }
public static SListResponse <T> ListResponse <T>(DataTable data, SListRequest request, bool include_underscores = false) where T : new() { SListResponse <T> lst = new SListResponse <T>(); if (data.Rows.Count == 0) { lst.data = new List <T>(); return(lst); } lst.items_total = data.Rows.Count; DataTable dttOut = null; lst.items_per_page = lst.items_total; lst.page_count = 1; lst.page_current = 1; dttOut = data; lst.item_count = dttOut.Rows.Count; lst.data = new List <T>(); foreach (DataRow dr in dttOut.Rows) { T item = new T(); GDataTypeConverter.ObjectFromDataRow(item, dr, include_underscores); lst.data.Add(item); item = default(T); } return(lst); }
public List <SSlike> GetAllSlike(string company_year) { SListRequest lrq = new SListRequest(); SListResponse <SSlike> s = birokrat.Slike.List(new SListRequest()); List <SSlike> data = s.data; data = data.Where((x) => (x.YearCode == company_year)).ToList(); return(data); }
public SListResponse <SSlike> List(SListRequest data) { SListResponse <SSlike> result = null; using (IDbCommand cmd = database.sqlConnection.GenerateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = CommandList(); // TODO : query parameters have to be added manually DataTable dtt = database.sqlConnection.ExecDataTable(cmd); result = GListHelper.ListResponse <SSlike>(dtt, data); } return(result); }
public SListResponse <SCRMStrankeOpcije> List(SListRequest data, Dictionary <string, string> WhereClauses) { SListResponse <SCRMStrankeOpcije> result = null; using (IDbCommand cmd = database.sqlConnection.GenerateCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = CommandList(WhereClauses); // TODO : query parameters have to be added manually DataTable dtt = database.sqlConnection.ExecDataTable(cmd); result = GListHelper.ListResponse <SCRMStrankeOpcije>(dtt, data); } return(result); }
public SSlike AddTestCaseToDatabase(string datum_vnosa, short zap_st, string year_code, string file_path, string tipposte) { // want to add a new test case - my rachuns from airbnb SPostnaKnjiga pk = new SPostnaKnjiga(); pk.Datum = DateTime.Now; pk.DatumVnosa = datum_vnosa; pk.ZapSt = zap_st; pk.YearCode = year_code; pk.TipPoste = tipposte; Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); byte[] arr = File.ReadAllBytes(file_path); string content = Encoding.GetEncoding(1250).GetString(arr); SSlike s = new SSlike(); s.Vsebina = content; s.Oznaka = pk.DatumVnosa + " " + pk.ZapSt; s.YearCode = year_code; s.DatumVnosa = datum_vnosa; pk.SyncId = Guid.NewGuid(); s.SyncId = Guid.NewGuid(); birokrat.PostnaKnjiga.Save(pk); birokrat.Slike.Save(s); SListRequest lrq = new SListRequest(); List <SSlike> slklst = birokrat.Slike.List(lrq).data; foreach (var x in slklst) { if (x.Oznaka == s.Oznaka) { return(x); } } return(null); }