public void UserRegister(Models.UserDetail User)
{
string sql = @" Insert INTO dbo.UserDetail
(
UserAccount,UserPassword,UserName,UserSex,UserEmail
)
VALUES
(
@UserAccount,@UserPassword,@UserName,@UserSex,@UserEmail
)
" ;
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@UserAccount", User.UserAccount));
cmd.Parameters.Add(new SqlParameter("@UserPassword", User.UserPassword));
cmd.Parameters.Add(new SqlParameter("@UserName", User.UserName));
cmd.Parameters.Add(new SqlParameter("@UserSex", User.UserSex));
cmd.Parameters.Add(new SqlParameter("@UserEmail", User.UserEmail));
cmd.ExecuteNonQuery();
conn.Close();
}
}
public ActionResult getUserDetails(Models.UserDetail ud)
{
dataConnect dc = new dataConnect();
ViewBag.result = dc.getUserDetails(ud.uid);
return(View());
}
public void UpdateUserData(Models.UserDetail User)
{
string sql = @" Update dbo.UserDetail
SET UserPassword=@UserPassword,UserName=@UserName,UserSex=@UserSex,UserEmail=@UserEmail
Where UserAccount=@UserAccount
" ;
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@UserAccount", User.UserAccount));
cmd.Parameters.Add(new SqlParameter("@UserPassword", User.UserPassword));
cmd.Parameters.Add(new SqlParameter("@UserName", User.UserName));
cmd.Parameters.Add(new SqlParameter("@UserSex", User.UserSex));
cmd.Parameters.Add(new SqlParameter("@UserEmail", User.UserEmail));
cmd.ExecuteNonQuery();
conn.Close();
}
}
public void InsertTrainees(Models.UserDetail User)
{
DBcontext.UserDetails.Add(User);
DBcontext.SaveChanges();
}
public ActionResult UpdateProfile()
{
Models.UserDetail modelUser = new Models.UserDetail();
repo = new WeatherTodayRepo();
UserDetail entityUser = repo.GetUserByEmail(Session["EmailID"].ToString());
modelUser.User_ID = entityUser.User_ID;
modelUser.User_First_Name = entityUser.User_First_Name;
modelUser.User_Last_Name = entityUser.User_Last_Name;
modelUser.User_Emaild = entityUser.User_Emaild;
modelUser.User_Password = entityUser.User_Password;
return(View(modelUser));
}
public ActionResult Login(Models.UserDetail model)
{
using (var context = new ProductmanagmentDBEntities())
{
bool isValid = context.UserDetails.Any(x => x.EmailID == model.EmailID && x.Password == model.Password);
if (isValid)
{
Session["UserID"] = model.UserID.ToString();
FormsAuthentication.SetAuthCookie(model.EmailID, true);
log.Info("User:"******" Login at " + DateTime.Now.ToString());
return(RedirectToAction("Welcome", "ProductDetailsMVC"));
}
ModelState.AddModelError("", "Invalid Username and Password");
return(View());
}
}
public override void OnAuthorization(AuthorizationContext filterContext)
{
string SessionKey = "ProfileCompleted";
bool Authorization = filterContext.ActionDescriptor.IsDefined(typeof(AuthorizeAttribute), true) ||
filterContext.ActionDescriptor.ControllerDescriptor.IsDefined(typeof(AuthorizeAttribute), true);
bool ContainsIgnore = filterContext.ActionDescriptor.IsDefined(typeof(IgnoreCompleteProfileAttribute), true) ||
filterContext.ActionDescriptor.ControllerDescriptor.IsDefined(typeof(IgnoreCompleteProfileAttribute), true);
if ((Authorization) && (!ContainsIgnore))
{
var ctx = System.Web.HttpContext.Current;
if (ctx != null)
{
if (filterContext.HttpContext.User.Identity.IsAuthenticated)
{
if (ctx.Session[SessionKey] == null)
{
Models.UserDetail user = dao.UserDao.GetByEmail(filterContext.HttpContext.User.Identity.Name);
if (user != null)
{
ctx.Session[SessionKey] = user.CompletedAccount;
}
}
bool ForceRedirect = ((ctx.Session[SessionKey] == null) || ((bool)ctx.Session[SessionKey] == false));
string ReturnUrl = string.Empty;
if ((filterContext.HttpContext.Request != null) && (!string.IsNullOrEmpty(filterContext.HttpContext.Request.RawUrl)))
{
ReturnUrl = filterContext.HttpContext.Request.RawUrl.ToString();
}
if (ForceRedirect)
{
filterContext.Result = new RedirectToRouteResult("CompleteAccount", new System.Web.Routing.RouteValueDictionary {
{ "ReturnUrl", ReturnUrl }
});
}
}
else
{
base.OnAuthorization(filterContext);
}
}
else
{
base.OnAuthorization(filterContext);
}
}
}
public ActionResult UpdateProfile(Models.UserDetail Ud)
{
UserDetail entityUser = new UserDetail();
entityUser.User_ID = Ud.User_ID;
entityUser.User_First_Name = Ud.User_First_Name;
entityUser.User_Last_Name = Ud.User_Last_Name;
entityUser.User_Emaild = Ud.User_Emaild;
entityUser.User_Password = Ud.User_Password;
repo = new WeatherTodayRepo();
bool status = repo.UpdateUserDetails(entityUser);
if (status)
{
ViewBag.Msg = " Your details are updated successfully";
}
else
{
ViewBag.Msg = "Something went wrong";
}
return(View());
}
public ActionResult CreateUser(Models.UserDetail ud)
{
repo = new WeatherTodayRepo();
UserDetail entityUser = new UserDetail();
entityUser.User_ID = ud.User_ID;
entityUser.User_First_Name = ud.User_First_Name;
entityUser.User_Last_Name = ud.User_Last_Name;
entityUser.User_Emaild = ud.User_Emaild;
entityUser.User_Password = ud.User_Password;
bool status = repo.AddUser(entityUser);
if (status)
{
return(RedirectToAction("LoginUser", "User"));
}
else
{
ViewBag.Msg = "Something went wrong.";
}
return(View(ud));
}
public ActionResult UpdateUserdata(Models.UserDetail User)
{
Models.SearchUserData UpdateUserData = new Models.SearchUserData();
UpdateUserData.UpdateUserData(User);
return(RedirectToAction("Index"));
}
public ActionResult Register(Models.UserDetail User)
{
Models.Register Register = new Models.Register();
Register.UserRegister(User);
return(RedirectToAction("Index"));
}
