/// <summary>
/// Autor: jlucero
/// Fecha: 2015-06-16
/// </summary>
/// <param name="__a"></param>
/// <returns></returns>
public ActionResult Descarga()
{
var grid = new System.Web.UI.WebControls.GridView();
var collection = new NServicio().NLista();
grid.DataSource = from d in collection
select new
{
ID = d.ser_id,
DESCRIPCION = d.ser_descripcion,
ESTADO = (d.ser_estado == 2 ? "Inactivo" : "Activo")
};
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Servicio_Listado.xls");
Response.ContentType = "application/x-ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
return(null);
}
public ActionResult Inserta(string __a, string __b)
{
Int32 respuesta = new NServicio().NInserta(
new Request_CRUD_Servicio()
{
descripcion = __a,
estado = Convert.ToInt32(__b),
usuario = ((Sesion)Session["Session_Usuario_Acceso"]).usuario.usu_id
}
);
return(new ContentResult
{
Content = "{ \"__a\": " + respuesta + " }",
ContentType = "application/json"
});
}
private void cboArea_SelectedValueChanged(object sender, EventArgs e)
{
var tablaEmp = NArea.BuscarAreaEmpleado(cboArea.Text);
if (tablaEmp.Rows.Count > 0)
{
cboEmpleado.DataSource = tablaEmp;
cboEmpleado.DisplayMember = "personal";
cboEmpleado.ValueMember = "idempleado";
}
var tablaServ = NServicio.BuscarServicioArea(cboArea.Text);
if (tablaServ.Rows.Count > 0)
{
cboServicio.DataSource = tablaServ;
cboServicio.DisplayMember = "servicio";
cboServicio.ValueMember = "idservicio";
txtCosto.Text = tablaServ.Rows[0]["precio"].ToString();
}
}
private void PServicio_Load(object sender, EventArgs e)
{
NSer = new NServicio();
dataGridView1.DataSource = NSer.ShowServicios();
}
