public string AddOrganizations(string token, Organization objOrganization) { try { if (ModelState.IsValid) { using (StudentContext db = new StudentContext()) { objOrganization.CreatedDate = DateTime.Now; objOrganization.CreatedBy = _userStatistics.UserId; RegistrationToken objToken = new RegistrationToken(); objToken.Token = UserStatistics.GenerateToken(); objToken.RoleId = (int)UserRoles.OrganizationAdmin; objToken.CreatedBy = _userStatistics.UserId; if (objRep.CreateOrganization(objOrganization, objToken)) { //objRep.CreateRegistrationToken(objToken); SaveFiles(token, this.GetType().Name, objOrganization.OrganizationId); EmailHandler.Utilities.SendRegistationEmail(objToken.Token, objOrganization.Email); return Convert.ToString(true); } return Convert.ToString(false); } } return Convert.ToString(false); } catch (Exception ex) { return ex.Message.ToString(); } }
public ActionResult RegisterUserStep2(string id = "") { ViewBag.Error = false; RegistrationToken objToken = new RegistrationToken(); objToken.Token = id; return View(objToken); }
public ActionResult CreateToken() { RegistrationToken objToken = new RegistrationToken(); LoadSelectLists(ref objToken); objToken.OrganizationId = ViewBag.OrganizationId == null ? 0 : (int)ViewBag.OrganizationId; return View(objToken); }
public ActionResult RegisterUserStep2(RegistrationToken objToken) { ViewBag.Error = false; RegistrationToken token = repository.GetRegistrationCode(objToken.Token); if (token != null && token.InsertedOn.AddDays(7) > DateTime.Now) { return RedirectToAction("RegisterUserStep3", new { token.Token }); } ViewBag.Error = true; return View(); }
public ActionResult Create(RegistrationToken token) { try { if (ModelState.IsValid) { token.Token = UserStatistics.GenerateToken(); token.CreatedBy = _userStatistics.UserId; if (repository.CreateToken(token) > 0) { ViewBag.Token = token.Token; return View("ViewToken", token); } return View(token); } return null; } catch (Exception ex) { return null; } }
public int CreateToken(RegistrationToken objToken) { var parameters = new { Token = objToken.Token, OrganizationId = objToken.OrganizationId, DepartmentId = objToken.DepartmentId, CourseId = objToken.CourseId, ClassId = objToken.ClassId, SectionId = objToken.SectionId, RoleId = objToken.RoleId, CreatedBy = objToken.CreatedBy, }; using (IDbConnection connection = OpenConnection()) { const string storedProcedure = "usp_AddRegistrationToken"; int rowsAffected = connection.Execute(storedProcedure, parameters, commandType: CommandType.StoredProcedure); //SetIdentity<int>(connection, id => objToken.TokenId = id); return rowsAffected; } }
public bool CreateOrganization(Organization objOrganization, RegistrationToken objToken) { var parameters = new { Address1 = objOrganization.Address1, Address2 = objOrganization.Address2, City = objOrganization.City, CountryId = objOrganization.CountryId, CreatedBy = objOrganization.CreatedBy, CreatedDate = DateTime.Now, Email = objOrganization.Email, OrganizationDesc = objOrganization.OrganizationDesc, OrganizationName = objOrganization.OrganizationName, OrganizationTypeId = objOrganization.OrganizationTypeId, Phone1 = objOrganization.Phone1, Phone2 = objOrganization.Phone2, RegisterationNumber = objOrganization.RegisterationNumber, StateId = objOrganization.StateId }; using (IDbConnection connection = OpenConnection()) { const string storedProcedure = "usp_addOrganization"; int rowsAffected = 0; rowsAffected = connection.Execute(storedProcedure, parameters, commandType: CommandType.StoredProcedure); SetIdentity<int>(connection, id => objOrganization.OrganizationId = id); objToken.OrganizationId = objOrganization.OrganizationId; objToken.Email = objOrganization.Email; if (rowsAffected > 0) { rowsAffected = 0; rowsAffected = CreateRegistrationToken(objToken, connection); } if (rowsAffected > 0) { return true; } return false; } }
public ActionResult ViewToken(RegistrationToken token) { ViewBag.Token = token.Token; return View(); }
public void LoadSelectLists(ref RegistrationToken objToken) { SelectList OrganizationList = null; List<Organization> organizationList = new List<Organization>(); List<Department> depList = new List<Department>(); List<Course> crsList = new List<Course>(); List<Class> clsList = new List<Class>(); List<Section> secList = new List<Section>(); List<SelectListItem> roleTypes = Enum.GetValues(typeof(StudentTracker.Core.Utilities.UserRoles)).Cast<StudentTracker.Core.Utilities.UserRoles>().Select(v => new SelectListItem { Text = v.ToString(), Value = ((int)v).ToString() }).ToList(); if (User.IsInRole("SiteAdmin")) { OrganizationList = new SelectList(repository.Organizations(), "OrganizationId", "OrganizationName", ""); objToken.RoleList = new SelectList(roleTypes, "Value", "Text"); } else { var organization = repository.Organizations(_userStatistics.OrganizationId); ViewBag.OrganizationId = organization.OrganizationId; ViewBag.Organization = organization.OrganizationName; objToken.RoleList = new SelectList(roleTypes.Skip(2), "Value", "Text"); crsList = repository.CourseByOrganization(_userStatistics.OrganizationId); } objToken.OrganizationList = OrganizationList; objToken.CourseList = new SelectList(crsList, "CourseId", "CourseName"); objToken.ClassList = new SelectList(clsList, "ClassId", "ClassName"); objToken.SectionList = new SelectList(secList, "SectionId", "SectionName"); objToken.DepartmentList = new SelectList(depList, "DepartmentId", "DepartmentName"); }
public bool SendRegistrationEmailToStudents(string importId) { try { List<Student> objModelList = repository.GetImportedSudents(importId); StudentContext context = new StudentContext(); Dictionary<string, string> parameters = new Dictionary<string, string>(); // RegistrationToken tokenObj = new RegistrationToken(); foreach (var student in objModelList) { string token = UserStatistics.GenerateToken(); RegistrationToken tokenObj = new RegistrationToken(); tokenObj.ClassId = student.ClassId; tokenObj.CourseId = student.CourseId; tokenObj.DepartmentId = student.DepartmentId; tokenObj.OrganizationId = student.OrganizationId; tokenObj.RoleId = Convert.ToInt32(UserRoles.Student); tokenObj.SectionId = student.SectionId; tokenObj.Token = token; tokenObj.Email = student.Email; tokenObj.ImportId = importId; tokenObj.InsertedOn = DateTime.Now; tokenObj.StudentId = student.StudentId; context.RegistrationTokens.Add(tokenObj); parameters.Add(token, student.Email); } context.SaveChanges(); Task.Factory.StartNew(() => SendEmails(parameters)); //SendEmails(parameters); return true; } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } }