public ActionResult Create(AreaModel area_m) { try { // TODO: Add insert logic here if (ModelState.IsValid) { cat_areas area = new cat_areas(); area.id_centro = area_m.id_centro; area.nombre = area_m.nombre; db.cat_areas.Add(area); db.SaveChanges(); FlashData.SetFlashData("success", "Registro agregado satisfactoriamente"); return(RedirectToAction("Index")); } return(ViewBag(area_m)); } catch { return(RedirectToAction("Index")); } }
public ActionResult Save(PermissionModel permissions_m) { List <string> items = new List <string>(); foreach (var module in permissions_m.list_module_m) { if (module.slug != null) { var permission = db.permissions.Where(w => w.group_id == permissions_m.group_id) .Where(w => w.module == module.slug).SingleOrDefault(); if (permission == null) { db.permissions.Add(new permissions { group_id = permissions_m.group_id, module = module.slug, roles = module.roles != null ? System.Web.Helpers.Json.Encode(module.roles) : null }); db.SaveChanges(); } else { //db.permissions.e(new permission { group_id = permissions_m.group_id, module = module.slug, roles = System.Web.Helpers.Json.Encode(module.roles) }); permissions permission_update = (permissions)permission; permission_update.roles = module.roles != null?System.Web.Helpers.Json.Encode(module.roles) : null; db.Entry(permission_update).State = EntityState.Modified; db.SaveChanges(); } items.Add(module.slug); } } List <permissions> list_delete = new List <permissions>(); if (items.Count > 0) { list_delete = db.permissions.Where(w => w.group_id == permissions_m.group_id) .Where(w => !items.Contains(w.module)) .ToList(); } else { list_delete = db.permissions.Where(w => w.group_id == permissions_m.group_id) .ToList(); } if (list_delete != null) { foreach (var enty in list_delete.ToList()) { db.permissions.Remove(enty); db.SaveChanges(); } } //return Content(""); return(RedirectToAction("Save", "Permissions", new { id = permissions_m.group_id })); }
public ActionResult Create(centros centros) { if (ModelState.IsValid) { db.centros.Add(centros); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(centros)); }
public ActionResult Create(groups groups) { if (ModelState.IsValid) { db.groups.Add(groups); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(groups)); }
public ActionResult Create(modules modules) { if (ModelState.IsValid) { db.modules.Add(modules); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(modules)); }
//Eliminacion del archivo fisico y en la BD public static File delete_file(string id) { rekursosEntities db = new rekursosEntities(); File result = new File(); result.status = true; try { var file_result = db.files.Where(w => w.id == id).SingleOrDefault(); if (file_result != null) { _unlink_file(file_result); db.files.Remove(file_result); db.SaveChanges(); result.message = file_result.name + " ha sido eliminado"; result.status = true; } } catch (Exception ex) { result.status = false; result.message = ex.Message.ToString(); } return(result); }
public ActionResult Edit(SettingModel setting_m) { foreach (var secctions in setting_m.Settings) { foreach (var setting_new in secctions.Value) { settings setting = db.settings.Where(w => w.slug == setting_new.slug).SingleOrDefault(); if (setting != null) { if (setting_new.values != null) { setting.value = String.Join(",", setting_new.values);// setting_new.values.Join(","); } else { setting.value = setting_new.value; } db.Entry(setting).State = EntityState.Modified; db.SaveChanges(); } } } /* if (ModelState.IsValid) * { * db.Entry(setting).State = EntityState.Modified; * db.SaveChanges(); * return RedirectToAction("Index"); * }*/ //return View(setting); FlashData.SetFlashData("success", "Tu configuración ha sido guardada."); return(RedirectToAction("Index")); }
public static File SaveCamera(string image, int folder_id) { File result = new File(); result.status = false; if (image != null) { rekursosEntities db = new rekursosEntities(); files insert = new files(); image = image.Replace("data:image/png;base64,", ""); byte[] data = Convert.FromBase64String(image); MD5 md5 = MD5.Create(); insert.filename = GetMd5Hash(md5, GetUniqID()) + ".png"; insert.name = "camera_" + insert.filename; var destinationImgPath = Path.Combine(HttpContext.Current.Server.MapPath("~/Uploads"), insert.filename); System.IO.File.WriteAllBytes(destinationImgPath, data); if (System.IO.File.Exists(destinationImgPath)) { DateTime now = DateTime.Now; var info = new System.IO.FileInfo(destinationImgPath); // var dto = new DateTimeOffset(DateTime.Now); insert.filesize = (int)info.Length; insert.mimetype = "image/png"; insert.folder_id = folder_id; insert.extension = ".png"; insert.type = "i"; insert.date_added = (int)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalSeconds; System.Drawing.Image myImage = System.Drawing.Image.FromFile(destinationImgPath); insert.width = myImage.Width; insert.height = myImage.Height; string id = GetMd5Hash(md5, insert.filename); insert.id = id.Substring(0, 15); db.files.Add(insert); db.SaveChanges(); result.status = true; result.message = "El archivo se ha subido correctamente"; result.data = insert; } } return(result); }
public static void SetLastLogin(int id) { rekursosEntities db = new rekursosEntities(); users user = db.users.Find(id); user.last_login = DateTime.Now; db.Entry(user).State = EntityState.Modified; db.SaveChanges(); }
// PUT api/Default1/5 public HttpResponseMessage Putcat_localidades(int id, cat_localidades cat_localidades) { if (ModelState.IsValid && id == cat_localidades.id) { db.Entry(cat_localidades).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public ActionResult Create(users user) { try { // TODO: Add insert logic here if (ModelState.IsValid) { user.created_on = (int)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalSeconds; user.password = Sha1.SHA1HashStringForUTF8String(user.password); db.users.Add(user); db.SaveChanges(); return(RedirectToAction("Index")); } return(View()); } catch (Exception ex) { FlashData.SetFlashData("error", ex.Message); return(RedirectToAction("Index")); } }
public ActionResult Edit(int id, alumnos alumno, HttpPostedFileBase fotografia) { try { if (fotografia != null) { var result = Libraries.File.upload(fotografia, 1); if (result.status) { alumno.fotografia = result.data.id; } } db.Entry(alumno).State = EntityState.Modified; db.SaveChanges(); // TODO: Add update logic here return(RedirectToAction("Index")); } catch { return(View()); } }
public static void Add(string to, string from, string subject, string body, int priority = 1) { rekursosEntities db = new rekursosEntities(); notifications notification = new notifications(); notification.from = from; notification.to = to; notification.subject = subject; notification.body = body; notification.created_on = DateTime.Now; notification.priority = priority; db.notifications.Add(notification); db.SaveChanges(); }
public ActionResult Create(EmpleadoModel empleado_m) { if (ModelState.IsValid) { empleados empleado = new empleados(); // empleado.id = empleado_m.no_empleado; empleado.id_empleado = empleado_m.id_empleado; empleado.nombre = empleado_m.nombre; empleado.apellido_paterno = empleado_m.apellido_paterno; empleado.apellido_materno = empleado_m.apellido_materno; empleado.fecha_nacimiento = empleado_m.fecha_nacimiento; empleado.id_area = null;//empleado_m.id_area; empleado.id_centro = empleado_m.id_centro; empleado.cargo = empleado_m.cargo; empleado.rfc = empleado_m.rfc; empleado.curp = empleado_m.curp; empleado.direccion = empleado_m.direccion; empleado.telefono = empleado_m.telefono; empleado.email = empleado_m.email; empleado.activo = 1; db.empleados.Add(empleado); db.SaveChanges(); return(RedirectToAction("Index")); } //ViewBag.id_area = new SelectList(db.cat_areas, "id", "nombre", empleados.id_area); ViewBag.id_area = new SelectList(db.cat_areas, "id", "nombre"); ViewBag.id_centro = new SelectList(db.centros, "id", "nombre"); ViewBag.tipo_mando = new SelectList(new List <SelectListItem> { //new SelectListItem { Text="[Seleccione]",Value="" }, new SelectListItem { Text = "Operativo", Value = "operativo" }, new SelectListItem { Text = "Medio", Value = "medio" }, new SelectListItem { Text = "Superior", Value = "superior" }, }, "Value", "Text"); return(View(empleado_m)); }
public static File upload(HttpPostedFileBase file, int folder_id) { rekursosEntities db = new rekursosEntities(); files insert = new files(); File result = new File(); result.status = false; try { var file_name = Path.GetFileName(file.FileName); var extension = Path.GetExtension(file.FileName); //Extraemos mime,type y extension _check_ext(file); MD5 md5 = MD5.Create(); DateTime now = DateTime.Now; // var dto = new DateTimeOffset(DateTime.Now); insert.filename = GetMd5Hash(md5, GetUniqID()) + extension; insert.name = file_name; insert.filesize = file.ContentLength; insert.mimetype = file.ContentType; insert.folder_id = folder_id; insert.extension = _ext; insert.type = _type; insert.date_added = (int)(DateTime.UtcNow - new DateTime(1970, 1, 1)).TotalSeconds; insert.user_id = null; insert.width = null; insert.height = null; if (System.Web.HttpContext.Current.User != null) { /*var user = Cobacam.Security.Ion_Auth.GetUser(System.Web.HttpContext.Current.User.Identity.Name); * * if (user != null) * { * file_m.user_id = user.id; * }*/ } string id = GetMd5Hash(md5, insert.filename); insert.id = id.Substring(0, 15); if (IsImage(file.ContentType)) { System.Drawing.Image myImage = System.Drawing.Image.FromStream(file.InputStream); insert.width = myImage.Width; insert.height = myImage.Height; } db.files.Add(insert); db.SaveChanges(); var path = Path.Combine(HttpContext.Current.Server.MapPath("~/Uploads"), insert.filename); file.SaveAs(path); result.status = true; result.message = "El archivo se ha subido correctamente"; result.data = insert; } catch (Exception ex) { result.status = false; result.message = ex.Message.ToString(); } return(result); }
public ActionResult Save(UserModel user_m, string tab = "profile") { users update = new users(); users user = Ion_Auth.GetUser(User.Identity.Name, false); update.id = user.id; update.group_id = user.group_id; update.password = user.password; update.active = user.active; update.created_on = user.created_on; update.last_login = user.last_login; update.username = user.username; update.display_name = user.display_name; update.email = user.email; switch (tab) { case "profile": update.email = user_m.email; update.display_name = user_m.display_name; //update.password = user.password; break; case "password": if (user_m.old_password != "" && Sha1.SHA1HashStringForUTF8String(user_m.old_password) != user.password) { ModelState.AddModelError("Error", "La antigua contraseña es inválida."); } if (user_m.new_password != user_m.retype_password) { ModelState.AddModelError("Error1", "La nueva contraseña no coinciden."); } else { update.password = Sha1.SHA1HashStringForUTF8String(user_m.new_password); } break; } if (ModelState.IsValid) { //user.groups = null; db.Entry(update).State = EntityState.Modified; db.SaveChanges(); FlashData.SetFlashData("success", "Tu cuenta ha sido modificada satisfactoriamente"); } else { string errors = ""; foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { errors += error.ErrorMessage + "\n"; } } if (errors != "") { FlashData.SetFlashData("error", errors); } } return(RedirectToAction("Details")); }