public static string GetUserName()
{
string n = "";
using (SqlServer database = new SqlServer(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
n = database.GetValue("dbo.UserNameGet", new List<System.Data.SqlClient.SqlParameter>()).ToString();
}
return n;
}
public static int GetPrivilege()
{
int p = 1;
using (SqlServer database = new SqlServer(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
p = int.Parse(database.GetValue("dbo.PrivilegeGet", new List<System.Data.SqlClient.SqlParameter>()));
}
return p;
}
public static string ValidateRoutineName(string routinename, string area)
{
using (SqlServer database = new SqlServer(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
List<SqlParameter> parameters = new List<SqlParameter>();
parameters.Add(new SqlParameter("RoutineName", SqlDbType.NVarChar) { Value = routinename.Replace("'", "''") });
parameters.Add(new SqlParameter("Area", SqlDbType.NVarChar) { Value = area.Replace("'", "''") });
return database.GetValue("dbo.ValidateRoutineName", parameters);
}
}
