public ActionResult SetsSatusCounterData(int id, int year, int month, bool status)
{
Admtszh admuser = null;
// uk_profile uk = null;
string result = null;
using (var context = new EFDbContext())
{
IEnumerable <Counter> ListCounters = repository.Counter.Where(u => u.UserId.Equals(id));
if (ListCounters.Count() != 0)
{
string res = "";
foreach (var item in ListCounters)
{
if (!res.Equals(""))
{
res = res + ",";
}
res = res + item.id.ToString();
}
result = context.SQLStringConnect("UPDATE[dbo].[Counter_data] SET status = 1 WHERE id IN( " + res + ")");
}
}
return(Json(result));
}
public void SQLstringConnect(string sqlcommand, out DataSet ds)
{
context.SQLStringConnect(sqlcommand, out ds);
}
