public ActionResult Index()
{
int yardId = Convert.ToInt32(HttpContext.Request["yardid"]);
string query = $"SELECT [YardId],[Name],[cur_equipment],[cur_units],[max_equipment],[max_units],[update] FROM Yard WHERE YardId = {yardId}";
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
List <Yard> yards = IDataTable.To <Yard>(DAO.Exec(cmd));
conn.Close();
SqlDependencyService service = new SqlDependencyService();
service.Config();
Yard yard = yards.Find(y => y.YardId == yardId);
ViewBag.yard = (yard != null) ? yard : new Yard();
string Name = (yard == null)?"":yard.Name;
ViewBag.Title = $"Yarda {Name}";
return(View());
}
public void Dispose_ShouldBeActivedStop()
{
//Arrange
Mock.Get <ISqlConnectService>(_sqlConnect).Setup(x => x.DesactivarSqlDependency()).Verifiable("No sé ha deshabilitado el Servicio de Sql Dependency");
//Act
using (var service = new SqlDependencyService(_sqlConnect))
{
}
//Assert
Mock.VerifyAll(Mock.Get(_sqlConnect));
}
/// <summary>
/// Get service on Custom ConnectionString
/// </summary>
/// <returns>SqlDependency Service</returns>
public SqlDependencyService GetDependency(string ConnectionString)
{
if (this.DependencyServices.ContainsKey(ConnectionString))
{
return(this.DependencyServices[ConnectionString]);
}
else
{
var dep = new SqlDependencyService(ConnectionString);
dep.Onlog -= Dep_Onlog; dep.Onlog += Dep_Onlog;
this.DependencyServices.Add(ConnectionString, dep);
return(dep);
}
}
