public IHttpActionResult ChangeSource(SourceAllCreateViewModel source)
{
if (!ModelState.IsValid)
{
return(this.BadRequestError(ModelState));
}
DataSet data = DBConnection.GetQuery(@"update [ReportServer].[dbo].[Source]
set [name] = '" + source.name + @"', [server] = '" + source.server + "', [db] = '" + source.db + "', [login] = '" + source.login + "',[password] = '" + source.password + "', [typeId] = '" + source.typeSource.id + "' where [id] = " + source.id);
if (data == null)
{
return(BadRequest("Not connect to DB"));
}
return(Ok());
}
public IHttpActionResult CreateSource(SourceAllCreateViewModel source)
{
if (!ModelState.IsValid)
{
return(this.BadRequestError(ModelState));
}
DataSet data = DBConnection.GetQuery("select max([id]) from [ReportServer].[dbo].[Source]");
string id = "0";
if (data.Tables[0].Rows[0][0].ToString() != "")
{
id = data.Tables[0].Rows[0][0].ToString();
}
data = DBConnection.GetQuery(@"insert into [ReportServer].[dbo].[Source]
values (" + (Convert.ToInt32(id) + 1).ToString() + ",'" + source.name + "','" + source.server + "','" + source.db + "','" + source.login + "','" + source.password + "'," + source.typeSource.id + ")");
if (data == null)
{
return(BadRequest("Not connect to DB"));
}
return(Ok());
}
