/// <summary>
/// Description : Método para consultar asignación de ejecutivos de cuenta a Director de Cuenta (cabeza)
/// Create by : Ing. Mauricio Ortiz
/// Date : 02/02/2010
/// </summary>
/// <param name="iPerson_id_Director"></param>
/// <returns>ds</returns>
public DataSet SearchAsign_Ejec_Direct(int iPerson_id_Director)
{
DataSet ds = oConn.ejecutarDataSet("UP_WEBSIGE_ADMIN_SEARCHASIGNEJECADIRECTORES", iPerson_id_Director);
EPerson_Asign_Ejec_Direct oeSAsign_Ejec_Direct = new EPerson_Asign_Ejec_Direct();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
oeSAsign_Ejec_Direct.cod_Country = ds.Tables[0].Rows[i]["cod_Country"].ToString().Trim();
oeSAsign_Ejec_Direct.Name_country = ds.Tables[0].Rows[i]["Name_Country"].ToString().Trim();
oeSAsign_Ejec_Direct.Person_id_Director = Convert.ToInt32(ds.Tables[0].Rows[i]["Person_id_Director"].ToString().Trim());
oeSAsign_Ejec_Direct.Person_NameDirector = ds.Tables[0].Rows[i]["Person_Name"].ToString().Trim();
}
}
if (ds.Tables[1].Rows.Count > 0)
{
for (int i = 0; i <= ds.Tables[1].Rows.Count - 1; i++)
{
oeSAsign_Ejec_Direct.Person_id_Ejecutive = Convert.ToInt32(ds.Tables[1].Rows[i]["Person_id_Ejecutive"].ToString().Trim());
oeSAsign_Ejec_Direct.Person_NameEjecutivo = ds.Tables[1].Rows[i]["Person_Name"].ToString().Trim();
}
}
return(ds);
}
else
{
return(null);
}
}
/// <summary>
/// Description : Método para registrar asignación de ejecutivos de cuenta a Director de Cuenta
/// Create by : Ing. Mauricio Ortiz
/// Date : 02/02/2010
/// </summary>
/// <param name="iPerson_id_Director"></param>
/// <param name="iPerson_id_Ejecutive"></param>
/// <param name="bAsign_Ejec_Direct_status"></param>
/// <param name="sAsign_Ejec_Direct_CreateBy"></param>
/// <param name="tAsign_Ejec_Direct_DateBy"></param>
/// <param name="sAsign_Ejec_Direct_ModiBy"></param>
/// <param name="tAsign_Ejec_Direct_DateModiBy"></param>
/// <returns>oerPerson_Asign_Ejec_Direct</returns>
public EPerson_Asign_Ejec_Direct RegisterAsign_Ejec_Direct(int iPerson_id_Director, int iPerson_id_Ejecutive,
bool bAsign_Ejec_Direct_status, string sAsign_Ejec_Direct_CreateBy, DateTime tAsign_Ejec_Direct_DateBy,
string sAsign_Ejec_Direct_ModiBy, DateTime tAsign_Ejec_Direct_DateModiBy)
{
DPerson_Asign_Ejec_Direct odrPerson_Asign_Ejec_Direct = new DPerson_Asign_Ejec_Direct();
EPerson_Asign_Ejec_Direct oerPerson_Asign_Ejec_Direct = odrPerson_Asign_Ejec_Direct.RegisterAsign_Ejec_Direct(iPerson_id_Director, iPerson_id_Ejecutive,
bAsign_Ejec_Direct_status, sAsign_Ejec_Direct_CreateBy, tAsign_Ejec_Direct_DateBy,
sAsign_Ejec_Direct_ModiBy, tAsign_Ejec_Direct_DateModiBy);
odrPerson_Asign_Ejec_Direct = null;
return(oerPerson_Asign_Ejec_Direct);
}
/// <summary>
/// Description : Método para registrar asignación de ejecutivos de cuenta a Director de Cuenta
/// Create by : Ing. Mauricio Ortiz
/// Date : 02/02/2010
/// </summary>
/// <param name="iPerson_id_Director"></param>
/// <param name="iPerson_id_Ejecutive"></param>
/// <param name="bAsign_Ejec_Direct_status"></param>
/// <param name="sAsign_Ejec_Direct_CreateBy"></param>
/// <param name="tAsign_Ejec_Direct_DateBy"></param>
/// <param name="sAsign_Ejec_Direct_ModiBy"></param>
/// <param name="tAsign_Ejec_Direct_DateModiBy"></param>
/// <returns>oerPerson_Asign_Ejec_Direct</returns>
public EPerson_Asign_Ejec_Direct RegisterAsign_Ejec_Direct(int iPerson_id_Director, int iPerson_id_Ejecutive,
bool bAsign_Ejec_Direct_status, string sAsign_Ejec_Direct_CreateBy, DateTime tAsign_Ejec_Direct_DateBy,
string sAsign_Ejec_Direct_ModiBy, DateTime tAsign_Ejec_Direct_DateModiBy)
{
DataTable dt = oConn.ejecutarDataTable("UP_WEBSIGE_ADMIN_REGISTERPERSON_ASIGN_EJEC_DIRECT", iPerson_id_Director, iPerson_id_Ejecutive,
bAsign_Ejec_Direct_status, sAsign_Ejec_Direct_CreateBy, tAsign_Ejec_Direct_DateBy,
sAsign_Ejec_Direct_ModiBy, tAsign_Ejec_Direct_DateModiBy);
EPerson_Asign_Ejec_Direct oerPerson_Asign_Ejec_Direct = new EPerson_Asign_Ejec_Direct();
oerPerson_Asign_Ejec_Direct.Person_id_Director = iPerson_id_Director;
oerPerson_Asign_Ejec_Direct.Person_id_Ejecutive = iPerson_id_Ejecutive;
oerPerson_Asign_Ejec_Direct.Asign_Ejec_Direct_status = bAsign_Ejec_Direct_status;
oerPerson_Asign_Ejec_Direct.Asign_Ejec_Direct_CreateBy = sAsign_Ejec_Direct_CreateBy;
oerPerson_Asign_Ejec_Direct.Asign_Ejec_Direct_DateBy = tAsign_Ejec_Direct_DateBy;
oerPerson_Asign_Ejec_Direct.Asign_Ejec_Direct_ModiBy = sAsign_Ejec_Direct_ModiBy;
oerPerson_Asign_Ejec_Direct.Asign_Ejec_Direct_DateModiBy = tAsign_Ejec_Direct_DateModiBy;
return(oerPerson_Asign_Ejec_Direct);
}