public string ActualizarOrdenServicio(string stObj)
{
JObject Jobj;
OrdenServicio objOrdenServicio;
clsOrdenServicio objClsOrdenServicio;
try
{
Jobj = JObject.Parse(stObj);
objOrdenServicio = new OrdenServicio();
objOrdenServicio.orServ_IDOrdenServicio = Convert.ToInt64(Jobj["orServ_IDOrdenServicio"]);
objOrdenServicio.orServ_numero = Convert.ToInt64(Jobj["orServ_numero"]);
objOrdenServicio.orServ_fechaAlta = Jobj["orServ_fechaAlta"].ToString();
objOrdenServicio.orServ_fechaCierre = Jobj["orServ_fechaAlta"].ToString();
objOrdenServicio.orServ_fechaVencimiento = Jobj["orServ_fechaVencimiento"].ToString();
objOrdenServicio.orServ_observaciones = Jobj["orServ_observaciones"].ToString();
objOrdenServicio.orServ_IDAreaServicio = Convert.ToInt32(Jobj["orServ_IDAreaServicio"]);
objOrdenServicio.orServ_IDEstado = Convert.ToInt32(Jobj["orServ_IDEstado"]);
objClsOrdenServicio = new clsOrdenServicio();
return(JsonConvert.SerializeObject(objClsOrdenServicio.ActualizarOrdenServicio(objOrdenServicio)));
}
catch (Exception)
{
throw;
}
finally
{
Jobj = null;
objOrdenServicio = null;
objClsOrdenServicio = null;
}
}
public string RegistrarOrdenServicio([FromBody] OrdenServicio objOrdServ)
{
clsOrdenServicio objClsOrdenServicio;
try
{
objClsOrdenServicio = new clsOrdenServicio();
return(objClsOrdenServicio.RegistrarOrdenServicio(objOrdServ));
}
catch (Exception)
{
throw;
}
finally
{
objClsOrdenServicio = null;
}
}
public ActionResult GeneraOrdenServicio()
{
var objOS = new clsOrdenServicio();
try
{
if (Session["Usuario"] != null)
{
var consultConcepto = entity.Database.SqlQuery <clsMsgSP2>("call spConceptoMov({0}, {1})", new object[] { "MANTTO", "Solicit Serv MODELO" }).ToList();
objOS.CatConcepto = consultConcepto.Select(s => new System.Web.Mvc.SelectListItem {
Value = s.Concepto, Text = s.Concepto
});
//Evaluamos si existe el usuario en la base
var consultTMantenimiento = from m in entity.manttotipoes
where m.EsPaquete == false
select new System.Web.Mvc.SelectListItem {
Value = m.MantenimientoTipo, Text = m.MantenimientoTipo
};
objOS.CatTipoMantenimiento = consultTMantenimiento;
objOS.CatServicio = new List <System.Web.Mvc.SelectListItem>()
{
new System.Web.Mvc.SelectListItem {
Value = "", Text = ""
}
};
}
}
catch (Exception e)
{
Danger("Error" + e.Message);
}
return(View(objOS));
}
public string SelectOrdenServicio(string stObj)
{
JObject Jobj;
clsOrdenServicio objClsOrdenServicio;
try
{
Jobj = JObject.Parse(stObj);
objClsOrdenServicio = new clsOrdenServicio();
return(JsonConvert.SerializeObject(objClsOrdenServicio.ListarOrdenServicio(Convert.ToInt64(Jobj["usu_IDAreaServicio"]))));
}
catch (Exception ex)
{
return(ex.ToString());
}
finally
{
Jobj = null;
objClsOrdenServicio = null;
}
}
public ActionResult GuardaOrdenServicio(clsOrdenServicio objOrdenServ)
{
var objOS = new clsOrdenServicio();
try
{
if (Session["Usuario"] != null)
{
var suc = int.Parse(Session["IdSuc"].ToString());
var usr = Session["Usuario"].ToString();
if (objOrdenServ != null)
{
var param1 = new MySqlParameter("vg_Empresa", 1)
{
Direction = ParameterDirection.Input
};
param1.Direction = System.Data.ParameterDirection.Input;
var param2 = new MySqlParameter("vg_Modulo", "MANTTO")
{
Direction = ParameterDirection.Input
};
param2.Direction = System.Data.ParameterDirection.Input;
var param3 = new MySqlParameter("vg_Sucursal", suc)
{
Direction = ParameterDirection.Input
};
param3.Direction = System.Data.ParameterDirection.Input;
var param4 = new MySqlParameter("vg_TipoMantto", objOrdenServ.CatSelectTipoMantenimiento)
{
Direction = ParameterDirection.Input
};
param4.Direction = System.Data.ParameterDirection.Input;
var param5 = new MySqlParameter("vg_Servicio", objOrdenServ.CatSelectServicio)
{
Direction = ParameterDirection.Input
};
param5.Direction = System.Data.ParameterDirection.Input;
var param6 = new MySqlParameter("vg_EquipoVin", objOrdenServ.unidad)
{
Direction = ParameterDirection.Input
};
param6.Direction = System.Data.ParameterDirection.Input;
var param7 = new MySqlParameter("vg_Usuario", usr)
{
Direction = ParameterDirection.Input
};
param7.Direction = System.Data.ParameterDirection.Input;
var param8 = new MySqlParameter("vg_Concepto", objOrdenServ.CatSelectConcpeto)
{
Direction = ParameterDirection.Input
};
param8.Direction = System.Data.ParameterDirection.Input;
var param9 = new MySqlParameter("vg_SinTransaccion", 0)
{
Direction = ParameterDirection.Input
};
param9.Direction = System.Data.ParameterDirection.Input;
var OK = new MySqlParameter("vg_OK", MySqlDbType.VarChar)
{
Direction = ParameterDirection.Output
};
var msg = new MySqlParameter("vg_OkMensaje", MySqlDbType.VarChar)
{
Direction = ParameterDirection.Output
};
var iDOS = new MySqlParameter("vg_IDOS", MySqlDbType.Int32)
{
Direction = ParameterDirection.Output
};
MySqlParameter[] lstPatram = new MySqlParameter[] { param1, param2, param3, param4, param5, param6, param7, param8, param9, OK, msg, iDOS };
var selectSuc = entity.Database.SqlQuery <string>($"Call spManttoGeneraPMOS({0},{1}, {2}, {3}, {4}, {5}, {6}, {7}, {8}, {9}, {10}, {11})", lstPatram);
Success("La orden fue guardada satisfactoriamente " + OK.Value + selectSuc.FirstOrDefault());
}
}
}
catch (Exception e)
{
Danger("Error" + e.Message);
}
return(RedirectToAction("GeneraOrdenServicio", objOS));
}
