public static void assignTask(decimal id, decimal userId) { using (var conn = new db_entities()) { try { var task = conn.tasks.Where(x => x.id == id).FirstOrDefault(); if (task != null) { task.task_status = "0"; task.assing_id = userId; } conn.SaveChanges(); conn.SP_LOG_TASK(id, userId, DateTime.Now, "0"); var alert = conn.alerts.Where(x => x.task_id == id && x.state == 0).FirstOrDefault(); if (alert != null) { conn.SP_ALERT_UPDATE(alert.id, alert.message, id, DateTime.Now, 1); } } catch (Exception e) { throw e; } } }
/** * Método para actualizar el registro */ public static void update(decimal id, String name, int state, List <modules> modules) { using (var conn = new db_entities()) { try { var entity = conn.roles.Where(x => x.id == id).FirstOrDefault(); if (entity == null) { throw new NotExistsException(); } else { conn.SP_ROL_UPDATE(id, name, DateTime.Now, state); // removemos los items foreach (roles_modules rm in conn.roles_modules.Where(x => x.rol_id == entity.id).ToList()) { conn.roles_modules.Remove(rm); } conn.SaveChanges(); // agregamos las actualizaciones foreach (modules item in modules) { conn.SP_ROL_MODULE_INSERT(entity.id, item.id); } } } catch (Exception e) { throw e; } } }
public static decimal createTask(tasks tasks) { using (var conn = new db_entities()) { try { conn.SP_TASK_INSERT(tasks.name, tasks.description, tasks.process_id, tasks.father_taks_id, tasks.task_status, tasks.date_start, tasks.date_end, DateTime.Now, tasks.creator_user_id, tasks.assing_id); var result = conn.tasks.Where(x => x.name == tasks.name && x.description == tasks.description && x.creator_user_id == tasks.creator_user_id).FirstOrDefault(); if (result != null) { log_task logTask = new log_task(); logTask.task_id = result.id; logTask.task_status_code = tasks.task_status; conn.log_task.Add(logTask); //conn.SaveChanges(); return(result.id); } else { return(-1); } } catch (Exception e) { throw e; } } }
/** * Método para actualizar el registro */ public static void update(users user) { using (var conn = new db_entities()) { try { var entity = conn.users.Where(x => x.id == user.id).FirstOrDefault(); user.updated_at = new DateTime(); if (entity == null) { throw new NotExistsException(); } else { if (user.password == null || user.password == "") { conn.SP_USER_UPDATE_WITHOUT_PASSWORD(user.id, user.name, user.email, user.rol_id, user.unit_id, DateTime.Now, user.state); } else { conn.SP_USER_UPDATE_WITH_PASSWORD(user.id, user.name, user.email, user.password, user.rol_id, user.unit_id, DateTime.Now, user.state); } } } catch (Exception e) { throw e; } } }
public static List <templates_tasks> fetchAllByTemplateId(decimal id) { using (var conn = new db_entities()) { try { return(conn.templates_tasks.Where(x => x.template_id == id).ToList()); } catch (Exception e) { throw e; } } }
public static List <tasks> getTasksByProcessId(decimal id) { using (var conn = new db_entities()) { try { return(conn.tasks.Where(x => x.process_id == id).ToList()); } catch (Exception e) { throw e; } } }
public static List <tasks> getCreationTasksByUser(decimal id) { using (var conn = new db_entities()) { try { return(conn.tasks.Where(x => x.creator_user_id == id).ToList()); } catch (Exception e) { throw e; } } }
public static List <tasks> getAssignTasksByUser(decimal id) { using (var conn = new db_entities()) { try { return(conn.tasks.Where(x => x.assing_id == id && x.task_status == "0").ToList()); } catch (Exception e) { throw e; } } }
/** * Método para crear nuevo registro */ public static void insert(String name, decimal?boss, decimal?enterprise_id) { using (var conn = new db_entities()) { try { conn.SP_UNIT_INSERT(name, DateTime.Now, 1, boss, enterprise_id); } catch (Exception e) { throw e; } } }
public static void createDocument(files file) { using (var conn = new db_entities()) { try { conn.SP_FILE_INSERT(file.task_id, file.name, file.url, file.path, DateTime.Now); } catch (Exception e) { throw e; } } }
/** * Método para crear nuevo registro */ public static void insert(String message, decimal id) { using (var conn = new db_entities()) { try { conn.SP_ALERT_INSERT(message, id, DateTime.Now, 0); } catch (Exception e) { throw e; } } }
public static alerts fetchByTaskId(long id) { using (var conn = new db_entities()) { try { return(conn.alerts.Where(x => x.task_id == id && x.state == 0).FirstOrDefault()); } catch (Exception e) { throw e; } } }
/** * Método para devolver lista de los registros */ public static config_traffic_lights fetch() { using (var conn = new db_entities()) { try { return(conn.config_traffic_lights.FirstOrDefault()); } catch (Exception e) { throw e; } } }
/** * Método para actualizar el registro */ public static void update(long id, int green, int yellow, int red) { using (var conn = new db_entities()) { try { conn.SP_CONFIG_TRAFFIC_LIGHTS_UPDATE(id, green, yellow, red, DateTime.Now); } catch (Exception e) { throw e; } } }
/** * Método para crear nuevo registro */ public static void insert(String name) { using (var conn = new db_entities()) { try { conn.SP_ENTERPRISE_INSERT(name, DateTime.Now, 1); } catch (Exception e) { throw e; } } }
public static List <files> fetchAllByTaskId(long id) { using (var conn = new db_entities()) { try { return(conn.files.Where(x => x.task_id == id).ToList()); } catch (Exception e) { throw e; } } }
/** * Método para actualizar el registro */ public static void update(decimal id, String name, int state) { using (var conn = new db_entities()) { try { conn.SP_ENTERPRISE_UPDATE(id, name, DateTime.Now, state); } catch (Exception e) { throw e; } } }
public static tasks fetchById(decimal id) { using (var conn = new db_entities()) { try { return(conn.tasks.Where(x => x.id == id).FirstOrDefault()); } catch (Exception e) { throw e; } } }
/** * Método para devolver lista de los registros */ public static List <modules> fetchAll() { using (var conn = new db_entities()) { try { return(conn.modules.ToList()); } catch (Exception e) { throw e; } } }
public static process getById(decimal id) { using (var conn = new db_entities()) { try { return(conn.process.Where(r => r.id == id).FirstOrDefault()); } catch (Exception e) { throw e; } } }
/** * Método para devolver lista de los registros */ public static List <templates_tasks> fetchAll() { using (var conn = new db_entities()) { try { return(conn.templates_tasks.ToList()); } catch (Exception e) { throw e; } } }
/** * Método para validar si existe el registro * @return true si existe */ public static bool exists(String name) { using (var conn = new db_entities()) { try { var result = conn.modules.Where(x => x.name.Equals(name)).FirstOrDefault(); return(result != null); } catch (Exception e) { throw e; } } }
/** * Método para crear nuevo registro */ public static void insert(users user) { using (var conn = new db_entities()) { try { conn.SP_USER_INSERT(user.name, user.email, user.password, user.rol_id, user.unit_id, DateTime.Now, 1); } catch (Exception e) { throw e; } } }
/** * Método para validar si existe el registro * @return true si existe */ public static bool exists(String email) { using (var conn = new db_entities()) { try { var result = conn.users.Where(x => x.email.Equals(email)).FirstOrDefault(); return(result != null); } catch (Exception e) { throw e; } } }
/** * Método para devolver lista de los registros */ public static List <process> fetchAllByUnit(decimal unit_id) { using (var conn = new db_entities()) { try { var users = conn.users.Where(x => x.unit_id == unit_id).Select(x => x.id).ToList(); return(conn.process.Where(r => users.Contains(r.user_id)).ToList()); } catch (Exception e) { throw e; } } }
/** * Método para actualizar el registro */ public static bool checkToken(String token) { using (var conn = new db_entities()) { try { var entity = conn.users.Where(x => x.token_session == token && x.state == 1 ).FirstOrDefault(); return(entity != null); } catch (Exception e) { throw e; } } }
/** * Método para actualizar el registro */ public static void update(decimal id, String name, int state) { using (var conn = new db_entities()) { try { var entity = conn.modules.Where(x => x.id == id).FirstOrDefault(); entity.name = name; entity.state = state; entity.updated_at = DateTime.Now; conn.SaveChanges(); } catch (Exception e) { throw e; } } }
/** * Método para crear nuevo registro */ public static void insert(String name) { using (var conn = new db_entities()) { try { modules entity = new modules(); entity.name = name; entity.created_at = DateTime.Now; entity.state = 1; conn.modules.Add(entity); conn.SaveChanges(); } catch (Exception e) { throw e; } } }
public static decimal insert(string name, string description, DateTime start, decimal userId) { using (var conn = new db_entities()) { try { conn.SP_PROCESS_INSERT(name, description, DateTime.Now, start, userId);; var process = conn.process.Where(x => x.name.Equals(name) && x.description.Equals(description) && x.user_id == userId).FirstOrDefault(); return(process.id); } catch (Exception e) { throw e; } } }
/** * Método para crear nuevo registro */ public static void insert(String name, String description, List <templates_tasks> tasks, long userId) { using (var conn = new db_entities()) { try { conn.SP_TEMPLATE_INSERT(name, description, DateTime.Now, 1, userId); var entity = conn.templates.Where(x => x.name == name).FirstOrDefault(); foreach (templates_tasks tt in tasks) { conn.SP_TEMPLATE_TASK_INSERT(tt.name, tt.description, entity.id, tt.task_status_code, DateTime.Now, tt.end_date, userId); } } catch (Exception e) { throw e; } } }