protected void Page_Init(object sender, EventArgs e) { if (!User.Identity.IsAuthenticated) Response.Redirect("~/signin.aspx"); if (Request.QueryString["act"] == "vis") { int vklId, visibility; if (int.TryParse(Request.QueryString["id"], out vklId)) { if (Member.Roles.IsSupremeAdministrator) { if (!int.TryParse(Request.QueryString["val"], out visibility) || !Enum.IsDefined(typeof(VKLVisibility), visibility)) { Common.LogError("Illegal parameters {" + Request.RawUrl + "}", "Account.init"); Response.End(); return; } } else visibility = (int)VKLVisibility.Public; using (DataAccess da = new DataAccess()) { da.ExecuteSP("Upd_VKLVisibility", new System.Data.Common.DbParameter[] {new SqlParameter("@id", vklId), new SqlParameter("@newVisibility", visibility), (Member.Roles.IsSupremeAdministrator ? null : new SqlParameter("@userId", Member.CurrentUser))}); } } Response.End(); return; } this.VKLLists.ItemCreated += new RepeaterItemEventHandler(VKLLists_ItemCreated); this.LoginStatus1.LoggedOut += new EventHandler(LoginStatus1_LoggedOut); }
protected void Page_Load(object sender, EventArgs e) { SqlDataReader sdr; using ( DataAccess da = new DataAccess()) { if (User.Identity.IsAuthenticated) sdr =(SqlDataReader) da.ExecuteSPForDataReader("Sel_VKLs", new SqlParameter[] {Parameters.Int("@userId", Member.CurrentUser)}); else sdr = (SqlDataReader) da.ExecuteSPForDataReader("Sel_VKLs", null); this.dsVkl.Text = "<script>\n" + JS.CreateObject(sdr, "vkls", true) + "</script>"; sdr.Close(); } }
private void PopulateInscripts() { DataAccess da = new DataAccess(); if (!ShowAll.Checked) { if (vklLang.SelectedItem == null || vklLang.SelectedValue == string.Empty) vklScript.Items.Clear(); else vklScript.DataSource = da.ExecuteQuerySPForDataTable("sel_inscripts", new SqlParameter[] { Parameters.String("LangId", vklLang.SelectedItem.Value) }).DefaultView; } else // Show All vklScript.DataSource = da.ExecuteQuerySPForDataTable("sel_inscripts", new SqlParameter[] { Parameters.String("LangId", DBNull.Value) }).DefaultView; vklScript.DataBind(); vklScript.Items.Insert(0, new ListItem {Value=string.Empty,Text="--Select--"}); }
protected void Page_Load(object sender, EventArgs e) { if (!Member.SessionBegun) Response.Redirect("~/signin.aspx"); SqlDataReader sdr; using (DataAccess da = new DataAccess()) { sdr = (SqlDataReader)da.ExecuteSPForDataReader("Sel_VKLs", new SqlParameter[] { Parameters.Int("@userId", Member.CurrentUser) }); this.ClientScript.RegisterClientScriptBlock(GetType(), "VKLs", "<script>\n" + JS.CreateObject(sdr, "vkls", true) + "</script>", false); sdr.Close(); } if (!IsPostBack) { int vid = 0; if (Request.QueryString["vid"] != null && int.TryParse(Request.QueryString["vid"], out vid)) { EditVKL(vid); } else { DataAccess da = new DataAccess(); vklLang.DataSource = da.ExecuteSelectForDataTable("SELECT * FROM [Languages] ORDER BY [Language]").DefaultView; vklLang.DataBind(); vklLang.Items.Insert(0, new ListItem {Value=string.Empty,Text="--Select--"}); PopulateInscripts(); Wizard.SetActiveView(step1); Act = Activities.Creating; } } }
public static Results CreateVKL(VKL vkl) { try { if (VKLExists(vkl.Name, vkl.Type)) { Common.LogError("Atempt to create a vkl that already exists.", "Vkm.CreateVKL", (int)Results.TamperingAttempt); return Results.AlreadyExists; } using (DataAccess da = new DataAccess ()) { vkl.Id = Convert.ToInt32(da.ExecuteSPForScalar("New_VKL", new SqlParameter[] { new SqlParameter("@langCode", vkl.LangCode), new SqlParameter("@name", vkl.Name), new SqlParameter("@userId", vkl.UserId), new SqlParameter("@type", (byte)vkl.Type), new SqlParameter("@visibility", (byte)vkl.Visibility) })); } vkl.Data.Save(VKLFilePath(vkl.Name, vkl.Type)); return Results.Ok; } catch (Exception ex) { Common.LogError("Error creating VKL: " + ex.Message, "VKM.CreateVKL", (int)Results.ResourceError); } return Results.SomeError; }
public static VKL GetVKL(string vklName, VKLTypes type) { try { using (DataAccess da = new DataAccess()) { var dt = da.ExecuteQuerySPForDataTable("Sel_VKL", new SqlParameter[] { new SqlParameter("@name", vklName), new SqlParameter("@type", (int)type) }); if (dt.Rows.Count > 0) { var dr = dt.Rows[0]; var vkl = new VKL { Id = (int)dr["VKLId"], LangCode = (string)dr["LangCode"], Name = (string)dr["Name"], UserId = (int)dr["UserId"], Type = (VKLTypes)int.Parse(dr["Type"].ToString()), Visibility = (VKLVisibility)int.Parse(dr["Visibility"].ToString()) }; vkl.Data = XElement.Load(VKLFilePath(vkl.Name, vkl.Type)); return vkl; } else Common.LogError("The VKL " + vklName + " (" + type.ToString() + ") couldn't be found.", Common.GetMethodName(MethodBase.GetCurrentMethod()), (int)Results.NotFound); } } catch (SqlException sqlEx) { Common.LogError(sqlEx.Message, Common.GetMethodName(MethodBase.GetCurrentMethod()), sqlEx.Number); } catch (Exception otherEx) { Common.LogError(otherEx.Message, Common.GetMethodName(MethodBase.GetCurrentMethod())); } return null; }
public static int Validate(string UserName, string Password, ref string DBUserName) { try { using (DataAccess da = new DataAccess()) { DataTable dt = da.ExecuteQuerySPForDataTable("Brief_UserInfo", new SqlParameter[] {new SqlParameter {DbType = DbType.String, ParameterName = "@userName", Direction = ParameterDirection.Input, Value = UserName}}); if (dt.Rows.Count == 0) { Common.LogError("Invalid UserName '" + UserName + "'", "Member.Validate",(int) Results.InvalidUserName); return (int) Results.InvalidUserName; } if ((string)dt.Rows[0]["Password"]!= FormsAuthentication.HashPasswordForStoringInConfigFile(Password, "MD5")) { Common.LogError("Invalid PWD'" + Password + "'", "Member.Validate", (int) Results.InvalidPassword); return (int) Results.InvalidPassword; } DBUserName =dt.Rows[0]["UserName"].ToString(); return (int)dt.Rows[0]["UserId"]; } } catch (SqlException sqlEx) { Common.LogError(sqlEx.Message, Common.GetMethodName(MethodBase.GetCurrentMethod()), sqlEx.Number); } catch (Exception otherEx) { Common.LogError(otherEx.Message, Common.GetMethodName(MethodBase.GetCurrentMethod())); } return (int) Results.SomeError; }
public static int Exists(string UserName) { try { using (DataAccess da = new DataAccess()) { int uId = Convert.ToInt32(da.ExecuteSPForScalar("UserExists", new SqlParameter[] { new SqlParameter { DbType = DbType.String, ParameterName = "@userName", Direction = ParameterDirection.Input, Value = UserName } })); if (uId > 0) return uId; else return 0; } } catch (SqlException sqlEx) { Common.LogError(sqlEx.Message, Common.GetMethodName(MethodBase.GetCurrentMethod()), sqlEx.Number); } catch (Exception otherEx) { Common.LogError(otherEx.Message, Common.GetMethodName(MethodBase.GetCurrentMethod())); } return (int)Results.SomeError; }