lunes, 27 de noviembre de 2017
martes, 24 de octubre de 2017
Obtener el indice de la columna de un gridView Utilizando el nombre
public static int GetColumnIndexByName(GridView grid, string name)
{
foreach (DataControlField col in grid.Columns)
{
if (col.HeaderText.ToLower().Trim() == name.ToLower().Trim())
{
return grid.Columns.IndexOf(col);
}
}
return -1;
}
{
foreach (DataControlField col in grid.Columns)
{
if (col.HeaderText.ToLower().Trim() == name.ToLower().Trim())
{
return grid.Columns.IndexOf(col);
}
}
return -1;
}
martes, 5 de septiembre de 2017
Convertir Imagen a Array de Byte C#
public static byte[] ConversionImagen(string ruta)
{
FileStream fs = new FileStream(ruta, FileMode.Open);
BinaryReader br = new BinaryReader(fs);
byte[] imagen = new byte[Convert.ToInt32(fs.Length)];
br.Read(imagen, 0, Convert.ToInt32(fs.Length));
br.Close();
fs.Close();
return imagen;
}
{
FileStream fs = new FileStream(ruta, FileMode.Open);
BinaryReader br = new BinaryReader(fs);
byte[] imagen = new byte[Convert.ToInt32(fs.Length)];
br.Read(imagen, 0, Convert.ToInt32(fs.Length));
br.Close();
fs.Close();
return imagen;
}
miércoles, 30 de agosto de 2017
Obtener un valor de retorno al ejecutar un insert
sb.Append("BEGIN INSERT INTO cliente( DATE_ALTA,NOMBRE, APELLIDO, CUIT)");
sb.Append("VALUES(SYSDATE,:NOMBRE,:APELLIDO,:CUIT) returning ID INTO :ID; END;");
using (OracleConnection conn = new OracleConnection(DA.ConeccionStringDDJJ))
{
using (OracleCommand comm = new OracleCommand(sb.ToString(), conn))
{
.........
comm.Parameters.Add(":ID", OracleDbType.Int32, 10,parameterDirection.ReturnValue);
}
}
sb.Append("VALUES(SYSDATE,:NOMBRE,:APELLIDO,:CUIT) returning ID INTO :ID; END;");
using (OracleConnection conn = new OracleConnection(DA.ConeccionStringDDJJ))
{
using (OracleCommand comm = new OracleCommand(sb.ToString(), conn))
{
.........
comm.Parameters.Add(":ID", OracleDbType.Int32, 10,parameterDirection.ReturnValue);
}
}
miércoles, 5 de abril de 2017
CV
ChristianMACZKA–
.NET Developer
Career Summary
·
10 years of experience in analysis, design and
development of client/server, web based and n-tier application. Expert in
developing windows applications, web applications, windows servicesand web
services in Microsoft Visual Studio .Net IDE using C#.Net,C#.Net 2.0,3.5, 4.0
VB.NET,ASP.NET, ADO.NET and SQL Server.
·
Experience working with agile methodology,
defining tasks and estimations.
·
Proficient in WebServices, SOAP, XML,
CSS, DOM, HTML, AJAX and JavaScript.
·
Extensive experience in SQL Server Database
design, Database maintenance, developing T-SQLqueries, stored procedures, and
triggers using SQL Server 2008 and Oracle.
·
Expert in debugging an application using the debugging tools
provided by the Visual Studio.NetIDE
·
Effective in working independently and collaboratively in teams.
Work Experience
Company –Fiscal SAPEM OCT2011–present
Role - .NET Developer
Project
Affidavit For advertisements
·
Development of an application
for the online presentation of a sworn affidavitof advertisements for Customers
who have their storesand have to present an affidavit of advertisements they
have in public places and then be able to print a form to pay the respective
taxes. The application has a public interface and an internal interface for the
office staff. I developed the application using MVP pattern as de architecture
of the application. Then I made implementations of web services consuming an
exposing for many interfaces the application has with other systems.
·
Development of an application
for the load of advertisements fetch by the inspector in the public road. The
application allows entering relevant information of the advertisement;
calculate taxes according to the information of the adv. And print several
reports to control the information gathered. Then it is able to mark advs as
controlled to be taken by another process and sending them to the system of sworn
affidavit. I have developed the system in apex (a tool of Oracle that enables
you create web pages), I have also made many customizations of controls coding
in pl/sql and HTML and jquery.
·
Maintenance of a desktop
application developed in visual studio 2008 for internal use of the staff
related to administrative tasks performed internally.
·
Maintenance of an application
developed in MVC for the charge of penalty fee related to car driven of the
town which is administrated by de local government. I was in charge of
generating many reports performed by the judge imposing the fee.
·
C#,Jquery,JS, CSS, Bootstrap,
MVC,Crystal report, ASP.NET, Entity Framework, SQL Server, GITHub.
Company –Pragma Consulting July2010 – Oct 2011
Role - .NET Developer
Project
YPF
·
Development of a sharepoint
application 2008. The application was able to enter information about all
products manufactured by YPF derived from petroleum and print all the labels to
be put on the product specifying all the characteristics of the product. I was in
charge of customizing the product according to the requirements of the client
creating web parts, configuring the application and modifying the handlers of
the system.
·
Development of an application
for Tenaris. The application allows making request of any workshop who wants to
work as certified partner of Tenaris. Once made the request there is a process
in which should follow a process that must fulfill the client in order to
validate the requirements needed to complete the certification. I participated designing web pages and working in the back-end
of the application.
·
C#, MVC, JavaScript, CSS,
ASP.NET, Entity Framework, SVN.
Company –IPGMedia Brands Oct2008 – Jul2010
Role - .NET Developer
Proyect Advertisement planning
·
Maintenance of the application for making a
planning of the advertisement of the client according to their budget in order
to be sent to different media such as tv programs, radios, magazines. I was in
charge of designing interfaces with other systems external to the company.
Developing new functionalities and reports gathering information relevant to
the directors of the company.
·
Visual basic 6, VB.NET, Visual
Studio 2005, SQL Server 2000, crystal reports.
Role - .NET Developer
·
Maintenance of the services
provides by different modules of the bank system. Working with stored
procedures, implementing new functionalities andcorrective development.
Creation of technical documentations and holding meeting with users to analyse
the modification required.
·
Visual basic 6, COM, Sybase.
Role - .NET Developer
·
Analysis of income incidents.
Software corrections, checking the correct application functionality with
different types of database connections.
Creation of test documentation, user manual, software implementations and
client support in configuring the application.
·
C#, Visual Studio 2005, SVN.
Education
·
Software Engineer “Universidad Abierta
Interamericana” (UAI). (Finished – 2012)
·
Teaching Course for Industry disciplines
“UniveridadTecnologica Argentina” (UTN). (Finished - 2016)
Languages
Spanish (Native)
English (Advanced)
Suscribirse a:
Entradas (Atom)