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))));
}
