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