public ActionResult Approve(int id) { int ID = id; tblSkill idea = entity.tblSkills.FirstOrDefault(g => g.skId == id); idea.skStatus = "Approved"; entity.Entry(idea).State = System.Data.Entity.EntityState.Modified; entity.SaveChanges(); return(RedirectToAction("ConfirmEmail", new { id = ID })); }
public ActionResult Create([Bind(Include = "idColaborador,Nome,Email,CPF,Senha,Oficio,DataNascimento,Sexo,Telefone,Disponibilidade")] Colaborador colaborador) { if (ModelState.IsValid) { db.Colaborador.Add(colaborador); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(colaborador)); }
public ActionResult Create([Bind(Include = "UserId,UserName,Password,IsActive")] UserProfile userProfile) { if (ModelState.IsValid) { db.UserProfiles.Add(userProfile); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(userProfile)); }
public ActionResult Create([Bind(Include = "UserID,Username,Password")] User user) { if (ModelState.IsValid) { db.Users.Add(user); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public ActionResult Edit([Bind(Include = "skId,skName,skExperience,skPrevProjects,skCurrentProject,skDomain,skUsername")] tblSkill tblSkill) { if (ModelState.IsValid) { db.Entry(tblSkill).State = EntityState.Modified; db.SaveChanges(); string un = loggedinUser; return(RedirectToAction("Dashboard_Employee", new { uname = loggedinUser })); } return(View(tblSkill)); }
public ActionResult Create([Bind(Include = "usuarioId,Nombre,CorreoElectronico,nombreus,pass")] Usuario usuario) { if (ModelState.IsValid) { db.Usuario.Add(usuario); db.SaveChanges(); return(RedirectToAction("/Index", "Login")); } return(View(usuario)); }
public ActionResult Create([Bind(Include = "ID,Usr,Password,Email,Phone")] User user) { if (ModelState.IsValid) { Guid guid = Guid.NewGuid(); user.ID = guid.ToString("D"); db.Users.Add(user); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(user)); }
public void SendEmail(string email) { //string message = "This email address does not match our records."; tblLogin user; user = entities.tblLogins.Where(x => x.eEmail == email).FirstOrDefault(); if (user != null) { string username = user.eEmail; string password = user.ePassword; // To send OTP to email string strNewPassword = GeneratePassword().ToString(); user.OTP = strNewPassword; entities.SaveChanges(); if (!string.IsNullOrEmpty(password)) { MimeMessage mm = new MimeMessage(); MailboxAddress from = new MailboxAddress("ADMIN", "*****@*****.**"); mm.From.Add(from); MailboxAddress to = new MailboxAddress(username, email); mm.To.Add(to); mm.Subject = "OTP For ResetPassword"; var body = "Hi, <br/>You recently requested to reset your password for your account.<br/><div style='background-color: white; display: block; font-family: sans-serif; text-align: center'> " + "<div style='background-color:#F7F6A2; width: 80%; color: white; text-align: center; font-size: 2rem; padding: 2rem;'> Your OTP for Resetting Password:<h2 style='color:black'>{0}</h2></div><div></div>" + "<br/>If you did not request a password reset, please ignore this email or reply to let us know.<br/><br/> Thank you" + "</div>"; BodyBuilder bodyBuilder = new BodyBuilder(); bodyBuilder.HtmlBody = string.Format(body, user.OTP); bodyBuilder.TextBody = string.Format(body, user.OTP); mm.Body = bodyBuilder.ToMessageBody(); using (var client = new SmtpClient()) { client.Connect("smtp.gmail.com", 465, true); client.Authenticate("*****@*****.**", "dxcproject"); client.Send(mm); client.Disconnect(true); client.Dispose(); ViewBag.Message = string.Format("OTP Generated Successfully."); } } } }
public static string deletarPessoa(pessoa p) { using (LoginEntities entities = new LoginEntities()) { try { pessoa deletePessoa = new pessoa(); deletePessoa = entities.pessoas.FirstOrDefault(del => del.cpf == p.cpf); if (deletePessoa == null || deletePessoa.cpf.Equals(null) || deletePessoa.cpf.Equals("")) { return("Operação não realizada.\nNão foi encontrado ninguém com este CPF na base de dados!"); } else { entities.pessoas.Remove(deletePessoa); entities.SaveChanges(); return("Operação realizada com sucesso!\nSua conta foi apagada da base de dados."); } } catch (Exception e) { return("Erro: " + e.Message); } } }
public ActionResult Cadastrar(Colaborador novoUsuario) { var senhaCriptografada = FormsAuthentication.HashPasswordForStoringInConfigFile(novoUsuario.Senha, "MD5"); novoUsuario.Disponibilidade = true; novoUsuario.Senha = senhaCriptografada; contextEntities.Colaborador.Add(novoUsuario); contextEntities.SaveChanges(); ViewBag.StatusCadastro = "Colaborador cadastrado com sucesso!"; return(View("Cadastro")); }
public ActionResult Register(tblLogin data) { if (ModelState.IsValid) { tblLogin obj = entity.tblLogins.Where(x => x.eEmail == data.eEmail).FirstOrDefault(); if (obj == null) { entity.tblLogins.Add(data); entity.SaveChanges(); return(RedirectToAction("Login")); } else { ModelState.AddModelError("", "Email ID already registered."); return(View("Register")); } } return(View(data)); }
public ActionResult Transfer([Bind(Include = "AccountNumber,TransferFrom,TransferTo,TransferAmount,TransferDate,CurrentBalance,Funds,CustomerName")] TransactionDetail transactionDetail) { if (Session["UserName"] != null && Session["UserRole"].ToString().Contains("Customer")) { if (ModelState.IsValid) { transactionDetail.TransferDate = DateTime.Now; transactionDetail.AccountNumber = Convert.ToInt32(Session["AccountNumber"]); transactionDetail.TransferFrom = Convert.ToInt32(Session["AccountNumber"]); transactionDetail.CustomerName = Convert.ToString(Session["CustomerName"]); db2.TransactionDetails.Add(transactionDetail); db2.SaveChanges(); //Receivers Balance Increases BanksCustomer banksCustomer = new BanksCustomer(); banksCustomer = db2.BanksCustomers.Where(u => u.AccountNumber == transactionDetail.TransferTo).FirstOrDefault(); LoginDetails updateBalanceReveiver = db.LoginDetails.Where(u => u.AccountNumber1 == transactionDetail.TransferTo).FirstOrDefault(); updateBalanceReveiver.CurrentBalance += transactionDetail.TransferAmount; db.Entry(updateBalanceReveiver).Property("CurrentBalance").IsModified = true; db.SaveChanges(); //Senders Balance Decreases banksCustomer = db2.BanksCustomers.Where(u => u.AccountNumber == transactionDetail.TransferFrom).FirstOrDefault(); LoginDetails updateBalanceSender = db.LoginDetails.Where(u => u.AccountNumber1 == transactionDetail.TransferFrom).FirstOrDefault(); updateBalanceSender.CurrentBalance -= transactionDetail.TransferAmount; db.Entry(updateBalanceSender).Property("CurrentBalance").IsModified = true; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ReceiversAccountNumber = new SelectList(db2.BanksCustomers.Where(u => u.UserRole.ToString().Contains("Customer")), "AccountNumber", "AccountNumber", transactionDetail.AccountNumber); return(View(transactionDetail)); } Response.Write("<script>alert('Session logged out. Sign in again');</script>"); FormsAuthentication.SignOut(); Session.Clear(); return(RedirectToAction("SignIn", "Auth")); }
public ActionResult Register(User userModel) { try { using (LoginEntities db = new LoginEntities()) { db.Users.Add(userModel); db.SaveChanges(); } } catch (Exception) { throw; } return(RedirectToAction("Index", "Login")); }
public ActionResult AddorEdit(Login login) { using (LoginEntities loginmodel = new LoginEntities()) { if (loginmodel.Logins.Any(x => x.UserName == login.UserName)) { ViewBag.Dublicate = "User name found "; return(View("AddorEdit", login)); } loginmodel.Logins.Add(login); loginmodel.SaveChanges(); } ModelState.Clear(); ViewBag.SuccessMessage = "Registration succesfull"; return(View("AddorEdit", new Login())); }
public string Register(RegistrationDetails RegUser) { string Response = "Registered"; try { using (LoginEntities ent = new LoginEntities()) { var query = (from u in ent.UserDetails where u.UserID == RegUser.UserID select u.UserID).Count(); if (query > 0) { Response = "User name already exists"; } else { UserDetail user = new UserDetail() { FirstName = RegUser.FirstName, LastName = RegUser.LastName, UserID = RegUser.UserID, Password = RegUser.Password, PhoneNumber = RegUser.PhoneNumber, EmailID = RegUser.EmailID }; ent.UserDetails.Add(user); if (ent.SaveChanges() > 0) { Response = "Registered"; } else { Response = "Failed to Register"; } } } } catch (Exception ex) { throw ex; } return(Response); }
public ActionResult Signup(User u) { if (ModelState.IsValid == true) { db.Users.Add(u); int a = db.SaveChanges(); if (a > 0) { TempData["Signup"] = "<p class=\"alert alert-success\">User registered successfully</p>"; ModelState.Clear(); return(RedirectToAction("Index")); } else { TempData["Signup"] = "<p class=\"alert alert-danger\">User registration failed</p>"; } } return(View()); }
public ActionResult AddFund(Fund fund) { if (ModelState.IsValid) { //Customers Fund Increases into BanksCustomer Table BanksCustomer banksCustomer = db.BanksCustomers.Where(u => u.AccountNumber == fund.AccountNumber).FirstOrDefault(); LoginDetails updateFund = db2.LoginDetails.Where(u => u.AccountNumber1 == fund.AccountNumber).FirstOrDefault(); updateFund.Fund = banksCustomer.Fund + fund.Fund1; db2.Entry(updateFund).Property("Fund").IsModified = true; db2.SaveChanges(); //Save Funds History into Fund Table db.Funds.Add(fund); db.SaveChanges(); return(RedirectToAction("Index")); } return(View()); }
public ActionResult Registre(Student s, HttpPostedFileBase img) { try { if (ModelState.IsValid == true) { string path = Uploadimage(img); if (path.Equals("-1")) { logger.Error("image path not find"); } else { s.User_Image = path; db.Students.Add(s); int a = db.SaveChanges(); if (a > 0) { ViewBag.InsertMeassage = "<script>alert('register succefully !!')</script>"; ModelState.Clear(); return(RedirectToAction("Index")); } else { ViewBag.InsertMeassage = "<script>alert('not register succefully !!')</script>"; } } } logger.Info("register success" + Environment.NewLine + DateTime.Now); } catch (Exception ex) { logger.ErrorException("Error occured in User controller Register Action", ex); } return(View()); }
public ActionResult TransferFunds(LoginTbl obj, string btn) { if (btn == "Transfer") { var data = project.LoginTbls.Where(x => x.AccountNo == obj.AccountNo).FirstOrDefault(); if (obj.Amount != null) { data.Amount -= obj.Amount; int mess = project.SaveChanges(); if (mess == 1) { ViewBag.data = "Transfer is Done!"; } else { ViewBag.data = "Transfer is not Successfull."; } } else { ViewBag.data = "Insufficient Balance."; } } if (btn == "View Balance") { var data = project.LoginTbls.Where(x => x.AccountNo == obj.AccountNo).FirstOrDefault(); ViewBag.show = "The Available balance in your account is : " + data.Amount; } //else //{ // ViewBag.show = "Wrong Details."; //} return(View()); }
public static string alterarPessoa(pessoa p) { using (LoginEntities entities = new LoginEntities()) { try { pessoa updatePessoa = new pessoa(); updatePessoa = entities.pessoas.FirstOrDefault(up => up.cpf == p.cpf); if (p.nome.Equals(null) || p.nome.Equals("")) { updatePessoa.nome = updatePessoa.nome; } else { updatePessoa.nome = p.nome; } if (p.sobrenome.Equals(null) || p.sobrenome.Equals("")) { updatePessoa.sobrenome = updatePessoa.sobrenome; } else { updatePessoa.sobrenome = p.sobrenome; } if (p.email.Equals(null) || p.email.Equals("")) { updatePessoa.email = updatePessoa.email; } else { updatePessoa.email = p.email; } if (p.idade.Equals(null) || p.idade.Equals("")) { updatePessoa.idade = updatePessoa.idade; } else { updatePessoa.idade = p.idade; } if (p.sexo.Equals(null) || p.sexo.Equals("")) { updatePessoa.sexo = updatePessoa.sexo; } else { updatePessoa.sexo = p.sexo; } if (p.senha.Equals(null) || p.senha.Equals("")) { updatePessoa.senha = updatePessoa.senha; } else { updatePessoa.senha = p.senha; } entities.SaveChanges(); return("Dados do Cadastro foram atualizados com sucesso!"); } catch (Exception e) { return("Erro: " + e.Message); } } }
public static string cadastrarPessoa(pessoa p) { using (LoginEntities entities = new LoginEntities()) { try { pessoa createPessoa = new pessoa(); bool cpfaux = false; bool nomeaux = false; bool sobrenomeaux = false; bool emailaux = false; bool idadeaux = false; bool sexoaux = false; bool senhaaux = false; if (p.cpf.Equals(null) || p.cpf.Equals("") || p.cpf.Length < 11) { cpfaux = false; } else { createPessoa.cpf = p.cpf; cpfaux = true; } if (p.nome.Equals(null) || p.nome.Equals("")) { nomeaux = false; } else { createPessoa.nome = p.nome; nomeaux = true; } if (p.sobrenome.Equals(null) || p.sobrenome.Equals("")) { sobrenomeaux = false; } else { createPessoa.sobrenome = p.sobrenome; sobrenomeaux = true; } if (p.email.Equals(null) || p.email.Equals("")) { emailaux = true; } else { createPessoa.email = p.email; emailaux = true; } if (p.idade.Equals(null) || p.idade.Equals("")) { idadeaux = false; } else { createPessoa.idade = p.idade; idadeaux = true; } if (p.sexo.Equals(null) || p.sexo.Equals("")) { sexoaux = false; } else { createPessoa.sexo = p.sexo; sexoaux = true; } if (p.senha.Equals(null) || p.senha.Equals("")) { senhaaux = false; } else { createPessoa.senha = p.senha; senhaaux = true; } if (cpfaux == true && nomeaux == true && sobrenomeaux == true && emailaux == true && idadeaux == true && sexoaux == true && senhaaux == true) { entities.pessoas.Add(createPessoa); entities.SaveChanges(); return("Cadastro realizado com sucesso!"); } else { return(null); } } catch (Exception e) { return("Erro: " + e.Message); } } }
public ActionResult EditTask() { if (HttpContext.Session["Username"] == null) { return(RedirectToAction("Login", "Home")); } if (Request.Form["can"] != null) { return(RedirectToAction("Index", "Home")); } string validate = ""; if (Request.Form["tid"] == null || Request.Form["tid"].Trim() == "" || Request.Form["tname"] == null || Request.Form["tdesc"] == null || Request.Form["tdate"] == null || Request.Form["tname"].Trim() == "" || Request.Form["tdesc"].Trim() == "" || Request.Form["tdate"].Trim() == "") { validate = "<div class='erralert'>Some fields are missing!</div>"; } if (validate == "") { int id = 0; if (int.TryParse(Request.Form["tid"], out id)) { string usern = (string)HttpContext.Session["Username"]; ASPProjectRedux.Models.Task t = db.Tasks.First(x => x.usr == usern && x.Id == id); if (t != null) { DateTime td = new DateTime(); t.name = Request.Form["tname"]; t.desc = Request.Form["tdesc"]; if (DateTime.TryParse(Request.Form["tdate"], out td)) { t.date = td; db.SaveChanges(); } else { validate = "<div class='erralert'>Invalid date!</div>"; } } else { validate = "<div class='erralert'>Failed to update task!</div>"; } } else { validate = "<div class='erralert'>Failed to update task!</div>"; } } if (validate != "") { HttpCookie k = new HttpCookie("validatEdit", HttpUtility.UrlEncode(validate)); k.Expires = DateTime.Now.AddSeconds(5); Response.Cookies.Add(k); return(RedirectToAction("Edit", "Home")); } return(RedirectToAction("Index", "Home")); }