public void addNewUser(Users user)
{
try
{
mindcetEntities DB = new mindcetEntities();
DB.Users.Add(user);
DB.SaveChanges();
}
catch (Exception e)
{
Logger.log(this.GetType().Name, MethodBase.GetCurrentMethod().Name, e.ToString());
}
}
public bool isUserExist(string userId)
{
bool exist = false;
try
{
var DB = new mindcetEntities();
exist = DB.Users.Any(x => x.UserID == userId);
}
catch (Exception e)
{
Logger.log(this.GetType().Name, MethodBase.GetCurrentMethod().Name, e.ToString());
}
return(exist);
}
public List <string> getAllCategory()
{
Question question = new Question();
List <String> visitors = new List <string>();
try
{
mindcetEntities DB = new mindcetEntities();
visitors = (from t in DB.Question
select t.Category).ToList();
}
catch (Exception e)
{
Logger.log(this.GetType().Name, MethodBase.GetCurrentMethod().Name, e.ToString());
}
return(visitors);
}
public void addNewUser(string channelId, string id, string name, string text)
{
try
{
var DB = new mindcetEntities();
var NewUsers = new Users();
NewUsers.Channel = channelId;
NewUsers.UserID = id;
NewUsers.UserName = name;
NewUsers.created = DateTime.UtcNow;
NewUsers.Message = text.Truncate(500);
DB.Users.Add(NewUsers);
DB.SaveChanges();
}catch (Exception e)
{
Logger.log(this.GetType().Name, MethodBase.GetCurrentMethod().Name, e.ToString());
}
}
public List <Question> getQuestion(string catgoty, string subCategory)
{
Question question = new Question();
List <Question> visitors = new List <Question>();
try
{
mindcetEntities DB = new mindcetEntities();
visitors = (from t in DB.Question
where t.Category == catgoty && t.SubCategory == subCategory
select t).ToList();
}
catch (Exception e)
{
Logger.log(this.GetType().Name, MethodBase.GetCurrentMethod().Name, e.ToString());
}
return(visitors);
}
public void deleteUser(string userId)
{
Users NewUsers = new Users();
List <Users> visitors = new List <Users>();
try
{
mindcetEntities DB = new mindcetEntities();
NewUsers = new Users();
var itemToRemove = DB.Users.SingleOrDefault(x => x.UserID == userId);
if (itemToRemove != null)
{
DB.Users.Remove(itemToRemove);
DB.SaveChanges();
}
}
catch (Exception e)
{
Logger.log(this.GetType().Name, MethodBase.GetCurrentMethod().Name, e.ToString());
}
}
public Users getUser(string userId)
{
Users NewUsers = new Users();
List <Users> visitors = new List <Users>();
try
{
mindcetEntities DB = new mindcetEntities();
NewUsers = new Users();
visitors = (from t in DB.Users
where t.UserID == userId
select t).ToList();
}
catch (Exception e)
{
Logger.log(this.GetType().Name, MethodBase.GetCurrentMethod().Name, e.ToString());
}
return(visitors[0]);
}