protected void btnLogin_Click(object sender, EventArgs e) { if (txtUsername.Value == null || txtUsername.Value == "") { throw new ApplicationException("field username is mandatory"); } if (txtPassword.Value == null || txtPassword.Value == "") { throw new ApplicationException("field password is mandatory"); } if (txtUsername.Value != null && txtUsername.Value != "") { PenjaminanDataset.UserProfileRow dr = UserProfile.getUserLogin(txtUsername.Value, txtPassword.Value); if (dr != null) { if (dr.password == txtPassword.Value) { Session["UserProfile"] = dr; Response.Redirect("/Dashboard.aspx"); } } else { throw new ApplicationException("Username and Password not found"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserProfile"] == null) { Response.Redirect("/Default.aspx"); } if (!Page.IsPostBack) { if (eType == "add") { } else if (eType == "edit") { bindData(); } else if (eType == "delete") { softDeleteData(eID); } } lblMenu.Text = "Entry Master User"; Session["activepage"] = "user"; if (!Page.IsPostBack) { Models.PenjaminanDatasetTableAdapters.DivisiTableAdapter ta = new Models.PenjaminanDatasetTableAdapters.DivisiTableAdapter(); Models.PenjaminanDatasetTableAdapters.u_roleTableAdapter taRole = new Models.PenjaminanDatasetTableAdapters.u_roleTableAdapter(); DropDownList1.DataSource = (PenjaminanDataset.DivisiDataTable)ta.GetData(); DropDownList1.DataBind(); RoleList.DataSource = (PenjaminanDataset.u_roleDataTable)taRole.GetData(); RoleList.DataBind(); //set jadi kosong ketika add new if (eType == "edit") { PenjaminanDataset.UserProfileRow dr = UserProfile.selectUserProfileByID(eID); tDivisiID = Convert.ToInt16(dr.division); tRoleID = Convert.ToInt16(dr.role); DropDownList1.SelectedValue = tDivisiID.ToString(); RoleList.SelectedValue = tRoleID.ToString(); } //else if(eType == "add") //{ // DropDownList1.SelectedValue = " "; // RoleList.SelectedValue = " "; //} //DropDownList1.DataTextFormatString = "{0} - {1}"; //DropDownList1.DataTextField = "ID,NamaDivisi"; } }
private void bindData() { PenjaminanDataset.UserProfileRow dr = UserProfile.selectUserProfileByID(eID); Models.PenjaminanDatasetTableAdapters.u_roleTableAdapter taRole = new Models.PenjaminanDatasetTableAdapters.u_roleTableAdapter(); Models.PenjaminanDatasetTableAdapters.DivisiTableAdapter ta = new Models.PenjaminanDatasetTableAdapters.DivisiTableAdapter(); DropDownList1.DataSource = (PenjaminanDataset.DivisiDataTable)ta.GetDataByID(Convert.ToInt16(dr.division)); RoleList.DataSource = (PenjaminanDataset.u_roleDataTable)taRole.GetDataRoleByID(Convert.ToInt16(dr.role)); DropDownList1.DataBind(); RoleList.DataBind(); txtUsername.Value = dr.username.ToString(); txtPassword.Value = dr.password.ToString(); //txtRole.Value = dr.role.ToString(); //txtDivision.Value = dr.division.ToString(); }
public static PenjaminanDataset.UserProfileRow getUserLogin(string username, string password) { PenjaminanDatasetTableAdapters.UserProfileTableAdapter ta = new PenjaminanDatasetTableAdapters.UserProfileTableAdapter(); PenjaminanDataset.UserProfileDataTable dt = new PenjaminanDataset.UserProfileDataTable(); PenjaminanDataset.UserProfileRow dr = null; try { ta.FillUserProfileByUsernamePassword(dt, username, password); if (dt.Count > 0) { dr = dt[0]; } return(dr); } catch (Exception ex) { throw new ApplicationException(ex.Message, ex); } }
public static PenjaminanDataset.UserProfileRow selectUserProfileByID(int id) { PenjaminanDatasetTableAdapters.UserProfileTableAdapter ta = new PenjaminanDatasetTableAdapters.UserProfileTableAdapter(); PenjaminanDataset.UserProfileDataTable dt = new PenjaminanDataset.UserProfileDataTable(); PenjaminanDataset.UserProfileRow dr = null; try { ta.FillUserProfileByID(dt, id); if (dt.Count > 0) { dr = dt[0]; } return(dr); } catch (Exception ex) { throw new ApplicationException("Failed to load user profile data : " + ex.Message); } }