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);
}
