public IEnumerable <TasksModel> GetEnd(DateTime end) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { return(entities.Tasks.Where(i => i.date_end == end).ToList().Select(c => modelFactory.Create(c))); } }
public IEnumerable <BranchesModel> GetCreator(int c_id) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { return(entities.Branches.Where(i => i.creator_id == c_id).ToList().Select(c => modelFactory.Create(c))); } }
public UsersModel Get(string username, string password) { using (TaskManagerDBEntities ctx = new TaskManagerDBEntities()) { return(modelFactory.Create(ctx.Users.Where(i => i.username.Equals(username)).Where(i => i.password.Equals(password)).FirstOrDefault())); } }
public IEnumerable <TasksModel> GetStatus(string status) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { return(entities.Tasks.Where(i => i.status.Equals(status)).ToList().Select(c => modelFactory.Create(c))); } }
public UsersModel Get(int ID) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { return(modelFactory.Create(entities.Users.Where(i => i.id == ID).FirstOrDefault())); } }
public IEnumerable <TasksModel> GetExecutor(int e_id) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { return(entities.Tasks.Where(i => i.executor_id == e_id).ToList().Select(c => modelFactory.Create(c))); } }
public IEnumerable <BranchesModel> GetBegin(DateTime begin) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { return(entities.Branches.Where(i => i.created_date.Equals(begin)).ToList().Select(c => modelFactory.Create(c))); } }
public TasksModel GetName(string name) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { return(modelFactory.Create(entities.Tasks.Where(i => i.taskname.Equals(name)).FirstOrDefault())); } }
public TasksModel GetId(int id) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { return(modelFactory.Create(entities.Tasks.Where(i => i.id == id).FirstOrDefault())); } }
public bool Post(Tasks task) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { if (entities.Tasks.Where(t => t.taskname.Equals(task.taskname)).FirstOrDefault() != null) { return(false); } entities.Tasks.Add(task); entities.SaveChanges(); return(true); } }
public bool Post(Users user) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { if (entities.Users.Where(t => t.username.Equals(user.username)).Where(t => t.password.Equals(user.password)).FirstOrDefault() != null) { return(false); } entities.Users.Add(new Users { username = user.username, password = user.password }); entities.SaveChanges(); return(true); } }
public bool Post(Branches branch) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { if (entities.Branches.Where(b => b.branchname.Equals(branch.branchname)).FirstOrDefault() != null) { return(false); } entities.Branches.Add(new Branches { branchname = branch.branchname, description = branch.description, creator_id = branch.creator_id, created_date = branch.created_date }); entities.SaveChanges(); return(true); } }
public bool Delete(Users userDel) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { if ((entities.UserBranch.Where(u => u.user_id == userDel.id).FirstOrDefault() != null) || (entities.UserTask.Where(u => u.user_id == userDel.id).FirstOrDefault() != null)) { return(false); } if (userDel != null) { entities.Users.Remove(userDel); entities.SaveChanges(); return(true); } else { return(false); } } }
public bool Delete(Tasks taskDel) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { if ((entities.TaskBranch.Where(i => i.task_id == taskDel.id).FirstOrDefault() != null) || (entities.UserTask.Where(i => i.task_id == taskDel.id).FirstOrDefault() != null)) { return(false); } Tasks task = entities.Tasks.Where(i => i.taskname.Equals(taskDel.taskname)).FirstOrDefault(); if (task != null) { entities.Tasks.Remove(task); entities.SaveChanges(); return(true); } else { return(false); } } }
public bool Delete(Branches branchDel) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { if ((entities.UserBranch.Where(i => i.branch_id == branchDel.id).FirstOrDefault() != null) || (entities.TaskBranch.Where(i => i.branch_id == branchDel.id).FirstOrDefault() != null)) { return(false); } Branches branch = entities.Branches.Where(i => i.branchname == branchDel.branchname).FirstOrDefault(); if (branch != null) { entities.Branches.Remove(branch); entities.SaveChanges(); return(true); } else { return(false); } } }
public bool SetTB(int t_id, int b_id) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { try { if (entities.TaskBranch.Where(i => i.task_id == t_id).Where(i => i.branch_id == b_id).FirstOrDefault() != null) { return(false); } entities.TaskBranch.Add(new TaskBranch { task_id = t_id, branch_id = b_id }); entities.SaveChanges(); return(true); } catch (Exception ex) { return(false); } } }
public bool SetTU(int t_id, int u_id) { using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { try { if (entities.UserTask.Where(i => i.task_id == t_id).Where(t => t.user_id == u_id).FirstOrDefault() != null) { return(false); } entities.UserTask.Add(new UserTask { task_id = t_id, user_id = u_id }); entities.SaveChanges(); return(true); } catch (Exception ex) { return(false); } } }
public string Get(CallbackData update) { if (update.@event == "webhook") { //SendMessage(update.sender.id, "Hello, newcomer!"); } else if (update.@event == "conversation_started") { SendMessage(update.sender.id, "Hello, your conversation with bot has just started!"); } else if (update.@event == "subscribed") { } else if (update.@event == "unsubscribed") { } else if (update.@event == "delivered") { } else if (update.@event == "seen") { } else if (update.@event == "failed") { } #region Message else if (update.@event == "message") { if (Logic.isFilter && Logic.isFilterParameter) { if (update.message.text == "Back") { /*if (Logic.isGetUsers) * { * Logic.isGetUsers = false; * } * else if (Logic.isGetBranches) * { * Logic.isGetBranches = false; * } * else if (Logic.isGetTasks) * { * Logic.isGetTasks = false; * }*/ Logic.isFilter = false; Logic.isFilterParameter = false; return(""); } else { Regex rxUID = new Regex(@"(ID)\s.*"); Regex rxUs = new Regex(@"(Username)\s.*"); Regex rxBN = new Regex(@"(Branchname)\s.*"); Regex rxCA = new Regex(@"(CreatedAt)\s.*"); Regex rxCID = new Regex(@"(CreatorId)\s.*"); using (TaskManagerDBEntities entities = new TaskManagerDBEntities()) { Match m1 = rxUID.Match(update.message.text); Match m2 = rxUs.Match(update.message.text); Match m3 = rxBN.Match(update.message.text); Match m4 = rxCA.Match(update.message.text); Match m5 = rxCID.Match(update.message.text); DataRepository data = new DataRepository(); string text = update.message.text.Replace(" ", String.Empty); if (m1.Success) { string param = text.Substring(2, text.Length - 2); int ID = Convert.ToInt32(param); string message = ConvertUsers(modelFactory.Create(entities.Users.Where(i => i.id == ID).FirstOrDefault())); SendMessage(update.sender.id, message); } else if (m2.Success) { string param = text.Substring(8, text.Length - 8); string message = ConvertUsers(modelFactory.Create(entities.Users.Where(i => i.username == param).FirstOrDefault())); SendMessage(update.sender.id, message); } else if (m3.Success) { string param = text.Substring(10, text.Length - 10); string message = ConvertBranches(modelFactory.Create(entities.Branches.Where(i => i.branchname == param).FirstOrDefault())); SendMessage(update.sender.id, message); } else if (m4.Success) { string param = text.Substring(9, text.Length - 9); if (Logic.isGetTasks) { string message = ConvertTasks(data.GetTaskViaBeginTime(Convert.ToDateTime(param)).ToList().Select(c => modelFactory.Create(c))); SendMessage(update.sender.id, message); } else if (Logic.isGetBranches) { string message = ConvertBranches(data.GetBranchesViaBeginTime(Convert.ToDateTime(param)).ToList().Select(c => modelFactory.Create(c))); SendMessage(update.sender.id, message); } } else if (m5.Success) { string param = text.Substring(9, text.Length - 9); int ID = Convert.ToInt32(param); if (Logic.isGetTasks) { string message = ConvertTasks(data.GetTaskViaCreatorID(ID).ToList().Select(c => modelFactory.Create(c))); SendMessage(update.sender.id, message); } else if (Logic.isGetBranches) { string message = ConvertBranches(data.GetBranchesViaCreatorID(ID).ToList().Select(c => modelFactory.Create(c))); SendMessage(update.sender.id, message); } } } SendMessage(update.sender.id, "Print Back to return"); return(""); } } else if ((Logic.isGetUsers || Logic.isGetBranches || Logic.isGetTasks) && Logic.isFilter) { string s = ""; string tmp = ""; if (Logic.isGetUsers) { s = "Users"; tmp = "ID, Username"; } else if (Logic.isGetBranches) { s = "Branches"; tmp = "Branchname, CreatedAt, CreatorId"; } else if (Logic.isGetTasks) { s = "Tasks"; tmp = "CreatorId, CreatedAt, FinishAt, Description, Status, ExecutorId"; } Logic.isFilterParameter = true; SendMessage(update.sender.id, "Possible parameters for filtering are: " + tmp + "\\n" + "Print Back to return, or enter the name of parameter, " + "\\n" + "Print name and parameter and value (w whitespace) to search"); } else if (Logic.isGet && Logic.isGetTasks) { if (update.message.text == "All") { DataRepository repository = new DataRepository(); var data = repository.GetAllTasks().ToList().Select(c => modelFactory.Create(c)); //sb.Append(data.ElementAt(0).username); //JsonConvert.SerializeObject(new { sb = sb }); string message = ConvertTasks(data); SendMessage(update.sender.id, message); return(""); } else if (update.message.text == "Filter") { //Logic.isFilterParameter = true; SendMessage(update.sender.id, "Oops"); return(""); } else if (update.message.text == "Back") { Logic.isGetTasks = false; Logic.isGet = false; SendMessage(update.sender.id, "If you want to get data from database, print Get + Users|Branches|Tasks; " + "\\n" + "if you want to Post new data into database, print Post + Users|Branches|Tasks; " + "\\n" + "if you need help, print Help; "); return(""); } else { SendMessage(update.sender.id, "Print All to get all data from Branches table, print Filter to start filtering, print Back to return "); return(""); } } else if (Logic.isGet && Logic.isGetBranches) { if (update.message.text == "All") { DataRepository repository = new DataRepository(); var data = repository.GetAllBranches().ToList().Select(c => modelFactory.Create(c)); //sb.Append(data.ElementAt(0).username); //JsonConvert.SerializeObject(new { sb = sb }); string message = ConvertBranches(data); SendMessage(update.sender.id, message); return(""); } else if (update.message.text == "Filter") { Logic.isFilter = true; SendMessage(update.sender.id, "Press any key"); return(""); } else if (update.message.text == "Back") { Logic.isGetBranches = false; Logic.isGet = false; SendMessage(update.sender.id, "If you want to get data from database, print Get + Users|Branches|Tasks; " + "\\n" + "if you want to Post new data into database, print Post + Users|Branches|Tasks; " + "\\n" + "if you need help, print Help; "); return(""); } else { SendMessage(update.sender.id, "Print All to get all data from Branches table, print Filter to start filtering, print Back to return "); return(""); } } else if (Logic.isGet && Logic.isGetUsers) { if (update.message.text == "All") { DataRepository repository = new DataRepository(); var data = repository.GetAllUsers().ToList().Select(c => modelFactory.Create(c)); //sb.Append(data.ElementAt(0).username); //JsonConvert.SerializeObject(new { sb = sb }); string message = ConvertUsers(data); SendMessage(update.sender.id, message); return(""); } else if (update.message.text == "Filter") { Logic.isFilter = true; SendMessage(update.sender.id, "Press any key"); return(""); } else if (update.message.text == "Back") { Logic.isGetUsers = false; Logic.isGet = false; SendMessage(update.sender.id, "If you want to get data from database, print Get + Users|Branches|Tasks; " + "\\n" + "if you want to Post new data into database, print Post + Users|Branches|Tasks; " + "\\n" + "if you need help, print Help; "); return(""); } else { SendMessage(update.sender.id, "Print All to get all data from Users table, print Filter to start filtering, print Back to return "); return(""); } } /*else if (Logic.isGet) * { * * * if (update.message.text == "Users") * { * Logic.isGetUsers = true; * SendMessage(update.sender.id, "Print All to get all data from Users table, print Filter to start filtering, print Back to return "); * return ""; * } * else if (update.message.text == "Branches") * { * Logic.isGetBranches = true; * SendMessage(update.sender.id, "Print All to get all data from Branches table, print Filter to start filtering, print Back to return "); * return ""; * } * else if (update.message.text == "Tasks") * { * Logic.isGetTasks = true; * SendMessage(update.sender.id, "Print All to get all data from Tasks table, print Filter to start filtering, print Back to return "); * return ""; * } * else if (update.message.text == "Back") * { * Logic.isGet = false; * return ""; * } * * * else SendMessage(update.sender.id, "Please, print what kind of data do you want to work with: Users, Branches, Tasks, or print Back to get back"); * }*/ else if (!Logic.isGet && !Logic.isPost) { Regex mGUser = new Regex(@"(Get)\s(Users)"); Regex mGBranches = new Regex(@"(Get)\s(Branches)"); Regex mGTasks = new Regex(@"(Get)\s(Tasks)"); Regex mPUser = new Regex(@"(Post)\s(Users)"); Regex mPBranches = new Regex(@"(Post)\s(Branches)"); Regex mPTasks = new Regex(@"(Post)\s(Tasks)"); Match mUg = mGUser.Match(update.message.text); Match mBg = mGBranches.Match(update.message.text); Match mTg = mGTasks.Match(update.message.text); Match mUp = mPUser.Match(update.message.text); Match mBp = mPBranches.Match(update.message.text); Match mTp = mPTasks.Match(update.message.text); if (mUg.Success) { Logic.isGetUsers = true; } else if (mBg.Success) { Logic.isGetBranches = true; } else if (mTg.Success) { Logic.isGetTasks = true; } if (mUg.Success || mBg.Success || mTg.Success) { Logic.isGet = true; SendMessage(update.sender.id, "Print All to get all data from table, print Filter to start filtering, print Back to return "); return(""); } else if (mUp.Success || mBp.Success || mTp.Success) { Logic.isPost = true; return(""); } else { SendMessage(update.sender.id, "If you want to get data from database, print Get + Users|Branches|Tasks; " + "\\n" + "if you want to Post new data into database, print Post + Users|Branches|Tasks; " + "\\n" + "if you need help, print Help; "); } return(""); } else { return(""); } //else SendMessage(update.sender.id, "Wrong command, please, print HELP to get info about posible actions. "); } #endregion Message else { } return(""); }