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)));
}
