protected void ODSContratoEmpresa_Selected(object sender, ObjectDataSourceStatusEventArgs e)
{
if (((DSConosud.ContratoEmpresasDataTable)e.ReturnValue).Count > 0)
{
_DTcontratoEmpresas = (DSConosud.ContratoEmpresasDataTable)e.ReturnValue;
}
}
protected void dvContratos_ItemDeleting(object sender, DetailsViewDeleteEventArgs e)
{
try
{
DSConosudTableAdapters.ContratoEmpresasTableAdapter TAContratoEmpresa = new DSConosudTableAdapters.ContratoEmpresasTableAdapter();
DSConosud.ContratoEmpresasDataTable dtContEmp = TAContratoEmpresa.GetDataByIdContrato(Convert.ToInt64(this.gvContratos.SelectedValue));
foreach (DSConosud.ContratoEmpresasRow rowContEmp in dtContEmp)
{
rowContEmp.Delete();
}
TAContratoEmpresa.Update(dtContEmp);
}
catch (Exception ex)
{
//if (-1 != ex.Message.IndexOf("FK_ContEmpLegajos",0))
//{
// string alert = "alert('El Contrato no puede ser eliminado, tiene legajos asociados')";
// System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "click", alert, true);
//}
e.Cancel = true;
}
}
protected void igbExcel_Click(object sender, ImageClickEventArgs e)
{
DSConosudTableAdapters.ContratoEmpresasTableAdapter TAEmp = new DSConosudTableAdapters.ContratoEmpresasTableAdapter();
DSConosud.ContratoEmpresasDataTable dtEmp = TAEmp.GetHojasVisor(Convert.ToDateTime(txtInicial.Text), Convert.ToDateTime(txtFinal.Text));
Helpers.GenExcell c = new Helpers.GenExcell();
c.DoExcell(Server.MapPath(Request.ApplicationPath) + @"\ReporteExcel.xls", dtEmp, this.gdHojasRuta.Columns);
System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "click", "window.open('ReporteExcel.xls')", true);
}
protected void dvContratos_ItemUpdated(object sender, DetailsViewUpdatedEventArgs e)
{
DSConosudTableAdapters.ContratoEmpresasTableAdapter TAContratoEmpresa = new DSConosudTableAdapters.ContratoEmpresasTableAdapter();
DSConosud.ContratoEmpresasDataTable dtContEmp = TAContratoEmpresa.GetDataByIdContratoContratista(Convert.ToInt64(this.gvContratos.SelectedValue));
if (dtContEmp.Count != 0)
{
DropDownList DDLEditContratista = (DropDownList)this.dvContratos.FindControl("DDLEditContratista");
if (dtContEmp[0].IdEmpresa != Convert.ToInt64(DDLEditContratista.SelectedValue))
{
dtContEmp[0].IdEmpresa = Convert.ToInt64(DDLEditContratista.SelectedValue);
TAContratoEmpresa.Update(dtContEmp[0]);
}
}
_datos = ODSSelContratos.Select();
gvContratos.DataSource = _datos;
gvContratos.DataBind();
}
protected void dvContratos_DataBound(object sender, EventArgs e)
{
DSConosudTableAdapters.ContratoEmpresasTableAdapter TAContratoEmpresa = new DSConosudTableAdapters.ContratoEmpresasTableAdapter();
DSConosud.ContratoEmpresasDataTable dtContEmp = TAContratoEmpresa.GetDataByIdContratoContratista(Convert.ToInt64(this.gvContratos.SelectedValue));
if (dtContEmp.Count != 0)
{
DropDownList DDLContratista = null;
if (dvContratos.CurrentMode == DetailsViewMode.Edit)
{
DDLContratista = (DropDownList)this.dvContratos.FindControl("DDLEditContratista");
}
else if (dvContratos.CurrentMode == DetailsViewMode.ReadOnly)
{
DDLContratista = (DropDownList)this.dvContratos.FindControl("DDLItemContratista");
}
if (dtContEmp[0].IdEmpresa != 0 && DDLContratista != null)
{
DDLContratista.SelectedValue = dtContEmp[0].IdEmpresa.ToString();
}
}
}
public CascadingDropDownNameValue[] GetSubContratistas(string knownCategoryValues, string category)
{
string[] Contratosvalues = knownCategoryValues.Split(':', ';');
long _ContratoID = 0;
_ContratoID = Convert.ToInt64(Contratosvalues[3]);
DSConosudTableAdapters.ContratoEmpresasTableAdapter adapter = new DSConosudTableAdapters.ContratoEmpresasTableAdapter();
DSConosud.ContratoEmpresasDataTable contratoEmpresa = adapter.GetContEmpresaExtend(Convert.ToInt32(_ContratoID));
Helpers._SubContratistas = new Hashtable();
string IdContratista = "";
List <CascadingDropDownNameValue> values = new List <CascadingDropDownNameValue>();
foreach (DSConosud.ContratoEmpresasRow dr in contratoEmpresa)
{
string make = (string)dr["RazonSocial"];
long makeId = dr.IdContratoEmpresas;
values.Add(new CascadingDropDownNameValue(
make, makeId.ToString()));
Helpers._SubContratistas.Add(make, dr);
if (bool.Parse(dr["EsContratista"].ToString()))
{
IdContratista = dr.IdContratoEmpresas.ToString();
}
}
values.Add(new CascadingDropDownNameValue(
"Todas", IdContratista));
return(values.ToArray());
}
