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