protected void txtBuscarD_OnClick(object sender, EventArgs e)
{
if (txtBuscar.ToString().Length > 0)
{
ModelNominas mdNominas = new ModelNominas();
mdNominas.Nombredepartamento = txtBuscarD.Value.ToString();
mdNominas.Nombreempleado = txtBuscarD.Value.ToString();
try
{
DataTable dataTable = nominasSRV.ObtenerNominasEmpleado(mdNominas).Tables[0];
if (dataTable.Rows.Count != 0)
{
gvNominas.DataSource = dataTable;
gvNominas.DataBind();
}
else
{
DataBinderNominas();
}
}
catch (Exception)
{
Response.Redirect("../GUI/Nominas.aspx");
}
}
}
public DataTable ListaNominas()
{
DataTable dataTable;
ModelNominas nominasM = new ModelNominas();
dataTable = nominasSRV.ObtenerNominasEmpleado(nominasM).Tables[0];
return(dataTable);
}
public DataSet SeleccionarNominasEmpleado(object obj)
{
string cadenaWhere = "";
bool edo = false;
DataSet nominasDS = new DataSet();
ModelNominas data = (ModelNominas)obj;
adapter = new SqlDataAdapter();
using (SqlConnection connection = new SqlConnection(cadena))
{
connection.Open();
command = connection.CreateCommand();
transaction = connection.BeginTransaction("SelectNominas");
command.Connection = connection;
command.Transaction = transaction;
try
{
if (data.Nombreempleado != null)
{
cadenaWhere = cadenaWhere + " nombreempleado like '" + data.Nombreempleado + "%' or";
edo = true;
}
if (data.Apellidomaterno != null)
{
cadenaWhere = cadenaWhere + " apellidomaterno like '" + data.Apellidomaterno + "%' or";
edo = true;
}
if (data.Apellidopaterno != null)
{
cadenaWhere = cadenaWhere + " apellidopaterno like '" + data.Apellidopaterno + "%' or";
edo = true;
}
if (data.Nombredepartamento != null)
{
cadenaWhere = cadenaWhere + " nombredepartamento like '" + data.Nombredepartamento + "%' or";
edo = true;
}
if (edo == true)
{
cadenaWhere = " WHERE " + cadenaWhere.Remove(cadenaWhere.Length - 3, 3);
}
command.CommandText = " SELECT * FROM vwNominas " + cadenaWhere;
transaction.Commit();
adapter.SelectCommand = command;
adapter.Fill(nominasDS);
connection.Close();
}
catch (System.Exception ex)
{
try
{
ex.Message.ToString();
connection.Close();
transaction.Rollback();
}
catch (System.Exception)
{
}
}
return(nominasDS);
}
}
