public CascadingDropDownNameValue[] GetContratos(string knownCategoryValues, string category)
{
string[] Empresasvalues = knownCategoryValues.Split(':', ';');
// Convert the element at index 1 in the string[] to get the CarId
int _empresaID = Convert.ToInt32(Empresasvalues[1]);
DSConosudTableAdapters.ContratoTableAdapter adapter = new DSConosudTableAdapters.ContratoTableAdapter();
DSConosud.ContratoDataTable contratos = adapter.GetDataByIdEmpresa(_empresaID);
Helpers._Contratos = new Hashtable();
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
foreach (DSConosud.ContratoRow dr in contratos)
{
string make = (string)dr.Codigo;
long makeId = dr.IdContrato;
values.Add(new CascadingDropDownNameValue(
make, makeId.ToString()));
Helpers._Contratos.Add(make, dr);
}
return(values.ToArray());
}
protected void igbExcel_Click(object sender, ImageClickEventArgs e)
{
DSConosudTableAdapters.ContratoTableAdapter TACont = new DSConosudTableAdapters.ContratoTableAdapter();
DSConosud.ContratoDataTable dtCont = TACont.GetDataByContratosCompleto();
Helpers.GenExcell c = new Helpers.GenExcell();
c.DoExcell(Server.MapPath(Request.ApplicationPath) + @"\ReporteExcel.xls", dtCont, this.gvContratos.Columns);
System.Web.UI.ScriptManager.RegisterStartupScript(upGrilla, this.GetType(), "click", "window.open('ReporteExcel.xls')", true);
}
protected void ODSContratos_Selected(object sender, ObjectDataSourceStatusEventArgs e)
{
_contratos = (DSConosud.ContratoDataTable)e.ReturnValue;
if (_contratos != null)
{
if (_contratos.Rows.Count > 0)
{
//string descip = "";
//descip += _contratos.Rows[0]["Servicio"].ToString() + " - ";
//descip += Convert.ToDateTime(_contratos.Rows[0]["FechaInicio"]).ToShortDateString() + " - ";
//descip += Convert.ToDateTime(_contratos.Rows[0]["FechaVencimiento"]).ToShortDateString();
}
}
}
