public ActionResult Create([Bind(Include = "UserId" + "," + "LoginId" + "," + "Pwd" + "," + "UserName" + "," + "IsPlansonUser" + "," + "FirstName" + "," + "LastName" + "," + "Locked" + "," + "IsActive" )] UserMaster UserMaster) { if (ModelState.IsValid) { bool bSucess = false; bSucess = UserMasterData.Add(UserMaster); if (bSucess == true) { return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Can Not Insert"); } } return(View(UserMaster)); }
public bool Add(UserMasterModel newUser) { newUser.UserType = "Demo"; newUser.UserStatus = UserStatusType.Active; newUser.Password = Security.PasswordManager.EncryptPassword(newUser.Password); newUser.SecAns = Security.PasswordManager.EncryptPassword(newUser.SecAns); UserMasterData userData = new UserMasterData(newUser); return(userData.Save()); }
public ActionResult DeleteConfirmed( Int64?UserId ) { UserMaster UserMaster = new UserMaster(); UserMaster.UserId = System.Convert.ToInt32(UserId); UserMaster = UserMasterData.Select_Record(UserMaster); bool bSucess = false; bSucess = UserMasterData.Delete(UserMaster); if (bSucess == true) { TempData["success"] = "Successfully deleted."; return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Can Not Delete"); } return(null); }
// GET: /UserMaster/Delete/<id> public ActionResult Delete( Int64?UserId ) { if ( UserId == null ) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } UserMaster UserMaster = new UserMaster(); UserMaster.UserId = System.Convert.ToInt32(UserId); UserMaster = UserMasterData.Select_Record(UserMaster); if (UserMaster == null) { return(HttpNotFound()); } return(View(UserMaster)); }
public ActionResult Edit(UserMaster UserMaster) { UserMaster oUserMaster = new UserMaster(); oUserMaster.UserId = System.Convert.ToInt32(UserMaster.UserId); oUserMaster = UserMasterData.Select_Record(UserMaster); if (ModelState.IsValid) { bool bSucess = false; bSucess = UserMasterData.Update(oUserMaster, UserMaster); if (bSucess == true) { return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Can Not Update"); } } return(View(UserMaster)); }
public static int GetUserNumberByUserId(string userName) { return(UserMasterData.GetUserNo(userName)); }
// public static List <SecreteQuestion> GetAllSecreteQuestionList() { return(UserMasterData.GetAllQuestionsList().ToList <SecreteQuestion>()); }
//Testing purpose public static System.Data.DataSet GetAllQuestionsDataSet() { System.Data.DataSet ds = new System.Data.DataSet(); return(UserMasterData.GetAllQuestionDataSet()); }
// GET: /UserMaster/ public ActionResult Index(string sortOrder, String SearchField, String SearchCondition, String SearchText, String Export, int?PageSize, int?page, string command) { if (command == "Clear") { SearchField = null; SearchCondition = null; SearchText = null; Session["SearchField"] = null; Session["SearchCondition"] = null; Session["SearchText"] = null; } /* else if (command == "Add New Record") { return RedirectToAction("Create"); } */ else if (command == "Export") { Session["Export"] = Export; } else if (command == "Search" | command == "Page Size") { if (!string.IsNullOrEmpty(SearchText)) { Session["SearchField"] = SearchField; Session["SearchCondition"] = SearchCondition; Session["SearchText"] = SearchText; } } if (command == "Page Size") { Session["PageSize"] = PageSize; } ViewData["SearchFields"] = GetFields((Session["SearchField"] == null ? "User Id" : Convert.ToString(Session["SearchField"]))); ViewData["SearchConditions"] = Library.GetConditions((Session["SearchCondition"] == null ? "Contains" : Convert.ToString(Session["SearchCondition"]))); ViewData["SearchText"] = Session["SearchText"]; ViewData["Exports"] = Library.GetExports((Session["Export"] == null ? "Pdf" : Convert.ToString(Session["Export"]))); ViewData["PageSizes"] = Library.GetPageSizes(); ViewData["CurrentSort"] = sortOrder; ViewData["UserIdSortParm"] = sortOrder == "UserId_asc" ? "UserId_desc" : "UserId_asc"; ViewData["LoginIdSortParm"] = sortOrder == "LoginId_asc" ? "LoginId_desc" : "LoginId_asc"; ViewData["PwdSortParm"] = sortOrder == "Pwd_asc" ? "Pwd_desc" : "Pwd_asc"; ViewData["UserNameSortParm"] = sortOrder == "UserName_asc" ? "UserName_desc" : "UserName_asc"; ViewData["IsPlansonUserSortParm"] = sortOrder == "IsPlansonUser_asc" ? "IsPlansonUser_desc" : "IsPlansonUser_asc"; ViewData["FirstNameSortParm"] = sortOrder == "FirstName_asc" ? "FirstName_desc" : "FirstName_asc"; ViewData["LastNameSortParm"] = sortOrder == "LastName_asc" ? "LastName_desc" : "LastName_asc"; ViewData["LockedSortParm"] = sortOrder == "Locked_asc" ? "Locked_desc" : "Locked_asc"; ViewData["IsActiveSortParm"] = sortOrder == "IsActive_asc" ? "IsActive_desc" : "IsActive_asc"; dtUserMaster = UserMasterData.SelectAll(); try { if (!string.IsNullOrEmpty(Convert.ToString(Session["SearchField"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchCondition"])) & !string.IsNullOrEmpty(Convert.ToString(Session["SearchText"]))) { dtUserMaster = UserMasterData.Search(Convert.ToString(Session["SearchField"]), Convert.ToString(Session["SearchCondition"]), Convert.ToString(Session["SearchText"])); } } catch { } var Query = from rowUserMaster in dtUserMaster.AsEnumerable() select new UserMaster() { UserId = rowUserMaster.Field <Int64>("UserId") , LoginId = rowUserMaster.Field <String>("LoginId") , Pwd = rowUserMaster.Field <String>("Pwd") , UserName = rowUserMaster.Field <String>("UserName") , IsPlansonUser = rowUserMaster.Field <Boolean>("IsPlansonUser") , FirstName = rowUserMaster.Field <String>("FirstName") , LastName = rowUserMaster.Field <String>("LastName") , Locked = rowUserMaster.Field <Boolean>("Locked") , IsActive = rowUserMaster.Field <Boolean>("IsActive") }; switch (sortOrder) { case "UserId_desc": Query = Query.OrderByDescending(s => s.UserId); break; case "UserId_asc": Query = Query.OrderBy(s => s.UserId); break; case "LoginId_desc": Query = Query.OrderByDescending(s => s.LoginId); break; case "LoginId_asc": Query = Query.OrderBy(s => s.LoginId); break; case "Pwd_desc": Query = Query.OrderByDescending(s => s.Pwd); break; case "Pwd_asc": Query = Query.OrderBy(s => s.Pwd); break; case "UserName_desc": Query = Query.OrderByDescending(s => s.UserName); break; case "UserName_asc": Query = Query.OrderBy(s => s.UserName); break; case "IsPlansonUser_desc": Query = Query.OrderByDescending(s => s.IsPlansonUser); break; case "IsPlansonUser_asc": Query = Query.OrderBy(s => s.IsPlansonUser); break; case "FirstName_desc": Query = Query.OrderByDescending(s => s.FirstName); break; case "FirstName_asc": Query = Query.OrderBy(s => s.FirstName); break; case "LastName_desc": Query = Query.OrderByDescending(s => s.LastName); break; case "LastName_asc": Query = Query.OrderBy(s => s.LastName); break; case "Locked_desc": Query = Query.OrderByDescending(s => s.Locked); break; case "Locked_asc": Query = Query.OrderBy(s => s.Locked); break; case "IsActive_desc": Query = Query.OrderByDescending(s => s.IsActive); break; case "IsActive_asc": Query = Query.OrderBy(s => s.IsActive); break; default: // Name ascending Query = Query.OrderBy(s => s.UserId); break; } if (command == "Export") { GridView gv = new GridView(); DataTable dt = new DataTable(); dt.Columns.Add("User Id", typeof(string)); dt.Columns.Add("Login Id", typeof(string)); dt.Columns.Add("Pwd", typeof(string)); dt.Columns.Add("User Name", typeof(string)); dt.Columns.Add("Is Planson User", typeof(string)); dt.Columns.Add("First Name", typeof(string)); dt.Columns.Add("Last Name", typeof(string)); dt.Columns.Add("Locked", typeof(string)); dt.Columns.Add("Is Active", typeof(string)); foreach (var item in Query) { dt.Rows.Add( item.UserId , item.LoginId , item.Pwd , item.UserName , item.IsPlansonUser , item.FirstName , item.LastName , item.Locked , item.IsActive ); } gv.DataSource = dt; gv.DataBind(); ExportData(Export, gv, dt); } int pageNumber = (page ?? 1); int?pageSZ = (Convert.ToInt32(Session["PageSize"]) == 0 ? 5 : Convert.ToInt32(Session["PageSize"])); return(View(Query.ToPagedList(pageNumber, (pageSZ ?? 5)))); }