public IvhunimAndActions GetAll(bool isUserAdmin, bool isUserNextStepAdmin, bool isUserTypist, string email) { using (IvhunimEntities entities = new IvhunimEntities()) { var ivhunim = new List <Ivhunim>(); var columns = new List <RolesMainTableColumns>(); IEnumerable <RolesActions> roles = null; roles = entities.RolesActionss; if (isUserAdmin) { roles = roles.Where(role => role.RoleId == 1); ivhunim = entities.Ivhunims.ToList(); foreach (var column in entities.RolesMainTableColumns.Where(role => role.RoleId == 1).OrderByDescending(o => o.OrderNumber)) { columns.Add(column); } } else if (isUserNextStepAdmin) { roles = roles.Where(role => role.RoleId == 3); foreach (var ivhun in entities.Ivhunims.Where(ivhun => ivhun.Institue == InstituesNames.NEXT_STEP)) { ivhunim.Add(ivhun); } foreach (var column in entities.RolesMainTableColumns.Where(role => role.RoleId == 3).OrderByDescending(o => o.OrderNumber)) { columns.Add(column); } } else if (isUserTypist) { roles = roles.Where(role => role.RoleId == 4); ivhunim = entities.Ivhunims.ToList(); foreach (var column in entities.RolesMainTableColumns.Where(role => role.RoleId == 4).OrderByDescending(o => o.OrderNumber)) { columns.Add(column); } } else { roles = roles.Where(role => role.RoleId == -1); foreach (var ivhun in entities.Ivhunims.Where(ivhun => ivhun.ParentEmail == email && ivhun.ReadyToBeSent == true)) { ivhunim.Add(ivhun); } foreach (var column in entities.RolesMainTableColumns.Where(role => role.RoleId == -1).OrderByDescending(o => o.OrderNumber)) { columns.Add(column); } } var result = new IvhunimAndActions { Ivhunim = ivhunim, Actions = roles.ToList(), Columns = columns.Select(o => o.ColumnName).ToList() }; return(result); } }
public async Task Delete(int id) { using (IvhunimEntities entities = new IvhunimEntities()) { var ivhunToDelete = entities.Ivhunims.Where(user => user.Id == id).SingleOrDefault(); if (ivhunToDelete != null) { entities.Ivhunims.Remove(ivhunToDelete); await entities.SaveChangesAsync(); } } }
public bool IsUserExis(int id) { using (IvhunimEntities entities = new IvhunimEntities()) { var ivhun = entities.Ivhunims.Where(o => o.Id == id).SingleOrDefault(); if (ivhun != null && entities.AspNetUsers.Any(o => o.UserName == ivhun.ParentEmail)) { return(true); } return(false); } }
public async Task Post(Ivhunim ivhun) { try { using (IvhunimEntities entities = new IvhunimEntities()) { entities.Ivhunims.Add(ivhun); await entities.SaveChangesAsync(); } } catch (Exception ex) { throw ex; } }
public async Task Upsert(Ivhunim ivhun) { try { using (IvhunimEntities entities = new IvhunimEntities()) { entities.Entry(ivhun).State = System.Data.Entity.EntityState.Modified; await entities.SaveChangesAsync(); } } catch (Exception ex) { throw ex; } }
public async Task Duplicate(int id) { try { using (IvhunimEntities entities = new IvhunimEntities()) { var ivhunToCopy = entities.Ivhunims.AsNoTracking().Where(user => user.Id == id).SingleOrDefault(); if (ivhunToCopy != null) { ivhunToCopy.FirstName = ivhunToCopy.FirstName + " - העתק"; entities.Ivhunims.Add(ivhunToCopy); await entities.SaveChangesAsync(); } } } catch (Exception ex) { throw ex; } }
public IHttpActionResult EmailClient([FromUri] int id, [FromBody] RegisterBindingModel registrationModel) { try { using (IvhunimEntities entities = new IvhunimEntities()) { var ivhun = entities.Ivhunims.Where(o => o.Id == id).FirstOrDefault(); if (ivhun == null) { return(NotFound()); } if (ivhun.ReadyToBeSent == false) { return(BadRequest("Cannot send ivhun not ready")); } string body = ""; if (string.IsNullOrWhiteSpace(registrationModel.Password)) { body = $@"שלום, האבחון של ילד/תך מוכן. בכדי להוריד את האבחון, כנס/י ל: ayaneeman.azurewebsites.net 'התחבר/י עם שם המשתמש והסיסמא שלך ולחצ/י על - 'האבחונים שלי. לשאלות נוספות, ניתן להשיב לאימייל הזה או להתקשר אלי לטלפון: 0522204509 תודה, איה."; } else { body = $@"שלום, האבחון של ילד/תך מוכן. בכדי להוריד את האבחון, כנס/י ל: ayaneeman.azurewebsites.net שם המשתמש: {ivhun.ParentEmail} סיסמא: {registrationModel.Password} לשאלות נוספות, ניתן להשיב לאימייל הזה או להתקשר אלי לטלפון: 0522204509 תודה, איה."; } if (string.IsNullOrWhiteSpace(ivhun.ParentEmail)) { return(NotFound()); } else { var fromAddress = new MailAddress("*****@*****.**", "איה נאמן"); var toAddress = new MailAddress(ivhun.ParentEmail, ivhun.FirstName + " " + ivhun.LastName); const string fromPassword = "******"; const string subject = "איה נאמן - אבחון"; var smtp = new SmtpClient { Host = "smtp.gmail.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new NetworkCredential(fromAddress.Address, fromPassword) }; using (var message = new MailMessage(fromAddress, toAddress) { Subject = subject, Body = body, IsBodyHtml = false }) { smtp.Send(message); } } } return(Ok()); } catch (Exception ex) { return(InternalServerError(ex)); } }