public ActionResult CreatebySong(MusicSheets MS)
{
String FileExt = Path.GetExtension(MS.files.FileName).ToUpper();
if (FileExt == ".PDF")
{
Stream str = MS.files.InputStream;
BinaryReader Br = new BinaryReader(str);
Byte[] FileDet = Br.ReadBytes((Int32)str.Length);
MS.FileName = MS.files.FileName;
MS.FileData = FileDet;
string InsertUser = User.Identity.GetUserName();
var r = MSBL.AddNew(MS, InsertUser);
if (!r)
{
ViewBag.Mensaje = "Ha ocurrido un error inesperado.";
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
return(RedirectToAction("MusicSheetsbySong", new { SongID = MS.SongID }));
}
}
else
{
ViewBag.FileStatus = "Archivo de formato Invalido.";
return(View());
}
}
public ActionResult CreatebySong(int SongID)
{
if (Request.IsAuthenticated)
{
MusicSheets Chart = new MusicSheets();
var songlist = from s in SongsBL.SongList()
where s.SongID == SongID
select s;
Chart.SongID = SongID;
Chart.SongList = songlist.ToList();
Chart.MSTypeList = MSTBL.MSTypeList().ToList();
Chart.InstrumentList = IBL.InstrumentList().ToList();
var SongName = from s in SongsBL.SongList()
where s.SongID == SongID
select s.SongName;
ViewBag.SongName = SongName.FirstOrDefault().ToString();
return(View(Chart));
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
public ActionResult AddVersion(int id = 0)
{
if ((Request.IsAuthenticated))
{
string InsertUser = User.Identity.GetUserName();
MusicSheets MS = MSBL.Details(id, InsertUser);
return(View(MS));
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
public ActionResult Vizor(int id = 0)
{
string InsertUser = User.Identity.GetUserName();
MusicSheets MS = MSBL.Details(id, InsertUser);
ViewBag.MSType = MS.MSTypesData.MSTypeName.ToString();
ViewBag.Instrument = MS.InstrumentsData.Instrument.ToString();
ViewBag.SongName = MS.SongsData.SongName.ToString();
ViewBag.Label = MS.MSTypesData.MSTypeName.ToString() + " para " + MS.InstrumentsData.Instrument.ToString() + " de " + MS.SongsData.SongName.ToString();
ViewBag.ID = id;
return(View());
}
public ActionResult AddVersion(MusicSheets MS)
{
string InsertUser = User.Identity.GetUserName();
var r = MSBL.Update(MS, InsertUser);
if (!r)
{
ViewBag.Mensaje = "Ha ocurrido un error inesperado.";
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
MS.ActionType = "CREATE";
return(View(MS));
}
}
public ActionResult Details(int id = 0)
{
if ((Request.IsAuthenticated))
{
string InsertUser = User.Identity.GetUserName();
MusicSheets MS = MSBL.Details(id, InsertUser);
MS.Version = MS.Version.Replace("https://youtu.be/", "https://www.youtube.com/embed/");
MS.Version = MS.Version.Replace("https://www.youtube.com/watch?v=", "https://www.youtube.com/embed/");
MS.Version = MS.Version.Replace("\"", "");
MS.Version = MS.Version + "?autoplay=1";
return(View(MS));
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
public ActionResult Create()
{
if (Request.IsAuthenticated)
{
MusicSheets Chart = new MusicSheets();
Chart.SongList = SongsBL.SongList().ToList();
Chart.MSTypeList = MSTBL.MSTypeList().ToList();
Chart.InstrumentList = IBL.InstrumentList().ToList();
return(View(Chart));
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
public ActionResult ChangeFavorite(int id)
{
string InsertUser = User.Identity.GetUserName();
MusicSheets MS = MSBL.Details(id, InsertUser);
var r = MSBL.UpdateFavorite(id, InsertUser);
if (!r)
{
ViewBag.Mensaje = "Ha ocurrido un error inesperado.";
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
//ViewBag.SongID = MS.SongID;
return(this.RedirectToAction("MusicSheetsbySong", "MusicSheets", new { SongID = MS.SongID }));
//return View();
}
}
public ActionResult Create(MusicSheets MS)
{
String FileExt = Path.GetExtension(MS.files.FileName).ToUpper();
if (FileExt == ".PDF")
{
Stream str = MS.files.InputStream;
BinaryReader Br = new BinaryReader(str);
Byte[] FileDet = Br.ReadBytes((Int32)str.Length);
MS.FileName = MS.files.FileName;
MS.FileData = FileDet;
string InsertUser = User.Identity.GetUserName();
var r = MSBL.AddNew(MS, InsertUser);
if (!r)
{
ViewBag.Mensaje = "Ha ocurrido un error inesperado.";
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
MS.ActionType = "CREATE";
MS.SongList = SongsBL.SongList().ToList();
MS.MSTypeList = MSTBL.MSTypeList().ToList();
MS.InstrumentList = IBL.InstrumentList().ToList();
return(View(MS));
}
}
else
{
ViewBag.FileStatus = "Invalid file format.";
return(View());
}
}
public ActionResult Edit(int id = 0)
{
if ((Request.IsAuthenticated))
{
string InsertUser = User.Identity.GetUserName();
MusicSheets MS = MSBL.Details(id, InsertUser);
MS.SongList = SongsBL.SongList().ToList();
MS.MSTypeList = MSTBL.MSTypeList().ToList();
MS.InstrumentList = IBL.InstrumentList().ToList();
ViewBag.MSID = id;
return(View(MS));
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
public bool AddNew(MusicSheets musicSheets, string InserUser)
{
bool rpta = false;
try
{
DynamicParameters Parm = new DynamicParameters();
Parm.Add("@InsertUser", InserUser);
Parm.Add("@MSTypeID", musicSheets.MSTypeID);
Parm.Add("@SongID", musicSheets.SongID);
Parm.Add("@Version", musicSheets.Version);
Parm.Add("@InstrumentID", musicSheets.InstrumentID);
Parm.Add("@Tonality", musicSheets.Tonality);
Parm.Add("@FileName", musicSheets.FileName);
Parm.Add("@FileData", musicSheets.FileData);
var SqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_MDA_CR_OA_Connection"].ToString());
SqlCon.Open();
SqlCon.Execute("[music].[uspAddMusicSheet]", Parm, commandType: CommandType.StoredProcedure);
rpta = true;
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
}
catch (Exception ex)
{
throw;
}
return(rpta);
}
public bool Update(MusicSheets musicsheet, string insertuser)
{
return(MSDAL.Update(musicsheet, insertuser));
}
public bool AddNew(MusicSheets musicsheet, string insertuser)
{
return(MSDAL.AddNew(musicsheet, insertuser));
}
public MusicSheets Details(int MSID, string User)
{
MusicSheets Chart = new MusicSheets();
try
{
using (var SqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_MDA_CR_OA_Connection"].ToString()))
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[music].[uspSearchMusicSheet]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
//Insert Parameters
SqlParameter ParMSID = new SqlParameter
{
ParameterName = "@MSID",
SqlDbType = SqlDbType.Int,
Value = MSID
};
SqlCmd.Parameters.Add(ParMSID);
SqlParameter ParUser = new SqlParameter
{
ParameterName = "@User",
SqlDbType = SqlDbType.VarChar,
Size = 50,
Value = User
};
SqlCmd.Parameters.Add(ParUser);
using (var dr = SqlCmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
Chart.MSID = Convert.ToInt32(dr["MSID"]);
Chart.MSTypeID = Convert.ToInt32(dr["MSTypeID"]);
Chart.SongID = Convert.ToInt32(dr["SongID"]);
Chart.Version = dr["Version"].ToString();
Chart.InstrumentID = Convert.ToInt32(dr["InstrumentID"]);
Chart.Tonality = dr["Tonality"].ToString();
Chart.ActiveFlag = Convert.ToBoolean(dr["ActiveFlag"]);
Chart.Favorite = Convert.ToBoolean(dr["Favorite"]);
Chart.FileData = (byte[])(dr["FileData"]);
}
}
SqlCmd = new SqlCommand("[music].[uspSearchSong]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
SqlCmd.Parameters.AddWithValue("@SongID", Chart.SongID);
using (var dr = SqlCmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
Chart.SongsData.SongID = Convert.ToInt32(dr["SongID"]);
Chart.SongsData.SongName = dr["SongName"].ToString();
}
}
SqlCmd = new SqlCommand("[music].[uspSearchMSTypes]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
SqlCmd.Parameters.AddWithValue("@MSTypeID", Chart.MSTypeID);
using (var dr = SqlCmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
Chart.MSTypesData.MSTypeID = Convert.ToInt32(dr["MSTypeID"]);
Chart.MSTypesData.MSTypeName = dr["MSTypeName"].ToString();
}
}
SqlCmd = new SqlCommand("[music].[uspSearchInstrument]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
SqlCmd.Parameters.AddWithValue("@InstrumentID", Chart.InstrumentID);
using (var dr = SqlCmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
Chart.InstrumentsData.InstrumentID = Convert.ToInt32(dr["InstrumentID"]);
Chart.InstrumentsData.Instrument = dr["Instrument"].ToString();
}
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
}
}
catch (Exception ex)
{
throw;
}
return(Chart);
}
