public static PyObject DBColumnToPyObject(int index, ref MySqlDataReader reader) { Type type = reader.GetFieldType(index); switch (type.Name) { case "String": return new PyString(reader.GetString(index)); case "UInt32": case "Int32": case "UInt16": case "Int16": case "SByte": case "Byte": return new PyInt(reader.GetInt32(index)); case "UInt64": case "Int64": return new PyLongLong(reader.GetInt64(index)); case "Byte[]": return new PyBuffer((byte[])reader.GetValue(index)); case "Double": return new PyFloat(reader.GetDouble(index)); case "Decimal": return new PyFloat((double)reader.GetDecimal(index)); case "Boolean": return new PyBool(reader.GetBoolean(index)); default: Log.Error("Database", "Unhandled MySQL type " + type.Name); break; } return null; }
public static Albaran GetAlbaran(MySqlDataReader rdr) { if (rdr.IsDBNull(rdr.GetOrdinal("NUMALBAR"))) return null; Albaran a = new Albaran(); a.CodTipom = rdr.GetString("CODTIPOM"); a.NumAlbar = rdr.GetInt32("NUMALBAR"); a.FechaAlb = rdr.GetDateTime("FECHAALB"); a.TotalAlb = rdr.GetDecimal("TOTALALB"); return a; }
private void AddDataIntoSalesList(SQLiteDataReader sqLiteDataReader, MySqlDataReader mySqlDataReader, List<SaleForExcelReport> sales) { var productTax = Convert.ToDecimal(sqLiteDataReader["Tax"].ToString()); var income = mySqlDataReader.GetDecimal(2); var taxPercentage = productTax / 100; var currentTax = income * taxPercentage; var sale = new SaleForExcelReport(mySqlDataReader.GetString(0), income, mySqlDataReader.GetDecimal(3), currentTax); sales.Add(sale); }
private static ProjectMember FillProjectMember(MySqlDataReader dr) { ProjectMember p = new ProjectMember(); p = new ProjectMember(); p.EmpProj = dr.GetInt32("EmpProj"); p.ProjID = dr.GetInt32("ProjID"); p.EmpID = dr.GetInt32("EmpID"); p.Role = dr.GetString("Role"); p.TotalHours = dr.GetDecimal("TotalHours"); p.StartDate = dr.GetDateTime("StartDate"); p.EndDate = dr["EndDate"] as DateTime?; return p; }
public SMSModel(MySqlDataReader dataReader) { id = dataReader.GetInt32("id"); if (!string.IsNullOrEmpty(dataReader["msg_id"].ToString())) msg_id = dataReader.GetString("msg_id"); if (!string.IsNullOrEmpty(dataReader["number"].ToString())) number = dataReader.GetString("number"); if (!string.IsNullOrEmpty(dataReader["message"].ToString())) message = dataReader.GetString("message"); if (!string.IsNullOrEmpty(dataReader["sign"].ToString())) sign = dataReader.GetString("sign"); if (!string.IsNullOrEmpty(dataReader["cost"].ToString())) cost = dataReader.GetDecimal("cost"); if (!string.IsNullOrEmpty(dataReader["balance"].ToString())) balance = dataReader.GetDecimal("balance"); if (!string.IsNullOrEmpty(dataReader["added"].ToString())) added = dataReader.GetString("added"); if (!string.IsNullOrEmpty(dataReader["sended"].ToString())) sended = dataReader.GetString("sended"); if (!string.IsNullOrEmpty(dataReader["received"].ToString())) received = dataReader.GetString("received"); if (!string.IsNullOrEmpty(dataReader["error_code"].ToString())) error_code = dataReader.GetString("error_code"); if (!string.IsNullOrEmpty(dataReader["status"].ToString())) status = dataReader.GetString("status"); }
public Session createSessionFromDataReader(MySqlDataReader dr) { Session session; String userLogin; int code = 0; DateTime date; String dateString; Video video; String mode; String comment; float evaluetion; if (dr.Equals(DBNull.Value)) return null; if (!dr["comment"].Equals(DBNull.Value)) comment = dr.GetString("comment"); else comment = ""; if (dr["code"].Equals(DBNull.Value)) return null; code = dr.GetInt32("code"); if (dr["userLogin"].Equals(DBNull.Value)) return null; userLogin = dr.GetString("userLogin"); if (!dr["evaluetion"].Equals(DBNull.Value)) evaluetion = (float)Convert.ToDouble(dr.GetDecimal("evaluetion")); else evaluetion = 0; DaoVideo daoVideo = new DaoVideo(); daoVideo.openConnection(); video = daoVideo.getVideoByCode(dr.GetInt32("videoCode")); date = dr.GetDateTime("date"); dateString = date.Day + "/" + date.Month + "/" + date.Year; if (!dr["modeCode"].Equals(DBNull.Value)) mode = getModeByCode(dr.GetInt32("modeCode")); else mode = ""; session = new Session(userLogin, video, dateString, evaluetion, mode, comment); session.setCode(code); return session; }
private ShoppingCart BuildObject(MySqlDataReader reader) { if (!reader.Read()) return null; var cart = new ShoppingCart(); do { cart.Items.Add(new ShoppingCart.ShoppingCartItem { Product = new Product { Id = reader.GetInt64("ProductId"), Name = reader.GetString("Name"), Price = reader.GetDecimal("Price"), Description = reader.GetString("Description"), }, Quantity = reader.GetInt32("Quantity"), }); } while (reader.Read()); return cart; }
public static LinFactura GetLinFactura(MySqlDataReader rdr) { if (rdr.IsDBNull(rdr.GetOrdinal("NUMLINEA"))) return null; LinFactura lf = new LinFactura(); lf.CodTipoa = rdr.GetString("CODTIPOA"); lf.NumAlbar = rdr.GetInt32("NUMALBAR"); lf.NumLinea = rdr.GetInt32("NUMLINEA"); lf.CodArtic = rdr.GetString("CODARTIC"); lf.NomArtic = rdr.GetString("NOMARTIC"); lf.PrecioAr = rdr.GetDecimal("PRECIOAR"); lf.Cantidad = rdr.GetDecimal("CANTIDAD"); lf.DtoLine1 = rdr.GetDecimal("DTOLINE1"); lf.DtoLine2 = rdr.GetDecimal("DTOLINE2"); lf.Importel = rdr.GetDecimal("IMPORTEL"); return lf; }
private List<User> readToUser(MySqlDataReader _reader) { List<User> users = new List<User>(); string usersQuery = String.Format("SELECT user_type, {0}.users.id, Username, name, dateOfBirth, surname, gender, password, length, weight FROM {0}.users LEFT JOIN {0}.client_bmi_info on {0}.users.id = {0}.client_bmi_info.users_id ", _database); OpenConnection(); _selectCommand = new MySqlCommand(usersQuery, Connection); while (_reader.Read()) { User u; int type = _reader.GetInt32(0); if (type == 2) { u = new Administrator() { Username = _reader.IsDBNull(2) ? null : _reader.GetString(2), Surname = _reader.IsDBNull(5) ? null : _reader.GetString(5), Name = _reader.IsDBNull(3) ? null : _reader.GetString(3), DateOfBirth = _reader.IsDBNull(4) ? DateTime.MinValue : (DateTime)_reader.GetMySqlDateTime(4), Id = _reader.IsDBNull(1) ? 0 : _reader.GetInt32(1), Gender = _reader.IsDBNull(6) ? null : _reader.GetString(6) }; } else if (type == 1) { u = new Specialist { Username = _reader.IsDBNull(2) ? null : _reader.GetString(2), Surname = _reader.IsDBNull(5) ? null : _reader.GetString(5), Name = _reader.IsDBNull(3) ? null : _reader.GetString(3), DateOfBirth = _reader.IsDBNull(4) ? DateTime.MinValue : (DateTime)_reader.GetMySqlDateTime(4), Id = _reader.IsDBNull(1) ? 0 : _reader.GetInt32(1), Gender = _reader.IsDBNull(6) ? null : _reader.GetString(6) }; } else if (_reader.GetInt32(0) == 0) { u = new Client { Username = _reader.IsDBNull(2) ? null : _reader.GetString(2), Surname = _reader.IsDBNull(5) ? null : _reader.GetString(5), Name = _reader.IsDBNull(3) ? null : _reader.GetString(3), DateOfBirth = _reader.IsDBNull(4) ? DateTime.MinValue : (DateTime)_reader.GetMySqlDateTime(4), Id = _reader.IsDBNull(1) ? 0 : _reader.GetInt32(1), Gender = _reader.IsDBNull(6) ? null : _reader.GetString(6), Lenght = _reader.IsDBNull(8) ? -1 : _reader.GetDecimal(8), Weight = _reader.IsDBNull(9) ? -1 : _reader.GetDecimal(9) }; } else continue; users.Add(u); } _reader.Close(); return users; }
private void rNextButton_Click(object sender, EventArgs e) { float np, m, o, nd, h, t, s, lwt, pax; System.Text.StringBuilder cmgmt = new StringBuilder(); System.Text.StringBuilder hv = new StringBuilder(); fsheet.registerClient(client.getID()); fsheet.registerPatient(patient.getID()); fsheet.setAmbWellness(ambCB.Checked); fsheet.setCareTraining(ctCB.Checked); fsheet.setSeniorResidential(senresCB.Checked); fsheet.ReqDetails = detIn.Text; if (caseMgmtCB.Checked) { int cnt = caseMgmtBox.CheckedItems.Count; for (int i = 0; i < cnt; i++) { cmgmt.Append("'" + caseMgmtBox.CheckedItems[i].ToString() + "'"); if (i < cnt - 1) cmgmt.Append(","); } Console.WriteLine(cmgmt); } if (hvacCB.Checked) { int num = hvacCoB.CheckedItems.Count; Console.WriteLine("Number of items checked for HVAC: {0}",num); for (int i = 0; i < num; i++) { hv.Append("'"+hvacCoB.CheckedItems[i].ToString()+"'"); if (i < num - 1) hv.Append(","); } Console.WriteLine(hv); } //initialize cost table parameters try { //get MD Parameters first np = float.Parse(mdNPIn.Text); m = float.Parse(mdmealsIn.Text); o = float.Parse(mdoverIn.Text); nd = float.Parse(mdndIn.Text); h = float.Parse(mdhpIn.Text); t = float.Parse(mdTranspoIn.Text); s = float.Parse(mdSomethingIn.Text); lwt = float.Parse(mdLWTIn.Text); pax = float.Parse(mdNoPaxIn.Text); cost.setMDParams(np, m, o, nd, h, t, s, lwt, pax); } catch (Exception err) { Console.WriteLine("Cost Table Field Error(MD): " + err.Message); } try { //get MD Parameters first np = float.Parse(hcNPIn.Text); m = float.Parse(hcmealsIn.Text); o = float.Parse(hcoverIn.Text); nd = float.Parse(hcndIn.Text); h = float.Parse(hchpIn.Text); t = float.Parse(hcTranspoIn.Text); s = float.Parse(hcSomethingIn.Text); lwt = float.Parse(hcLWTIn.Text); pax = float.Parse(hcNoPaxIn.Text); cost.setHCParams(np, m, o, nd, h, t, s, lwt, pax); } catch (Exception err) { Console.WriteLine("Cost Table Field Error(HCP): " + err.Message); } if (true) { if (OpenConnection()) { string query = "INSERT INTO FACESHEET(PATID,CLIENTID,CTRAINING,AMBWELLNESS,SENIORRES,REQDETAILS) " + "VALUES (@ptid,@ctid,@cty,@amb,@sen,@rqdet)"; cmd = new MySqlCommand(query, conn); cmd.Prepare(); cmd.Parameters.AddWithValue("@ptid", fsheet.PatientID); cmd.Parameters.AddWithValue("@ctid", fsheet.ClientID); cmd.Parameters.AddWithValue("@cty", fsheet.CarTra); cmd.Parameters.AddWithValue("@amb", fsheet.AmbWel); cmd.Parameters.AddWithValue("@sen", fsheet.SenRes); cmd.Parameters.AddWithValue("@rqdet", fsheet.ReqDetails); cmd.ExecuteNonQuery(); query = "SELECT LAST_INSERT_ID() FROM FACESHEET;"; cmd.CommandText = query; read = cmd.ExecuteReader(); read.Read(); fsheet.FID = UInt16.Parse(read.GetDecimal(0).ToString()); read.Close(); //insert values to case mgmt map if (caseMgmtBox.CheckedItems.Count > 0) { string caseQuery = "SELECT CASEID FROM CASE_MGMT_REF WHERE DESCRIPTION IN (" + cmgmt + ");"; cmd = new MySqlCommand(caseQuery, conn); UInt16[] ctmp = new UInt16[caseMgmtBox.CheckedItems.Count]; read = cmd.ExecuteReader(); int x = 0; while (read.Read()) { Console.WriteLine(read.GetDecimal(0).ToString()); ctmp[x] = UInt16.Parse(read.GetDecimal(0).ToString()); x++; } fsheet.addCaseMgmtIndex(ctmp); read.Close(); query = "INSERT INTO CASE_MGMT_MAP VALUES (@fcID,@cmgmtID);"; cmd.CommandText = query; for (int ccnt = 0; ccnt < ctmp.Length; ccnt++) { cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@fcID", fsheet.FID); cmd.Parameters.AddWithValue("@cmgmtID", ctmp[ccnt]); cmd.Prepare(); cmd.ExecuteNonQuery(); } } if (hvacCoB.CheckedItems.Count > 0) { string HVacquery = "SELECT HVACID FROM HVAC_REF WHERE DESCRIPTION IN (" + hv + ");"; cmd = new MySqlCommand(HVacquery,conn); UInt16[] htmp = new UInt16[hvacCoB.CheckedItems.Count]; read = cmd.ExecuteReader(); int x = 0; while (read.Read()) { Console.WriteLine(read.GetDecimal(0).ToString()); htmp[x] = UInt16.Parse(read.GetDecimal(0).ToString()); x++; } fsheet.addHomeVacIndex(htmp); read.Close(); query = "INSERT INTO HVAC_MAP VALUES (@fcID,@hvacID);"; cmd.CommandText = query; for (int hcnt = 0; hcnt < htmp.Length; hcnt++) { cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@fcID", fsheet.FID); cmd.Parameters.AddWithValue("@hvacID",htmp[hcnt]); cmd.Prepare(); cmd.ExecuteNonQuery(); } } CloseConnection(); tabControl1.SelectedIndex++; } } }
public static LineaStock GetLineaStock(MySqlDataReader rdr) { LineaStock ls = new LineaStock(); ls.NumLinea = rdr.GetInt32("CODALMAC"); ls.Almacen = rdr.GetString("NOMALMAC"); ls.Stock = rdr.GetDecimal("CANSTOCK"); return ls; }
public static Articulo GetArticulo(MySqlDataReader rdr) { if (rdr.IsDBNull(rdr.GetOrdinal("CODARTIC"))) return null; Articulo a = new Articulo(); a.CodArtic = rdr.GetString("CODARTIC"); a.NomArtic = rdr.GetString("NOMARTIC"); a.Preciove = rdr.GetDecimal("PRECIOVE"); a.CodFamia = rdr.GetInt32("CODFAMIA"); a.CodMarca = rdr.GetInt32("CODMARCA"); return a; }
private static Option<Team> MapOption(MySqlDataReader dr) { var option = new Option<Team> { CutOff = dr.GetDateTime("cutOffTime"), GameId = dr.GetInt64("gameId"), GroupId = dr.GetInt64("groupId"), Id = dr.GetInt64("id"), Team = new Team { Id = dr.GetInt32("teamId") }, Type = (GameOptionType) dr.GetInt32("type") }; if (dr["value"] != DBNull.Value) { option.Value = dr.GetDecimal("value"); } if (dr["outcome"] != DBNull.Value) { option.Outcome = (OptionOutcome) dr.GetInt32("outcome"); option.IsWinner = option.Outcome.Value == OptionOutcome.Won; } option.CutOff = option.CutOff.AddDays(ConfigSettings.GameTimeOffSetInDays); option.IsPastCutOff = DateTime.UtcNow >= option.CutOff; return option; }
// //------------------------------------------------------------------------------------------------- // public bool ds2purchase(int cart_items, int[] prod_id_in, int[] qty_in, int customerid_out, ref int neworderid_out, ref bool IsRollback, ref double rt) { int i, j; bool success = false; #if (USE_WIN32_TIMER) long ctr0 = 0, ctr = 0, freq = 0; #else TimeSpan TS = new TimeSpan(); DateTime DT0; #endif // Find total cost of purchase Decimal netamount_in = 0; string db_query = "select PROD_ID, PRICE from PRODUCTS where PROD_ID in (" + prod_id_in[0]; for (i=1; i<cart_items; i++) db_query = db_query + "," + prod_id_in[i]; db_query = db_query + ")"; //Console.WriteLine(db_query); Purchase = new MySqlCommand(db_query, objConn); Rdr = Purchase.ExecuteReader(); while (Rdr.Read()) { j = 0; int prod_id = Rdr.GetInt32(0); while (prod_id_in[j] != prod_id) ++j; // Find which product was returned netamount_in = netamount_in + qty_in[j] * Rdr.GetDecimal(1); //Console.WriteLine(j + " " + prod_id + " " + Rdr.GetDecimal(1)); } Rdr.Close(); Decimal taxamount_in = (Decimal) 0.0825 * netamount_in; Decimal totalamount_in = netamount_in + taxamount_in; // Insert new order into ORDERS table string currentdate = DateTime.Today.ToString("yyyy'-'MM'-'dd"); MySqlTransaction trans = objConn.BeginTransaction(IsolationLevel.RepeatableRead); db_query = String.Format("INSERT into DS2.ORDERS (ORDERDATE, CUSTOMERID, NETAMOUNT, TAX, TOTALAMOUNT) VALUES" + "('{0}', {1}, {2:F2}, {3:F2}, {4:F2})", currentdate, customerid_out, netamount_in, taxamount_in, totalamount_in); Purchase = new MySqlCommand(db_query, objConn, trans); // Console.WriteLine("Thread {0}: Calling Purchase w/ customerid = {1} number_items= {2}", // Thread.CurrentThread.Name, customerid_out, cart_items); #if (USE_WIN32_TIMER) QueryPerformanceFrequency(ref freq); // obtain system freq (ticks/sec) QueryPerformanceCounter(ref ctr0); // Start response time clock #else DT0 = DateTime.Now; #endif bool deadlocked = false; do { try { deadlocked = false; Purchase.ExecuteNonQuery(); db_query = "select LAST_INSERT_ID();"; Purchase = new MySqlCommand(db_query, objConn); neworderid_out = Convert.ToInt32(Purchase.ExecuteScalar().ToString()); // Console.WriteLine("Thread {0}: Purchase: neworderid_out= {1}", Thread.CurrentThread.Name, neworderid_out); if (neworderid_out > 0) success = true; // loop through purchased items and make inserts into orderdetails table // (o_insert_query) and cust_hist table (ch_insert_query) string o_insert_query = "INSERT into DS2.ORDERLINES (ORDERLINEID, ORDERID, PROD_ID, QUANTITY, ORDERDATE)" + " VALUES "; string c_insert_query = "INSERT into DS2.CUST_HIST (CUSTOMERID, ORDERID, PROD_ID) VALUES "; for (i=0; i<cart_items; i++) { j = i+1; db_query = "SELECT QUAN_IN_STOCK, SALES FROM DS2.INVENTORY WHERE PROD_ID=" + prod_id_in[i] + ";"; Purchase = new MySqlCommand(db_query, objConn); Rdr = Purchase.ExecuteReader(); Rdr.Read(); int curr_quan = Rdr.GetInt32(0); int curr_sales = Rdr.GetInt32(1); Rdr.Close(); int new_quan = curr_quan - qty_in[i]; int new_sales = curr_sales + qty_in [i]; if (new_quan < 0) { //Console.WriteLine("Insufficient quantity for product " + prod_id_in[i]); success = false; } else { db_query = "UPDATE DS2.INVENTORY SET QUAN_IN_STOCK=" + new_quan + ", SALES=" + new_sales + " WHERE PROD_ID=" + prod_id_in[i] + ";"; Purchase = new MySqlCommand(db_query, objConn, trans); Purchase.ExecuteNonQuery(); } o_insert_query = o_insert_query + "(" + j + "," + neworderid_out + "," + prod_id_in[i] + "," + qty_in[i] + ",'" + currentdate + "'),"; c_insert_query = c_insert_query + "(" + customerid_out + "," + neworderid_out + "," + prod_id_in[i] + "),"; } // End of for (i=0; i<cart_items; i++) o_insert_query = o_insert_query.Remove(o_insert_query.Length-1,1) + ";"; // Console.WriteLine(o_insert_query); c_insert_query = c_insert_query.Remove(c_insert_query.Length-1,1) + ";"; // Console.WriteLine(c_insert_query); Purchase = new MySqlCommand(o_insert_query, objConn, trans); if (Purchase.ExecuteNonQuery()<0) { Console.WriteLine("Thread {0}: Insert into ORDERLINES table failed; query= {1}", Thread.CurrentThread.Name, o_insert_query); success = false; } Purchase = new MySqlCommand(c_insert_query, objConn, trans); if (Purchase.ExecuteNonQuery()<0) { Console.WriteLine("Thread {0}: Insert into CUST_HIST table failed; query= {1}", Thread.CurrentThread.Name, c_insert_query); success = false; } if (success)trans.Commit(); else trans.Rollback(); } // End Try catch (MySqlException e) { if ((e.Number == 1205) || (e.Number == 1213)) { deadlocked = true; Random r = new Random(DateTime.Now.Millisecond); int wait = r.Next(1000); Console.WriteLine("Thread {0}: Purchase deadlocked (error {1}: {2})...waiting {3} msec, then will retry", Thread.CurrentThread.Name, e.Number, e.Message, wait); Thread.Sleep(wait); // Wait up to 1 sec, then try again } else if (e.Number == 1062) { deadlocked = true; // Not really but it will cause a retry Console.WriteLine("Thread {0}: Duplicate entry found in Purchase (error {1}: {2})... will retry", Thread.CurrentThread.Name, e.Number, e.Message); } else { Console.WriteLine("Thread {0}: MySql Error {1} in Purchase: {2}", Thread.CurrentThread.Name, e.Number, e.Message); return(false); } } // End Catch } while (deadlocked); #if (USE_WIN32_TIMER) QueryPerformanceCounter(ref ctr); // Stop response time clock rt = (ctr - ctr0)/(double) freq; // Calculate response time #else TS = DateTime.Now - DT0; rt = TS.TotalSeconds; // Calculate response time #endif if (!success) { IsRollback = true; // Console.WriteLine("Thread {0}: Purchase: Insufficient stock for order {1} - order not processed", // Thread.CurrentThread.Name, neworderid_out); neworderid_out = 0; } return(true); }
public static Cobro GetCobro(MySqlDataReader rdr) { Cobro c = new Cobro(); c.FechaVenci = rdr.GetDateTime("FECHAVENCI"); c.FechaFact = rdr.GetDateTime("FECHAFACT"); c.NumFact = rdr.GetString("NUMFACT"); c.NomForpa = rdr.GetString("NOMFORPA"); c.Total = rdr.GetDecimal("TOTAL"); return c; }
public static LinPedido GetLinPedido(MySqlDataReader rdr) { if (rdr.IsDBNull(rdr.GetOrdinal("NUMLINEA"))) return null; LinPedido lp = new LinPedido(); lp.NumLinea = rdr.GetInt32("NUMLINEA"); lp.CodArtic = rdr.GetString("CODARTIC"); lp.NomArtic = rdr.GetString("NOMARTIC"); lp.PrecioAr = rdr.GetDecimal("PRECIOAR"); lp.Cantidad = rdr.GetDecimal("CANTIDAD"); lp.DtoLine1 = rdr.GetDecimal("DTOLINE1"); lp.DtoLine2 = rdr.GetDecimal("DTOLINE2"); lp.Importel = rdr.GetDecimal("IMPORTEL"); return lp; }
public static Cliente GetCliente(MySqlDataReader rdr) { if (rdr.IsDBNull(rdr.GetOrdinal("CODCLIEN"))) return null; Cliente c = new Cliente(); c.CodClien = rdr.GetInt32("CODCLIEN"); c.NomClien = rdr.GetString("NOMCLIEN"); c.NomComer = rdr.GetString("NOMCOMER"); c.DomClien = rdr.GetString("DOMCLIEN"); c.CodPobla = rdr.GetString("CODPOBLA"); c.PobClien = rdr.GetString("POBCLIEN"); c.ProClien = rdr.GetString("PROCLIEN"); c.NifClien = rdr.GetString("NIFCLIEN"); if (!rdr.IsDBNull(rdr.GetOrdinal("PERCLIE1"))) c.PerClie1 = rdr.GetString("PERCLIE1"); if (!rdr.IsDBNull(rdr.GetOrdinal("TELCLIE1"))) c.TelClie1 = rdr.GetString("TELCLIE1"); if (!rdr.IsDBNull(rdr.GetOrdinal("FAXCLIE1"))) c.FaxClie1 = rdr.GetString("FAXCLIE1"); if (!rdr.IsDBNull(rdr.GetOrdinal("PERCLIE2"))) c.PerClie2 = rdr.GetString("PERCLIE2"); if (!rdr.IsDBNull(rdr.GetOrdinal("TELCLIE2"))) c.TelClie2 = rdr.GetString("TELCLIE2"); if (!rdr.IsDBNull(rdr.GetOrdinal("FAXCLIE2"))) c.FaxClie2 = rdr.GetString("FAXCLIE2"); if (!rdr.IsDBNull(rdr.GetOrdinal("MAICLIE1"))) c.Maiclie1 = rdr.GetString("MAICLIE1"); if (!rdr.IsDBNull(rdr.GetOrdinal("MAICLIE2"))) c.Maiclie2 = rdr.GetString("MAICLIE2"); if (!rdr.IsDBNull(rdr.GetOrdinal("CODMACTA"))) c.Codmacta = rdr.GetString("CODMACTA"); c.CodActiv = rdr.GetInt32("CODACTIV"); c.CodTarif = rdr.GetInt32("CODTARIF"); c.Promocio = rdr.GetInt32("PROMOCIO"); if (!rdr.IsDBNull(rdr.GetOrdinal("SITUACION"))) c.Situacion = rdr.GetString("SITUACION"); if (!rdr.IsDBNull(rdr.GetOrdinal("LIMITE_CREDITO"))) c.LimiteCredito = rdr.GetDecimal("LIMITE_CREDITO"); int tcred = rdr.GetInt32("CREDITO_PRIVADO"); if (tcred == 1) c.TipoCredito = "PRIVADO"; return c; }
public static Articulo GetArticuloExt(MySqlDataReader rdr) { if (rdr.IsDBNull(rdr.GetOrdinal("CODARTIC"))) return null; Articulo a = new Articulo(); a.CodArtic = rdr.GetString("CODARTIC"); a.NomArtic = rdr.GetString("NOMARTIC"); a.Preciove = rdr.GetDecimal("PRECIOVE"); a.Familia = GetFamilia(rdr); a.Proveedor = GetProveedor(rdr); a.Stock = rdr.GetDecimal("STOCK"); if (rdr.GetInt32("ROTACION") == 1) a.Rotacion = true; a.Reservas = rdr.GetDecimal("RESERVAS"); a.Referprov = rdr.GetString("REFERPROV"); a.Pedido = rdr.GetDecimal("PEDIDO"); return a; }
public static PrecioEspecial GetPrecioEspecial(MySqlDataReader rdr) { if (rdr.IsDBNull(rdr.GetOrdinal("CODARTIC"))) return null; PrecioEspecial pe = new PrecioEspecial(); pe.Codartic = rdr.GetInt32("CODARTIC"); pe.Nomartic = rdr.GetString("NOMARTIC"); pe.Precioac = rdr.GetDecimal("PRECIOAC"); pe.Dtoespe = rdr.GetDecimal("DTOESPE"); return pe; }
public static Pedido GetPedidoAgente(MySqlDataReader rdr) { if (rdr.IsDBNull(rdr.GetOrdinal("NUMPEDCL"))) return null; Pedido p = new Pedido(); p.NumPedcl = rdr.GetInt32("NUMPEDCL"); p.FecPedcl = rdr.GetDateTime("FECPEDCL"); p.FecEntre = rdr.GetDateTime("FECENTRE"); p.TotalPed = rdr.GetDecimal("TOTALPED"); if (!rdr.IsDBNull(rdr.GetOrdinal("CLIENTE"))) p.Cliente = rdr.GetString("CLIENTE"); if (!rdr.IsDBNull(rdr.GetOrdinal("AGENTE"))) p.Agente = rdr.GetString("AGENTE"); return p; }
private Employee constructEmployee(MySqlDataReader staffReader) { Employee newEmployee = new Employee(); newEmployee.NINo = staffReader.GetString("National_Insurance_Number"); newEmployee.FirstName = staffReader.GetString("First_Name"); newEmployee.LastName = staffReader.GetString("Last_Name"); newEmployee.Position = staffReader.GetString("Position"); newEmployee.Gender = staffReader.GetChar("Gender"); newEmployee.DateStarted = staffReader.GetDateTime("Date_Started"); newEmployee.DateFinished = SafeGetDateTime(staffReader, "Date_Finished"); newEmployee.PVGDate = staffReader.GetDateTime("PVG_Date"); newEmployee.HolidaysEntitled = staffReader.GetInt16("Holidays_Entitled"); newEmployee.HolidaysTaken = staffReader.GetInt16("Holidays_Taken"); newEmployee.WeeksHours = staffReader.GetInt16("Hours"); newEmployee.Address = constructAddress(staffReader); newEmployee.DOB = staffReader.GetDateTime("DOB"); newEmployee.Salary = staffReader.GetDecimal("Salary"); newEmployee.HomePhone = staffReader.GetString("Home_Phone"); newEmployee.MobilePhone = staffReader.GetString("Mobile_Phone"); newEmployee.Email = staffReader.GetString("Email"); newEmployee.Training = SafeGetString(staffReader, "Training"); newEmployee.Medical = constructMedical(staffReader); //EC... return newEmployee; }
private static Event _EventRead(Engine engine, MySqlDataReader dataReader) { Event aEvent = new Event(engine); uint flags = dataReader.IsDBNull(dataReader.GetOrdinal("flagsEvent")) ? 0 : dataReader.GetUInt32("flagsEvent"); aEvent._idRundownEvent = dataReader.GetUInt64("idRundownEvent"); aEvent._layer = (VideoLayer)dataReader.GetSByte("Layer"); aEvent._eventType = (TEventType)dataReader.GetByte("typEvent"); aEvent._startType = (TStartType)dataReader.GetByte("typStart"); aEvent._scheduledTime = _readDateTimeField(dataReader, "ScheduledTime"); aEvent._duration = dataReader.IsDBNull(dataReader.GetOrdinal("Duration")) ? default(TimeSpan) : aEvent.Engine.AlignTimeSpan(dataReader.GetTimeSpan("Duration")); aEvent._scheduledDelay = dataReader.IsDBNull(dataReader.GetOrdinal("ScheduledDelay")) ? default(TimeSpan) : aEvent.Engine.AlignTimeSpan(dataReader.GetTimeSpan("ScheduledDelay")); aEvent._scheduledTC = dataReader.IsDBNull(dataReader.GetOrdinal("ScheduledTC")) ? TimeSpan.Zero : dataReader.GetTimeSpan("ScheduledTC"); aEvent._mediaGuid = (dataReader.IsDBNull(dataReader.GetOrdinal("MediaGuid"))) ? Guid.Empty : dataReader.GetGuid("MediaGuid"); aEvent._eventName = dataReader.IsDBNull(dataReader.GetOrdinal("EventName")) ? default(string) : dataReader.GetString("EventName"); var psb = dataReader.GetByte("PlayState"); aEvent._playState = (TPlayState)psb; if (aEvent._playState == TPlayState.Playing || aEvent._playState == TPlayState.Paused) aEvent._playState = TPlayState.Aborted; if (aEvent._playState == TPlayState.Fading) aEvent._playState = TPlayState.Played; aEvent._startTime = _readDateTimeField(dataReader, "StartTime"); aEvent._startTC = dataReader.IsDBNull(dataReader.GetOrdinal("StartTC")) ? TimeSpan.Zero : dataReader.GetTimeSpan("StartTC"); aEvent._requestedStartTime = dataReader.IsDBNull(dataReader.GetOrdinal("RequestedStartTime")) ? null : (TimeSpan?)dataReader.GetTimeSpan("RequestedStartTime"); aEvent._transitionTime = dataReader.IsDBNull(dataReader.GetOrdinal("TransitionTime")) ? default(TimeSpan) : dataReader.GetTimeSpan("TransitionTime"); aEvent._transitionType = (TTransitionType)dataReader.GetByte("typTransition"); aEvent._audioVolume = dataReader.IsDBNull(dataReader.GetOrdinal("AudioVolume")) ? 0 : dataReader.GetDecimal("AudioVolume"); aEvent._idProgramme = dataReader.IsDBNull(dataReader.GetOrdinal("idProgramme")) ? 0 : dataReader.GetUInt64("idProgramme"); aEvent._idAux = dataReader.IsDBNull(dataReader.GetOrdinal("IdAux")) ? default(string) : dataReader.GetString("IdAux"); aEvent._enabled = (flags & (1 << 0)) != 0; aEvent._hold = (flags & (1 << 1)) != 0; EventGPI.FromUInt64(ref aEvent._gPI, (flags >> 4) & EventGPI.Mask); aEvent._nextLoaded = false; return aEvent; }
public List<DataRow> GetObjectByIDs(List<decimal> rowIDs) { dr.Close(); List<DataRow> wantedRoews = new List<DataRow>(); foreach(int ID in rowIDs) { string SqlCommand = string.Empty; SqlCommand = "SELECT * FROM `HEAD` WHERE `ID` = " + ID + " "; MySqlCommand MySqlTriggerCommand = new MySqlCommand(SqlCommand, mySqlConnection); dr = MySqlTriggerCommand.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { DataRow drr = Table.NewRow(); for (int i = 0; i < 5; i++) { if (!dr.IsDBNull(i)) { if (Table.Columns[i].DataType == typeof(string)) { drr[i] = dr.GetString(i); } if (Table.Columns[i].DataType == typeof(decimal)) { drr[i] = dr.GetDecimal(i); } } } wantedRoews.Add(drr); } } } return wantedRoews; }
public static Oferta GetOferta(MySqlDataReader rdr) { if (rdr.IsDBNull(rdr.GetOrdinal("NUMOFERT"))) return null; Oferta o = new Oferta(); o.NumOfert = rdr.GetInt32("NUMOFERT"); o.FecOfert = rdr.GetDateTime("FECOFERT"); o.FecEntre = rdr.GetDateTime("FECENTRE"); o.TotalOfe = rdr.GetDecimal("TOTALOFE"); o.Aceptado = rdr.GetBoolean("ACEPTADO"); return o; }
// //------------------------------------------------------------------------------------------------- // public bool ds2browse(string browse_type_in, string browse_category_in, string browse_actor_in, string browse_title_in, int batch_size_in, int customerid_out, ref int rows_returned, ref int[] prod_id_out, ref string[] title_out, ref string[] actor_out, ref decimal[] price_out, ref int[] special_out, ref int[] common_prod_id_out, ref double rt) { // Products table: PROD_ID INT, CATEGORY TINYINT, TITLE VARCHAR(50), ACTOR VARCHAR(50), // PRICE DECIMAL(12,2), SPECIAL TINYINT, COMMON_PROD_ID INT int i_row; int[] category_out = new int[GlobalConstants.MAX_ROWS]; #if (USE_WIN32_TIMER) long ctr0 = 0, ctr = 0, freq = 0; #else TimeSpan TS = new TimeSpan(); DateTime DT0; #endif switch(browse_type_in) { case "title": db_query = "select * from PRODUCTS where MATCH (TITLE) AGAINST ('" + browse_title_in + "') LIMIT " + batch_size_in + ";"; break; case "actor": db_query = "select * from PRODUCTS where MATCH (ACTOR) AGAINST ('" + browse_actor_in + "') LIMIT " + batch_size_in + ";"; break; case "category": db_query="select * from PRODUCTS where CATEGORY = " + Convert.ToInt32(browse_category_in) + " and SPECIAL=1 LIMIT " + batch_size_in + ";"; break; } Browse = new MySqlCommand(db_query, objConn); #if (USE_WIN32_TIMER) QueryPerformanceFrequency(ref freq); // obtain system freq (ticks/sec) QueryPerformanceCounter(ref ctr0); // Start response time clock #else DT0 = DateTime.Now; #endif try { Rdr = Browse.ExecuteReader(); i_row = 0; if (!Rdr.HasRows) // No rows returned { //Console.WriteLine("No DVDs Found"); } else // Rows returned { while (Rdr.Read()) { prod_id_out[i_row] = Rdr.GetInt32(0); category_out[i_row] = Rdr.GetByte(1); title_out[i_row] = Rdr.GetString(2); actor_out[i_row] = Rdr.GetString(3); price_out[i_row] = Rdr.GetDecimal(4); special_out[i_row] = Rdr.GetByte(5); common_prod_id_out[i_row] = Rdr.GetInt32(6); ++i_row; } } Rdr.Close(); rows_returned = i_row; } catch (MySqlException e) { Console.WriteLine("Thread {0}: Error in Browse: {1}", Thread.CurrentThread.Name, e.Message); return(false); } // Console.WriteLine("Thread {0}: Calling Browse w/ browse_type= {1} batch_size_in= {2} category= {3}" + // " title= {4} actor= {5}", Thread.CurrentThread.Name, browse_type_in, batch_size_in, browse_category_in, // browse_title_in, browse_actor_in); #if (USE_WIN32_TIMER) QueryPerformanceCounter(ref ctr); // Stop response time clock rt = (ctr - ctr0)/(double) freq; // Calculate response time #else TS = DateTime.Now - DT0; rt = TS.TotalSeconds; // Calculate response time #endif return(true); }
private void doneButton_Click(object sender, EventArgs e) { desig = edesigCoB.Text; fname = efnameIn.Text; sname = esnameIn.Text; mname = emnameIn.Text; birthdate = ebdayPick.Value; try { gender = egenCoB.Text; nationality = enatIn.Text; religion = erelIn.Text; civstat = ecivstatCoB.SelectedItem.ToString(); Console.WriteLine(civstat); educattain = eedattCoB.Text; } catch (Exception err) { Console.WriteLine(err.Message); } addline = eaddIn.Text; city = ecityIn.Text; region = eregIn.Text; try { stnumber = UInt16.Parse(estnoIn.Text); } catch (FormatException err) { Console.WriteLine("Street #: " + err.Message); } catch (OverflowException of) { Console.WriteLine("Street #: " + of.Message); } try { workNum = UInt16.Parse(eWorkIn.Text); homeNum = UInt16.Parse(eHomeIn.Text); mobNum = UInt16.Parse(eMobileIn.Text); otherNum = UInt16.Parse(eOtherIn.Text); } catch (Exception err) { } //get email //needs regex based error checking email = eemailIn.Text; emp.setName(desig, fname, mname, sname); emp.setBday(birthdate); emp.setGender(gender); emp.setNationality(nationality); emp.setReligion(religion); emp.setCivilStatus(civstat); emp.setEducAttainment(educattain); emp.setEmail(email); emp.setAddress(stnumber, addline, city, region); emp.setNumbers(homeNum, workNum, mobNum, otherNum); if (true) { RegisterPerson(emp); OpenConnection(); string query = "SELECT LAST_INSERT_ID() FROM PERSON;"; cmd = new MySqlCommand(query, conn); read = cmd.ExecuteReader(); read.Read(); UInt16 lastID = UInt16.Parse(read.GetDecimal(0).ToString()); emp.setID(lastID); read.Close(); query = "INSERT INTO EMPLOYEE (EMPID) VALUES(@eid);"; cmd.CommandText = query; cmd.Prepare(); cmd.Parameters.AddWithValue("@eid", lastID); cmd.ExecuteNonQuery(); CloseConnection(); } }
private static void _mediaReadFields(MySqlDataReader dataReader, PersistentMedia media) { uint flags = dataReader.IsDBNull(dataReader.GetOrdinal("flags")) ? (uint)0 : dataReader.GetUInt32("flags"); byte typVideo = dataReader.IsDBNull(dataReader.GetOrdinal("typVideo")) ? (byte)0 : dataReader.GetByte("typVideo"); media._mediaName = dataReader.IsDBNull(dataReader.GetOrdinal("MediaName")) ? string.Empty : dataReader.GetString("MediaName"); media._duration = dataReader.IsDBNull(dataReader.GetOrdinal("Duration")) ? default(TimeSpan) : dataReader.GetTimeSpan("Duration"); media._durationPlay = dataReader.IsDBNull(dataReader.GetOrdinal("DurationPlay")) ? default(TimeSpan) : dataReader.GetTimeSpan("DurationPlay"); media._folder = dataReader.IsDBNull(dataReader.GetOrdinal("Folder")) ? string.Empty : dataReader.GetString("Folder"); media._fileName = dataReader.IsDBNull(dataReader.GetOrdinal("FileName")) ? string.Empty : dataReader.GetString("FileName"); media._fileSize = dataReader.IsDBNull(dataReader.GetOrdinal("FileSize")) ? 0 : dataReader.GetUInt64("FileSize"); media.idFormat = dataReader.IsDBNull(dataReader.GetOrdinal("idFormat")) ? 0 : dataReader.GetUInt64("idFormat"); media._lastUpdated = _readDateTimeField(dataReader, "LastUpdated"); media._mediaStatus = (TMediaStatus)(dataReader.IsDBNull(dataReader.GetOrdinal("statusMedia")) ? 0 : dataReader.GetInt32("statusMedia")); media._mediaType = (TMediaType)(dataReader.IsDBNull(dataReader.GetOrdinal("typMedia")) ? 0 : dataReader.GetInt32("typMedia")); media._tCStart = dataReader.IsDBNull(dataReader.GetOrdinal("TCStart")) ? default(TimeSpan) : dataReader.GetTimeSpan("TCStart"); media._tCPlay = dataReader.IsDBNull(dataReader.GetOrdinal("TCPlay")) ? default(TimeSpan) : dataReader.GetTimeSpan("TCPlay"); media.idProgramme = dataReader.IsDBNull(dataReader.GetOrdinal("idProgramme")) ? 0 : dataReader.GetUInt64("idProgramme"); media._audioVolume = dataReader.IsDBNull(dataReader.GetOrdinal("AudioVolume")) ? 0 : dataReader.GetDecimal("AudioVolume"); media._audioLevelIntegrated = dataReader.IsDBNull(dataReader.GetOrdinal("AudioLevelIntegrated")) ? 0 : dataReader.GetDecimal("AudioLevelIntegrated"); media._audioLevelPeak = dataReader.IsDBNull(dataReader.GetOrdinal("AudioLevelPeak")) ? 0 : dataReader.GetDecimal("AudioLevelPeak"); media._audioChannelMapping = dataReader.IsDBNull(dataReader.GetOrdinal("typAudio")) ? TAudioChannelMapping.Stereo : (TAudioChannelMapping)dataReader.GetByte("typAudio"); media.HasExtraLines = (typVideo & (byte)0x80) > 0; media._videoFormat = (TVideoFormat)(typVideo & 0x7F); media._idAux = dataReader.IsDBNull(dataReader.GetOrdinal("idAux")) ? string.Empty : dataReader.GetString("idAux"); media._killDate = _readDateTimeField(dataReader, "KillDate"); media._mediaGuid = dataReader.IsDBNull(dataReader.GetOrdinal("MediaGuid")) ? Guid.Empty : dataReader.GetGuid("MediaGuid"); media._mediaEmphasis = (TMediaEmphasis)((flags >> 8) & 0xF); media._parental = (TParental)((flags >> 12) & 0xF); if (media is ServerMedia) ((ServerMedia)media)._doNotArchive = (flags & 0x1) != 0; media._mediaCategory = (TMediaCategory)((flags >> 4) & 0xF); // bits 4-7 of 1st byte }
private void cNextButton_Click(object sender, EventArgs e) { desig = cdesigCoB.Text; fname = cfnameIn.Text; sname = csnameIn.Text; mname = cmnameIn.Text; birthdate = cbdayPick.Value; try { gender = cgenCoB.Text; nationality = cnatIn.Text; religion = crelIn.Text; civstat = ccivstatCoB.Text; educattain = cedattCoB.Text; } catch (Exception err) { Console.WriteLine(err.Message); } addline = caddIn.Text; city = ccityIn.Text; region = cregIn.Text; try { stnumber = UInt16.Parse(pstnoIn.Text); } catch (FormatException err) { Console.WriteLine("Street #: " + err.Message); } catch (OverflowException of) { Console.WriteLine("Street #: " + of.Message); } try { workNum = UInt16.Parse(cWorkIn.Text); homeNum = UInt16.Parse(cHomeIn.Text); mobNum = UInt16.Parse(cMobileIn.Text); otherNum = UInt16.Parse(cOtherIn.Text); } catch (Exception err) { } //get email //needs regex based error checking email = cemailIn.Text; //get position/relationship of client to patient posrel = posIn.Text; isPrimary = primaryCB.Checked; client.setName(desig, fname, mname, sname); client.setBday(birthdate); client.setGender(gender); client.setNationality(nationality); client.setReligion(religion); client.setCivilStatus(civstat); client.setEducAttainment(educattain); client.setEmail(email); client.setAddress(stnumber, addline, city, region); client.setNumbers(homeNum, workNum, mobNum, otherNum); if (true)//implement error checking flags here { string query; UInt16 lastID; if(selID == 0) RegisterPerson(client); OpenConnection(); if (selID == 0) { query = "SELECT LAST_INSERT_ID() FROM PERSON;"; cmd = new MySqlCommand(query, conn); read = cmd.ExecuteReader(); read.Read(); Console.WriteLine(read.GetDecimal(0).ToString()); lastID = UInt16.Parse(read.GetDecimal(0).ToString()); client.setID(lastID); read.Close(); query = "INSERT INTO CLIENT (ClientID) VALUES(@cid);"; cmd.CommandText = query; cmd.Prepare(); cmd.Parameters.AddWithValue("@cid", lastID); cmd.ExecuteNonQuery(); } else { client.setID(selID); } query = "INSERT INTO RELATIONSHIP VALUES (@pd,@cd,@ip,@rel);"; cmd.CommandText = query; cmd.Prepare(); cmd.Parameters.AddWithValue("@pd", patient.getID()); cmd.Parameters.AddWithValue("@cd", client.getID()); cmd.Parameters.AddWithValue("@ip", isPrimary); cmd.Parameters.AddWithValue("@rel", posrel); cmd.ExecuteNonQuery(); CloseConnection(); tabControl1.SelectedIndex++; } else { } }
private void pNextButton_Click(object sender, EventArgs e) { //Patient Tab //get all the values in the fields & perform error checking //currently, clicking this button will register the Patient details into //the database. Will change this in the future so that if the user cancels the //registration, all table entries related to the cancelled registration //will be removed from the database. desig = pdesigCoB.Text; fname = pfnameIn.Text; sname = psnameIn.Text; mname = pmnameIn.Text; birthdate = pbdayPick.Value; //Get data from DateTime Picker if (Checker.check(fname)) Console.WriteLine("FNAME IS GOOD"); else Console.WriteLine("FNAME IS SHIT"); if (Checker.check(sname)) Console.WriteLine("SNAME IS GOOD"); else Console.WriteLine("SNAME IS SHIT"); if (Checker.check(mname)) Console.WriteLine("MNAME IS GOOD"); else Console.WriteLine("MNAME IS SHIT"); //following fields must not be blank gender = pgenCoB.Text; nationality = pnatIn.Text; religion = prelIn.Text; civstat = pcivStatCoB.Text; educattain = pedattCoB.Text; //fields for address. must not be blank! addline = paddlineIn.Text; city = pcityIn.Text; region = pregIn.Text; try { stnumber = UInt16.Parse(pstnoIn.Text); } catch (FormatException err) { Console.WriteLine("Street #: " + err.Message); } catch (OverflowException of) { Console.WriteLine("Street #: " + of.Message); } try { workNum = UInt16.Parse(pWorkIn.Text); homeNum = UInt16.Parse(pHomeIn.Text); mobNum = UInt16.Parse(pMobileIn.Text); otherNum = UInt16.Parse(pOtherIn.Text); } catch (Exception err) { } //get email //needs regex based error checking email = pemailIn.Text; //add fields to Patient Object patient.setName(desig, fname, mname, sname); patient.setBday(birthdate); patient.setGender(gender); patient.setNationality(nationality); patient.setReligion(religion); patient.setCivilStatus(civstat); patient.setEducAttainment(educattain); patient.setEmail(email); patient.setAddress(stnumber, addline, city, region); patient.setNumbers(homeNum, workNum, mobNum, otherNum); //displayStuff(patient); //open connection to database if (true) { RegisterPerson(patient); //insert into patient table OpenConnection(); string query = "SELECT LAST_INSERT_ID() FROM PERSON;"; cmd.CommandText = query; read = cmd.ExecuteReader(); read.Read(); Console.WriteLine(read.GetDecimal(0).ToString()); UInt16 lastID = UInt16.Parse(read.GetDecimal(0).ToString()); patient.setID(lastID); read.Close(); query = "INSERT INTO PATIENT(PatID) VALUES(@pid);"; cmd.CommandText = query; cmd.Prepare(); cmd.Parameters.AddWithValue("@pid", lastID); cmd.ExecuteNonQuery(); CloseConnection(); tabControl1.SelectedIndex++; } else { } //move to next tab }
public static LineaComponente GetLineaComponente(MySqlDataReader rdr) { LineaComponente lc = new LineaComponente(); lc.NumLinea = rdr.GetInt32("NUMLINEA"); lc.Articulo = rdr.GetString("NOMARTIC"); lc.Cantidad = rdr.GetDecimal("CANTIDAD"); return lc; }