public ActionResult Delete(string area_Razoninactivo)
{
//declaramos la variable de coneccion solo para recuperar los datos necesarios.
//posteriormente es destruida.
string result = "";
var cAreas =
new cAreas
{
area_Id = (int)Session["area_Id"],
area_Razoninactivo = area_Razoninactivo
};
var Usuario = (tbUsuario)Session["Usuario"];
try
{
using (db = new ERP_GMEDINAEntities())
{
var list = db.UDP_RRHH_tbAreas_Delete(cAreas.area_Id, cAreas.area_Razoninactivo,
(int)Session["UserLogin"],
Function.DatetimeNow());
foreach (UDP_RRHH_tbAreas_Delete_Result item in list)
{
result = item.MensajeError;
}
}
}
catch (Exception ex)
{
ex.Message.ToString();
result = "-2";
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
private void GuardarArea()
{
cAreas area = new cAreas();
if (!string.IsNullOrEmpty(Clave))
{ //Actualizar
area.Actualizar(new AREA
{
ID_AREA = SelectedItem.ID_AREA,
DESCR = Descripcion,
ID_CENTRO = SelectedTipo.ID_CENTRO
});
}
else
{ //Agregar
area.Insertar(new AREA
{
ID_AREA = 0,
DESCR = Descripcion,
ID_CENTRO = SelectedTipo.ID_CENTRO
});
}
//Limpiamos las variables
Clave = string.Empty;
Descripcion = string.Empty;
Tipo = 0;
//Mostrar Listado
this.GetAreas();
}
private void GetAreas()
{
cAreas area = new cAreas();
ListItems.Clear();
ListItems = new ObservableCollection <AREA>(area.ObtenerTodos(Busqueda, SelectedTipo.ID_CENTRO));
if (ListItems.Count > 0)
{
EmptyVisible = false;
}
else
{
EmptyVisible = true;
}
}
private bool EliminarArea()
{
if (SelectedItem != null)
{
cAreas area = new cAreas();
if (!area.Eliminar(SelectedItem.ID_AREA))
{
return(false);
}
Clave = string.Empty;
Descripcion = string.Empty;
Tipo = 0;
this.GetAreas();
}
return(true);
}
//
// Page class constructor
//
public cPersonas_add(AspNetMaker9_ControlVehicular APage)
{
m_ParentPage = APage;
m_Page = this;
m_PageID = "add";
m_PageObjName = "Personas_add";
m_PageObjTypeName = "cPersonas_add";
// Initialize language object
if (Language == null)
Language = new cLanguage(this);
// Initialize table object
if (Personas == null)
Personas = new cPersonas(this);
if (Areas == null)
Areas = new cAreas(this);
if (Usuarios == null)
Usuarios = new cUsuarios(this);
if (VehiculosAutorizados_grid == null)
VehiculosAutorizados_grid = new cVehiculosAutorizados_grid(ParentPage);
if (VehiculosAutorizados == null)
VehiculosAutorizados = new cVehiculosAutorizados(this);
// Table
m_TableName = "Personas";
m_Table = Personas;
CurrentTable = Personas;
//CurrentTableType = Personas.GetType();
// Initialize URLs
// Connect to database
if (Conn == null)
Conn = new cConnection();
}
//
// Page class constructor
//
public cAreas_view(AspNetMaker9_ControlVehicular APage)
{
m_ParentPage = APage;
m_Page = this;
m_PageID = "view";
m_PageObjName = "Areas_view";
m_PageObjTypeName = "cAreas_view";
// Initialize language object
if (Language == null)
Language = new cLanguage(this);
// Initialize table object
if (Areas == null)
Areas = new cAreas(this);
if (Usuarios == null)
Usuarios = new cUsuarios(this);
// Table
m_TableName = "Areas";
m_Table = Areas;
CurrentTable = Areas;
//CurrentTableType = Areas.GetType();
// Initialize URLs
string KeyUrl = "";
if (ew_NotEmpty(ew_Get("IdArea"))) {
RecKey["IdArea"] = ew_Get("IdArea");
KeyUrl += "&IdArea=" + ew_UrlEncode(RecKey["IdArea"]);
}
ExportPrintUrl = PageUrl + "export=print" + KeyUrl;
ExportHtmlUrl = PageUrl + "export=html" + KeyUrl;
ExportExcelUrl = PageUrl + "export=excel" + KeyUrl;
ExportWordUrl = PageUrl + "export=word" + KeyUrl;
ExportXmlUrl = PageUrl + "export=xml" + KeyUrl;
ExportCsvUrl = PageUrl + "export=csv" + KeyUrl;
ExportPdfUrl = PageUrl + "export=pdf" + KeyUrl;
// Connect to database
if (Conn == null)
Conn = new cConnection();
// Export options
ExportOptions = new cListOptions();
ExportOptions.Tag = "span";
ExportOptions.Separator = " ";
}
//
// Page class constructor
//
public cAreas_list(AspNetMaker9_ControlVehicular APage)
{
m_ParentPage = APage;
m_Page = this;
m_PageID = "list";
m_PageObjName = "Areas_list";
m_PageObjTypeName = "cAreas_list";
// Initialize language object
if (Language == null)
Language = new cLanguage(this);
// Initialize table object
if (Areas == null)
Areas = new cAreas(this);
if (Personas == null)
Personas = new cPersonas(this);
if (Usuarios == null)
Usuarios = new cUsuarios(this);
// Table
m_TableName = "Areas";
m_Table = Areas;
CurrentTable = Areas;
//CurrentTableType = Areas.GetType();
// Initialize URLs
ExportPrintUrl = PageUrl + "export=print";
ExportExcelUrl = PageUrl + "export=excel";
ExportWordUrl = PageUrl + "export=word";
ExportHtmlUrl = PageUrl + "export=html";
ExportXmlUrl = PageUrl + "export=xml";
ExportCsvUrl = PageUrl + "export=csv";
ExportPdfUrl = PageUrl + "export=pdf";
AddUrl = "Areasadd.aspx?" + EW_TABLE_SHOW_DETAIL + "=";
InlineAddUrl = PageUrl + "a=add";
GridAddUrl = PageUrl + "a=gridadd";
GridEditUrl = PageUrl + "a=gridedit";
MultiDeleteUrl = "Areasdelete.aspx";
MultiUpdateUrl = "Areasupdate.aspx";
// Connect to database
if (Conn == null)
Conn = new cConnection();
// Initialize list options
ListOptions = new cListOptions();
// Export options
ExportOptions = new cListOptions();
ExportOptions.Tag = "span";
ExportOptions.Separator = " ";
}
//
// Page class constructor
//
public cPersonas_grid(AspNetMaker9_ControlVehicular APage)
{
m_ParentPage = APage;
m_Page = this;
m_PageID = "grid";
m_PageObjName = "Personas_grid";
m_PageObjTypeName = "cPersonas_grid";
// Initialize language object
if (Language == null)
Language = new cLanguage(this);
// Initialize table object
if (Personas == null)
Personas = new cPersonas(this);
if (Areas == null)
Areas = new cAreas(this);
if (Usuarios == null)
Usuarios = new cUsuarios(this);
// Table
m_TableName = "Personas";
m_Table = Personas;
MasterTable = CurrentTable;
//MasterTableType = CurrentTableType;
CurrentTable = Personas;
//CurrentTableType = Personas.GetType();
Personas.LoadDetailParms();
if (ew_NotEmpty(ew_Get("confirmpage")))
ConfirmPage = ew_ConvertToBool(ew_Get("confirmpage"));
if (Personas.CurrentMasterTable == "Areas") {
Personas.IdArea.FldIsDetailKey = true;
if (ew_NotEmpty(ew_Get("IdArea"))) {
Personas.IdArea.CurrentValue = ew_Get("IdArea");
Personas.IdArea.SessionValue = Personas.IdArea.CurrentValue;
}
}
// Initialize URLs
// Connect to database
if (Conn == null)
Conn = new cConnection();
// Initialize list options
ListOptions = new cListOptions();
}
public ActionResult Edit(cAreas cAreas, cDepartamentos[] Departamentos, cDepartamentos[] inactivar)
{
//declaramos la variable de coneccion solo para recuperar los datos necesarios.
//posteriormente es destruida.
string result = "";
cAreas.area_Id = (int)Session["area_Id"];
var Usuario = (tbUsuario)Session["Usuario"];
//en esta area ingresamos el registro con el procedimiento almacenado
try
{
db = new ERP_GMEDINAEntities();
using (var transaction = db.Database.BeginTransaction())
{
var list = db.UDP_RRHH_tbAreas_Update(
cAreas.area_Id,
cAreas.suc_Id,
cAreas.area_Descripcion,
(int)Session["UserLogin"],
Function.DatetimeNow());
foreach (UDP_RRHH_tbAreas_Update_Result item in list)
{
if (item.MensajeError == "-1")
{
return(Json(new { codigo = "-1" }, JsonRequestBehavior.AllowGet));
}
cAreas.area_Id = int.Parse(item.MensajeError);
}
inactivar = inactivar == null ? new cDepartamentos[] { } : inactivar;
Departamentos = Departamentos == null ? new cDepartamentos[] { } : Departamentos;
foreach (cDepartamentos item in inactivar)
{
var depto = db.UDP_RRHH_tbDepartamentos_Delete(
item.depto_Id,
item.depto_RazonInactivo,
(int)Session["UserLogin"],
Function.DatetimeNow());
foreach (UDP_RRHH_tbDepartamentos_Delete_Result dep in depto)
{
dep.ToString();
}
}
foreach (cDepartamentos item in Departamentos)
{
if (item.Accion == "i")
{
var deptocargo = db.UDP_RRHH_tbCargos_Insert(
item.car_Descripcion,
item.car_SalarioMinimo,
item.car_SalarioMaximo,
(int)Session["UserLogin"],
Function.DatetimeNow()
);
foreach (UDP_RRHH_tbCargos_Insert_Result i in deptocargo)
{
var resultadod = i.MensajeError + " ";
if (resultadod.Substring(0, 2) == "-1")
{
return(Json(new { codigo = "-3", Accion = "i" }, JsonRequestBehavior.AllowGet));
}
item.car_Id = int.Parse(i.MensajeError);
}
var depto = db.UDP_RRHH_tbDepartamentos_Insert(
cAreas.area_Id,
item.depto_Descripcion,
item.car_Id,
(int)Session["UserLogin"],
Function.DatetimeNow());
string mensajeDB = "";
foreach (UDP_RRHH_tbDepartamentos_Insert_Result i in depto)
{
mensajeDB = i.MensajeError.ToString();
}
if (mensajeDB == "-1")
{
return(Json(new { codigo = "-4", Accion = "i" }, JsonRequestBehavior.AllowGet));
}
}
else if (item.Accion == "e")
{
var depto = db.UDP_RRHH_tbDepartamentos_Update(
item.depto_Id,
cAreas.area_Id,
item.depto_Descripcion,
(int)Session["UserLogin"],
Function.DatetimeNow());
string mensajeDB = "";
foreach (UDP_RRHH_tbDepartamentos_Update_Result i in depto)
{
mensajeDB = i.MensajeError.ToString();
}
if (mensajeDB == "-1")
{
return(Json(new { codigo = "-4", Accion = "e" }, JsonRequestBehavior.AllowGet));
}
}
else if (item.Accion == "a")
{
var depto = db.UDP_RRHH_tbDepartamentos_Restore(item.depto_Id,
(int)Session["UserLogin"],
Function.DatetimeNow());
foreach (UDP_RRHH_tbDepartamentos_Restore_Result dep in depto)
{
dep.ToString();
}
}
}
transaction.Commit();
}
}
catch (Exception ex)
{
ex.Message.ToString();
return(Json(new { codigo = "-2" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { codigo = result }, JsonRequestBehavior.AllowGet));
}
//
// Page class constructor
//
public cAreas_delete(AspNetMaker9_ControlVehicular APage)
{
m_ParentPage = APage;
m_Page = this;
m_PageID = "delete";
m_PageObjName = "Areas_delete";
m_PageObjTypeName = "cAreas_delete";
// Initialize language object
if (Language == null)
Language = new cLanguage(this);
// Initialize table object
if (Areas == null)
Areas = new cAreas(this);
if (Usuarios == null)
Usuarios = new cUsuarios(this);
// Table
m_TableName = "Areas";
m_Table = Areas;
CurrentTable = Areas;
//CurrentTableType = Areas.GetType();
// Initialize URLs
// Connect to database
if (Conn == null)
Conn = new cConnection();
}