private long getOrden(long lngPlanId)
{
clsPlan oPlan = new clsPlan(clsAppInfo.Connection);
long returnValue = 0;
try
{
oPlan.VM.PlanId = lngPlanId;
if (oPlan.FindByPK())
{
returnValue = oPlan.VM.Orden;
}
}
catch (Exception exp)
{
throw (exp);
}
finally
{
oPlan.Dispose();
}
return(returnValue);
}
// GET: Plan/Create
public ActionResult Create(int?id)
{
string strMsg = string.Empty;
clsPlanVM oPlanVM = new clsPlanVM();
long lngPlanPadreId = SysData.ToLong(id);
try
{
this.GetDefaultData();
if (lngPlanPadreId > 0)
{
clsPlan oPlanPadre = new clsPlan(clsAppInfo.Connection);
if (oPlanPadre.FindByPK())
{
if (oPlanPadre.VM.Nivel >= 1)
{
PlanHijoNew(oPlanPadre, oPlanVM);
ViewBagLoad();
return(View(oPlanVM));
}
else
{
strMsg += "Cuenta Padre Inválida" + Environment.NewLine;
}
}
else
{
strMsg += "Cuenta Padre no encontrada" + Environment.NewLine;
}
}
else
{
strMsg += "Cuenta Padre Inválida" + Environment.NewLine;
}
}
catch (Exception exp)
{
return(RedirectToAction("httpErrorMsg", "Error", new { MessageErr = exp.Message }));
}
if (strMsg.Trim() != string.Empty)
{
ViewBag.MessageErr = strMsg;
return(RedirectToAction("Index", new { MessageErr = strMsg }));
}
else
{
return(RedirectToAction("Index"));
}
}
public List <long> CalcularCaminoListaId(long id)
{
List <long> ruta = new List <long>();
clsPlan clsPlan = new clsPlan(clsAppInfo.Connection);
clsPlan.VM.PlanId = id;
clsPlan.FindByPK();
while (clsPlan.VM.PlanId > 0)
{
ruta.Add(SysData.ToLong(clsPlan.VM.PlanId));
clsPlan.VM.PlanId = clsPlan.VM.PlanPadreId;
clsPlan.FindByPK();
}
ruta.Add(-1); // agregamos el nodo 0
ruta.Reverse();
return(ruta);
}
// GET: Plan/Create
public ActionResult Create(int?id)
{
string strMsg = string.Empty;
try
{
this.GetDefaultData();
if (ReferenceEquals(id, null))
{
return(RedirectToAction("httpErrorMsg", "Error", new { MessageErr = "Índice nulo o no encontrado" }));
}
clsPlan oPlanPadre = new clsPlan(clsAppInfo.Connection);
oPlanPadre.VM.PlanId = SysData.ToLong(id);
if (oPlanPadre.FindByPK())
{
strMsg += CheckPlanGetCreate(oPlanPadre); // funcion que valida al plan
if (String.IsNullOrEmpty(strMsg))
{
clsPlanVM oPlanVM = new clsPlanVM();
PlanHijoNew(oPlanPadre, oPlanVM);
return(View(oPlanVM));
}
}
else
{
strMsg += "Cuenta Padre Inválida" + Environment.NewLine;
}
// mostramos mensaje de error
if (strMsg.Trim() != string.Empty)
{
ViewBag.MessageErr = strMsg;
return(RedirectToAction("Index", new { MessageErr = strMsg, idPlan = SysData.ToLong(id) }));
}
else
{
return(RedirectToAction("Index", new { idPlan = SysData.ToLong(id) }));
}
}
catch (Exception exp)
{
return(RedirectToAction("httpErrorMsg", "Error", new { MessageErr = exp.Message }));
}
}
/*private bool TieneHijos(long lngPlanPadreId)
* {
* clsPlan oPlan = new clsPlan(clsAppInfo.Connection);
* bool returnValue = false;
*
* try
* {
* oPlan.SelectFilter = clsPlan.SelectFilters.All;
* oPlan.WhereFilter = clsPlan.WhereFilters.PlanPadreId;
* oPlan.VM.PlanPadreId = lngPlanPadreId;
*
* if (oPlan.FindOnly())
* {
* returnValue = true;
* }
* }
*
* catch (Exception exp)
* {
* throw (exp);
* }
* finally
* {
* oPlan.Dispose();
* }
*
* return returnValue;
* }*/
private clsPlanVM PlanFind(long lngPlanId)
{
clsPlan oPlan = new clsPlan(clsAppInfo.Connection);
clsPlanVM oPlanVM = new clsPlanVM();
try
{
oPlan.VM.PlanId = lngPlanId;
if (oPlan.FindByPK())
{
oPlanVM.PlanId = oPlan.VM.PlanId;
oPlanVM.PlanCod = oPlan.VM.PlanCod;
oPlanVM.PlanDes = oPlan.VM.PlanDes;
oPlanVM.PlanEsp = oPlan.VM.PlanEsp;
oPlanVM.TipoPlanId = oPlan.VM.TipoPlanId;
oPlanVM.Orden = oPlan.VM.Orden;
oPlanVM.Nivel = oPlan.VM.Nivel;
oPlanVM.MonedaId = oPlan.VM.MonedaId;
oPlanVM.TipoAmbitoId = oPlan.VM.TipoAmbitoId;
oPlanVM.PlanAjusteId = oPlan.VM.PlanAjusteId;
oPlanVM.CapituloId = oPlan.VM.CapituloId;
oPlanVM.PlanPadreId = oPlan.VM.PlanPadreId;
oPlanVM.EstadoId = oPlan.VM.EstadoId;
return(oPlanVM);
}
}
catch (Exception exp)
{
throw (exp);
}
finally
{
oPlan.Dispose();
}
return(null);
}
public ActionResult DeleteConfirmed(int id)
{
string strMsg = string.Empty;
clsPlan oPlan = new clsPlan(clsAppInfo.Connection);
oPlan.WhereFilter = clsPlan.WhereFilters.PrimaryKey;
oPlan.VM.PlanId = id;
try
{
if (ReferenceEquals(id, null))
{
return(RedirectToAction("httpErrorMsg", "Error", new { MessageErr = "Índice nulo o no encontrado" }));
}
oPlan.FindByPK();
long idPadre = oPlan.VM.PlanPadreId;
strMsg += CheckPlanDeletePost(oPlan.VM);
if (String.IsNullOrEmpty(strMsg))
{
if (oPlan.Delete())
{
return(RedirectToAction("Index", new { idPlan = SysData.ToLong(idPadre) }));
}
}
return(RedirectToAction("Delete", new { id = oPlan.VM.PlanId, mensajeError = " Error al eliminar Plan" }));
}
catch (Exception exp)
{
ViewBag.MessageErr = exp.Message;
return(View(oPlan.VM.PlanId));
}
}
