public int Update(int Adminid, tblAdminConfig configInfo)
{
string sQry = "UPDATE [tblAdminConfig] SET [Coinprice]='" + configInfo.Coinprice + "',[confirmseconds]='" + configInfo.confirmseconds + "' WHERE [Adminid]=" + Adminid;
int retVal = ExecuteUpdateQuery(sQry);
return(retVal);
}
public int Add(tblAdminConfig configInfo)
{
string sQry = "INSERT INTO [tblAdminConfig] ([Coinprice],[confirmseconds]) " +
"VALUES('" + configInfo.Coinprice + "','" + configInfo.confirmseconds + "')";
int retVal = ExecuteCRUDByQuery(sQry);
return(retVal);
}
private tblAdminConfig GetPlaceInfoByRow(DataRow dr)
{
tblAdminConfig configInfo = new tblAdminConfig();
configInfo.Coinprice = Convert.ToInt32(dr["Coinprice"]);
configInfo.confirmseconds = Convert.ToInt32(dr["confirmseconds"]);
return(configInfo);
}
public tblAdminConfig Find(int id)
{
tblAdminConfig configInfo = null;
string sQry = "SELECT * FROM [tblAdminConfig] WHERE [Adminid]=" + id;
DataTable dtConfigInfo = ExecuteQuery(sQry);
if (dtConfigInfo != null)
{
DataRow dr = dtConfigInfo.Rows[0];
configInfo = GetPlaceInfoByRow(dr);
}
return(configInfo);
}
public IActionResult GetAdminConfigById(int id)
{
tblAdminConfig configInfo = _configInfoService.Find(id);
if (configInfo == null)
{
return(NotFound());
}
else
{
return(new ObjectResult(configInfo));
}
}
public IActionResult PostAdminConfig([FromBody] tblAdminConfig configinfo)
{
if (configinfo == null)
{
return(BadRequest());
}
int retVal = _configInfoService.Add(configinfo);
if (retVal > 0)
{
return(Ok());
}
else
{
return(NotFound());
}
}
public IActionResult PostAdminConfig(int id, [FromBody] tblAdminConfig configinfo)
{
if (configinfo == null || id != configinfo.Adminid)
{
return(BadRequest());
}
if (_configInfoService.Find(id) == null)
{
return(NotFound());
}
int retVal = _configInfoService.Update(configinfo.Adminid, configinfo);
if (retVal > 0)
{
return(Ok());
}
else
{
return(NotFound());
}
}
