/// <summary>
/// Obtiene todos los Tipos de Cambio
/// </summary>
/// <returns></returns>
public List <ExchangeTypeCompositeType> getAll()
{
List <ExchangeTypeCompositeType> lst = new List <ExchangeTypeCompositeType>();
//try
//{
DataTable dt = objDB.Consult("sp_selectExchangeType");
foreach (DataRow dr in dt.Rows)
{
ExchangeTypeCompositeType et = new ExchangeTypeCompositeType();
et.iIdExchangeType = int.Parse(dr.ItemArray[0].ToString());
et.sDescription = dr.ItemArray[1].ToString();
et.bStatus = bool.Parse(dr.ItemArray[2].ToString());
et.sInitial = dr.ItemArray[3].ToString();
lst.Add(et);
}
return(lst);
//}
//catch (Exception ex)
//{
// throw ex.Message();
//}
}
public List <employedCompositeType> getAll()
{
List <employedCompositeType> lst = new List <employedCompositeType>();
DataTable dt = objDB.Consult("sp_selectEmployed");
foreach (DataRow dr in dt.Rows)
{
employedCompositeType et = new employedCompositeType();
et.iIdEmployed = int.Parse(dr.ItemArray[0].ToString());
et.iNumber = int.Parse(dr.ItemArray[1].ToString());
et.sName = dr.ItemArray[2].ToString();
et.sMLastName = dr.ItemArray[3].ToString();
et.sFLastName = dr.ItemArray[4].ToString();
et.sEMail = dr.ItemArray[5].ToString();
et.iStatus = int.Parse(dr.ItemArray[6].ToString());
et.iIdArea = int.Parse(dr.ItemArray[7].ToString());
et.iIdPlant = int.Parse(dr.ItemArray[9].ToString());
et.dDate = DateTime.Parse(dr.ItemArray[11].ToString());
et.iBoss = int.Parse(dr.ItemArray[12].ToString());
et.iSubstitute = int.Parse(dr.ItemArray[13].ToString());
et.sBoss = dr.ItemArray[14].ToString();
et.sSubstitute = dr.ItemArray[15].ToString();
et.sCompleteName = dr.ItemArray[16].ToString();
et.sDescriptionArea = dr.ItemArray[8].ToString(); //Add
lst.Add(et);
}
return(lst);
}
/// <summary>
/// Obtiene todos los Tipos de Cambio
/// </summary>
/// <returns></returns>
public List <TaskGroupCompositeType> getAll()
{
List <TaskGroupCompositeType> lst = new List <TaskGroupCompositeType>();
//try
//{
DataTable dt = objDB.Consult("sp_selectTaskGroup");
foreach (DataRow dr in dt.Rows)
{
TaskGroupCompositeType et = new TaskGroupCompositeType();
et.iIdTaskGroup = int.Parse(dr.ItemArray[0].ToString());
et.iIdTask = int.Parse(dr.ItemArray[1].ToString());
et.iIdGroup = int.Parse(dr.ItemArray[2].ToString());
et.bStatus = bool.Parse(dr.ItemArray[3].ToString());
et.sDescriptionTask = dr.ItemArray[4].ToString();
et.sDescriptionGroup = dr.ItemArray[5].ToString();
lst.Add(et);
}
return(lst);
//}
//catch (Exception ex)
//{
// throw ex.Message();
//}
}
/// <summary>
/// Obtiene todos los Tipos de Cambio
/// </summary>
/// <returns></returns>
public List <reviewTypeCompositeType> getAll()
{
var dt = objDB.Consult("sp_selectReviewType");
return((from DataRow dr in dt.Rows
select new reviewTypeCompositeType
{
iIdReviewType = int.Parse(dr.ItemArray[0].ToString()), sDescription = dr.ItemArray[1].ToString(), bStatus = bool.Parse(dr.ItemArray[2].ToString())
}).ToList());
}
/// <summary>
/// Obtiene todos los Tipos de Cambio
/// </summary>
/// <returns></returns>
public List <PriorityCompositeType> getAll()
{
DataTable dt = objDB.Consult("sp_selectPriority");
return((from DataRow dr in dt.Rows
select new PriorityCompositeType
{
iIdPriority = int.Parse(dr.ItemArray[0].ToString()),
sDescription = dr.ItemArray[1].ToString(),
bStatus = bool.Parse(dr.ItemArray[2].ToString())
}).ToList());
}
/// <summary>
/// Obtiene todos los Tipos de Cambio
/// </summary>
/// <returns></returns>
public List <GroupCompositeType> getAll()
{
List <GroupCompositeType> lst = new List <GroupCompositeType>();
DataTable dt = objDB.Consult("sp_selectGroup");
foreach (DataRow dr in dt.Rows)
{
GroupCompositeType et = new GroupCompositeType();
et.iIdGroup = int.Parse(dr.ItemArray[0].ToString());
et.sDescription = dr.ItemArray[1].ToString();
et.bStatus = bool.Parse(dr.ItemArray[2].ToString());
lst.Add(et);
}
return(lst);
}
/// <summary>
/// Obtiene todos los Tipos de Cambio
/// </summary>
/// <returns></returns>
public List <affectationTypeCompositeType> getAll()
{
var lst = new List <affectationTypeCompositeType>();
DataTable dt = objDB.Consult("sp_selectAffectationType");
foreach (DataRow dr in dt.Rows)
{
var et = new affectationTypeCompositeType
{
iIdAffectationType = int.Parse(dr.ItemArray[0].ToString()),
sDescription = dr.ItemArray[1].ToString(),
bStatus = bool.Parse(dr.ItemArray[2].ToString())
};
lst.Add(et);
}
return(lst);
}
public List <menuCompositeType> getAll()
{
try
{
DataTable dt = objDB.Consult("sp_selectMenu");
return((from DataRow dr in dt.Rows
select new menuCompositeType
{
sDescription = dr.ItemArray[1].ToString(),
sURL = dr.ItemArray[3].ToString()
}).ToList());
}
catch (Exception ex)
{
throw new Exception();
}
}
public List <RolCompositeType> getAll()
{
var lst = new List <RolCompositeType>();
DataTable dt = objDB.Consult("sp_selectRol");
foreach (DataRow dr in dt.Rows)
{
var et = new RolCompositeType
{
iIdRol = int.Parse(dr.ItemArray[0].ToString()),
dRegistry = DateTime.Parse(dr.ItemArray[2].ToString()),
sDescription = dr.ItemArray[1].ToString(),
bStatus = bool.Parse(dr.ItemArray[3].ToString())
};
lst.Add(et);
}
return(lst);
}
/// <summary>
/// Obtiene todos los Tipos de Cambio
/// </summary>
/// <returns></returns>
public List <PartListCompositeType> getAll()
{
var lst = new List <PartListCompositeType>();
DataTable dt = objDB.Consult("sp_selectPartList");
foreach (DataRow dr in dt.Rows)
{
var et = new PartListCompositeType
{
iIdPart = int.Parse(dr.ItemArray[0].ToString()),
iNumber = dr.ItemArray[1].ToString(),
sDescription = dr.ItemArray[2].ToString(),
bStatus = bool.Parse(dr.ItemArray[4].ToString()),
iNumberClient = dr.ItemArray[3].ToString()
};
lst.Add(et);
}
return(lst);
}
/// <summary>
/// Obtiene todos los Tipos de Cambio
/// </summary>
/// <returns></returns>
public List <taskCompositeType> getAll()
{
List <taskCompositeType> lst = new List <taskCompositeType>();
DataTable dt = objDB.Consult("sp_selectTask");
foreach (DataRow dr in dt.Rows)
{
var et = new taskCompositeType
{
iIdTask = int.Parse(dr.ItemArray[0].ToString()),
sDescription = dr.ItemArray[1].ToString(),
bStatus = bool.Parse(dr.ItemArray[2].ToString()),
iIdArea = int.Parse(dr.ItemArray[3].ToString()),
sDescriptionArea = dr.ItemArray[4].ToString()
};
lst.Add(et);
}
return(lst);
}
/// <summary>
/// Obtiene todos los Tipos de Cambio
/// </summary>
/// <returns></returns>
public List <DataTypeCompositeType> getAll()
{
var lst = new List <DataTypeCompositeType>();
try
{
DataTable dt = objDB.Consult("sp_selectDataType");
foreach (DataRow dr in dt.Rows)
{
var swap = new DataTypeCompositeType
{
iIdDataType = int.Parse(dr.ItemArray[0].ToString()),
sDescription = dr.ItemArray[1].ToString(),
bStatus = bool.Parse(dr.ItemArray[2].ToString())
};
lst.Add(swap);
}
return(lst);
}
catch (Exception ex)
{
throw new Exception();
}
}
public int getNumberPreFolio()
{
return(int.Parse(objDB.Consult("[sp_getPreFolio]").Rows[0].ItemArray[0].ToString()));
}
public DataTable GetAll()
{
return(objDB.Consult("sp_selectSalesAutorization_Type"));
}