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(); } } }