public FixedAssetGroup Add(FixedAssetGroup F*G, string userid) { var sqlQuery = @"INSERT INTO FIXEDASSETGROUP (IDFAGROUP, FAGROUPNAME, ESTIMATELIFEYEAR, COSTCENTER, INPUTBY, INPUTDATE, UPDATEBY, UPDATEDATE) VALUES ('" + F*G.IDFAGROUP + @"', '" + F*G.FAGROUPNAME + "', '" + F*G.ESTIMATELIFEYEAR + "', '" + F*G.COSTCENTER + @"', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"', " + Convert.ToInt32(userid) + ", '" + DateTime.Now + @"'); " + "SELECT CAST(SCOPE_IDENTITY() as int)"; var SID = _db.Query <int>(sqlQuery, F*G).Single(); F*G.SID = SID; return(F*G); }
public FixedAssetGroup Update(FixedAssetGroup F*G, string userid) { var sqlQuery = string.Format(@"UPDATE FIXEDASSETGROUP SET IDFAGROUP = '{0}', FAGROUPNAME = '{1}', ESTIMATELIFEYEAR = '{2}', COSTCENTER = '{3}', UPDATEBY = {4}, UPDATEDATE = '{5}' WHERE SID = {6}", F*G.IDFAGROUP, F*G.FAGROUPNAME, F*G.ESTIMATELIFEYEAR, F*G.COSTCENTER, Convert.ToInt32(userid), DateTime.Now, F*G.SID); this._db.Execute(sqlQuery, F*G); return(F*G); }
public JsonResult Edit(FixedAssetGroup fixedassetgroup, string userid) { try { if (ModelState.IsValid) { F*G.Update(fixedassetgroup, Session["userid"].ToString()); } } catch { return(Json("error")); } return(Json("success")); }
public async Task <IActionResult> GetFixedAssetGroupByFixedAssetGroupName(String FixedAssetGroupName) { FixedAssetGroup Items = new FixedAssetGroup(); try { Items = await _context.FixedAssetGroup.Where(q => q.FixedAssetGroupName == FixedAssetGroupName).FirstOrDefaultAsync(); } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); return(BadRequest($"Ocurrio un error:{ex.Message}")); } return(await Task.Run(() => Ok(Items))); }
public async Task <ActionResult <FixedAssetGroup> > Insert([FromBody] FixedAssetGroup _FixedAssetGroup) { FixedAssetGroup _FixedAssetGroupq = new FixedAssetGroup(); try { _FixedAssetGroupq = _FixedAssetGroup; _context.FixedAssetGroup.Add(_FixedAssetGroupq); await _context.SaveChangesAsync(); } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); return(BadRequest($"Ocurrio un error:{ex.Message}")); } return(await Task.Run(() => Ok(_FixedAssetGroupq))); }
public async Task <IActionResult> Delete([FromBody] FixedAssetGroup _FixedAssetGroup) { FixedAssetGroup _FixedAssetGroupq = new FixedAssetGroup(); try { _FixedAssetGroupq = _context.FixedAssetGroup .Where(x => x.FixedAssetGroupId == (Int64)_FixedAssetGroup.FixedAssetGroupId) .FirstOrDefault(); _context.FixedAssetGroup.Remove(_FixedAssetGroupq); await _context.SaveChangesAsync(); } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}"))); } return(await Task.Run(() => Ok(_FixedAssetGroupq))); }
public async Task <ActionResult <FixedAssetGroup> > Update([FromBody] FixedAssetGroup _FixedAssetGroup) { FixedAssetGroup _FixedAssetGroupq = _FixedAssetGroup; try { _FixedAssetGroupq = await(from c in _context.FixedAssetGroup .Where(q => q.FixedAssetGroupId == _FixedAssetGroup.FixedAssetGroupId) select c ).FirstOrDefaultAsync(); _context.Entry(_FixedAssetGroupq).CurrentValues.SetValues((_FixedAssetGroup)); //_context.FixedAssetGroup.Update(_FixedAssetGroupq); await _context.SaveChangesAsync(); } catch (Exception ex) { _logger.LogError($"Ocurrio un error: { ex.ToString() }"); return(await Task.Run(() => BadRequest($"Ocurrio un error:{ex.Message}"))); } return(await Task.Run(() => Ok(_FixedAssetGroupq))); }