public ActionResult ResumeUpload() { AlumniDBModel db = new AlumniDBModel(); var image = Request.Files["resume"]; if (image == null) { ViewBag.UploadMessage = "Failed to upload image"; } else { Stream resumeStream = image.InputStream; ContactProfile profileId = (from contact in db.ContactProfiles where contact.PrimaryEmail == User.Identity.Name select contact).FirstOrDefault(); UserResume refreshModel = db.UserResumes.FirstOrDefault(r => r.ProfileID == profileId.ProfileId); byte[] resumeBytes; using (BinaryReader binaryData = new BinaryReader(resumeStream)) { resumeBytes = binaryData.ReadBytes((int)resumeStream.Length);//must convert long to int } refreshModel.ResumeImg = resumeBytes; db.Entry(refreshModel).State = EntityState.Modified; db.SaveChanges(); } return RedirectToAction("Edit", "Admin"); }
public async Task<ActionResult> Register(RegisterViewModel model) { if (ModelState.IsValid) { var user = new ApplicationUser { UserName = model.Email, Email = model.Email, FirstName = model.FirstName, LastName = model.LastName}; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { //await SignInManager.SignInAsync(user, isPersistent:false, rememberBrowser:false); // For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771 // Send an email with this link // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>"); await this.UserManager.AddToRoleAsync(user.Id, model.Name); AlumniDBModel db = new AlumniDBModel(); ContactProfile newContact = new ContactProfile(); newContact.FirstName = user.FirstName; newContact.LastName = user.LastName; newContact.PrimaryEmail = user.Email; db.ContactProfiles.Add(newContact); db.Entry(newContact).State = EntityState.Added; db.SaveChanges(); ContactProfile profileId = (from contact in db.ContactProfiles where contact.PrimaryEmail == user.Email select contact).FirstOrDefault(); //string connectionStringResume = ConfigurationManager.ConnectionStrings[2].ConnectionString; //using (SqlConnection connection = new SqlConnection(connectionStringResume)) //{ // connection.Open(); // UserResume newResume = new UserResume(); // newResume.ProfileID = profileId.ProfileId; // newResume.HtmlUpload = " "; // db.UserResumes.Add(newResume); // SqlCommand cmd = new SqlCommand("INSERT INTO UserResume(ProfileID,HtmlUpload) Values (@fName,@html)"); // cmd.CommandType = CommandType.Text; // cmd.Connection = connection; // cmd.Parameters.AddWithValue("@fName", profileId.ProfileId); // cmd.Parameters.AddWithValue("@html", ' '); // cmd.ExecuteNonQuery(); //} UserResume newResume = new UserResume(); newResume.ProfileID = profileId.ProfileId; newResume.HtmlUpload = " "; db.UserResumes.Add(newResume); db.SaveChanges(); //UserResume newResume = new UserResume(); //newResume.ContactProfile = profileId; //newResume.ProfileID = profileId.ProfileId; //newResume.HtmlUpload = " "; //db.UserResumes.Add(newResume); //db.SaveChanges(); ModelState.Clear(); ViewBag.Name = new SelectList(context.Roles.ToList(), "Name", "Name"); return View(); } AddErrors(result); } ViewBag.Name = new SelectList(context.Roles.ToList(), "Name", "Name"); // If we got this far, something failed, redisplay form return View(); }