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"));
}
