/// <summary> /// Function to delete entity whose primary key is passes. /// </summary> /// <param name="pk">Primary key of entity to be deleted</param> /// <param name="context">context to maintain transaction</param> public void Delete(object pk, AgroAppEntities context) { DbSet <T> table = context.Set <T>(); T existing = table.Find(pk); context.Entry(existing).State = EntityState.Deleted; }
public async Task <ActionResult> ChangePassword([DataSourceRequest] DataSourceRequest request, ChangePasswordModel model) { int result = 0; string message; try { var UserIdParam = new SqlParameter { ParameterName = "UserId", DbType = DbType.Int32, Value = model.CurrentUserId }; var PasswordParam = new SqlParameter { ParameterName = "Password", DbType = DbType.String, Value = model.NewPassword }; AgroAppEntities context = new AgroAppEntities(); result = context.Database.SqlQuery <int>("SP_User_ChangePassword @UserId,@Password", UserIdParam, PasswordParam).FirstOrDefault(); } catch (Exception ex) { return(Json(new { Message = CommonHelper.GetErrorMessage(ex), IsError = Convert.ToString((int)Enums.NotifyType.Error) }, JsonRequestBehavior.AllowGet)); } return(Json(new { id = result }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Function to update entity. /// </summary> /// <param name="entity">entity to be updated</param> /// <param name="context">context to maintain transaction</param> public void Update(T entity, AgroAppEntities context) { DbSet <T> table = context.Set <T>(); table.Attach(entity); context.Entry(entity).State = EntityState.Modified; }
/// <summary> /// Function to insert entity. /// </summary> /// <param name="entity">entity to be inserted</param> public string Insert(T entity) { try { using (AgroAppEntities context = BaseContext.GetDbContext()) { DbSet <T> table = context.Set <T>(); table.Add(entity); context.SaveChanges(); return(string.Empty); } } catch (DbEntityValidationException dbEx) { string messages = String.Empty; foreach (DbEntityValidationResult entityErr in dbEx.EntityValidationErrors) { foreach (DbValidationError error in entityErr.ValidationErrors) { //Console.WriteLine("Error Property Name {0} : Error Message: {1}", // error.PropertyName, error.ErrorMessage); messages = messages + "<br/>" + string.Join("<br/>", error.ErrorMessage); } } return(messages); } catch (Exception ex) { return(CommonHelper.GetErrorMessage(ex)); } }
public static List <RoleReadModel> RoleList() { using (AgroAppEntities Context = new AgroAppEntities()) { return(Context.Database.SqlQuery <RoleReadModel>("SP_RoleList").ToList()); } }
public ActionResult Index(LoginModel model) { //if (!ModelState.IsValid) //{ // return View("Index", model); //} var UserNameParam = new SqlParameter { ParameterName = "UserName", DbType = DbType.String, Value = model.UserName }; var PasswordParam = new SqlParameter { ParameterName = "Password", DbType = DbType.String, Value = model.Password }; UserModel logedInUser = new UserModel(); using (AgroAppEntities obj = new AgroAppEntities()) { try { var List = obj.Database.SqlQuery <UserModel>("Sp_UserLogin @UserName,@Password", UserNameParam, PasswordParam).FirstOrDefault(); logedInUser = List; } catch (Exception ex) { return(View()); } } if (logedInUser == null) { ModelState.AddModelError("UserName", "Invalid Login Credentials."); return(View(model)); } if (!logedInUser.IsActive) { ModelState.AddModelError("UserName", string.Format("User '{0}' is no longer active.", logedInUser.UserName)); return(View(model)); } SessionHelper.UserId = Convert.ToInt32(logedInUser.UserId); SessionHelper.WelcomeUser = logedInUser.Name; SessionHelper.RoleId = logedInUser.RoleId; SessionHelper.Email = logedInUser.EmailAddress; SessionHelper.Password = logedInUser.Password; SessionHelper.IsSuperAdmin = logedInUser.IsSuperAdmin; SessionHelper.ProfilePic = logedInUser.Image; SessionHelper.UserAccessPermissions = CustomRepository.UserAccessPermissions(SessionHelper.RoleId, logedInUser.IsSuperAdmin); FormsService.SignIn(logedInUser.UserName, model.RememberMe); return(RedirectToAction("Index", "Home")); }
/// <summary> /// Function to select entity by primary key /// </summary> /// <param name="pk">Primary key of entity to fetch</param> /// <returns></returns> public T SelectById(object pk) { using (AgroAppEntities context = BaseContext.GetDbContext()) { DbSet <T> table = context.Set <T>(); return(table.Find(pk)); } }
/// <summary> /// Function to create entity instance /// </summary> /// <returns>New instance of entity</returns> public T CreateEntity() { using (AgroAppEntities context = BaseContext.GetDbContext()) { DbSet <T> table = context.Set <T>(); return(table.Create()); } }
public static AgroAppEntities GetDbContext() { AgroAppEntities context = new AgroAppEntities(); context.Configuration.ProxyCreationEnabled = false; ObjectContext objectContext = ((IObjectContextAdapter)context).ObjectContext; objectContext.CommandTimeout = int.MaxValue; return(context); }
public ActionResult ResetPassword(ResetPasswordModel userModel) { if (userModel.ConfirmPassword != userModel.Password) { ModelState.AddModelError("ConfirmPassword", "Password and Confirm Password must be same."); return(View("Index")); } UserModel model = new UserModel(); using (AgroAppEntities obj = new AgroAppEntities()) { var UserIdParam = new SqlParameter { ParameterName = "UserId", DbType = DbType.String, Value = userModel.UserId }; model = obj.Database.SqlQuery <UserModel>("SP_GetUserDetail @UserId", UserIdParam).FirstOrDefault(); } if (model != null) { model.Token = null; model.TokenExpiryDate = null; model.Password = userModel.Password; using (AgroAppEntities obj = new AgroAppEntities()) { var UserIdParam = new SqlParameter { ParameterName = "UserId", DbType = DbType.Int32, Value = model.UserId }; var PasswordParam = new SqlParameter { ParameterName = "Password", DbType = DbType.String, Value = model.Password }; var result = obj.Database.SqlQuery <UserModel>("SP_UpdateUserPassword @UserId,@Password", UserIdParam, PasswordParam).FirstOrDefault(); } } if (model.UserId > 0) { ModelState.AddModelError("ConfirmPassword", "Password reset successful."); return(View()); } ModelState.AddModelError("ConfirmPassword", "Something went wrong. Please try again later."); return(View()); }
/// <summary> /// Function to update entity. /// </summary> /// <param name="entity">entity to be updated</param> public string Update(T entity) { try { using (AgroAppEntities context = BaseContext.GetDbContext()) { DbSet <T> table = context.Set <T>(); table.Attach(entity); context.Entry(entity).State = EntityState.Modified; context.SaveChanges(); return(string.Empty); } } catch (Exception ex) { return(CommonHelper.GetErrorMessage(ex)); } }
/// <summary> /// /// </summary> /// <param name="pk">Primary key of entity to be deleted</param> public string Delete(object pk) { try { using (AgroAppEntities context = BaseContext.GetDbContext()) { DbSet <T> table = context.Set <T>(); T existing = table.Find(pk); context.Entry(existing).State = EntityState.Deleted; context.SaveChanges(); return(string.Empty); } } catch (Exception ex) { return(CommonHelper.GetDeleteException(ex)); } }
public async Task <ActionResult> KendoRead([DataSourceRequest] DataSourceRequest request) { try { if (!request.Sorts.Any()) { request.Sorts.Add(new SortDescriptor("RoleName", ListSortDirection.Ascending)); } List <RoleReadModel> model = new List <RoleReadModel>(); using (AgroAppEntities obj = new AgroAppEntities()) { model = obj.Database.SqlQuery <RoleReadModel>("SP_GetRoleRightsList").ToList(); } return(Json(model.ToDataSourceResult(request), JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(CommonHelper.GetErrorMessage(ex))); } }
public ActionResult ResetPassword(string Token) { UserModel userModel = new UserModel(); using (AgroAppEntities obj = new AgroAppEntities()) { var TokenParam = new SqlParameter { ParameterName = "Token", DbType = DbType.String, Value = Token }; userModel = obj.Database.SqlQuery <UserModel>("SP_CompareTokenForResetPassword", TokenParam).FirstOrDefault(); } if (userModel != null) { if (userModel.UserId > 0 && userModel.TokenExpiryDate >= DateTime.Now) { ResetPasswordModel model = new ResetPasswordModel { UserId = userModel.UserId }; return(View(model)); } if (userModel.TokenExpiryDate < DateTime.Now) { TempData["Message"] = "Token for reset password has been expired.please try agian to reset password."; return(RedirectToAction("Index", "Login")); } TempData["Message"] = "Something Went wrong. Please try again later."; return(RedirectToAction("Index", "Login")); } else { TempData["Message"] = "Link has been expired"; return(RedirectToAction("Index", "Login")); } }
public static List <UserAccessPermissionModel> UserAccessPermissions(int?roleId = null, bool isSuperAdmin = false) { List <UserAccessPermissionModel> dataList; using (AgroAppEntities context = new AgroAppEntities()) { var UserIdParam = new SqlParameter { ParameterName = "RoleId", DbType = DbType.Int32, Value = roleId }; var IsSuperAdminParam = new SqlParameter { ParameterName = "IsSuperAdmin", DbType = DbType.Boolean, Value = (object)isSuperAdmin ?? DBNull.Value }; dataList = context.Database.SqlQuery <UserAccessPermissionModel>("sp_UserAccessPermissions @RoleId,@IsSuperAdmin", UserIdParam, IsSuperAdminParam).ToList(); } return(dataList.ToList()); }
/// <summary> /// Function to get entites /// </summary> /// <returns>DbSet result of entities</returns> public DbSet <T> GetEntities() { AgroAppEntities context = BaseContext.GetDbContext(); return(context.Set <T>()); }
public ActionResult ForgotPassword(string Email) { try { UserModel model = new UserModel(); using (AgroAppEntities obj = new AgroAppEntities()) { var EmailParam = new SqlParameter { ParameterName = "EmailAddress", DbType = DbType.String, Value = Email }; model = obj.Database.SqlQuery <UserModel>("SP_ForgotPassGetDetail @EmailAddress", EmailParam).FirstOrDefault(); } string token = Guid.NewGuid().ToString(); if (model.UserId > 0) { string link = Url.Action("ResetPassword", "Login", new RouteValueDictionary(new { Token = token }), System.Web.HttpContext.Current.Request.Url.Scheme); string resetLink = "<a href='" + link + "'>" + link + "</a>"; string toEmail = model.EmailAddress; string bodyTemplate = System.IO.File.ReadAllText(Server.MapPath("~/Template/ForgotPassword.html")); bodyTemplate = bodyTemplate.Replace("[@FirstName]", model.Name); bodyTemplate = bodyTemplate.Replace("[@link]", resetLink); Task task = new Task(() => EmailHelper.SendAsyncEmail(toEmail, "ForgotPassword", bodyTemplate, true)); task.Start(); model.Token = token; model.TokenExpiryDate = DateTime.Now.AddDays(1); using (AgroAppEntities obj = new AgroAppEntities()) { var UserIdParam = new SqlParameter { ParameterName = "UserId", DbType = DbType.Int32, Value = model.UserId }; var TokenParam = new SqlParameter { ParameterName = "Token", DbType = DbType.String, Value = model.Token }; var TokenExpiryDateParam = new SqlParameter { ParameterName = "TokenExpiryDate", DbType = DbType.DateTime, Value = model.TokenExpiryDate }; var result = obj.Database.SqlQuery <UserModel>("SP_UserForgotPassTokenSave @UserId,@Token,@TokenExpiryDate", UserIdParam, TokenParam, TokenExpiryDateParam).FirstOrDefault(); } ModelState.AddModelError("Email", "Email For Reset Passsword has been sent. Please check your email."); return(View()); } else { ModelState.AddModelError("Email", "Please enter valid Email Address."); return(View()); } } catch (Exception ex) { ModelState.AddModelError("Email", "Please enter valid Email Address."); return(View("Index")); } }
/// <summary> /// Function to insert entity. /// </summary> /// <param name="entity">entity to be inserted</param> /// <param name="context">context to maintain transaction</param> public void Insert(T entity, AgroAppEntities context) { DbSet <T> table = context.Set <T>(); table.Add(entity); }