public bool Delete(SPostnaKnjiga data)
{
bool result = false;
using (IDbCommand cmd = database.sqlConnection.GenerateCommand()) {
cmd.CommandType = CommandType.Text;
cmd.CommandText = CommandDelete();
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@RecNo", data.RecNo));
result = database.sqlConnection.ExecDataTableBln(cmd);
}
return(result);
}
public SPostnaKnjiga Load(int id)
{
SPostnaKnjiga result = null;
using (IDbCommand cmd = database.sqlConnection.GenerateCommand()) {
cmd.CommandType = CommandType.Text;
cmd.CommandText = CommandLoad();
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@RecNo", id));
DataTable dtt = database.sqlConnection.ExecDataTable(cmd);
if (dtt != null && dtt.Rows.Count == 1)
{
result = new SPostnaKnjiga();
if (!GDataTypeConverter.ObjectFromDataRow(result, dtt.Rows[0]))
{
result = null;
}
}
}
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);
}
public int Save(SPostnaKnjiga data)
{
int result = 0;
using (IDbCommand cmd = database.sqlConnection.GenerateCommand()) {
cmd.CommandType = CommandType.Text;
if (data.RecNo != 0)
{
cmd.CommandText = CommandUpdate();
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@RecNo", data.RecNo));
}
else
{
cmd.CommandText = CommandInsert();
}
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Datum", data.Datum));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@DatumPotrditve", data.DatumPotrditve));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@DatumVnosa", data.DatumVnosa));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@ImePartnerja", data.ImePartnerja));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Komentar", data.Komentar));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Letalsko", data.Letalsko));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Nujno", data.Nujno));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Odkupnina", data.Odkupnina));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Postnina", data.Postnina));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@SifraPartnerja", data.SifraPartnerja));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Sporocilo", data.Sporocilo));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Teza", data.Teza));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Tip", data.Tip));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Vnasalec", data.Vnasalec));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@VrednostPoste", data.VrednostPoste));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@VrstaPoste", data.VrstaPoste));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Zadeva", data.Zadeva));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Zaposlen", data.Zaposlen));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@ZapSt", data.ZapSt));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Datum1", data.Datum1));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Datum2", data.Datum2));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@eSLOGGUID", data.eSLOGGUID));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@InternaStevilka", data.InternaStevilka));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@MPO", data.MPO));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@PE", data.PE));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@ScanPrenesen", data.ScanPrenesen));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@SlikeOznaka", data.SlikeOznaka));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@SlikeVrsta", data.SlikeVrsta));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@TipPoste", data.TipPoste));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@ZZI", data.ZZI));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@ZZI1", data.ZZI1));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@ZZI2", data.ZZI2));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Likvidacija", data.Likvidacija));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_DateTime_Received", data.Rih_DateTime_Received));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_DateTime_Sent", data.Rih_DateTime_Sent));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_DateTime_Updated", data.Rih_DateTime_Updated));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_gross", data.Rih_gross));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_gross_0", data.Rih_gross_0));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_gross_M", data.Rih_gross_M));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_gross_V", data.Rih_gross_V));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_inv_date", data.Rih_inv_date));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_inv_num", data.Rih_inv_num));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_net", data.Rih_net));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_net_0", data.Rih_net_0));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_net_M", data.Rih_net_M));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_net_V", data.Rih_net_V));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_pay_until", data.Rih_pay_until));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_reference", data.Rih_reference));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_vat", data.Rih_vat));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_vat_0", data.Rih_vat_0));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_vat_id_buyer", data.Rih_vat_id_buyer));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_vat_id_publisher", data.Rih_vat_id_publisher));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_vat_M", data.Rih_vat_M));
cmd.Parameters.Add(database.sqlConnection.GenerateParameter("@Rih_vat_V", data.Rih_vat_V));
result = database.sqlConnection.ExecDataTableInt(cmd);
}
return(result);
}
