public ActionResult MusicSheetsbySong(int SongID)
{
if (Request.IsAuthenticated)
{
ControllerDirectory val = CDBL.Validation(this.ControllerContext.RouteData.Values["controller"].ToString(), User.Identity.Name, AppID);
if (val.ReadFlag == true)
{
string InsertUser = User.Identity.GetUserName();
ViewBag.WriteFlag = val.WriteFlag;
List <MusicSheets> Charts = MSBL.MusicSheetsbySong(SongID, InsertUser);
var songname = from s in SongsBL.SongList()
where s.SongID == SongID
select s.SongName;
ViewBag.SongID = SongID;
ViewBag.SongName = songname.FirstOrDefault().ToString();
return(View(Charts.ToList()));
}
else
{
ViewBag.Mensaje = "Usted no tiene accesso a este sección, solicítelo a un administrador.";
return(View("~/Views/Shared/Error.cshtml"));
}
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
// GET: /Authors/Details/1
public ActionResult Details(int id = 0)
{
if (Request.IsAuthenticated)
{
List <Songs> Repertoire = SongsBL.Reportoires(id);
Authors Author = AuthorsBL.Details(id);
ControllerDirectory val = CDBL.Validation("Songs", User.Identity.Name, AppID);
ViewBag.WriteFlag = val.WriteFlag;
ViewBag.AuthorName = Author.AuthorName;
ViewBag.AuthorID = id;
if (Author == null)
{
return(HttpNotFound());
}
return(View(Repertoire.ToList()));
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
// GET: MusicSheets
public ActionResult Index()
{
if (Request.IsAuthenticated)
{
ControllerDirectory val = CDBL.Validation(this.ControllerContext.RouteData.Values["controller"].ToString(), User.Identity.Name, AppID);
if (val.ReadFlag == true)
{
string InsertUser = User.Identity.GetUserName();
ViewBag.WriteFlag = val.WriteFlag;
List <MusicSheets> Charts = MSBL.MSList(InsertUser);
return(View(Charts.ToList()));
}
else
{
ViewBag.Mensaje = "Usted no tiene accesso a este sección, solicítelo a un administrador.";
return(View("~/Views/Shared/Error.cshtml"));
}
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
public List <ControllerDirectory> Rights(int RoleID)
{
var rights = new List <ControllerDirectory>();
try
{
using (var SqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_MDA_CR_OA_Connection"].ToString()))
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[adm].[uspReadControllerRights]", SqlCon);
SqlCmd.CommandType = CommandType.StoredProcedure;
//Insert Parameters
SqlParameter ParRoleID = new SqlParameter
{
ParameterName = "@RoleID",
SqlDbType = SqlDbType.Int,
Value = RoleID
};
SqlCmd.Parameters.Add(ParRoleID);
using (var dr = SqlCmd.ExecuteReader())
{
while (dr.Read())
{
var right = new ControllerDirectory
{
ControllerID = Convert.ToInt32(dr["ControllerID"]),
CTRRightID = Convert.ToInt32(dr["CTRRightID"]),
ControllerName = dr["ControllerName"].ToString(),
ReadFlag = Convert.ToBoolean(dr["ReadFlag"]),
WriteFlag = Convert.ToBoolean(dr["WriteFlag"])
};
rights.Add(right);
}
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
}
}
catch (Exception ex)
{
throw;
}
return(rights);
}
// GET: Rights
public ActionResult Index(int id = 0)
{
if (Request.IsAuthenticated)
{
var Rights = CDBL.Rights(id);
Roles role = RBL.Details(id);
string layout = "~/Views/Shared/_MinistryLayout.cshtml";
if (role.ApplicationID == 2)
{
layout = "~/Views/Shared/_MusicLayout.cshtml";
}
else
{
if (role.ApplicationID == 3)
{
layout = "~/Views/Shared/_ScenicLayout.cshtml";
}
else
{
}
}
ViewBag.Layout = layout;
ViewBag.AppID = role.ApplicationID;
ViewBag.RoleName = role.RoleName;
ViewBag.RoleID = id;
ControllerDirectory val = CDBL.Validation(this.ControllerContext.RouteData.Values["controller"].ToString(), User.Identity.Name, role.ApplicationID);
if (val.ReadFlag == true)
{
ViewBag.WriteFlag = val.WriteFlag;
return(View(Rights.ToList()));
}
else
{
ViewBag.Mensaje = "Usted no tiene accesso a este sección, solicítelo a un administrador.";
return(View("~/Views/Shared/Error.cshtml"));
}
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
public ActionResult Details(int id)
{
if (Request.IsAuthenticated)
{
var details = from p in PBL.ProgramList()
where p.ProgramID == id
select p;
Programs Program = details.FirstOrDefault();
CultureInfo ci = new CultureInfo("Es-Es");
string day = ci.DateTimeFormat.GetDayName(Program.ProgramDate.DayOfWeek).ToString();
ViewBag.DayName = day.First().ToString().ToUpper() + day.Substring(1);
ViewBag.PDate = Program.ProgramDate.ToString("dd/MM/yyyy");
ViewBag.PSchedule = Program.ProgramSchedule;
ViewBag.Status = Program.CompleteFlag;
ViewBag.PID = id;
ViewBag.ND = Program.NotificationDate;
ControllerDirectory val = CDBL.Validation(this.ControllerContext.RouteData.Values["controller"].ToString(), User.Identity.Name, AppID);
ViewBag.WriteFlag = val.WriteFlag;
List <ProgramDetails> PDetails = new List <ProgramDetails>();
PDetails = PDBL.Details(id).OrderBy(x => x.SongsData.SongName).ToList();
foreach (var r in PDetails)
{
r.Status = Program.CompleteFlag;
}
ViewBag.Rows = PDetails.Count;
return(View(PDetails));
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
public ActionResult WeeklyProgram()
{
if (Request.IsAuthenticated)
{
ControllerDirectory val = CDBL.Validation(this.ControllerContext.RouteData.Values["controller"].ToString(), User.Identity.Name, AppID);
if (val.ReadFlag == true)
{
ViewBag.WriteFlag = val.WriteFlag;
return(View(PBL.WeeklyProgram().ToList()));
}
else
{
ViewBag.Mensaje = "Usted no tiene accesso a este sección, solicítelo a un administrador.";
return(View("~/Views/Shared/Error.cshtml"));
}
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
// GET: MusicHome
public ActionResult Index()
{
if (Request.IsAuthenticated)
{
ControllerDirectory val = CDBL.Validation(this.ControllerContext.RouteData.Values["controller"].ToString(), User.Identity.Name, AppID);
if (val.ReadFlag == true)
{
var data = from p in WebBL.ProfilebyUser(User.Identity.Name, AppID)
select p.MainClass;
var FinalData = data.Distinct();
List <WebDirectory> MainMenu = new List <WebDirectory>();
foreach (var item in FinalData)
{
WebDirectory r = new WebDirectory();
r.ProfileID = Convert.ToInt32(MainMenu.Count()) + 2;
r.MainClass = item;
MainMenu.Add(r);
}
return(View(MainMenu.ToList()));
}
else
{
ViewBag.Mensaje = "Usted no tiene accesso a este sección, solicítelo a un administrador.";
return(View("~/Views/Shared/Error.cshtml"));
}
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
static void Main(string[] args)
{
_lockObject = new object();
_queue = new ConcurrentQueue <IScriptInput>();
_event = new AutoResetEvent(false);
_queue.Enqueue(new ScriptInput(new ControlEvent[0]));
using (_keyboardPlugin = new KeyboardPlugin())
using (_ps3Plugin = new Ps3Plugin())
using (_vJoyPlugin = new VJoyPlugin())
using (_xInputPlugin = new XInputPlugin())
{
_keyboardPlugin.ControlEvent += OnControlEvent;
_keyboardPlugin.ControlEvents += OnControlEvents;
_ps3Plugin.ControlEvent += OnControlEvent;
_ps3Plugin.ControlEvents += OnControlEvents;
_xInputPlugin.ControlEvent += OnControlEvent;
_xInputPlugin.ControlEvents += OnControlEvents;
var serviceProvider = new DefaultJsPieServiceProvider();
serviceProvider.Register <IScriptConsole>(() => new ScriptConsole(ScriptSeverity.Info));
var settings = new ScriptEngineSettings(args.Length > 0 ? args[0] : "D:\\Development\\JsPie\\test.js");
serviceProvider.Register(() => settings);
var directory = new ControllerDirectory(
new IInputPlugin[] { _keyboardPlugin, _ps3Plugin, _xInputPlugin }.SelectMany(p => p.GetControllers()),
new IOutputPlugin[] { _keyboardPlugin, _vJoyPlugin }.SelectMany(p => p.GetControllers()));
serviceProvider.Register(() => directory);
_serviceProvider = serviceProvider;
_scriptTask = Task.Factory.StartNew(Run);
Application.Run();
}
}
public ControllerDirectory Validation(string UserName, string ControllerName, int AppID)
{
ControllerDirectory validation = new ControllerDirectory();
try
{
using (var SqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_MDA_CR_OA_Connection"].ToString()))
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[adm].[uspSearchControllerValidation]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
//Insert Parameters
SqlParameter ParAppName = new SqlParameter
{
ParameterName = "@AppID",
SqlDbType = SqlDbType.Int,
Value = AppID
};
SqlCmd.Parameters.Add(ParAppName);
SqlParameter ParController = new SqlParameter
{
ParameterName = "@ControllerName",
SqlDbType = SqlDbType.VarChar,
Size = 50,
Value = ControllerName
};
SqlCmd.Parameters.Add(ParController);
SqlParameter ParUserName = new SqlParameter
{
ParameterName = "@UserName",
SqlDbType = SqlDbType.VarChar,
Size = 50,
Value = UserName
};
SqlCmd.Parameters.Add(ParUserName);
using (var dr = SqlCmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
validation.CTRRightID = Convert.ToInt32(dr["CTRRightID"]);
validation.ControllerID = Convert.ToInt32(dr["ControllerID"]);
validation.ControllerName = dr["ControllerName"].ToString();
validation.ReadFlag = Convert.ToBoolean(dr["ReadFlag"]);
validation.WriteFlag = Convert.ToBoolean(dr["WriteFlag"]);
}
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
}
}
catch (Exception ex)
{
throw;
}
return(validation);
}
// GET: Preaches
public ActionResult Index(string sortOrder, string currentFilter, string searchString, int?page)
{
if (Request.IsAuthenticated)
{
ControllerDirectory val = CDBL.Validation(this.ControllerContext.RouteData.Values["controller"].ToString(), User.Identity.Name, AppID);
if (val.ReadFlag == true)
{
ViewBag.WriteFlag = val.WriteFlag;
ViewBag.CurrentSort = sortOrder;
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "name_asc";
ViewBag.DateSortParm = sortOrder == "Date" ? "date_asc" : "Date";
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
var preaches = from s in PBL.List()
select s;
if (!String.IsNullOrEmpty(searchString))
{
preaches = preaches.Where(s => s.Description.Contains(searchString) ||
s.Tags.Contains(searchString) ||
s.Title.Contains(searchString));
}
switch (sortOrder)
{
case "name_desc":
preaches = preaches.OrderByDescending(s => s.Title);
break;
case "name_asc":
preaches = preaches.OrderBy(s => s.Title);
break;
case "date_asc":
preaches = preaches.OrderBy(s => s.PreachingDate);
break;
default:
preaches = preaches.OrderByDescending(s => s.PreachingDate);
break;
}
int pageSize = 10;
int pageNumber = (page ?? 1);
return(View(preaches.ToPagedList(pageNumber, pageSize)));
}
else
{
ViewBag.Mensaje = "Usted no tiene accesso a este sección, solicítelo a un administrador.";
return(View("~/Views/Shared/Error.cshtml"));
}
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
