/// <summary>
/// Metodo para Consultar Departamentos
/// </summary>
public DataTable ConsultaDepartamento(string scoddpto, string scodcountry, string snamedpto)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEBSIGE_SEARCHDPTO", scodcountry, scoddpto, snamedpto);
EDepartamento oesdpto = new EDepartamento();
if (dt != null)
{
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
oesdpto.coddpto = dt.Rows[i]["cod_dpto"].ToString().Trim();
oesdpto.codCountry = dt.Rows[i]["cod_Country"].ToString().Trim();
oesdpto.Namedpto = dt.Rows[i]["Name_dpto"].ToString().Trim();
oesdpto.DepartamentCreateBy = dt.Rows[i]["Departament_CreateBy"].ToString().Trim();
oesdpto.DepartamentDateBy = Convert.ToDateTime(dt.Rows[i]["Departament_DateBy"].ToString().Trim());
oesdpto.DepartamentModiBy = dt.Rows[i]["Departament_ModiBy"].ToString().Trim();
oesdpto.DepartamentDateModiBy = Convert.ToDateTime(dt.Rows[i]["Departament_DateModiBy"].ToString().Trim());
}
}
return(dt);
}
else
{
return(null);
}
}
//}
/// <summary>
/// Metodo para Actualizar de Departamentos
/// </summary>
public EDepartamento ActualizarDepartamento(string scoddpto, string scodcountry, string snamedpto,
bool bdptostatus, string sdptoModiBy, DateTime tdptoModiDateBy)
{
DDepartamento odadpto = new DDepartamento();
EDepartamento oeadpto = odadpto.ActualizarDepartamento(scoddpto, scodcountry, snamedpto, bdptostatus,
sdptoModiBy, tdptoModiDateBy);
odadpto = null;
return(oeadpto);
}
/// <summary>
/// Metodo para el Registro de Departamentos
/// </summary>
public EDepartamento RegisterDepartamento(string scoddpto, string scodcountry, string snamedpto,
bool bdptostatus, string sdptoCreateBy, DateTime tdptoDateBy, string sdptoModiBy, DateTime tdptoModiDateBy)
{
DDepartamento odrdpto = new DDepartamento();
EDepartamento oedpto = odrdpto.RegisterDepartamento(scoddpto, scodcountry, snamedpto, bdptostatus, sdptoCreateBy,
tdptoDateBy, sdptoModiBy, tdptoModiDateBy);
odrdpto = null;
return(oedpto);
}
/// <summary>
/// Metodo para Actualizar de Departamentos
/// </summary>
public EDepartamento ActualizarDepartamento(string scoddpto, string scodcountry, string snamedpto,
bool bdptostatus, string sdptoModiBy, DateTime tdptoModiDateBy)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEBSIGE_ACTUALIZARDPTO", scoddpto, scodcountry, snamedpto, bdptostatus, sdptoModiBy, tdptoModiDateBy);
EDepartamento oeadepto = new EDepartamento();
oeadepto.coddpto = scoddpto;
oeadepto.codCountry = scodcountry;
oeadepto.Namedpto = snamedpto;
oeadepto.DptoStatus = bdptostatus;
oeadepto.DepartamentModiBy = sdptoModiBy;
oeadepto.DepartamentDateModiBy = tdptoModiDateBy;
return(oeadepto);
}
/// <summary>
/// Metodo para el Registro de Departamentos
/// </summary>
public EDepartamento RegisterDepartamento(string scoddpto, string scodcountry, string snamedpto,
bool bdptostatus, string sdptoCreateBy, DateTime tdptoDateBy, string sdptoModiBy, DateTime tdptoModiDateBy)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEBSIGE_REGISTERDEPTO", scoddpto, scodcountry, snamedpto, bdptostatus, sdptoCreateBy,
tdptoDateBy, sdptoModiBy, tdptoModiDateBy);
EDepartamento oerdepto = new EDepartamento();
oerdepto.coddpto = scoddpto;
oerdepto.codCountry = scodcountry;
oerdepto.Namedpto = snamedpto;
oerdepto.DptoStatus = bdptostatus;
oerdepto.DepartamentCreateBy = sdptoCreateBy;
oerdepto.DepartamentDateBy = tdptoDateBy;
oerdepto.DepartamentModiBy = sdptoModiBy;
oerdepto.DepartamentDateModiBy = tdptoModiDateBy;
return(oerdepto);
}