public string VerificarUsuarioExiste(string dni) { string sql, result = ""; int cont = 0; sql = "SELECT count(*) n_count FROM TBC_USUARIO where v_dni = '" + dni + "'"; SqlConnection cn = con.conexion(); cn.Open(); SqlDataAdapter dap = new SqlDataAdapter(sql, cn); DataTable dt = new DataTable(); dap.SelectCommand.CommandType = CommandType.Text; dap.Fill(dt); cn.Close(); if (dt != null) { cont = Convert.ToInt32(dt.Rows[0]["n_count"]); } if (cont == 0) { result = "OK"; } else if (cont > 0) { result = "NO"; } return(result); }
public string VerificarCatalogo(string sfilro) { string resul = "N"; Conexion con = new Conexion(); // String BodyHtml = "", HeadHtml = "", FotHtml = ""; SqlConnection cn = con.conexion(); cn.Open(); SqlDataAdapter dap = new SqlDataAdapter("UP_MVE_CATALOGOLYS", cn); DataTable dt = new DataTable(); dap.SelectCommand.CommandType = CommandType.StoredProcedure; dap.SelectCommand.Parameters.AddWithValue("@Item", sfilro); dap.Fill(dt); cn.Close(); if (dt == null) { resul = "N"; } else if (dt.Rows.Count <= 0) { resul = "N"; } else if (dt.Rows.Count > 0) { resul = "S"; return(resul); } return(resul); }
public ItemFactor[] GetItemsFactor(string Dni) { Conexion con = new Conexion(); List <ItemFactor> listItem = new List <ItemFactor>(); // String BodyHtml = "", HeadHtml = "", FotHtml = ""; SqlConnection cn = con.conexion(); cn.Open(); SqlDataAdapter dap = new SqlDataAdapter("UP_MVE_FACTORITEM", cn); DataTable dt = new DataTable(); dap.SelectCommand.CommandType = CommandType.StoredProcedure; dap.SelectCommand.Parameters.AddWithValue("@Dni", Dni); dap.Fill(dt); cn.Close(); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { ItemFactor it = new ItemFactor(); it.Item = dt.Rows[i]["c_item"].ToString(); it.Flagcontador = dt.Rows[i]["c_flagactcontador"].ToString(); it.Propaganda = dt.Rows[i]["c_propaganda"].ToString(); it.Segundos = Convert.ToInt32(dt.Rows[i]["n_segundosTot"]); it.DescPromo = dt.Rows[i]["c_htmlDesc"].ToString(); listItem.Add(it); } } return(listItem.ToArray()); }
public void LoadPortal() { Conexion con = new Conexion(); // String BodyHtml = "", HeadHtml = "", FotHtml = ""; SqlConnection cn = con.conexion(); cn.Open(); SqlDataAdapter dap = new SqlDataAdapter("SP_CO_MVL_LISTAPAGEINICIO", cn); DataTable dt = new DataTable(); dap.SelectCommand.CommandType = CommandType.StoredProcedure; //dap.SelectCommand.Parameters.AddWithValue("@Dni", dni); dap.Fill(dt); cn.Close(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { string HtmlSeccion = ""; string imgBase64 = ""; string stittulo = ""; string sdetalle = ""; string rutaimg = ""; stittulo = dt.Rows[i]["c_htmlTit"].ToString(); sdetalle = dt.Rows[i]["c_htmlDesc"].ToString(); rutaimg = dt.Rows[i]["c_foto1"].ToString(); stittulo = stittulo.ToUpper(); sdetalle = sdetalle.ToUpper(); // Bitmap b = new Bitmap(@"\\Ibserver_1\servidor de archivos\Fotos\LWP2040P-web.jpg"); Bitmap b = new Bitmap(rutaimg); System.IO.MemoryStream ms = new System.IO.MemoryStream(); b.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] byteImage = ms.ToArray(); imgBase64 = Convert.ToBase64String(byteImage); dt.Rows[i][11] = "data:image/jpeg;base64," + imgBase64; dt.AcceptChanges(); /*HtmlSeccion = " <td><tr > <p style='font-weight: bold' >" + stittulo + "</p> </tr> </td>"; * HtmlSeccion = HtmlSeccion + "<td><tr > " + sdetalle + "</tr></td>"; * HtmlSeccion = HtmlSeccion + "<td> <tr ><img style='height: 100%; width: 100%; object-fit: contain' src='data:image/jpeg;base64," + imgBase64 + "' /></tr></td>"; * BodyHtml = BodyHtml + HtmlSeccion;*/ } // lblHeader.Text = "PROMOCIONES DEL DÍA " + DateTime.Now.ToShortDateString(); repeatHtml.DataSource = dt; repeatHtml.DataBind(); } }
public void LoadPremios(string dni) { Conexion con = new Conexion(); // String BodyHtml = "", HeadHtml = "", FotHtml = ""; SqlConnection cn = con.conexion(); cn.Open(); SqlDataAdapter dap = new SqlDataAdapter("UP_MVE_PREMIOLYS", cn); DataTable dt = new DataTable(); dap.SelectCommand.CommandType = CommandType.StoredProcedure; dap.SelectCommand.Parameters.AddWithValue("@Dni", dni); dap.Fill(dt); cn.Close(); if (dt != null) { // Fdt = dt; /*for (int i = 0; i < dt.Rows.Count; i++) * { * * string imgBase64 = ""; * string rutaimg = ""; * * rutaimg = dt.Rows[i]["c_rutafoto"].ToString(); * // rutaimg = @"\\100.100.100.1\\spring\\Planillas\\ROYALOGO.BMP"; * //rutaimg = @Constantes.CarpetaFotos+sfilro+".jpg"; * rutaimg = Server.MapPath("~/Fotos") + "\\" + sfilro + ".jpg"; * //rutaimg = Constantes.CarpetaFotos+sfilro+".jpg"; * // CopyFile(rutaimg); * if (System.IO.File.Exists(@rutaimg)) * { * // Bitmap b = new Bitmap(@"\\IBSERVER_1\\Servidor de Archivos\\Fotos\\L50.jpg"); * Bitmap b = new Bitmap(rutaimg); * // Bitmap b = new Bitmap(@"E:\Fotos\L50.jpg"); * System.IO.MemoryStream ms = new System.IO.MemoryStream(); * b.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); * byte[] byteImage = ms.ToArray(); * imgBase64 = Convert.ToBase64String(byteImage); * * dt.Rows[i][35] = "data:image/jpeg;base64," + imgBase64; * dt.AcceptChanges(); * } * * * }*/ rptPremios.DataSource = dt; rptPremios.DataBind(); } }
public string RegistrarCupon() { string res = "OK"; int sqlrows; //string opcion = "INS"; string codProm = txtCodPromocion.Text; string dni = txtDni.Text; string nomb = txtNombre.Text; string apellido = txtApellidos.Text; string telefono = txtTelefono.Text; DateTime fechanac = Convert.ToDateTime(txtFechaNacimiento.Text); string correo = txtCorreo.Text; try { Conexion con = new Conexion(); SqlConnection cn = con.conexion(); SqlCommand sqlcmd = new SqlCommand("UP_MWE_GANACONLYS", cn); sqlcmd.Connection = cn; sqlcmd.CommandType = CommandType.StoredProcedure; cn.Open(); // sqlcmd.Parameters.AddWithValue("@Opcion", opcion); sqlcmd.Parameters.AddWithValue("@Dni", dni.Trim().ToUpper()); sqlcmd.Parameters.AddWithValue("@Nombre", nomb); sqlcmd.Parameters.AddWithValue("@Apellido", apellido); sqlcmd.Parameters.AddWithValue("@Telefono", telefono); sqlcmd.Parameters.AddWithValue("@FecNac", fechanac); sqlcmd.Parameters.AddWithValue("@Correo", correo); sqlcmd.Parameters.AddWithValue("@Cupon", codProm.Trim().ToUpper()); SqlParameter par = new SqlParameter("@Mensaje", SqlDbType.VarChar); par.Size = 500; par.Direction = ParameterDirection.Output; sqlcmd.Parameters.Add(par); sqlrows = sqlcmd.ExecuteNonQuery(); res = Convert.ToString(sqlcmd.Parameters["@Mensaje"].Value); } catch (Exception e) { // res = e.Message; res = e.Message; } return(res); }
public void LoadCatalogo(string sfilro) { Conexion con = new Conexion(); // String BodyHtml = "", HeadHtml = "", FotHtml = ""; SqlConnection cn = con.conexion(); cn.Open(); SqlDataAdapter dap = new SqlDataAdapter("SP_CO_MVE_CATALOGOLYS", cn); DataTable dt = new DataTable(); dap.SelectCommand.CommandType = CommandType.StoredProcedure; dap.SelectCommand.Parameters.AddWithValue("@Item", sfilro); dap.Fill(dt); cn.Close(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { string imgBase64 = ""; string rutaimg = ""; rutaimg = dt.Rows[i]["c_rutafoto"].ToString(); if (System.IO.File.Exists(rutaimg)) { // Bitmap b = new Bitmap(@"\\Ibserver_1\servidor de archivos\Fotos\LWP2040P-web.jpg"); Bitmap b = new Bitmap(rutaimg); System.IO.MemoryStream ms = new System.IO.MemoryStream(); b.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] byteImage = ms.ToArray(); imgBase64 = Convert.ToBase64String(byteImage); dt.Rows[i][35] = "data:image/jpeg;base64," + imgBase64; dt.AcceptChanges(); } } rptCatalogo.DataSource = dt; rptCatalogo.DataBind(); } }
public void LoadReglas(string dni) { Conexion con = new Conexion(); // String BodyHtml = "", HeadHtml = "", FotHtml = ""; SqlConnection cn = con.conexion(); cn.Open(); SqlDataAdapter dap = new SqlDataAdapter("UP_MVE_REGLAMENTOLYS", cn); DataTable dt = new DataTable(); dap.SelectCommand.CommandType = CommandType.StoredProcedure; dap.SelectCommand.Parameters.AddWithValue("@Dni", dni); dap.Fill(dt); cn.Close(); if (dt != null) { rptReglas.DataSource = dt; rptReglas.DataBind(); } }
public void LoadFactores(string Dni) { Conexion con = new Conexion(); // String BodyHtml = "", HeadHtml = "", FotHtml = ""; SqlConnection cn = con.conexion(); cn.Open(); SqlDataAdapter dap = new SqlDataAdapter("UP_MVE_FACTORITEM", cn); DataTable dt = new DataTable(); dap.SelectCommand.CommandType = CommandType.StoredProcedure; dap.SelectCommand.Parameters.AddWithValue("@Dni", Dni); dap.Fill(dt); cn.Close(); if (dt != null) { rptFactorItem.DataSource = dt; rptFactorItem.DataBind(); } ExecScript(dt); }
public string InsertarUsuario(string dni, string nombre, string apellido, string fechanac, string mail, string telefono, string empruc, string empnom) { string res = "-1"; int sqlrows; if (dni == "" || String.IsNullOrEmpty(dni) == true) { return("-1"); } try { SqlConnection cn = con.conexion(); SqlCommand sqlcmd = new SqlCommand("UP_MVE_INSERTUSERAPP", cn); sqlcmd.Connection = cn; sqlcmd.CommandType = CommandType.StoredProcedure; cn.Open(); sqlcmd.Parameters.AddWithValue("@dni", dni); sqlcmd.Parameters.AddWithValue("@nombre", nombre.Trim().ToUpper()); sqlcmd.Parameters.AddWithValue("@apellido", apellido.Trim().ToUpper()); sqlcmd.Parameters.AddWithValue("@fechaNac", Convert.ToDateTime(fechanac)); sqlcmd.Parameters.AddWithValue("@mail", mail); sqlcmd.Parameters.AddWithValue("@telefono", telefono); sqlcmd.Parameters.AddWithValue("@empruc", empruc); sqlcmd.Parameters.AddWithValue("@empnom", empnom); SqlParameter par = new SqlParameter("@IdReg", SqlDbType.Int); par.Direction = ParameterDirection.Output; sqlcmd.Parameters.Add(par); sqlrows = sqlcmd.ExecuteNonQuery(); res = Convert.ToString(sqlcmd.Parameters["@IdReg"].Value); } catch (Exception e) { // res = e.Message; res = "-1"; } return(res); }
public void LoadPortal(string dni) { string flagconteotiempo = ""; int hora = 0, minuto = 0, segundo = 0; string factvence = ""; Conexion con = new Conexion(); // String BodyHtml = "", HeadHtml = "", FotHtml = ""; SqlConnection cn = con.conexion(); cn.Open(); SqlDataAdapter dap = new SqlDataAdapter("UP_MVE_LISTAPAGEINICIO", cn); DataTable dt = new DataTable(); dap.SelectCommand.CommandType = CommandType.StoredProcedure; dap.SelectCommand.Parameters.AddWithValue("@Dni", dni); dap.Fill(dt); cn.Close(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { string HtmlSeccion = ""; string imgBase64 = ""; string stittulo = ""; string sdetalle = ""; string rutaimg = ""; // string flagconteotiempo; // int hora, minuto, segundo; stittulo = dt.Rows[i]["c_htmlTit"].ToString(); sdetalle = dt.Rows[i]["c_htmlDesc"].ToString(); rutaimg = dt.Rows[i]["c_foto1"].ToString(); stittulo = stittulo.ToUpper(); sdetalle = sdetalle.ToUpper(); flagconteotiempo = dt.Rows[i]["c_flagactcontador"].ToString(); factvence = dt.Rows[i]["c_piemaxvenc"].ToString(); if (String.IsNullOrEmpty(factvence) == false) { hora = Convert.ToInt32(dt.Rows[i]["n_horaRes"]); minuto = Convert.ToInt32(dt.Rows[i]["n_minuRes"]); segundo = Convert.ToInt32(dt.Rows[i]["n_seguRes"]); } // Bitmap b = new Bitmap(@"\\IBSERVER_1\Servidor de Archivos\Fotos\L17.jpg"); if (System.IO.File.Exists(@rutaimg)) { Bitmap b = new Bitmap(rutaimg); System.IO.MemoryStream ms = new System.IO.MemoryStream(); b.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] byteImage = ms.ToArray(); imgBase64 = Convert.ToBase64String(byteImage); dt.Rows[i][11] = "data:image/jpeg;base64," + imgBase64; dt.AcceptChanges(); } /*HtmlSeccion = " <td><tr > <p style='font-weight: bold' >" + stittulo + "</p> </tr> </td>"; * HtmlSeccion = HtmlSeccion + "<td><tr > " + sdetalle + "</tr></td>"; * HtmlSeccion = HtmlSeccion + "<td> <tr ><img style='height: 100%; width: 100%; object-fit: contain' src='data:image/jpeg;base64," + imgBase64 + "' /></tr></td>"; * BodyHtml = BodyHtml + HtmlSeccion;*/ } // lblHeader.Text = "PROMOCIONES DEL DÍA " + DateTime.Now.ToShortDateString(); repeatHtml.DataSource = dt; repeatHtml.DataBind(); if (String.IsNullOrEmpty(factvence) == true || factvence == "") { divConteo.Visible = false; } else { lblfchavcto.InnerText = factvence + " "; } if (flagconteotiempo == "S") { int tiempoTotal = (hora * 3600) + (minuto * 60) + segundo; ClientScript.RegisterStartupScript(typeof(Page), "Script", "Activate(" + tiempoTotal + ")", true); } } }