//Add
public List <employedCompositeType> getEmployedArea(String sArea)
{
List <employedCompositeType> lst = new List <employedCompositeType>();
param = new SqlParameter[1];
param[0] = new SqlParameter("@area", SqlDbType.VarChar);
param[0].Value = sArea;
DataTable dt = objDB.ExecStore("sp_selectEmployedByNameArea", param);
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[8].ToString());
et.dDate = DateTime.Parse(dr.ItemArray[9].ToString());
et.iBoss = int.Parse(dr.ItemArray[10].ToString());
et.iSubstitute = int.Parse(dr.ItemArray[11].ToString());
et.sCompleteName = dr.ItemArray[12].ToString();
lst.Add(et);
}
return(lst);
}
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);
}
public employedCompositeType GetEmployedById(int iIdEmployed)
{
employedCompositeType et = new employedCompositeType();
param = new SqlParameter[1];
param[0] = new SqlParameter("@fiid_Employed", SqlDbType.Int);
param[0].Value = iIdEmployed;
DataTable dt = objDB.ExecStore("sp_getEmployedById", param);
if (dt.Rows.Count > 0)
{
et.iIdEmployed = int.Parse(dt.Rows[0].ItemArray[0].ToString());
et.iNumber = int.Parse(dt.Rows[0].ItemArray[1].ToString());
et.sName = dt.Rows[0].ItemArray[2].ToString();
et.sMLastName = dt.Rows[0].ItemArray[3].ToString();
et.sFLastName = dt.Rows[0].ItemArray[4].ToString();
et.sEMail = dt.Rows[0].ItemArray[5].ToString();
et.iStatus = int.Parse(dt.Rows[0].ItemArray[6].ToString());
et.iIdArea = int.Parse(dt.Rows[0].ItemArray[7].ToString());
et.iIdPlant = int.Parse(dt.Rows[0].ItemArray[8].ToString());
et.dDate = DateTime.Parse(dt.Rows[0].ItemArray[9].ToString());
et.iBoss = int.Parse(dt.Rows[0].ItemArray[10].ToString());
et.iSubstitute = int.Parse(dt.Rows[0].ItemArray[11].ToString());
et.sBoss = dt.Rows[0].ItemArray[12].ToString();
et.sSubstitute = dt.Rows[0].ItemArray[13].ToString();
et.sCompleteName = dt.Rows[0].ItemArray[14].ToString();
}
else
{
et = null;
}
return(et);
}
