/// <summary> /// Creates a new instance of the ViewAuditoriaListaVerificacionDetalleCross class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewAuditoriaListaVerificacionDetalleCrossInfo MakeViewAuditoriaListaVerificacionDetalleCross(SqlDataReader dataReader) { ViewAuditoriaListaVerificacionDetalleCrossInfo viewAuditoriaListaVerificacionDetalleCross = new ViewAuditoriaListaVerificacionDetalleCrossInfo(); if (dataReader.IsDBNull(AuditoriaListaVerificacionDetalleCargoId) == false) viewAuditoriaListaVerificacionDetalleCross.AuditoriaListaVerificacionDetalleCargoId = dataReader.GetInt32(AuditoriaListaVerificacionDetalleCargoId); if (dataReader.IsDBNull(AuditoriaListaVerificacionDetalleId) == false) viewAuditoriaListaVerificacionDetalleCross.AuditoriaListaVerificacionDetalleId = dataReader.GetInt32(AuditoriaListaVerificacionDetalleId); if (dataReader.IsDBNull(AuditoriaListaVerificacionId) == false) viewAuditoriaListaVerificacionDetalleCross.AuditoriaListaVerificacionId = dataReader.GetInt32(AuditoriaListaVerificacionId); if (dataReader.IsDBNull(CargoId) == false) viewAuditoriaListaVerificacionDetalleCross.CargoId = dataReader.GetInt32(CargoId); if (dataReader.IsDBNull(Cargo) == false) viewAuditoriaListaVerificacionDetalleCross.Cargo = dataReader.GetString(Cargo); if (dataReader.IsDBNull(Activo) == false) viewAuditoriaListaVerificacionDetalleCross.Activo = dataReader.GetBoolean(Activo); if (dataReader.IsDBNull(AuditoriaPunto) == false) viewAuditoriaListaVerificacionDetalleCross.AuditoriaPunto = dataReader.GetString(AuditoriaPunto); if (dataReader.IsDBNull(AuditoriaControl) == false) viewAuditoriaListaVerificacionDetalleCross.AuditoriaControl = dataReader.GetString(AuditoriaControl); if (dataReader.IsDBNull(PuntajeRequerido) == false) viewAuditoriaListaVerificacionDetalleCross.PuntajeRequerido = dataReader.GetDecimal(PuntajeRequerido); if (dataReader.IsDBNull(Empresa) == false) viewAuditoriaListaVerificacionDetalleCross.Empresa = dataReader.GetString(Empresa); if (dataReader.IsDBNull(Orden) == false) viewAuditoriaListaVerificacionDetalleCross.Orden = dataReader.GetByte(Orden); return viewAuditoriaListaVerificacionDetalleCross; }
/// <summary> /// 数据转用户实体 /// </summary> public static UserInfo DataToModel(SqlDataReader rdr) { UserInfo user = new UserInfo(); if (!rdr.IsDBNull(0)) user.UserID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) user.UserName = rdr.GetString(1); if (!rdr.IsDBNull(2)) user.UserPassword = rdr.GetString(2); if (!rdr.IsDBNull(3)) user.UserNickName = rdr.GetString(3); if (!rdr.IsDBNull(4)) user.UserImage = rdr.GetString(4); if (!rdr.IsDBNull(5)) user.UserPhone = rdr.GetString(5); if (!rdr.IsDBNull(6)) user.UserEmail = rdr.GetString(6); if (!rdr.IsDBNull(7)) user.UserTheme = rdr.GetString(7); if (!rdr.IsDBNull(8)) user.UserLevel = rdr.GetByte(8); if (!rdr.IsDBNull(9)) user.UserFrom = rdr.GetString(9); if (!rdr.IsDBNull(10)) user.ModifyDate = rdr.GetDateTime(10); if (!rdr.IsDBNull(11)) user.CreateDate = rdr.GetDateTime(11); if (!rdr.IsDBNull(12)) user.UserCity = rdr.GetString(12); if (!rdr.IsDBNull(13)) user.UserMoney = rdr.GetDecimal(13); if (!rdr.IsDBNull(14)) user.UserWorkDay = rdr.GetString(14); if (!rdr.IsDBNull(15)) user.UserFunction = rdr.GetString(15); if (!rdr.IsDBNull(16)) user.CategoryRate = rdr.GetInt32(16); if (!rdr.IsDBNull(17)) user.Synchronize = rdr.GetByte(17); if (!rdr.IsDBNull(18)) user.MoneyStart = rdr.GetDecimal(18); if (!rdr.IsDBNull(19)) user.IsUpdate = rdr.GetByte(19); return user; }
public List <Product> SearchProductListByName(string searchvalue) { List <Product> ProductList = new List <Product>(); Dao dao = new Dao(); string sqlStatement = "SELECT ProductID, ProductName, Price, Quantity, Image, Description, CategoryID FROM Product where ProductName Like N'%" + searchvalue + "%'"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader == null) { return(null); } while (reader.Read()) { try { int id = reader.GetInt32(0); string name = reader.GetString(1); double price = (double)reader.GetDecimal(2); int quantity = reader.GetInt32(3); string image = reader.GetString(4); string description = "sss"; int categoryID = reader.GetInt32(6); ProductList.Add(new Product(id, name, price, quantity, image, description, categoryID)); } catch (Exception) { } } dao.Con.Close(); return(ProductList); }
/// <summary> /// Creates a new instance of the ViewAuditoriaListaVerificacionDetalle class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewAuditoriaListaVerificacionDetalleInfo MakeViewAuditoriaListaVerificacionDetalle(SqlDataReader dataReader) { ViewAuditoriaListaVerificacionDetalleInfo viewAuditoriaListaVerificacionDetalle = new ViewAuditoriaListaVerificacionDetalleInfo(); if (dataReader.IsDBNull(AuditoriaListaVerificacionDetalleId) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaListaVerificacionDetalleId = dataReader.GetInt32(AuditoriaListaVerificacionDetalleId); if (dataReader.IsDBNull(AuditoriaListaVerificacionId) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaListaVerificacionId = dataReader.GetInt32(AuditoriaListaVerificacionId); if (dataReader.IsDBNull(AuditoriaPuntoId) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaPuntoId = dataReader.GetInt32(AuditoriaPuntoId); if (dataReader.IsDBNull(AuditoriaControlId) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaControlId = dataReader.GetInt32(AuditoriaControlId); if (dataReader.IsDBNull(PuntajeRequerido) == false) viewAuditoriaListaVerificacionDetalle.PuntajeRequerido = dataReader.GetDecimal(PuntajeRequerido); if (dataReader.IsDBNull(AuditoriaPunto) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaPunto = dataReader.GetString(AuditoriaPunto); if (dataReader.IsDBNull(AuditoriaControl) == false) viewAuditoriaListaVerificacionDetalle.AuditoriaControl = dataReader.GetString(AuditoriaControl); if (dataReader.IsDBNull(Orden) == false) viewAuditoriaListaVerificacionDetalle.Orden = dataReader.GetByte(Orden); if (dataReader.IsDBNull(Activo) == false) viewAuditoriaListaVerificacionDetalle.Activo = dataReader.GetBoolean(Activo); return viewAuditoriaListaVerificacionDetalle; }
private void button2_Click(object sender, EventArgs e) { if (tablaReg.Rows.Count == 0) { MessageBox.Show("Debe seleccionar por lo menos 1 Consumible"); return; } foreach (DataRow fila in tablaReg.Rows) { resultado = Home.BD.comando("EXEC GESTION_DE_GATOS.RegistrarConsXEstadiaXHab "+ textBox1.Text +","+ fila["Id"].ToString() + "," +textBox2.Text); if (resultado.Read()) { if (resultado.GetDecimal(0) == 0) { MessageBox.Show("Error. El consumible ya estaba agregado"); } } else { MessageBox.Show("Error. El consumible ya estaba agregado"); } resultado.Close(); } MessageBox.Show("El proceso de carga de consumibles finalizo correctamente"); this.Close(); }
public TList_Empreendimento Select(TpBusca[] vBusca, Int32 vTop, string vNM_Campo) { bool podeFecharBco = false; TList_Empreendimento lista = new TList_Empreendimento(); if (Banco_Dados == null) { this.CriarBanco_Dados(false); podeFecharBco = true; } System.Data.SqlClient.SqlDataReader reader = this.ExecutarBusca(this.SqlCodeBusca(vBusca, vTop, vNM_Campo)); try { while (reader.Read()) { TRegistro_Empreendimento reg = new TRegistro_Empreendimento(); if (!(reader.IsDBNull(reader.GetOrdinal("ID_Empreendimento")))) { reg.Id_empreendimento = reader.GetDecimal(reader.GetOrdinal("ID_Empreendimento")); } if (!(reader.IsDBNull(reader.GetOrdinal("CD_Empresa")))) { reg.Cd_empresa = reader.GetString(reader.GetOrdinal("CD_Empresa")); } if (!(reader.IsDBNull(reader.GetOrdinal("NM_Empresa")))) { reg.Nm_empresa = reader.GetString(reader.GetOrdinal("NM_Empresa")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Empreendimento"))) { reg.Ds_empreendimento = reader.GetString(reader.GetOrdinal("DS_Empreendimento")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Observacao"))) { reg.Ds_observacao = reader.GetString(reader.GetOrdinal("DS_Observacao")); } if (!reader.IsDBNull(reader.GetOrdinal("DT_IniEmpreendimento"))) { reg.Dt_iniempreendimento = reader.GetDateTime(reader.GetOrdinal("DT_IniEmpreendimento")); } if (!(reader.IsDBNull(reader.GetOrdinal("ST_Registro")))) { reg.St_registro = reader.GetString(reader.GetOrdinal("ST_Registro")); } lista.Add(reg); } } finally { reader.Close(); reader.Dispose(); if (podeFecharBco) { this.deletarBanco_Dados(); } } return(lista); }
public ClientesEstadia(string nroRes,string nroEst) { InitializeComponent(); nroReserva = nroRes; nroEstadia = nroEst; tabla = new DataTable(); tabla.Columns.Add("Id"); DataColumn column = tabla.Columns["Id"]; column.Unique = true; tabla.Columns.Add("Nombre"); tabla.Columns.Add("Apellido"); bSource2 = new BindingSource(); bSource2.DataSource = tabla; //set the DataGridView DataSource dataGridView1.DataSource = bSource2; consulta = "select sum(T.cantPersonas) from GESTION_DE_GATOS.ReservaXHabitacion RH,GESTION_DE_GATOS.Habitacion H,GESTION_DE_GATOS.TipoHabitacion T where RH.habitacion = H.idHabitacion and T.codigo=H.tipo and RH.reserva = " + nroReserva; resultado = Home.BD.comando(consulta); if (resultado.Read()) { textBox2.Text = resultado.GetDecimal(0).ToString(); totalPers = resultado.GetDecimal(0); resultado.Close(); } else { resultado.Close(); MessageBox.Show("La reserva no tiene habitaciones"); this.Close(); } consulta = "select C.idCli,C.nombre,C.apellido from GESTION_DE_GATOS.Reserva R,GESTION_DE_GATOS.Cliente C where R.cliente = C.idCli and R.idReserva = " + nroReserva; resultado = Home.BD.comando(consulta); resultado.Read(); textBox3.Text = resultado.GetString(1) + " " + resultado.GetString(2); persDisp = totalPers - 1; textBox4.Text = (persDisp).ToString(); idCli = resultado.GetDecimal(0); nombre = resultado.GetString(1); apellido = resultado.GetString(2); DataRow row = tabla.NewRow(); row["Id"] = idCli; row["Nombre"] = nombre; row["Apellido"] = apellido; tabla.Rows.Add(row); textBox1.Text = nroReserva; resultado.Close(); }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { consulta= "select H.numero,H.piso,T.descripcion,T.cantPersonas from GESTION_DE_GATOS.Habitacion H, GESTION_DE_GATOS.TipoHabitacion T where H.tipo = T.codigo and H.idHabitacion = "+comboBox1.Text; resultado = Home.BD.comando(consulta); if( resultado.Read()) { textBox1.Text = resultado.GetDecimal(0).ToString(); textBox2.Text = resultado.GetDecimal(1).ToString(); textBox4.Text = resultado.GetDecimal(3).ToString(); textBox3.Text = resultado.GetString(2); } else { MessageBox.Show("Error la habitacion no existe"); } resultado.Close(); }
/// <summary> /// 数据转类别实体 /// </summary> public static UserCategoryInfo DataToModel(SqlDataReader rdr) { UserCategoryInfo category = new UserCategoryInfo(); if (!rdr.IsDBNull(0)) category.CategoryTypeID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) category.CategoryTypeName = rdr.GetString(1); if (!rdr.IsDBNull(2)) category.CategoryTypePrice = rdr.GetDecimal(2); return category; }
/// <summary> /// 数据转钱包实体 /// </summary> public static CardInfo DataToModel(SqlDataReader rdr) { CardInfo card = new CardInfo(); if (!rdr.IsDBNull(0)) card.CardID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) card.CardName = rdr.GetString(1); if (!rdr.IsDBNull(2)) card.CardNumber = rdr.GetString(2); if (!rdr.IsDBNull(3)) card.CardImage = rdr.GetString(3); if (!rdr.IsDBNull(4)) card.CardMoney = rdr.GetDecimal(4); if (!rdr.IsDBNull(5)) card.CardLive = rdr.GetByte(5); if (!rdr.IsDBNull(6)) card.Synchronize = rdr.GetByte(6); if (!rdr.IsDBNull(7)) card.ModifyDate = rdr.GetDateTime(7); if (!rdr.IsDBNull(8)) card.CDID = rdr.GetInt32(8); if (!rdr.IsDBNull(9)) card.UserID = rdr.GetInt32(9); if (!rdr.IsDBNull(10)) card.MoneyStart = rdr.GetDecimal(10); if (!rdr.IsDBNull(11)) card.CardShow = rdr.GetByte(11); return card; }
public Modificacion_Direccion(decimal direccion) { InitializeComponent(); string consulta = "select nombre from GESTION_DE_GATOS.Pais"; resultado = Home.BD.comando(consulta); while (resultado.Read() == true) { comboBox1.Items.Add(resultado.GetSqlString(0)); } resultado.Close(); idDir = direccion; consulta = "select D.calle,D.numero,D.piso,D.depto,D.ciudad,P.nombre from GESTION_DE_GATOS.Direccion D,GESTION_DE_GATOS.Pais P where D.pais = P.idPais and D.idDir = " + direccion.ToString(); resultado = Home.BD.comando(consulta); if (resultado.Read()) { textBox1.Text = resultado.GetString(0); textBox2.Text = resultado.GetDecimal(1).ToString(); if(string.IsNullOrEmpty(resultado.GetValue(2).ToString())) { } else { textBox3.Text= resultado.GetDecimal(2).ToString(); } if (string.IsNullOrEmpty(resultado.GetValue(3).ToString())) { } else { textBox4.Text = resultado.GetString(3); } if (string.IsNullOrEmpty(resultado.GetValue(3).ToString())) { } else { textBox5.Text = resultado.GetString(4); } comboBox1.Text = resultado.GetString(5); } resultado.Close(); textBox1.Focus(); }
public Receipt GetReceiptByReceiptID(int id) { Receipt Receipt = null; Dao dao = new Dao(); string sqlStatement = "SELECT EmployeeID, TableNumber, PrintDate, Total, AdditionalFee FROM Receipt WHERE ReceiptID='" + id + "'"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader.Read()) { int emID = reader.GetInt32(0); int tablenumber = reader.GetInt32(1); DateTime date = reader.GetDateTime(2); double total = (double)reader.GetDecimal(3); double addFee = (double)reader.GetDecimal(4); Receipt = new Receipt(id, emID, tablenumber, date, total, addFee); } dao.Con.Close(); return(Receipt); }
public TList_LanServico_X_Duplicata Select(Utils.TpBusca[] vBusca, Int32 vTop, string vNM_Campo) { bool podeFecharBco = false; TList_LanServico_X_Duplicata lista = new TList_LanServico_X_Duplicata(); if (Banco_Dados == null) { podeFecharBco = this.CriarBanco_Dados(false); } System.Data.SqlClient.SqlDataReader reader = this.ExecutarBusca(this.SqlCodeBusca(vBusca, vTop, vNM_Campo)); try { while (reader.Read()) { TRegistro_LanServico_X_Duplicata reg = new TRegistro_LanServico_X_Duplicata(); if (!reader.IsDBNull(reader.GetOrdinal("id_os"))) { reg.Id_os = reader.GetDecimal(reader.GetOrdinal("id_os")); } if (!reader.IsDBNull(reader.GetOrdinal("cd_empresa"))) { reg.Cd_empresa = reader.GetString(reader.GetOrdinal("cd_empresa")); } if (!reader.IsDBNull(reader.GetOrdinal("nr_lancto"))) { reg.Nr_lancto = reader.GetDecimal(reader.GetOrdinal("nr_lancto")); } lista.Add(reg); } } finally { reader.Close(); reader.Dispose(); if (podeFecharBco) { this.deletarBanco_Dados(); } } return(lista); }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { string consulta="exec GESTION_DE_GATOS.BuscarHotelDeUser '"+comboBox1.SelectedItem+"' , "+Login.HomeLogin.idUsuario.ToString()+";"; resultado = Home.BD.comando(consulta); comboBox2.Items.Clear(); while (resultado.Read() == true) { comboBox2.Items.Add(resultado.GetDecimal(0)); } resultado.Close(); }
public TList_Empreendimento_X_LanCCusto Select(TpBusca[] vBusca, Int32 vTop, string vNM_Campo) { bool podeFecharBco = false; TList_Empreendimento_X_LanCCusto lista = new TList_Empreendimento_X_LanCCusto(); if (Banco_Dados == null) { this.CriarBanco_Dados(false); podeFecharBco = true; } System.Data.SqlClient.SqlDataReader reader = this.ExecutarBusca(this.SqlCodeBusca(vBusca, vTop, vNM_Campo)); try { while (reader.Read()) { TRegistro_Empreendimento_X_lanCCusto reg = new TRegistro_Empreendimento_X_lanCCusto(); if (!(reader.IsDBNull(reader.GetOrdinal("ID_Empreendimento")))) { reg.Id_empreendimento = reader.GetDecimal(reader.GetOrdinal("ID_Empreendimento")); } if (!(reader.IsDBNull(reader.GetOrdinal("ID_CCustoLan")))) { reg.Id_ccustolan = reader.GetDecimal(reader.GetOrdinal("ID_CCustoLan")); } lista.Add(reg); } } finally { reader.Close(); reader.Dispose(); if (podeFecharBco) { this.deletarBanco_Dados(); } } return(lista); }
public decimal GetDecimal(SqlDataReader row, string field) { try { var i = GetField(row, field); if (row.IsDBNull(i)) return 0m; return row.GetDecimal(i); } catch (Exception ex) { throw new Exception("BindingError: " + field, ex); } }
public Distribucion_Clientes(DataTable tablaP,string nroReserva, string nroEstadia) { InitializeComponent(); tabla = tablaP; estadia = nroEstadia; dataGridView1.DataSource = tabla; consulta= "select habitacion from GESTION_DE_GATOS.ReservaXHabitacion where reserva = "+nroReserva; resultado = Home.BD.comando(consulta); while( resultado.Read()) { comboBox1.Items.Add(resultado.GetDecimal(0)); } resultado.Close(); }
private void IntermediaUsuarioConRol_Load(object sender, EventArgs e) { string consulta = "select H.idHotel from GESTION_DE_GATOS.UserXRolXHotel U,GESTION_DE_GATOS.Hotel H where U.hotel=H.idHotel and U.usuario = " + Login.HomeLogin.idUsuario.ToString() + " order by H.idHotel"; resultado = Home.BD.comando(consulta); while (resultado.Read() == true) { comboBox1.Items.Add(resultado.GetDecimal(0)); } resultado.Close(); consulta = "select H.idHotel Id, H.nombre Nombre from GESTION_DE_GATOS.UserXRolXHotel U,GESTION_DE_GATOS.Hotel H where U.hotel=H.idHotel and U.usuario = " + Login.HomeLogin.idUsuario.ToString() + " order by H.idHotel"; DataTable result = Home.BD.consulta(consulta); dataGridView1.DataSource = result; }
public void Property(string key, SqlDataReader reader, int idx) { jsonWriter.WritePropertyName(key); string typeName = reader.GetDataTypeName(idx); if (reader.IsDBNull(idx)) jsonWriter.WriteNull(); else if (typeName == "decimal") jsonWriter.WriteValue(reader.GetDecimal(idx)); else if (typeName == "datetime") jsonWriter.WriteValue(reader.GetDateTime(idx)); else if (typeName == "varchar" || typeName == "nvarchar") jsonWriter.WriteValue(reader.GetString(idx)); else throw new Exception("Unknown data type " + typeName); }
public List <Receipt> GetReceiptList() { List <Receipt> ReceiptList = new List <Receipt>(); Dao dao = new Dao(); string sqlStatement = "SELECT ReceiptID, EmployeeID, TableNumber, PrintDate, Total, AdditionalFee FROM Receipt"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader == null) { return(null); } while (reader.Read()) { int reID = reader.GetInt32(0); int emID = reader.GetInt32(1); int tablenumber = reader.GetInt32(2); DateTime date = reader.GetDateTime(3); double total = (double)reader.GetDecimal(4); double addFee = (double)reader.GetDecimal(5); ReceiptList.Add(new Receipt(reID, emID, tablenumber, date, total, addFee)); } dao.Con.Close(); return(ReceiptList); }
public static long GetLong(SqlDataReader myReader, int myColumnNo) { Decimal myDecimal = new Decimal(); long myData = 0; try { myDecimal = myReader.GetDecimal(myColumnNo); myData = Convert.ToInt64(myDecimal); } catch (Exception) { myData = 0; } return myData; }
public List <ReceiptDetail> GetReceiptDetailByReceiptId(int receiptId) { List <ReceiptDetail> receiptDetailList = new List <ReceiptDetail>(); Dao dao = new Dao(); string sqlStatement = "SELECT ProductID, Quantity, Total FROM ReceiptDetails WHERE ReceiptID='" + receiptId + "'"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); while (reader.Read()) { int productID = reader.GetInt32(0); int quantity = reader.GetInt32(1); decimal total = reader.GetDecimal(2); receiptDetailList.Add(new ReceiptDetail(productID, quantity, Decimal.ToDouble(total))); } dao.Con.Close(); return(receiptDetailList); }
public Checkin() { InitializeComponent(); textBox1.Clear(); textBox1.Focus(); resok = 0; resultado = Home.BD.comando("Select idEstado from GESTION_DE_GATOS.Estado where descripcion = 'RESERVA CORRECTA'"); resultado.Read(); resok = resultado.GetDecimal(0); resultado.Close(); resmodif = 0; resultado = Home.BD.comando("Select idEstado from GESTION_DE_GATOS.Estado where descripcion = 'RESERVA MODIFICADA'"); resultado.Read(); resmodif = resultado.GetDecimal(0); resultado.Close(); }
/// <summary> /// 数据转转账实体 /// </summary> public static ZhuanZhangInfo DataToModel(SqlDataReader rdr) { ZhuanZhangInfo zhang = new ZhuanZhangInfo(); if (!rdr.IsDBNull(0)) zhang.ZhuanZhangID = rdr.GetInt32(0); if (!rdr.IsDBNull(1)) zhang.ZhuanZhangFrom = rdr.GetInt32(1); if (!rdr.IsDBNull(2)) zhang.ZhuanZhangTo = rdr.GetInt32(2); if (!rdr.IsDBNull(3)) zhang.ZhuanZhangDate = rdr.GetDateTime(3); if (!rdr.IsDBNull(4)) zhang.ZhuanZhangMoney = rdr.GetDecimal(4); if (!rdr.IsDBNull(5)) zhang.ZhuanZhangLive = rdr.GetByte(5); if (!rdr.IsDBNull(7)) zhang.Synchronize = rdr.GetByte(6); if (!rdr.IsDBNull(6)) zhang.ModifyDate = rdr.GetDateTime(7); if (!rdr.IsDBNull(7)) zhang.UserID = rdr.GetInt32(8); if (!rdr.IsDBNull(7)) zhang.ZhuanZhangNote = rdr.GetString(9); if (!rdr.IsDBNull(7)) zhang.ZZID = rdr.GetInt32(10); return zhang; }
public String[] getDBAlarm() { comm.Connection = conn; comm.Connection.Open(); comm.CommandText = "SELECT TOP 1 [ALARMOBJDN],[ALARMOBJTYPE],[ALARMLEVEL],CONVERT(DateTime,[BEGINTIME]) FROM [SunCoreDB].[dbo].[ALM_ALARMINFO]"; dr = comm.ExecuteReader(); dr.Read(); String[] alarm = new String[4]; alarm[0] = dr.GetString(0); alarm[1] = dr.GetString(1); alarm[2] = dr.GetDecimal(2).ToString(); alarm[3] = dr.GetDateTime(3).ToString(); comm.Connection.Close(); return alarm; }
public Payment GetPaymentByEmpID(int employeeID) { Payment payment = null; Dao dao = new Dao(); string sqlStatement = "SELECT PaymentID, EmployeeID, PayDate, TotalFee, Detail FROM Payment WHERE EmployeeID='" + employeeID + "'"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader.Read()) { int pID = reader.GetInt32(0); int eID = reader.GetInt32(1); DateTime pD = reader.GetDateTime(2); decimal tF = reader.GetDecimal(3); string de = reader.GetString(4); payment = new Payment(pID, eID, pD, Decimal.ToDouble(tF), de); } dao.Con.Close(); return(payment); }
public Product GetProductByName(string Name) { Product Product = null; Dao dao = new Dao(); string sqlStatement = "SELECT ProductID, Price, Quantity, Image, Description, CategoryID FROM Product WHERE ProductName='" + Name + "'"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader.Read()) { int id = reader.GetInt32(0); double price = (double)reader.GetDecimal(1); int quantity = reader.GetInt32(2); string image = reader.GetString(3); string description = reader.GetString(4); int categoryID = reader.GetInt32(5); Product = new Product(id, Name, price, quantity, image, description, categoryID); } dao.Con.Close(); return(Product); }
public Cancelacion() { InitializeComponent(); textBox1.Clear(); textBox1.Focus(); noshow = 0; resultado = Home.BD.comando("Select idEstado from GESTION_DE_GATOS.Estado where descripcion = 'RESERVA CANCELADA POR NO-SHOW'"); resultado.Read(); noshow = resultado.GetDecimal(0); resultado.Close(); canceUser = 0; resultado = Home.BD.comando("Select idEstado from GESTION_DE_GATOS.Estado where descripcion = 'RESERVA CANCELADA POR RECEPCION'"); resultado.Read(); canceUser = resultado.GetDecimal(0); resultado.Close(); cancelCli = 0; resultado = Home.BD.comando("Select idEstado from GESTION_DE_GATOS.Estado where descripcion = 'RESERVA CANCELADA POR CLIENTE'"); resultado.Read(); cancelCli = resultado.GetDecimal(0); resultado.Close(); }
public List <ReceiptDetail> GetReceiptDetailList() { List <ReceiptDetail> receiptDetailList = new List <ReceiptDetail>(); Dao dao = new Dao(); string sqlStatement = "SELECT ReceiptID, ProductID, Quantity, Total FROM ReceiptDetails"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader == null) { return(null); } while (reader.Read()) { int rID = reader.GetInt32(0); int pID = reader.GetInt32(1); int q = reader.GetInt32(2); decimal t = reader.GetDecimal(3); receiptDetailList.Add(new ReceiptDetail(rID, pID, q, Decimal.ToDouble(t))); } dao.Con.Close(); return(receiptDetailList); }
public double GetByMonth(string month) { double all = 0; List <Receipt> ReceiptList = new List <Receipt>(); Dao dao = new Dao(); try { string sqlStatement = "SELECT SUM(Total) FROM Receipt where FORMAT(PrintDate,'MM')= '" + month + "'"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader.Read()) { all = (double)reader.GetDecimal(0); } } catch (Exception e) { return(0); } dao.Con.Close(); return(all); }
public List <Payment> GetPaymentList() { List <Payment> paymentList = new List <Payment>(); Dao dao = new Dao(); string sqlStatement = "SELECT PaymentID, EmployeeID, PayDate, TotalFee, Detail FROM Payment"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader == null) { return(null); } while (reader.Read()) { int pID = reader.GetInt32(0); int eID = reader.GetInt32(1); DateTime pD = reader.GetDateTime(2); decimal tF = reader.GetDecimal(3); string de = reader.GetString(4); paymentList.Add(new Payment(pID, eID, pD, Decimal.ToDouble(tF), de)); } dao.Con.Close(); return(paymentList); }
public double GetByYear(int year) { double all = 0; List <Receipt> ReceiptList = new List <Receipt>(); Dao dao = new Dao(); try { string sqlStatement = "SELECT SUM(TotalFee) FROM Payment where FORMAT(PayDate,'yyyy')= '" + year + "'"; System.Data.SqlClient.SqlDataReader reader = dao.Get(sqlStatement); if (reader.Read()) { all = (double)reader.GetDecimal(0); } } catch (Exception e) { return(0); } dao.Con.Close(); return(all); }
public static void ReportBuilder(SqlDataReader dr, int cropYear, DateTime letterDate, DateTime deadlineDate, string logoUrl, System.IO.FileStream fs) { const string METHOD_NAME = "ReportBuilder"; const float primaryLeading = 13.5F; const float primaryLeftIndent = 20F; string strLetterDate = letterDate.ToString("MMMM dd, yyyy"); string strDeadlineDate = deadlineDate.ToString("MMMM dd, yyyy"); string LdoBusinessName = ""; string tmpStr = ""; string tmpStr2 = ""; Document document = null; PdfWriter writer = null; LandownerLetterEvent pgEvent = null; ColumnText ct = null; iTextSharp.text.Image imgLogo = null; try { while (dr.Read()) { LdoBusinessName = dr["LdoBusinessName"].ToString(); string LdoAddressLine1 = dr["LdoAddressLine1"].ToString(); string LdoAddressLine2 = dr["LdoAddressLine2"].ToString(); string LdoCityStateZip = dr["LdoCityStateZip"].ToString(); if (document == null) { // IF YOU CHANGE MARGINS, CHANGE YOUR TABLE LAYOUTS !!! // *** US LETTER: 612 X 792 *** document = new Document(PortraitPageSize.PgPageSize, PortraitPageSize.PgLeftMargin, PortraitPageSize.PgRightMargin, PortraitPageSize.PgTopMargin, PortraitPageSize.PgBottomMargin); imgLogo = PdfReports.GetImage(logoUrl, 127, 50, iTextSharp.text.Element.ALIGN_CENTER); // we create a writer that listens to the document // and directs a PDF-stream to a file writer = PdfWriter.GetInstance(document, fs); // Attach my override event handler(s) pgEvent = new LandownerLetterEvent(); pgEvent.FillEvent(imgLogo, strLetterDate, LdoBusinessName, LdoAddressLine1, LdoAddressLine2, LdoCityStateZip); writer.PageEvent = pgEvent; // Open the document document.Open(); } else { pgEvent.FillEvent(imgLogo, strLetterDate, LdoBusinessName, LdoAddressLine1, LdoAddressLine2, LdoCityStateZip); document.NewPage(); } ct = pgEvent.GetColumnObject(); Paragraph p = new Paragraph(primaryLeading, "Your tenant, " + dr["GroBusinessName"].ToString() + ", has indicated that the proceeds for sugar beets grown on your land in\n" + cropYear.ToString() + " are to be split and you will be receiving " + dr.GetDecimal(dr.GetOrdinal("LdoSplitPercent")).ToString("##.0##") + "% of the proceeds. Since Western Sugar Cooperative no\n" + "longer requires signatures for the second payees, this letter has been sent for your verification.\n\n", _normalFont); ct.AddElement(p); p = new Paragraph(new Phrase(primaryLeading, "Your check will be made payable as follows:", _normalFont)); ct.AddElement(p); p = new Paragraph(primaryLeading, dr["ldoPayeeDescription"].ToString(), _normalFont); p.IndentationLeft = primaryLeftIndent; ct.AddElement(p); p = new Paragraph(primaryLeading, "If you have a lien on the beets, the lien holder’s name should be included above.\n\n" + "In addition, the following options were selected by your tenant.", _normalFont); ct.AddElement(p); decimal ldoChemPct = dr.GetDecimal(dr.GetOrdinal("LdoChemicalSplitPct")); if (dr.GetBoolean(dr.GetOrdinal("IsSplitChemical")) && ldoChemPct != 0) { tmpStr = ldoChemPct.ToString("##.0##") + "%"; } else { tmpStr = "No"; } decimal ldoRetainPct = dr.GetDecimal(dr.GetOrdinal("LdoSplitPercent")); if (dr.GetBoolean(dr.GetOrdinal("IsSplitRetain")) && ldoRetainPct != 0) { tmpStr2 = ldoRetainPct.ToString("##.0##") + "% of the"; } else { tmpStr2 = "No"; } p = new Paragraph(primaryLeading, tmpStr2 + " Unit Retains on this contract will be deducted from your proceeds.\n" + tmpStr + " seed & chemical receivables charged to this contract will be deducted from your proceeds.", _normalFont); p.IndentationLeft = primaryLeftIndent; ct.AddElement(p); p = new Paragraph(primaryLeading, "If the above information is correct, no response is needed.\n\n", _normalFont); ct.AddElement(p); p = new Paragraph(primaryLeading, "If any of the above information is not correct, please contact your tenant’s agriculturist, " + dr["AgriculturistName"].ToString() + " at\n" + WSCIEMP.Common.CodeLib.FormatPhoneNumber2Display(dr["AgriculturistPhone"].ToString()) + " by " + strDeadlineDate + ", or mail the corrections to:\n\n", _normalFont); ct.AddElement(p); p = new Paragraph(12F, "Western Sugar Cooperative\n" + "Attn: Marty Smith\n" + "1221 8th Avenue Unit E\n" + "Greeley, CO 80631\n\n", _normalFont); p.IndentationLeft = primaryLeftIndent; ct.AddElement(p); p = new Paragraph(primaryLeading, "Sincerely,\n\n" + "Marty Smith\n" + "Beet Accounting Manager\n\n" + "Ref: " + dr["ContractNo"].ToString(), _normalFont); ct.AddElement(p); ct.Go(false); } // ====================================================== // Close document // ====================================================== if (document != null) { pgEvent.IsDocumentClosing = true; document.Close(); document = null; } if (writer == null || String.IsNullOrEmpty(LdoBusinessName)) { // Warn that we have no data. WSCIEMP.Common.CWarning warn = new WSCIEMP.Common.CWarning("No records matched your report criteria."); throw (warn); } } catch (Exception ex) { string errMsg = "document is null: " + (document == null).ToString() + "; " + "writer is null: " + (writer == null).ToString(); WSCIEMP.Common.CException wscex = new WSCIEMP.Common.CException(MOD_NAME + METHOD_NAME + errMsg, ex); throw (wscex); } finally { if (document != null) { pgEvent.IsDocumentClosing = true; document.Close(); } if (writer != null) { writer.Close(); } } }
protected static void PopulateEntity(SqlDataReader reader, ServerEntity entity, Dictionary<string, PropertyInfo> propMap) { for (int i = 0; i < reader.FieldCount; i++) { String columnName = reader.GetName(i); // Special case for when we select a range of values with an EntityBroker, just ignore if (columnName.Equals("RowNum")) continue; if (columnName.Equals("GUID")) { Guid uid = reader.GetGuid(i); entity.SetKey(new ServerEntityKey(entity.Name, uid)); continue; } if (columnName.Equals(entity.Name) && columnName.Contains("Enum")) columnName = "Enum"; PropertyInfo prop; if (!propMap.TryGetValue(columnName, out prop)) throw new EntityNotFoundException("Unable to match column to property: " + columnName, null); if (columnName.Contains("GUID")) columnName = columnName.Replace("GUID", "Key"); if (reader.IsDBNull(i)) { prop.SetValue(entity, null, null); continue; } Type propType = prop.PropertyType; if (propType == typeof(String)) prop.SetValue(entity, reader.GetString(i), null); else if (propType == typeof(ServerEntityKey)) { Guid uid = reader.GetGuid(i); prop.SetValue(entity, new ServerEntityKey(columnName.Replace("Key", String.Empty), uid), null); } else if (propType == typeof(DateTime)) prop.SetValue(entity, reader.GetDateTime(i), null); else if (propType == typeof(DateTime?)) { if (reader.IsDBNull(i)) { prop.SetValue(entity, null, null); } else { prop.SetValue(entity, reader.GetDateTime(i), null); } } else if (propType == typeof(bool)) prop.SetValue(entity, reader.GetBoolean(i), null); else if (propType == typeof(Int32)) prop.SetValue(entity, reader.GetInt32(i), null); else if (propType == typeof(Int16)) prop.SetValue(entity, reader.GetInt16(i), null); else if (propType == typeof(double)) prop.SetValue(entity, reader.GetDouble(i), null); else if (propType == typeof(Decimal)) prop.SetValue(entity, reader.GetDecimal(i), null); else if (propType == typeof(float)) prop.SetValue(entity, reader.GetFloat(i), null); else if (propType == typeof(XmlDocument)) { SqlXml xml = reader.GetSqlXml(i); if (xml!=null && !xml.IsNull) { XmlReader xmlReader = xml.CreateReader(); if (xmlReader != null) { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(xmlReader); prop.SetValue(entity, xmlDoc, null); } else prop.SetValue(entity, null, null); } else { prop.SetValue(entity, null, null); } } else if (typeof(ServerEnum).IsAssignableFrom(propType)) { short enumVal = reader.GetInt16(i); ConstructorInfo construct = prop.PropertyType.GetConstructor(new Type[0]); ServerEnum val = (ServerEnum)construct.Invoke(null); val.SetEnum(enumVal); prop.SetValue(entity, val, null); } else throw new EntityNotFoundException("Unsupported property type: " + propType, null); } }
/// <summary> /// Creates a new instance of the ViewResultadoAuditoriaTipo class and populates it with data from the specified SqlDataReader. /// </summary> private static ViewResultadoAuditoriaTipoInfo MakeViewResultadoAuditoriaTipo(SqlDataReader dataReader) { ViewResultadoAuditoriaTipoInfo viewResultadoAuditoriaTipo = new ViewResultadoAuditoriaTipoInfo(); if (dataReader.IsDBNull(AuditoriaId) == false) viewResultadoAuditoriaTipo.AuditoriaId = dataReader.GetInt32(AuditoriaId); if (dataReader.IsDBNull(AuditoriaTipoId) == false) viewResultadoAuditoriaTipo.AuditoriaTipoId = dataReader.GetInt32(AuditoriaTipoId); if (dataReader.IsDBNull(AuditoriaTipo) == false) viewResultadoAuditoriaTipo.AuditoriaTipo = dataReader.GetString(AuditoriaTipo); if (dataReader.IsDBNull(Periodo) == false) viewResultadoAuditoriaTipo.Periodo = dataReader.GetString(Periodo); if (dataReader.IsDBNull(Territorio) == false) viewResultadoAuditoriaTipo.Territorio = dataReader.GetString(Territorio); if (dataReader.IsDBNull(Grupo) == false) viewResultadoAuditoriaTipo.Grupo = dataReader.GetString(Grupo); if (dataReader.IsDBNull(PuntajeRequerido) == false) viewResultadoAuditoriaTipo.PuntajeRequerido = dataReader.GetDecimal(PuntajeRequerido); if (dataReader.IsDBNull(PuntajeObtenido) == false) viewResultadoAuditoriaTipo.PuntajeObtenido = dataReader.GetDecimal(PuntajeObtenido); if (dataReader.IsDBNull(Cargo) == false) viewResultadoAuditoriaTipo.Cargo = dataReader.GetString(Cargo); if (dataReader.IsDBNull(ResultadoCargo) == false) viewResultadoAuditoriaTipo.ResultadoCargo = dataReader.GetDecimal(ResultadoCargo); if (dataReader.IsDBNull(Orden) == false) viewResultadoAuditoriaTipo.Orden = dataReader.GetByte(Orden); return viewResultadoAuditoriaTipo; }
private static Registration MakeRegistration(SqlDataReader dataReader) { Registration registration = new Registration(); if (dataReader.IsDBNull(0) == false) { registration.StudentID = dataReader.GetInt32(0); } if (dataReader.IsDBNull(1) == false) { registration.Name = dataReader.GetString(1); } if (dataReader.IsDBNull(2) == false) { registration.DateOfBirth = dataReader.GetDateTime(2); } if (dataReader.IsDBNull(3) == false) { registration.GradePointAvg = dataReader.GetDecimal(3); } if (dataReader.IsDBNull(4) == false) { registration.Active = dataReader.GetBoolean(4); } return registration; }
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e) { consulta = "select cantPersonas from GESTION_DE_GATOS.TipoHabitacion where descripcion = '" + comboBox2.SelectedItem + "'"; resultado = Home.BD.comando(consulta); if (resultado.Read()) { textBox1.Text = resultado.GetDecimal(0).ToString(); } resultado.Close(); }
private void button2_Click(object sender, EventArgs e) { if (habitaciones == "" || cant == 0) { MessageBox.Show("Debe seleccionar por lo menos una habitacion"); return; } if (string.IsNullOrEmpty(textBox2.Text)) { MessageBox.Show("Debe seleccionar 1 cliente"); return; } bool estado = false; resultado = Home.BD.comando("select habilitado from GESTION_DE_GATOS.Cliente where idCli =" + textBox2.Text); if (resultado.Read()) { estado = resultado.GetBoolean(0); } resultado.Close(); if (estado == false) { MessageBox.Show("Cliente Inhabilitado para realizar reservas"); return; } //AHORA LOS INSERTS string insert = "EXEC GESTION_DE_GATOS.InsertarReserva "; insert = insert + "'" + dateTimePicker1.Value.Date.ToString("yyyyMMdd HH:mm:ss") + "',"; insert = insert + "'" + comboBox3.Text + "',"; insert = insert + "'" + dateTimePicker2.Value.Date.ToString("yyyyMMdd HH:mm:ss") + "',"; insert = insert + "'" + Home.fecha.Date.ToString("yyyyMMdd HH:mm:ss") + "',"; insert = insert + Login.HomeLogin.idUsuario + ","; insert = insert + textBox2.Text + ","; double ab = (dateTimePicker2.Value.Date - dateTimePicker1.Value.Date).TotalDays; insert = insert + ab.ToString() + ","; insert = insert + Convert.ToInt32(total).ToString(); decimal id = 0; resultado = Home.BD.comando(insert); if (resultado.Read() == true) { id = resultado.GetDecimal(0); } resultado.Close(); if (id == 0) { MessageBox.Show("No se pudo generar la reserva"); button1_Click(null, null); return; } string comand = "EXEC GESTION_DE_GATOS.InsertarReservaXHabitacion " + id.ToString() + ","; string[] strArr = null; int count = 0; char[] splitchar = { ',' }; comand = "EXEC GESTION_DE_GATOS.InsertarReservaXHabitacion " + id.ToString() + ","; if (cant > 1) { strArr = null; count = 0; strArr = habitaciones.Split(splitchar); for (count = 0; count <= strArr.Length - 1; count++) { resultado = Home.BD.comando(comand + strArr[count]); if (!resultado.Read()) { MessageBox.Show("No se pudo insertar la habitacion a la reserva,error en el read"); resultado.Close(); return; } decimal a = resultado.GetDecimal(0); if (a == 0) { MessageBox.Show("No se pudo insertar la habitacion a la reserva, no cumplio el unique"); resultado.Close(); return; } resultado.Close(); } } else { resultado = Home.BD.comando(comand + habitaciones); if (!resultado.Read()) { MessageBox.Show("No se pudo insertar la habitacion a la reserva,error en el read"); resultado.Close(); return; } decimal b = resultado.GetDecimal(0); if (b == 0) { MessageBox.Show("No se pudo insertar la habitacion a la reserva, no cumplio el unique"); resultado.Close(); return; } resultado.Close(); } MessageBox.Show("Reserva generada correctamente, su numero de reserva es: "+id.ToString()); this.Close(); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 0) { string numero = dataGridView1.CurrentRow.Cells[1].Value.ToString(); string piso = dataGridView1.CurrentRow.Cells[2].Value.ToString(); string tipo = dataGridView1.CurrentRow.Cells[4].Value.ToString(); string estado = dataGridView1.CurrentRow.Cells[6].Value.ToString(); if (estado == "False") { MessageBox.Show("No se puede eliminar porque ya esta en estado inactivo"); return; } if (MessageBox.Show("Estas seguro que desea eliminar?", "AVISO", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { decimal id = 0; decimal tipoT = 0; consulta = "select codigo from GESTION_DE_GATOS.TipoHabitacion where descripcion = '" + tipo + "'"; resultado = Home.BD.comando(consulta); if (resultado.Read()) { tipoT = resultado.GetDecimal(0); } resultado.Close(); consulta = "select idHabitacion from GESTION_DE_GATOS.Habitacion where numero = " + numero + " and piso = " + piso + " and hotel = " + Login.HomeLogin.hotel + " and tipo = " + tipoT; resultado = Home.BD.comando(consulta); if (resultado.Read()) { id = resultado.GetDecimal(0); } resultado.Close(); consulta = "update GESTION_DE_GATOS.Habitacion set estado=0 where idHabitacion = " + id; resultado = Home.BD.comando(consulta); if (resultado.Read() == true) { } resultado.Close(); } Baja_Load(null, null); } }
public TList_Plantio Select(Utils.TpBusca[] vBusca, Int32 vTop, string vNm_Campo) { TList_Plantio lista = new TList_Plantio(); System.Data.SqlClient.SqlDataReader reader = null; bool podeFecharBco = false; if (Banco_Dados == null) { podeFecharBco = this.CriarBanco_Dados(false); } try { reader = this.ExecutarBusca(this.SqlCodeBusca(vBusca, Convert.ToInt16(vTop), vNm_Campo)); while (reader.Read()) { TRegistro_Plantio reg = new TRegistro_Plantio(); if (!reader.IsDBNull(reader.GetOrdinal("Id_Plantio"))) { reg.Id_plantio = reader.GetDecimal(reader.GetOrdinal("Id_Plantio")); } if (!reader.IsDBNull(reader.GetOrdinal("id_cultura"))) { reg.Id_cultura = reader.GetDecimal(reader.GetOrdinal("id_cultura")); } if (!reader.IsDBNull(reader.GetOrdinal("ds_cultura"))) { reg.Ds_cultura = reader.GetString(reader.GetOrdinal("ds_cultura")); } if (!reader.IsDBNull(reader.GetOrdinal("sigla_unidade"))) { reg.Sigla_unidade = reader.GetString(reader.GetOrdinal("sigla_unidade")); } if (!reader.IsDBNull(reader.GetOrdinal("cd_produto"))) { reg.Cd_produto = reader.GetString(reader.GetOrdinal("cd_produto")); } if (!reader.IsDBNull(reader.GetOrdinal("ds_produto"))) { reg.Ds_produto = reader.GetString(reader.GetOrdinal("ds_produto")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Observacao"))) { reg.Ds_observacao = reader.GetString(reader.GetOrdinal("DS_Observacao")); } if (!reader.IsDBNull(reader.GetOrdinal("AnoSafra"))) { reg.Anosafra = reader.GetString(reader.GetOrdinal("AnoSafra")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Safra"))) { reg.Ds_safra = reader.GetString(reader.GetOrdinal("DS_Safra")); } if (!reader.IsDBNull(reader.GetOrdinal("DT_IniPlantio"))) { reg.Dt_iniplantio = reader.GetDateTime(reader.GetOrdinal("DT_IniPlantio")); } if (!reader.IsDBNull(reader.GetOrdinal("DT_FinPlantio"))) { reg.Dt_finplantio = reader.GetDateTime(reader.GetOrdinal("DT_FinPlantio")); } if (!reader.IsDBNull(reader.GetOrdinal("QT_SementesPorMetro"))) { reg.Qt_sementespormetro = reader.GetDecimal(reader.GetOrdinal("QT_SementesPorMetro")); } if (!reader.IsDBNull(reader.GetOrdinal("EspacoSemente"))) { reg.Espacosemente = reader.GetDecimal(reader.GetOrdinal("EspacoSemente")); } lista.Add(reg); } } finally { reader.Close(); reader.Dispose(); if (podeFecharBco) { this.deletarBanco_Dados(); } } return(lista); }
/// <summary> /// Creates a new instance of the AuditoriaResultado class and populates it with data from the specified SqlDataReader. /// </summary> private static AuditoriaResultadoInfo MakeAuditoriaResultado(SqlDataReader dataReader) { AuditoriaResultadoInfo auditoriaResultado = new AuditoriaResultadoInfo(); if (dataReader.IsDBNull(AuditoriaResultadoId) == false) auditoriaResultado.AuditoriaResultadoId = dataReader.GetInt32(AuditoriaResultadoId); if (dataReader.IsDBNull(AuditoriaId) == false) auditoriaResultado.AuditoriaId = dataReader.GetInt32(AuditoriaId); if (dataReader.IsDBNull(AuditoriaPuntoId) == false) auditoriaResultado.AuditoriaPuntoId = dataReader.GetInt32(AuditoriaPuntoId); if (dataReader.IsDBNull(AuditoriaControlId) == false) auditoriaResultado.AuditoriaControlId = dataReader.GetInt32(AuditoriaControlId); if (dataReader.IsDBNull(PuntajeRequerido) == false) auditoriaResultado.PuntajeRequerido = dataReader.GetDecimal(PuntajeRequerido); if (dataReader.IsDBNull(PuntajeObtenido) == false) auditoriaResultado.PuntajeObtenido = dataReader.GetDecimal(PuntajeObtenido); if (dataReader.IsDBNull(ResultadoPunto) == false) auditoriaResultado.ResultadoPunto = dataReader.GetDecimal(ResultadoPunto); if (dataReader.IsDBNull(EsNoConformidad) == false) auditoriaResultado.EsNoConformidad = dataReader.GetBoolean(EsNoConformidad); if (dataReader.IsDBNull(AuditoriaCausaRaizId) == false) auditoriaResultado.AuditoriaCausaRaizId = dataReader.GetInt32(AuditoriaCausaRaizId); if (dataReader.IsDBNull(Observacion) == false) auditoriaResultado.Observacion = dataReader.GetString(Observacion); return auditoriaResultado; }
public TList_Plantio_X_Talhoes Select(Utils.TpBusca[] vBusca, Int32 vTop, string vNm_Campo) { TList_Plantio_X_Talhoes lista = new TList_Plantio_X_Talhoes(); System.Data.SqlClient.SqlDataReader reader = null; bool podeFecharBco = false; if (Banco_Dados == null) { podeFecharBco = this.CriarBanco_Dados(false); } try { reader = this.ExecutarBusca(this.SqlCodeBusca(vBusca, Convert.ToInt16(vTop), vNm_Campo)); while (reader.Read()) { TRegistro_Plantio_X_Talhoes reg = new TRegistro_Plantio_X_Talhoes(); if (!reader.IsDBNull(reader.GetOrdinal("Id_Plantio"))) { reg.Id_plantio = reader.GetDecimal(reader.GetOrdinal("Id_Plantio")); } if (!reader.IsDBNull(reader.GetOrdinal("ID_Talhao"))) { reg.Id_talhao = reader.GetDecimal(reader.GetOrdinal("ID_Talhao")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Talhao"))) { reg.Ds_talhao = reader.GetString(reader.GetOrdinal("DS_Talhao")); } if (!reader.IsDBNull(reader.GetOrdinal("area_talhao"))) { reg.Area_talhao = reader.GetDecimal(reader.GetOrdinal("area_talhao")); } if (!reader.IsDBNull(reader.GetOrdinal("ID_Area"))) { reg.Id_area = reader.GetDecimal(reader.GetOrdinal("ID_Area")); } if (!reader.IsDBNull(reader.GetOrdinal("DS_Area"))) { reg.Ds_area = reader.GetString(reader.GetOrdinal("DS_Area")); } if (!reader.IsDBNull(reader.GetOrdinal("CD_Fazenda"))) { reg.Cd_fazenda = reader.GetString(reader.GetOrdinal("CD_Fazenda")); } if (!reader.IsDBNull(reader.GetOrdinal("NM_Fazenda"))) { reg.Nm_fazenda = reader.GetString(reader.GetOrdinal("NM_Fazenda")); } if (!reader.IsDBNull(reader.GetOrdinal("sigla_unidade"))) { reg.Sigla_unidade = reader.GetString(reader.GetOrdinal("sigla_unidade")); } if (!reader.IsDBNull(reader.GetOrdinal("Area_Plantada"))) { reg.Area_plantada = reader.GetDecimal(reader.GetOrdinal("Area_Plantada")); } if (!reader.IsDBNull(reader.GetOrdinal("producao_prevista"))) { reg.Producao_prevista = reader.GetDecimal(reader.GetOrdinal("producao_prevista")); } lista.Add(reg); } } finally { reader.Close(); reader.Dispose(); if (podeFecharBco) { this.deletarBanco_Dados(); } } return(lista); }
private bool IsValidateVIP() { bool vip = false; string sql = @" SELECT Salute,FullName,WorkTel,HomeTel,ISNULL(PagerTel,''),Email,Birthday,[Profile],Remarks, DateOfRegister,ExpiryDate,VipNumber,CodeNumber,LoyaltyNum, SUM(TxCount) AS AccumulativeTranscations, SUM(TxAmount) AS AccumulativeSpending, CONVERT(VARCHAR(10),TxDate,126) AS TxDate FROM (SELECT Salute,FullName,WorkTel,HomeTel,PagerTel,Email,CAST(Birthday AS DateTime) AS Birthday,[Profile],Remarks, CAST(DateOfRegister AS DateTime) AS DateOfRegister,ExpiryDate,HKID,VipNumber,CodeNumber,LoyaltyNum, MemberNumber, TxDate,TxNumber, TxType, 1 AS TxCount, SUM((CASE TxType WHEN 'CAS' THEN 1 ELSE -1 END) * Amount) AS TxAmount FROM dbo.vwVIPSalesAnalysis GROUP BY Salute,FullName,WorkTel,HomeTel,PagerTel,Email,Birthday,[Profile],Remarks, DateOfRegister,ExpiryDate,HKID,VipNumber,CodeNumber,LoyaltyNum,MemberNumber,TxDate,TxNumber,TxType) lst "; string whereCaluse = string.Empty; if (this.txtNumber.Text.Trim().Length > 0) { whereCaluse = " lst.MemberNumber ='" + this.txtNumber.Text.Trim() + "'"; } if (this.txtHKID.Text.Trim().Length > 0) { whereCaluse += (whereCaluse.Length > 0 ? " OR " : "") + " lst.HKID ='" + this.txtHKID.Text.Trim() + "'"; } if (this.txtLoyalty.Text.Trim().Length > 0) { whereCaluse += (whereCaluse.Length > 0 ? " OR " : "") + " lst.LoyaltyNum ='" + this.txtLoyalty.Text.Trim() + "'"; } if (this.txtCode.Text.Trim().Length > 0) { whereCaluse += (whereCaluse.Length > 0 ? " OR " : "") + " lst.CodeNumber ='" + this.txtCode.Text.Trim() + "'"; } whereCaluse += " AND (CONVERT(NVARCHAR(10),TxDate,126) BETWEEN '" + this.dtDateFrom.Value.ToString("yyyy-MM-dd") + "' AND '" + this.dtDateTo.Value.ToString("yyyy-MM-dd") + "')"; whereCaluse += "GROUP BY CONVERT(VARCHAR(10),TxDate,126),Salute,FullName,WorkTel,HomeTel,PagerTel,Email,Birthday,[Profile],Remarks,DateOfRegister,ExpiryDate,VipNumber,CodeNumber,LoyaltyNum"; sql = sql + string.Format(" WHERE {0}", whereCaluse); SqlCommand cmd = new SqlCommand(); cmd.CommandText = sql; cmd.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimedOut"]); cmd.CommandType = CommandType.Text; using (System.Data.SqlClient.SqlDataReader reader = SqlHelper.Default.ExecuteReader(cmd)) { decimal spending = 0; int trnNo = 0; while (reader.Read()) { vip = true; txtSalute.Text = ": " + reader.GetString(0); txtVipName.Text = ": " + reader.GetString(1); txtContactNumber.Text = ": " + reader.GetString(2) + "\t"; txtContactNumber.Text += "/" + reader.GetString(3) + "\t"; txtContactNumber.Text += "/" + reader.GetString(4); txtEmail.Text = ": " + reader.GetString(5); txtBirthday.Text = ": " + reader.GetDateTime(6).ToString("dd/MM/yyyy").Replace("01/01/1900", ""); txtProfile.Text = ": " + reader.GetString(7); txtRemarks.Text = ": " + reader.GetString(8); txtRegDate.Text = ": " + reader.GetDateTime(9).ToString("dd/MM/yyyy").Replace("01/01/1900", ""); txtExpiryDate.Text = ": " + reader.GetDateTime(10).ToString("dd/MM/yyyy").Replace("01/01/1900", ""); txtTypeAndNumber.Text = ": " + "EXVIP \t" + reader.GetString(11) + "\t"; txtTypeAndNumber.Text += "/" + reader.GetString(12) + "\t"; txtTypeAndNumber.Text += "/" + reader.GetString(13); spending += reader.GetDecimal(15); txtAccumulativeSpending.Text = ": " + spending.ToString("C"); trnNo += reader.GetInt32(14); txtAccumulativeTransactionNumber.Text = ": " + trnNo.ToString("n0"); } } return(vip); }
/// <summary> /// Gets the user from data reader. /// </summary> /// <param name="user_list">The user_list.</param> /// <returns>User from database</returns> private static User GetUserFromDataReader( SqlDataReader user_list ) { return new User( user_list.GetString( 0 ), user_list.GetString( 1 ), user_list.GetInt32( 2 ), user_list.GetInt32( 3 ), user_list.GetString( 4 ), user_list.GetBoolean( 5 ), user_list.GetDateTime( 6 ), user_list.GetString( 7 ), user_list.GetBoolean( 8 ), user_list.GetBoolean( 9 ), user_list.GetDateTime( 10 ), user_list.GetGuid( 11 ), user_list.GetBoolean( 12 ), user_list.GetBoolean( 13 ), user_list.GetInt32( 14 ), user_list.GetDecimal( 15 ), user_list.GetBoolean( 16 ), user_list.GetString( 17 ), user_list.GetDecimal( 18 ), user_list.GetString( 19 ), user_list.GetString( 20 ), user_list.GetString( 21 ), user_list.GetString( 22 ), user_list.GetString( 23 ), user_list.GetString( 24 ), user_list.GetString( 25 ), user_list.GetString( 26 ), user_list.GetString( 27 ), user_list.GetString( 28 ), user_list.GetString( 39 ), user_list.GetString( 30 ), user_list.GetString( 31 ), user_list.GetInt32( 32 ), user_list.GetBoolean( 33 ), user_list.GetInt32( 34 ), user_list.GetString( 35 ), user_list.GetBoolean( 36 ), user_list.GetBoolean( 37 ), user_list.GetString( 38 ), user_list.GetString( 39 ), user_list.GetString( 40 ), user_list.GetString( 41 ), user_list.GetString( 42 ), user_list.GetInt32( 43 ), user_list.GetString( 44 ), user_list.GetBoolean( 45 ), user_list.GetBoolean( 46 ), user_list.GetInt32( 47 ), user_list.GetInt32( 48 ), user_list.GetString( 49 ), user_list.GetInt32( 50 ), user_list.GetString( 51 ) ); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 0) { if(Convert.ToInt32(comboBox1.SelectedIndex) == -1) { MessageBox.Show("Debe seleccionar una habitacion"); return; } int index = dataGridView1.CurrentRow.Index; consulta = "select count(*) from GESTION_DE_GATOS.ClienteXEstadia where estadia = "+estadia +" and habitacion = "+comboBox1.Text; resultado = Home.BD.comando(consulta); resultado.Read(); int aux = resultado.GetInt32(0); resultado.Close(); if(aux < Convert.ToInt32(textBox4.Text)) { consulta = "EXEC GESTION_DE_GATOS.ModificarClienteXEstadia "+comboBox1.Text+ ","+dataGridView1.CurrentRow.Cells[1].Value.ToString()+","+estadia; resultado = Home.BD.comando(consulta); resultado.Read(); if(resultado.GetDecimal(0)==1) { MessageBox.Show("El cliente se agrego correctamente"); tabla.Rows.RemoveAt(index); dataGridView1.DataSource = tabla; resultado.Close(); } else { resultado.Close(); MessageBox.Show("El cliente ya estaba agregado a esa estadia"); return; } } else { MessageBox.Show("Esa habitacion ya esta llena"); } } }
Patient getNextPatient(SqlDataReader reader) { Patient p = new Patient(); p.LocalSiteId = (reader.GetInt16(reader.GetOrdinal("sitecode"))).ToString(); Decimal d = Convert.ToDecimal(reader.GetDecimal(reader.GetOrdinal("localPid"))); if ((d - Math.Floor(d)) > 0) { p.LocalPid = (d).ToString(); } else { p.LocalPid = (Convert.ToInt64(d)).ToString(); } p.Name = new PersonName(reader.GetString(reader.GetOrdinal("name"))); p.SSN = new SocSecNum(reader.GetString(reader.GetOrdinal("ssn"))); if (!reader.IsDBNull(reader.GetOrdinal("gender"))) { p.Gender = reader.GetBoolean(reader.GetOrdinal("gender")) ? "M" : "F"; // 1 or true == male, 0 or false == female } else { p.Gender = ""; } if (!reader.IsDBNull(reader.GetOrdinal("vistaDOB"))) { p.DOB = reader.GetString(reader.GetOrdinal("vistaDOB")); } p.MpiPid = (reader.GetInt32(reader.GetOrdinal("icn"))).ToString(); p.MpiChecksum = (reader.GetInt32(reader.GetOrdinal("icnx"))).ToString(); p.Demographics = new Dictionary<string, DemographicSet>(); DemographicSet demogs = new DemographicSet(); demogs.PhoneNumbers = new List<PhoneNum>(); demogs.EmailAddresses = new List<EmailAddress>(); demogs.StreetAddresses = new List<Address>(); if (!reader.IsDBNull(reader.GetOrdinal("homePhone"))) { demogs.PhoneNumbers.Add(new PhoneNum(reader.GetString(reader.GetOrdinal("homePhone")))); } if (!reader.IsDBNull(reader.GetOrdinal("workPhone"))) { demogs.PhoneNumbers.Add(new PhoneNum(reader.GetString(reader.GetOrdinal("workPhone")))); } if (!reader.IsDBNull(reader.GetOrdinal("cellPhone"))) { demogs.PhoneNumbers.Add(new PhoneNum(reader.GetString(reader.GetOrdinal("cellPhone")))); } if (!reader.IsDBNull(reader.GetOrdinal("emailAddress"))) { demogs.EmailAddresses.Add(new EmailAddress(reader.GetString(reader.GetOrdinal("emailAddress")))); } Address address = new Address(); if (!reader.IsDBNull(reader.GetOrdinal("addressLine1"))) { address.Street1 = reader.GetString(reader.GetOrdinal("addressLine1")); } if (!reader.IsDBNull(reader.GetOrdinal("addressLine2"))) { address.Street2 = reader.GetString(reader.GetOrdinal("addressLine2")); } if (!reader.IsDBNull(reader.GetOrdinal("addressLine3"))) { address.Street3 = reader.GetString(reader.GetOrdinal("addressLine3")); } if (!reader.IsDBNull(reader.GetOrdinal("city"))) { address.City = reader.GetString(reader.GetOrdinal("city")); } if (!reader.IsDBNull(reader.GetOrdinal("county"))) { address.County = reader.GetString(reader.GetOrdinal("county")); } if (!reader.IsDBNull(reader.GetOrdinal("state"))) { address.State = reader.GetString(reader.GetOrdinal("state")); } if (!reader.IsDBNull(reader.GetOrdinal("zipcode"))) { address.Zipcode = reader.GetString(reader.GetOrdinal("zipcode")); } demogs.StreetAddresses.Add(address); p.Demographics.Add(p.LocalSiteId, demogs); return p; }
protected void scholarshipTable_Load(object sender, EventArgs e) { int countTotalScholarships = 0; String connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString; System.Data.SqlClient.SqlConnection sc = new System.Data.SqlClient.SqlConnection(connectionString); sc.Open(); System.Data.SqlClient.SqlCommand countScholarships = new System.Data.SqlClient.SqlCommand(); countScholarships.CommandText = "SELECT count(SchoolApproval.OpportunityEntityID) FROM OpportunityEntity INNER JOIN SchoolApproval ON OpportunityEntity.OpportunityEntityID = SchoolApproval.OpportunityEntityID where OpportunityEntity.OpportunityType = 'SCHOL' and schoolApproval.approvedflag = 'Y' and SchoolApproval.SchoolEntityID = " + Session["schoolID"]; countScholarships.Connection = sc; System.Data.SqlClient.SqlDataReader reader = countScholarships.ExecuteReader(); while (reader.Read()) { countTotalScholarships = reader.GetInt32(0); } sc.Close(); sc.Open(); System.Data.SqlClient.SqlCommand pullScholarshipInfo = new System.Data.SqlClient.SqlCommand(); pullScholarshipInfo.CommandText = "SELECT Organization.OrganizationName, Scholarship.ScholarshipName, Scholarship.ScholarshipDescription, Organization.Image, Organization.ExternalLink, Scholarship.ScholarshipMin, Scholarship.ScholarshipMax, Scholarship.ScholarshipDueDate, Scholarship.ScholarshipID FROM SchoolApproval INNER JOIN OpportunityEntity ON SchoolApproval.OpportunityEntityID = OpportunityEntity.OpportunityEntityID INNER JOIN Scholarship" + " ON OpportunityEntity.OpportunityEntityID = Scholarship.ScholarshipID INNER JOIN Organization ON Scholarship.OrganizationID = Organization.OrganizationEntityID " + "where SchoolApproval.ApprovedFlag = 'Y' and OpportunityEntity.OpportunityType = 'SCHOL' and SchoolApproval.SchoolEntityID = " + Session["schoolID"]; pullScholarshipInfo.Connection = sc; reader = pullScholarshipInfo.ExecuteReader(); { List <Scholarship> scholarships = new List <Scholarship>(); String orgName; String scholarshipName; String scholarshipDescription; String image; String link; decimal scholarshipMin; decimal scholarshipMax; DateTime deadline; int scholarshipID; int x = 0; while (reader.Read()) { orgName = reader.GetString(0); scholarshipName = reader.GetString(1); scholarshipDescription = reader.GetString(2); image = reader.GetString(3); link = reader.GetString(4); scholarshipMin = reader.GetDecimal(5); scholarshipMax = reader.GetDecimal(6); deadline = reader.GetDateTime(7); scholarshipID = reader.GetInt32(8); x++; Scholarship scholarship = new Scholarship(scholarshipID, scholarshipName, scholarshipDescription, scholarshipMin, scholarshipMax, image, link, deadline, orgName); scholarships.Add(scholarship); } sc.Close(); double doubleRows = countTotalScholarships / 3.0; int numrows = (int)(Math.Ceiling(doubleRows)); int numcells = 3; int count = 0; for (int j = 0; j < numrows; j++) { TableRow r = new TableRow(); for (int i = 0; i < numcells; i++) { if (count == countTotalScholarships) { break; } TableCell c = new TableCell(); LinkButton referralLink = new LinkButton(); referralLink.ID = "referralLink" + count; referralLink.CssClass = "far fa-paper-plane"; referralLink.CommandArgument += scholarships[count].getScholarshipID(); referralLink.Command += new CommandEventHandler(this.referralButton_Click); c.Controls.Add(new LiteralControl("<div class='image-flip' ontouchstart='this.classList.toggle('hover');'>")); c.Controls.Add(new LiteralControl("<div class='mainflip'>")); c.Controls.Add(new LiteralControl("<div class='frontside'>")); c.Controls.Add(new LiteralControl("<div class='card'>")); c.Controls.Add(new LiteralControl("<div class='card-body text-center'>")); c.Controls.Add(new LiteralControl("<p><img class='img-fluid' src='" + scholarships[count].getImage() + "' alt='card image'></p>")); c.Controls.Add(new LiteralControl("<h4 class='card-title'>" + scholarships[count].getScholarshipName() + "</h4>")); c.Controls.Add(new LiteralControl("<p class='card-text'>" + scholarships[count].getOrgName() + "</p>")); c.Controls.Add(new LiteralControl("<a href='#' class='btn btn-primary btn-sm'><i class='fa fa-plus'></i></a>")); c.Controls.Add(new LiteralControl("</div>")); c.Controls.Add(new LiteralControl("</div>")); c.Controls.Add(new LiteralControl("</div>")); c.Controls.Add(new LiteralControl("<div class='backside'>")); c.Controls.Add(new LiteralControl("<div class='card'>")); c.Controls.Add(new LiteralControl("<div class='card-body text-center'>")); c.Controls.Add(new LiteralControl("<h4 class='card-title'>" + scholarships[count].getScholarshipName() + "</h4>")); c.Controls.Add(new LiteralControl("<p class='card-text'>" + scholarships[count].getScholarshipName() + "</p>")); c.Controls.Add(new LiteralControl("<p class='card-text'>" + scholarships[count].getScholarshipDescription() + "</p>")); c.Controls.Add(new LiteralControl("<p class='card-text'> Minimum: " + scholarships[count].getScholarshipMin().ToString() + "</p>")); c.Controls.Add(new LiteralControl("<p class='card-text'> Maximum: " + scholarships[count].getScholarshipMax().ToString() + "</p>")); c.Controls.Add(new LiteralControl("<p class='card-text'> Deadline: " + scholarships[count].getScholarshipDueDate().ToString() + "</p>")); c.Controls.Add(new LiteralControl("<ul class='list-inline'>")); c.Controls.Add(new LiteralControl("<li class='list-inline-item'>")); c.Controls.Add(new LiteralControl("<a class='social-icon text-xs-center' target='_blank' href='" + scholarships[count].getLink() + "'>")); c.Controls.Add(new LiteralControl("<i class='fas fa-external-link-alt'></i> ")); c.Controls.Add(referralLink); c.Controls.Add(new LiteralControl("</a>")); c.Controls.Add(new LiteralControl("</li>")); c.Controls.Add(new LiteralControl("</ul>")); c.Controls.Add(new LiteralControl("</div>")); c.Controls.Add(new LiteralControl("</div>")); c.Controls.Add(new LiteralControl("</div>")); c.Controls.Add(new LiteralControl("</div>")); c.Controls.Add(new LiteralControl("</div>")); c.Style.Add("width", "33%"); r.Cells.Add(c); count++; } scholarshipTable.Rows.Add(r); } } }