/// <summary>
/// This Method fills out an Asset's various properties to be inserted as a single asset into the database.
/// </summary>
/// <param name="dr"></param>
public void Fill(MySql.Data.MySqlClient.MySqlDataReader dr)
{
ID = dr.GetInt32("AssetID");
InventoryNumber = dr.GetString("InventoryNumber");
DatePurchased = dr.GetDateTime("DatePurchased");
DateWarrantyExpires = dr.GetDateTime("DateWarrantyExpires");
DateArchived = dr.GetDateTime("DateArchived");
IsLoanable = dr.GetBoolean("IsLoanable");
IsLoaned = dr.GetBoolean("IsLoaned");
ModelID = dr.GetInt32("ModelID");
StateID = dr.GetInt32("StateID");
LocationID = dr.GetInt32("LocationID");
}
//VALIDATE USER
public User ValidateUser(string userName, string password)
{
User user = new User();
string sql = "SELECT * FROM users WHERE name = @name AND password = @password";
MySql.Data.MySqlClient.MySqlDataReader mySQLReader = null;
MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand(sql, connection);
//Parameters to avoid SQL injection
command.Parameters.AddWithValue("@name", userName);
command.Parameters.AddWithValue("@password", password);
mySQLReader = command.ExecuteReader();
//If the user exists, read and return him
if (mySQLReader.Read())
{
user.Id = mySQLReader.GetInt16(0);
user.Name = mySQLReader.GetString(1);
user.Password = mySQLReader.GetString(2);
user.IsAdmin = mySQLReader.GetBoolean(3);
mySQLReader.Close();
return(user);
}
else
{
return(null);
}
}
/// <summary>
/// Calls DAL function to remove Role from the database.
/// </summary>
/// <remarks></remarks>
#endregion
#region Public Subs
/// <summary>
/// Fills object from a MySqlClient Data Reader
/// </summary>
/// <remarks></remarks>
public override void Fill(MySql.Data.MySqlClient.MySqlDataReader dr)
{
_ID = dr.GetInt32(db_ID);
_Name = dr.GetString(db_Name);
_IsAdmin = dr.GetBoolean(db_IsAdmin);
_Users = new PermissionSet((byte)dr.GetUInt64(db_Users));
_Role = new PermissionSet((byte)dr.GetUInt64(db_Role));
_Assignment = new PermissionSet((byte)dr.GetUInt64(db_Assignment));
}
/// <summary>
/// Get DB Bool
/// </summary>
/// <param name="rdr">SqlDataReader</param>
/// <param name="ordinal">Field Indx</param>
/// <returns>Field Value</returns>
public static bool GetDBBool(SqlDataReader rdr, int ordinal)
{
bool s = false;
try
{
if (!rdr.IsDBNull(ordinal))
{
s = rdr.GetBoolean(ordinal);
}
}
catch (Exception ex)
{
throw ex;
}
return(s);
}
/// <summary>
/// Get DB Bool
/// </summary>
/// <param name="rdr">SqlDataReader</param>
/// <param name="fieldname">Field Name</param>
/// <returns>Field Value</returns>
public static bool GetDBBool(SqlDataReader rdr, string fieldname)
{
bool s = false;
try
{
int ordinal = 0;
ordinal = rdr.GetOrdinal(fieldname);
if (!rdr.IsDBNull(ordinal))
{
s = rdr.GetBoolean(ordinal);
}
}
catch (Exception ex)
{
throw ex;
}
return(s);
}
public static Ljekar CreateLjekarFromReader(MySql.Data.MySqlClient.MySqlDataReader dr)
{
Ljekar ljekar = null;
try
{
ljekar = new Ljekar(dr.GetInt32("ID"));
ljekar.Ime = dr.IsDBNull(dr.GetOrdinal("Ime")) ? String.Empty : dr.GetString("Ime");
ljekar.Sifra = dr.IsDBNull(dr.GetOrdinal("Sifra")) ? String.Empty : dr.GetString("Sifra");
ljekar.Aktivan = dr.IsDBNull(dr.GetOrdinal("Aktivan")) ? false : dr.GetBoolean("Aktivan");
SetBaseProps <Ljekar>(ljekar, dr);
return(ljekar);
}
catch (System.Exception ex)
{
Logging.Log.Create("Greška u kreiranju objekta Ljekar iz readera.",
Logging.LogEntryLevel.Critical, ex);
}
return(null);
}
// Visibilidad para que sea visto por otras clases internal - como protected.
internal Partido Retrieve()
{
//Class1 c = new Class1(1, "aaa", 1995, 2);
MySql.Data.MySqlClient.MySqlConnection c = Connect();
MySql.Data.MySqlClient.MySqlCommand cmd = c.CreateCommand();
cmd.CommandText = " select * from futbol";
c.Open();
MySql.Data.MySqlClient.MySqlDataReader res = cmd.ExecuteReader();
Partido c1 = null;
if (res.Read())
{
Debug.WriteLine("Recupera: " + res.GetInt32(0) + " " + res.GetString(1) + " " +
res.GetString(2) + " " + res.GetString(3) + " ");
c1 = new Partido(res.GetInt32(0), res.GetString(1), res.GetBoolean(2), res.GetString(3));
}
c.Close();
return(c1);
}
//READ ALL USERS
public ArrayList GetUsers()
{
ArrayList users = new ArrayList();
string sql = "SELECT * FROM users";
MySql.Data.MySqlClient.MySqlDataReader mySQLReader = null;
MySql.Data.MySqlClient.MySqlCommand command = new MySql.Data.MySqlClient.MySqlCommand(sql, connection);
mySQLReader = command.ExecuteReader();
//While there were users, keep reading them
while (mySQLReader.Read())
{
User user = new User();
user.Id = mySQLReader.GetInt16(0);
user.Name = mySQLReader.GetString(1);
user.Password = mySQLReader.GetString(2);
user.IsAdmin = mySQLReader.GetBoolean(3);
users.Add(user);
}
return(users);
}
public static string getInserts(string sourceTable, MySql.Data.MySqlClient.MySqlDataReader Reader)
{
string insertSql = "";
string add = "";
string addTableString = ""; // if option addTablename set her was set the tablename to adding idendtifier
addTableString = sourceTable + ".";
for (int i = 0; i < Reader.FieldCount; i++)
{
if (i == 0)
{
insertSql = "INSERT INTO " + sourceTable + " SET ";
}
System.Type fType = Reader.GetFieldType(i);
Object chk = null;
try
{
chk = Reader.GetValue(i);
}
catch (Exception)
{
//throw;
}
if (chk != null)
{
int hash = chk.GetHashCode();
string dd = chk.ToString();
if (chk != null && dd != "")
{
switch (fType.Name)
{
case "Int32":
case "UInt32":
case "Int64":
case "UInt64":
Int64 val = Reader.GetInt64(i);
insertSql += add + addTableString + Reader.GetName(i) + " = " + val;
break;
case "Single":
case "Float":
float fVal = Reader.GetFloat(i);
insertSql += add + addTableString + Reader.GetName(i) + " = '" + fVal.ToString().Replace(',', '.') + "'";
break;
case "Double":
double dVal = Reader.GetDouble(i);
insertSql += add + addTableString + Reader.GetName(i) + " = '" + dVal.ToString().Replace(',', '.') + "'";
break;
case "DateTime":
DateTime dt = Reader.GetDateTime(i);
String dtValue = zeroValue(dt.Year) + "-" + zeroValue(dt.Month) + "-" + zeroValue(dt.Day) + " " + dt.TimeOfDay;
insertSql += add + addTableString + Reader.GetName(i) + " = '" + dtValue + "'";
break;
case "Boolean":
bool bval = Reader.GetBoolean(i);
if (bval)
{
insertSql += add + Reader.GetName(i) + " = 1";
}
else
{
insertSql += add + addTableString + Reader.GetName(i) + " = 0";
}
break;
default:
string sval = Reader.GetString(i).Replace("'", @"\'");
insertSql += add + addTableString + Reader.GetName(i) + " = '" + sval + "'";
break;
}
add = ",";
}
}
}
return(insertSql);
}
public Int64 copyValues(MysqlHandler connection, string sourceTable, Int64 start, MysqlHandler targetConnection)
{
Int64 count = 0;
Int64 refresher = 0;
List <MysqlStruct> Struct = connection.getAllFieldsStruct(sourceTable);
string addToField = sourceTable + ".";
if (showProgress && msg.Visible)
{
msg.progressBar.Maximum = (int)this.copyRowLimit + 1;
}
if (connection.isConnected())
{
MySql.Data.MySqlClient.MySqlDataReader Reader =
connection.sql_select("SELECT * FROM " + sourceTable + " LIMIT " + start + "," + this.copyRowLimit);
if (Reader != null)
{
//if (Reader.RecordsAffected==-1) return 0;
while (Reader.Read())
{
count++;
refresher++;
string insertSql = "INSERT INTO " + sourceTable + " SET ";
string add = "";
for (int i = 0; i < Reader.FieldCount; i++)
{
if (refresher > 1000)
{
if (showProgress && msg.Visible)
{
msg.msg.Text = "Copying Table " + sourceTable + " block: " + start + "/" + count;
msg.progressBar.Value = (int)count;
msg.progressBar.Refresh();
msg.Refresh();
msg.Focus();
}
refresher = 0;
}
System.Type fType = Reader.GetFieldType(i);
Object chk = null;
try
{
chk = Reader.GetValue(i);
}
catch (Exception)
{
//throw;
}
if (chk != null)
{
int hash = chk.GetHashCode();
string dd = chk.ToString();
if (chk != null && dd != "")
{
switch (fType.Name)
{
case "Int32":
case "UInt32":
case "Int64":
case "UInt64":
Int64 val = Reader.GetInt64(i);
insertSql += add + addToField + Struct[i].name + " = " + val;
break;
case "Single":
case "Float":
float fVal = Reader.GetFloat(i);
insertSql += add + addToField + Struct[i].name + " = '" + fVal.ToString().Replace(',', '.') + "'";
break;
case "Double":
double dVal = Reader.GetDouble(i);
insertSql += add + addToField + Struct[i].name + " = '" + dVal.ToString().Replace(',', '.') + "'";
break;
case "DateTime":
DateTime dt = Reader.GetDateTime(i);
String dtValue = zeroVal(dt.Year) + "-" + zeroVal(dt.Month) + "-" + zeroVal(dt.Day) + " " + dt.TimeOfDay;
insertSql += add + addToField + Struct[i].name + " = '" + dtValue + "'";
break;
case "Boolean":
bool bval = Reader.GetBoolean(i);
if (bval)
{
insertSql += add + addToField + Struct[i].name + " = 1";
}
else
{
insertSql += add + addToField + Struct[i].name + " = 0";
}
break;
default:
string sval = Reader.GetString(i).Replace("'", @"\'");
insertSql += add + addToField + Struct[i].name + " = '" + sval + "'";
break;
}
add = ",";
}
}
}
//returnValue += insertSql + ";\n";
targetConnection.sql_update(insertSql);
}
Reader.Close();
}
}
return(count);
}
public static Roba CreateRobaFromReader(MySql.Data.MySqlClient.MySqlDataReader dr)
{
Roba roba = null;
try
{
roba = new Roba(dr.GetInt32("ID"));
roba.Sifra = dr["Sifra"].GetType() == typeof(System.DBNull) ? String.Empty : dr.GetString("Sifra");
roba.Naziv = dr["Naziv"].GetType() == typeof(System.DBNull) ? String.Empty : dr.GetString("Naziv");
roba.ProizvodjacID = dr["ProizvodjacID"].GetType() == typeof(System.DBNull) ? 0 : dr.GetInt32("ProizvodjacID");
roba.FakturnaCijena = dr["FakturnaCijena"].GetType() == typeof(System.DBNull) ? 0 : dr.GetDecimal("FakturnaCijena");
roba.PDVStopaID = dr["PDVStopaID"].GetType() == typeof(System.DBNull) ? 0 : dr.GetInt32("PDVStopaID");
roba.PocetnoStanje = dr["PocetnoStanje"].GetType() == typeof(System.DBNull) ? 0 : dr.GetDecimal("PocetnoStanje");
roba.Ulaz = dr["Ulaz"].GetType() == typeof(System.DBNull) ? 0 : dr.GetDecimal("Ulaz");
roba.Izlaz = dr["Izlaz"].GetType() == typeof(System.DBNull) ? 0 : dr.GetDecimal("Izlaz");
roba.Zaliha = dr["Zaliha"].GetType() == typeof(System.DBNull) ? 0 : dr.GetDecimal("Zaliha");
roba.ReferalnaCijena = dr["ReferalnaCijena"].GetType() == typeof(System.DBNull) ? 0 : dr.GetDecimal("ReferalnaCijena");
roba.ATC = dr["ATC"].GetType() == typeof(System.DBNull) ? String.Empty : dr.GetString("ATC");
roba.Participacija = dr["Participacija"].GetType() == typeof(System.DBNull) ? 0 : dr.GetInt32("Participacija");
roba.Opis = dr["Opis"].GetType() == typeof(System.DBNull) ? String.Empty : dr.GetString("Opis");
roba.MPC = dr["MPC"].GetType() == typeof(System.DBNull) ? 0 : dr.GetDecimal("MPC");
roba.Popust = dr["Popust"].GetType() == typeof(System.DBNull) ? 0 : dr.GetDecimal("Popust");
roba.DoplataBezPDV = dr["DoplataBezPDV"].GetType() == typeof(System.DBNull) ? 0 : dr.GetDecimal("DoplataBezPDV");
roba.DoplataSaPDV = dr["DoplataSaPDV"].GetType() == typeof(System.DBNull) ? 0 : dr.GetDecimal("DoplataSaPDV");
roba.RezimIzdavanja = dr["RezimIzdavanja"].GetType() == typeof(System.DBNull) ? String.Empty : dr.GetString("RezimIzdavanja");
roba.MjeraID = dr["MjeraID"].GetType() == typeof(System.DBNull) ? 0 : dr.GetInt32("MjeraID");
roba.StopaMarze = dr["StopaMarze"].GetType() == typeof(System.DBNull) ? 0 : dr.GetDecimal("StopaMarze");
roba.VrstaProskripcije = dr["VrstaProskripcije"].GetType() == typeof(System.DBNull) ? 0 : (VrstaProskripcije)dr.GetInt32("VrstaProskripcije");
roba.Taksa = dr["Taksa"].GetType() == typeof(System.DBNull) ? false : dr.GetBoolean("Taksa");
if (!dr.IsDBNull(dr.GetOrdinal("DatumCijene")))
{
roba.DatumCijene = dr.GetDateTime("DatumCijene");
}
if (dr["Oznaka"].GetType() == typeof(System.DBNull) ||
String.IsNullOrEmpty(dr["Oznaka"].ToString()))
{
roba.Oznaka = ' ';
}
else
{
roba.Oznaka = dr.GetChar("Oznaka");
}
roba.TipRobeID = dr.IsDBNull(dr.GetOrdinal("TipRobeID")) ? 0 : dr.GetInt32("TipRobeID");
SetBaseProps <Roba>(roba, dr);
return(roba);
}
catch (System.Exception ex)
{
Logging.Log.Create("Greška u kreiranju objekta Roba iz readera.",
Logging.LogEntryLevel.Critical, ex);
}
return(null);
}
public static Normativ CreateNormativFromReader(MySql.Data.MySqlClient.MySqlDataReader dr)
{
Normativ normativ = null;
try
{
normativ = new Normativ(dr.GetInt32("ID"));
normativ.RobaID = dr.IsDBNull(dr.GetOrdinal("RobaID")) ? 0 : dr.GetInt32("RobaID");
normativ.MaterijalRobaID = dr.IsDBNull(dr.GetOrdinal("MaterijalRobaID")) ? 0 : dr.GetInt32("MaterijalRobaID");
normativ.NormativVrijednost = dr.IsDBNull(dr.GetOrdinal("Normativ")) ? 0 : dr.GetDecimal("Normativ");
normativ.PoslovnaJedinica = dr.IsDBNull(dr.GetOrdinal("PoslovnaJedinica")) ? 0 : dr.GetInt32("PoslovnaJedinica");
normativ.Taksa = dr.IsDBNull(dr.GetOrdinal("Taksa")) ? false : dr.GetBoolean("Taksa");
SetBaseProps <Normativ>(normativ, dr);
return(normativ);
}
catch (System.Exception ex)
{
Logging.Log.Create("Greška u kreiranju objekta Normativ iz readera.",
Logging.LogEntryLevel.Critical, ex);
}
return(null);
}
public static MagistralaNalogStavka CreateMagistralaNalogStavkaFromReader(MySql.Data.MySqlClient.MySqlDataReader dr)
{
MagistralaNalogStavka stavkaNaloga = null;
try
{
stavkaNaloga = new MagistralaNalogStavka(dr.GetInt32("ID"));
stavkaNaloga.MaterijalRobaID = dr.IsDBNull(dr.GetOrdinal("MaterijalRobaID")) ? 0 : dr.GetInt32("MaterijalRobaID");
stavkaNaloga.MagistralaNalogID = dr.IsDBNull(dr.GetOrdinal("MagNalogID")) ? 0 : dr.GetInt32("MagNalogID");
stavkaNaloga.Kolicina = dr.IsDBNull(dr.GetOrdinal("Kolicina")) ? 0 : dr.GetDecimal("Kolicina");
stavkaNaloga.Normativ = dr.IsDBNull(dr.GetOrdinal("Normativ")) ? 0 : dr.GetDecimal("Normativ");
stavkaNaloga.Iznos = dr.IsDBNull(dr.GetOrdinal("Iznos")) ? 0 : dr.GetDecimal("Iznos");
stavkaNaloga.Cijena = dr.IsDBNull(dr.GetOrdinal("Cijena")) ? 0 : dr.GetDecimal("Cijena");
stavkaNaloga.Taksa = dr.IsDBNull(dr.GetOrdinal("Taksa")) ? false : dr.GetBoolean("Taksa");
SetBaseProps <MagistralaNalogStavka>(stavkaNaloga, dr);
return(stavkaNaloga);
}
catch (System.Exception ex)
{
Logging.Log.Create("Greška u kreiranju objekta Normativ iz readera.",
Logging.LogEntryLevel.Critical, ex);
}
return(null);
}
public static Korisnik CreateKorisnikFromReader(MySql.Data.MySqlClient.MySqlDataReader dr)
{
Korisnik korisnik = null;
try
{
korisnik = new Korisnik(dr.GetInt32("ID"));
korisnik.Ime = dr.IsDBNull(dr.GetOrdinal("Ime")) ? String.Empty : dr.GetString("Ime");
korisnik.Prezime = dr.IsDBNull(dr.GetOrdinal("Prezime")) ? String.Empty : dr.GetString("Prezime");
korisnik.KorisnickoIme = dr.IsDBNull(dr.GetOrdinal("KorisnickoIme")) ? String.Empty : dr.GetString("KorisnickoIme");
korisnik.Lozinka = dr.IsDBNull(dr.GetOrdinal("Lozinka")) ? String.Empty : dr.GetString("Lozinka");
korisnik.EMail = dr.IsDBNull(dr.GetOrdinal("EMail")) ? String.Empty : dr.GetString("EMail");
korisnik.TitulaID = dr.IsDBNull(dr.GetOrdinal("TitulaID")) ? 0 : dr.GetInt32("TitulaID");
korisnik.IsAdmin = dr.IsDBNull(dr.GetOrdinal("Admin")) ? false : dr.GetBoolean("Admin");
SetBaseProps <Korisnik>(korisnik, dr);
return(korisnik);
}
catch (System.Exception ex)
{
Logging.Log.Create("Greška u kreiranju objekta Korisnik iz readera.",
Logging.LogEntryLevel.Critical, ex);
}
return(null);
}
public static Smjena CreateSmjenaFromReader(MySql.Data.MySqlClient.MySqlDataReader dr)
{
Smjena smjena = null;
try
{
smjena = new Smjena(dr.GetInt32("ID"));
smjena.VrijemeOtvaranja = dr.IsDBNull(dr.GetOrdinal("VrijemeOtvaranja")) ? DateTime.MinValue : dr.GetDateTime("VrijemeOtvaranja");
smjena.VrijemeZatvaranja = dr.IsDBNull(dr.GetOrdinal("VrijemeZatvaranja")) ? DateTime.MinValue : dr.GetDateTime("VrijemeZatvaranja");
smjena.Broj = dr.IsDBNull(dr.GetOrdinal("Broj")) ? 0 : dr.GetInt32("Broj");
smjena.OdgovornoLiceID = dr.IsDBNull(dr.GetOrdinal("OdgovornoLiceID")) ? 0 : dr.GetInt32("OdgovornoLiceID");
smjena.Ukupno = dr.IsDBNull(dr.GetOrdinal("Ukupno")) ? 0 : dr.GetDecimal("Ukupno");
smjena.Zatvorena = dr.IsDBNull(dr.GetOrdinal("Zatvorena")) ? false : dr.GetBoolean("Zatvorena");
SetBaseProps <Smjena>(smjena, dr);
return(smjena);
}
catch (System.Exception ex)
{
Logging.Log.Create("Greška u kreiranju objekta Smjena iz readera.",
Logging.LogEntryLevel.Critical, ex);
}
return(null);
}
public static RacunStavka CreateStavkaRacunaFromReader(MySql.Data.MySqlClient.MySqlDataReader dr)
{
RacunStavka stavkaRacuna = null;
try
{
stavkaRacuna = new RacunStavka(dr.GetInt32("ID"));
stavkaRacuna.RacunID = dr.IsDBNull(dr.GetOrdinal("RacunID")) ? 0 : dr.GetInt32("RacunID");
stavkaRacuna.RobaID = dr.IsDBNull(dr.GetOrdinal("RobaID")) ? 0 : dr.GetInt32("RobaID");
//stavkaRacuna.MjeraID = 0;
stavkaRacuna.Kolicina = dr.IsDBNull(dr.GetOrdinal("Kolicina")) ? 0 : dr.GetDecimal("Kolicina");
stavkaRacuna.PDVStopa = dr.IsDBNull(dr.GetOrdinal("PDVStopa")) ? 0 : dr.GetDecimal("PDVStopa");
stavkaRacuna.Participacija = dr.IsDBNull(dr.GetOrdinal("Participacija")) ? 0 : dr.GetInt32("Participacija");
stavkaRacuna.ReferalnaCijena = dr.IsDBNull(dr.GetOrdinal("ReferalnaCijena")) ? 0 : dr.GetDecimal("ReferalnaCijena");
stavkaRacuna.Popust = dr.IsDBNull(dr.GetOrdinal("Popust")) ? 0 : dr.GetDecimal("Popust");
stavkaRacuna.IznosPopusta = dr.IsDBNull(dr.GetOrdinal("IznosPopusta")) ? 0 : dr.GetDecimal("IznosPopusta");
stavkaRacuna.DoplataBezPDV = dr.IsDBNull(dr.GetOrdinal("DoplataBezPDV")) ? 0 : dr.GetDecimal("DoplataBezPDV");
stavkaRacuna.DoplataSaPDV = dr.IsDBNull(dr.GetOrdinal("DoplataSaPDV")) ? 0 : dr.GetDecimal("DoplataSaPDV");
stavkaRacuna.Cijena = dr.IsDBNull(dr.GetOrdinal("Cijena")) ? 0 : dr.GetDecimal("Cijena");
stavkaRacuna.Vrijednost = dr.IsDBNull(dr.GetOrdinal("Vrijednost")) ? 0 : dr.GetDecimal("Vrijednost");
stavkaRacuna.Iznos = dr.IsDBNull(dr.GetOrdinal("Iznos")) ? 0 : dr.GetDecimal("Iznos");
stavkaRacuna.BrojRecepta = dr.IsDBNull(dr.GetOrdinal("BrojRecepta")) ? String.Empty : dr.GetString("BrojRecepta");
stavkaRacuna.LjekarID = dr.IsDBNull(dr.GetOrdinal("LjekarID")) ? 0 : dr.GetInt32("LjekarID");
stavkaRacuna.VrstaID = dr.IsDBNull(dr.GetOrdinal("VrstaID")) ? 0 : dr.GetInt32("VrstaID");
stavkaRacuna.Pausal = dr.IsDBNull(dr.GetOrdinal("Pausal")) ? 0 : dr.GetDecimal("Pausal");
stavkaRacuna.JMBG = dr.IsDBNull(dr.GetOrdinal("JMBG")) ? String.Empty : dr.GetString("JMBG");
stavkaRacuna.Izlaz = dr.IsDBNull(dr.GetOrdinal("Izlaz")) ? 0 : dr.GetDecimal("Izlaz");
stavkaRacuna.Zaliha = dr.IsDBNull(dr.GetOrdinal("Zaliha")) ? 0 : dr.GetDecimal("Zaliha");
stavkaRacuna.IznosTakse = dr.IsDBNull(dr.GetOrdinal("IznosTakse")) ? 0 : dr.GetDecimal("IznosTakse");
stavkaRacuna.BrJedinica = dr.IsDBNull(dr.GetOrdinal("BrJedinica")) ? 0 : dr.GetInt32("BrJedinica");
stavkaRacuna.IznosKupac = dr.IsDBNull(dr.GetOrdinal("IznosKupac")) ? 0 : dr.GetDecimal("IznosKupac");
stavkaRacuna.IznosKzzo = dr.IsDBNull(dr.GetOrdinal("IznosKzzo")) ? 0 : dr.GetDecimal("IznosKzzo");
stavkaRacuna.Stornirano = dr.IsDBNull(dr.GetOrdinal("Stornirano")) ? false : dr.GetBoolean("Stornirano");
stavkaRacuna.DatumPropisivanja = dr.IsDBNull(dr.GetOrdinal("DatumPropisivanja")) ? DateTime.MinValue : dr.GetDateTime("DatumPropisivanja");
stavkaRacuna.PonovljenRecept = dr.IsDBNull(dr.GetOrdinal("PonovljenRecept")) ? 0 : dr.GetInt32("PonovljenRecept");
stavkaRacuna.PropisanaKolicina = dr.IsDBNull(dr.GetOrdinal("PropisanaKolicina")) ? 0 : dr.GetDecimal("PropisanaKolicina");
SetBaseProps <RacunStavka>(stavkaRacuna, dr);
return(stavkaRacuna);
}
catch (System.Exception ex)
{
Logging.Log.Create("Greška u kreiranju objekta RacunStavka iz readera.",
Logging.LogEntryLevel.Critical, ex);
}
return(null);
}
public static Racun CreateRacunFromReader(MySql.Data.MySqlClient.MySqlDataReader dr)
{
Racun racun = null;
try
{
racun = new Racun(dr.GetInt32("ID"));
racun.Datum = dr.IsDBNull(dr.GetOrdinal("Datum")) ? DateTime.MinValue : dr.GetDateTime("Datum");
racun.Vrijednost = dr.IsDBNull(dr.GetOrdinal("Vrijednost")) ? 0 : dr.GetDecimal("Vrijednost");
racun.Iznos = dr.IsDBNull(dr.GetOrdinal("Iznos")) ? 0 : dr.GetDecimal("Iznos");
racun.IznosPopusta = dr.IsDBNull(dr.GetOrdinal("IznosPopusta")) ? 0 : dr.GetDecimal("IznosPopusta");
racun.DoplataSaPDV = dr.IsDBNull(dr.GetOrdinal("DoplataSaPDV")) ? 0 : dr.GetDecimal("DoplataSaPDV");
racun.NacinPlacanja = dr["NacinPlacanja"].GetType() == typeof(System.DBNull) ? 0 : (NacinPlacanja)dr.GetInt32("NacinPlacanja");
racun.SmjenaID = dr["SmjenaID"].GetType() == typeof(System.DBNull) ? 0 : dr.GetInt32("SmjenaID");
racun.Isprintan = dr["Isprintan"].GetType() == typeof(System.DBNull) ? false : dr.GetBoolean("Isprintan");
racun.Storniran = dr["Storniran"].GetType() == typeof(System.DBNull) ? false : dr.GetBoolean("Storniran");
racun.KomitentID = dr["KomitentID"].GetType() == typeof(System.DBNull) ? 0 : dr.GetInt32("KomitentID");
racun.Zaokruzenje = dr.IsDBNull(dr.GetOrdinal("Zaokruzenje")) ? 0 : dr.GetDecimal("Zaokruzenje");
//jasenko tring
racun.BrojFisk = dr["BrojFisk"].GetType() == typeof(System.DBNull) ? 0 : dr.GetInt32("BrojFisk");
racun.BrojKase = dr["BrojKase"].GetType() == typeof(System.DBNull) ? 0 : dr.GetInt32("BrojKase");
racun.FiskalniIznos = dr.IsDBNull(dr.GetOrdinal("FiskalniIznos")) ? 0 : dr.GetDecimal("FiskalniIznos");
racun.FiskalniDatum = dr.IsDBNull(dr.GetOrdinal("FiskalniDatum")) ? DateTime.MinValue : dr.GetDateTime("FiskalniDatum");
SetBaseProps <Racun>(racun, dr);
return(racun);
}
catch (System.Exception ex)
{
Logging.Log.Create("Greška u kreiranju objekta Racun iz readera.",
Logging.LogEntryLevel.Critical, ex);
}
return(null);
}
public static MagistralaNalog CreateNalogFromReader(MySql.Data.MySqlClient.MySqlDataReader dr)
{
MagistralaNalog nalog = null;
try
{
nalog = new MagistralaNalog(dr.GetInt32("ID"));
nalog.Datum = dr.IsDBNull(dr.GetOrdinal("Datum")) ? DateTime.MinValue : dr.GetDateTime("Datum");
nalog.RobaID = dr.IsDBNull(dr.GetOrdinal("RobaID")) ? 0 : dr.GetInt32("RobaID");
nalog.Kolicina = dr.IsDBNull(dr.GetOrdinal("Kolicina")) ? 0 : dr.GetDecimal("Kolicina");
nalog.VrijednostSastojaka = dr.IsDBNull(dr.GetOrdinal("VrijednostSastojaka")) ? Decimal.Zero : dr.GetDecimal("VrijednostSastojaka");
nalog.IznosTaksi = dr.IsDBNull(dr.GetOrdinal("IznosTaksi")) ? Decimal.Zero : dr.GetDecimal("IznosTaksi");
nalog.Odstupanje = dr.IsDBNull(dr.GetOrdinal("Odstupanje")) ? Decimal.Zero : dr.GetDecimal("Odstupanje");
nalog.Cijena = dr.IsDBNull(dr.GetOrdinal("Cijena")) ? Decimal.Zero : dr.GetDecimal("Cijena");
nalog.Iznos = dr.IsDBNull(dr.GetOrdinal("Iznos")) ? Decimal.Zero : dr.GetDecimal("Iznos");
nalog.PoslovnaJedinica = dr.IsDBNull(dr.GetOrdinal("PoslovnaJedinica")) ? 0 : dr.GetInt32("PoslovnaJedinica");
nalog.Storniran = dr.IsDBNull(dr.GetOrdinal("Storniran")) ? false : dr.GetBoolean("Storniran");
SetBaseProps <MagistralaNalog>(nalog, dr);
return(nalog);
}
catch (System.Exception ex)
{
Logging.Log.Create("Greška u kreiranju objekta Nalog iz readera.",
Logging.LogEntryLevel.Critical, ex);
}
return(null);
}
public Int64 getCopyStatements(MysqlHandler connection, string sourceTable, Int64 start, MysqlHandler targetConnection, List <string> queryList, bool asFullInsert)
{
Int64 count = 0;
Int64 refresher = 0;
List <MysqlStruct> Struct = connection.getAllFieldsStruct(sourceTable);
string addToField = sourceTable + ".";
if (showProgress && msg.Visible)
{
msg.progressBar.Maximum = (int)this.copyRowLimit + 1;
}
if (connection.isConnected())
{
MySql.Data.MySqlClient.MySqlDataReader Reader =
connection.sql_select("SELECT * FROM " + sourceTable + " LIMIT " + start + "," + this.copyRowLimit);
if (Reader != null)
{
//if (Reader.RecordsAffected==-1) return 0;
bool startRow = true;
string fullInsert = "INSERT INTO " + sourceTable;
string valuesExport = "";
string valuesExportAdd = "";
string fields = "";
string fieldsAdd = "(";
string valuesSeperator = "";
while (Reader.Read())
{
count++;
refresher++;
string insertSql = "INSERT INTO " + sourceTable + " SET ";
string add = "";
valuesExportAdd = valuesSeperator + "(";
for (int i = 0; i < Reader.FieldCount; i++)
{
if (refresher > 1000)
{
if (showProgress && msg.Visible)
{
msg.msg.Text = "get copy statement for Table " + sourceTable + " block: " + start + "/" + count;
msg.progressBar.Value = (int)count;
msg.progressBar.Refresh();
msg.Refresh();
msg.Focus();
}
refresher = 0;
}
System.Type fType = Reader.GetFieldType(i);
Object chk = null;
try
{
chk = Reader.GetValue(i);
}
catch (Exception)
{
//throw;
}
if (asFullInsert)
{
if (startRow)
{
fields += fieldsAdd + "`" + Struct[i].name + "`";
fieldsAdd = ",";
}
}
if (chk != null)
{
int hash = chk.GetHashCode();
string dd = chk.ToString();
if (chk != null && dd != "")
{
switch (fType.Name)
{
case "Int32":
case "UInt32":
case "Int64":
case "UInt64":
Int64 val = Reader.GetInt64(i);
insertSql += add + addToField + Struct[i].name + " = " + val;
if (asFullInsert)
{
valuesExport += valuesExportAdd + val;
}
break;
case "Single":
case "Float":
float fVal = Reader.GetFloat(i);
insertSql += add + addToField + Struct[i].name + " = '" + fVal.ToString().Replace(',', '.') + "'";
if (asFullInsert)
{
valuesExport += valuesExportAdd + "'" + fVal.ToString().Replace(',', '.') + "'";
}
break;
case "Double":
double dVal = Reader.GetDouble(i);
insertSql += add + addToField + Struct[i].name + " = '" + dVal.ToString().Replace(',', '.') + "'";
if (asFullInsert)
{
valuesExport += valuesExportAdd + "'" + dVal.ToString().Replace(',', '.') + "'";
}
break;
case "DateTime":
DateTime dt = Reader.GetDateTime(i);
String dtValue = zeroVal(dt.Year) + "-" + zeroVal(dt.Month) + "-" + zeroVal(dt.Day) + " " + dt.TimeOfDay;
insertSql += add + addToField + Struct[i].name + " = '" + dtValue + "'";
if (asFullInsert)
{
valuesExport += valuesExportAdd + "'" + dtValue + "'";
}
break;
case "Boolean":
bool bval = Reader.GetBoolean(i);
if (bval)
{
insertSql += add + addToField + Struct[i].name + " = 1";
}
else
{
insertSql += add + addToField + Struct[i].name + " = 0";
}
if (asFullInsert)
{
if (bval)
{
valuesExport += valuesExportAdd + "1";
}
else
{
valuesExport += valuesExportAdd + "0";
}
}
break;
default:
string stringVal = Reader.GetString(i);
/*
* if (stringVal.Contains(@"\"))
* {
* stringVal.Replace(@"\", @"\\");
* }
*/
string sval = stringVal.Replace("'", @"\'");
sval = sval.Replace("‘", "?");
insertSql += add + addToField + Struct[i].name + " = '" + sval + "'";
if (asFullInsert)
{
valuesExport += valuesExportAdd + "'" + sval + "'";
}
break;
}
add = ",";
valuesExportAdd = ",";
}
else
{
valuesExport += valuesExportAdd + "NULL";
}
}
else
{
valuesExport += valuesExportAdd + "NULL";
}
valuesSeperator = ",";
}
valuesExport += ")";
startRow = false;
if (!asFullInsert)
{
queryList.Add(insertSql);
}
}
if (asFullInsert && count > 0)
{
string exportSql = fullInsert + fields + ") VALUES " + valuesExport + ";";
queryList.Add(exportSql);
}
Reader.Close();
}
}
return(count);
}
public static Dokument CreateDokumentFromReader(MySql.Data.MySqlClient.MySqlDataReader dr)
{
Dokument dokument = null;
try
{
dokument = new Dokument(dr.GetInt32("ID"));
dokument.BrojDokumenta = dr["BrojDokumenta"].GetType() == typeof(System.DBNull) ? 0 : dr.GetInt32("BrojDokumenta");
dokument.BrojRacuna = dr["BrojRacuna"].GetType() == typeof(System.DBNull) ? String.Empty : dr.GetString("BrojRacuna");
dokument.DatumDokumenta = dr["DatumDokumenta"].GetType() == typeof(System.DBNull) ? DateTime.MinValue : dr.GetDateTime("DatumDokumenta");
dokument.DatumRacuna = dr["DatumRacuna"].GetType() == typeof(System.DBNull) ? DateTime.MinValue : dr.GetDateTime("DatumRacuna");
dokument.FakturnaVrijednost = dr["FakturnaVrijednost"].GetType() == typeof(System.DBNull) ? Decimal.Parse("0") : dr.GetDecimal("FakturnaVrijednost");
dokument.Rabat = dr["Rabat"].GetType() == typeof(System.DBNull) ? Decimal.Parse("0") : dr.GetDecimal("Rabat");
dokument.UlazniPDV = dr["UlazniPDV"].GetType() == typeof(System.DBNull) ? Decimal.Parse("0") : dr.GetDecimal("UlazniPDV");
dokument.VrstaDokumenta = dr["VrstaDokumenta"].GetType() == typeof(System.DBNull) ? 0 : (VrstaDokumentaEnum)dr.GetInt32("VrstaDokumenta");
dokument.KomitentID = dr["KomitentID"].GetType() == typeof(System.DBNull) ? 0 : dr.GetInt32("KomitentID");
dokument.NabavnaVrijednost = dr["NabavnaVrijednost"].GetType() == typeof(System.DBNull) ? Decimal.Parse("0") : dr.GetDecimal("NabavnaVrijednost");
dokument.Marza = dr["Marza"].GetType() == typeof(System.DBNull) ? Decimal.Parse("0") : dr.GetDecimal("Marza");
dokument.UkalkulisaniPDV = dr["UkalkulisaniPDV"].GetType() == typeof(System.DBNull) ? Decimal.Parse("0") : dr.GetDecimal("UkalkulisaniPDV");
dokument.ProdajnaVrijednost = dr["ProdajnaVrijednost"].GetType() == typeof(System.DBNull) ? Decimal.Parse("0") : dr.GetDecimal("ProdajnaVrijednost");
dokument.Zatvoreno = dr.IsDBNull(dr.GetOrdinal("Zatvoreno")) ? false : dr.GetBoolean("Zatvoreno");
dokument.BrojTK = dr["BrojTK"].GetType() == typeof(System.DBNull) ? 0 : dr.GetInt32("BrojTK");
dokument.Exportovano = dr["Exportovano"].GetType() == typeof(System.DBNull) ? 0 : dr.GetInt32("Exportovano");
SetBaseProps <Dokument>(dokument, dr);
return(dokument);
}
catch (System.Exception ex)
{
Logging.Log.Create("Greška u kreiranju objekta Dokument iz readera.",
Logging.LogEntryLevel.Critical, ex);
}
return(null);
}
