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