Esempio n. 1
0
        public JSONCollection<TBL_CAUSA> Create(string ID_INFORME, string DESCRIPCION, string TIPO_CAUSA)
        {
            JSONCollection<TBL_CAUSA> objJSON = new JSONCollection<TBL_CAUSA>();
            try
            {
                TBL_CAUSA nuevo = new TBL_CAUSA()
                {
                    //ID_INFORME = int.Parse(ID_INFORME),
                    DESCRIPCION = DESCRIPCION,
                    TIPO_CAUSA = int.Parse(TIPO_CAUSA)
                };
                bd.TBL_CAUSA.InsertOnSubmit(nuevo);
                bd.SubmitChanges();

                objJSON.items = nuevo;
                objJSON.totalCount = bd.TBL_CAUSA.Count();
                objJSON.success = true;
            }
            catch (Exception e)
            {
                objJSON.success = false;
            }
            return objJSON;
        }
Esempio n. 2
0
 public JSONCollection<TBL_CAUSA> Update(string id, TBL_CAUSA nuevo)
 {
     JSONCollection<TBL_CAUSA> objJSON = new JSONCollection<TBL_CAUSA>();
     try
     {
         var objeto = (from variable in bd.TBL_CAUSA
                       where variable.ID_CAUSA == int.Parse(id)
                       select variable).Single();
         //objeto.ID_INFORME = nuevo.ID_INFORME;
         objeto.DESCRIPCION = nuevo.DESCRIPCION;
         objeto.TIPO_CAUSA = nuevo.TIPO_CAUSA;
         bd.SubmitChanges();
         objJSON.items = objeto;
         objJSON.totalCount = bd.TBL_CAUSA.Count();
         objJSON.success = true;
     }
     catch (Exception ex)
     {
         objJSON.success = false;
     }
     return objJSON;
 }