public Preaches Details(int PreachID)
{
Preaches Preach = new Preaches();
try
{
using (var SqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_MDA_CR_OA_Connection"].ToString()))
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[ministry].[uspSearchPreach]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
//Insert Parameters
SqlParameter ParID = new SqlParameter
{
ParameterName = "@PreachID",
SqlDbType = SqlDbType.Int,
Value = PreachID
};
SqlCmd.Parameters.Add(ParID);
using (var dr = SqlCmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
Preach.PreachID = Convert.ToInt32(dr["PreachID"]);
Preach.MinisterID = Convert.ToInt32(dr["MinisterID"]);
Preach.MinisterName = dr["MinisterName"].ToString();
Preach.Title = dr["Title"].ToString();
Preach.Description = dr["Description"].ToString();
Preach.Tags = dr["Tags"].ToString();
Preach.FileData = (byte[])(dr["FileData"]);
Preach.FileType = dr["FileType"].ToString();
Preach.PreachingDate = Convert.ToDateTime(dr["PreachingDate"]);
Preach.SubmittedDate = Convert.ToDateTime(dr["InsertDate"]);
}
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
}
}
catch (Exception ex)
{
throw;
}
return(Preach);
}
//
// GET: /Authors/Create
public ActionResult Create()
{
if (Request.IsAuthenticated)
{
Preaches Preach = new Preaches();
Preach.MinistersList = MBL.List();
return(View(Preach));
}
else
{
return(this.RedirectToAction("Login", "Account"));
}
}
public List <Preaches> List()
{
List <Preaches> List = new List <Preaches>();
try
{
using (var SqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_MDA_CR_OA_Connection"].ToString()))
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[ministry].[uspReadPreaches]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
using (var dr = SqlCmd.ExecuteReader())
{
while (dr.Read())
{
var preach = new Preaches
{
PreachID = Convert.ToInt32(dr["PreachID"]),
MinisterID = Convert.ToInt32(dr["MinisterID"]),
MinisterName = dr["MinisterName"].ToString(),
Title = dr["Title"].ToString(),
Description = dr["Description"].ToString(),
Tags = dr["Tags"].ToString(),
//FileData = (byte[])(dr["FileData"]),
PreachingDate = Convert.ToDateTime(dr["PreachingDate"])
};
List.Add(preach);
}
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
}
}
catch (Exception ex)
{
throw;
}
return(List);
}
public ActionResult Create(Preaches Preach)
{
String FileExt = Path.GetExtension(Preach.files.FileName).ToUpper();
if (FileExt == ".MP3" || FileExt == ".MP4")
{
Stream str = Preach.files.InputStream;
BinaryReader Br = new BinaryReader(str);
byte[] FileDet = Br.ReadBytes((int)str.Length);
Preach.FileData = FileDet;
Preach.FileType = FileExt;
string InsertUser = User.Identity.GetUserName();
Preach.Tags = Preach.Tags.Replace(",", ", ");
var r = PBL.AddNew(Preach, InsertUser);
if (!r)
{
ViewBag.Mensaje = "Ha ocurrido un error inesperado.";
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
Preach.ActionType = "CREATE";
Preach.MinistersList = MBL.List();
return(View(Preach));
}
}
else
{
ViewBag.FileStatus = "Archivo de formato Invalido, solo es permitido subir audios MP3 o videos MP4.";
return(View());
}
}
public bool AddNew(Preaches Preach, string InsertUser)
{
bool rpta = false;
try
{
DynamicParameters Parm = new DynamicParameters();
Parm.Add("@InsertUser", InsertUser);
Parm.Add("@MinisterID", Preach.MinisterID);
Parm.Add("@Title", Preach.Title);
Parm.Add("@Description", Preach.Description);
Parm.Add("@Tags", Preach.Tags);
Parm.Add("@FileData", Preach.FileData);
Parm.Add("@FileType", Preach.FileType);
Parm.Add("@Date", Preach.PreachingDate);
var SqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_MDA_CR_OA_Connection"].ToString());
SqlCon.Open();
SqlCon.Execute("[ministry].[uspAddPreach]", Parm, commandType: CommandType.StoredProcedure);
rpta = true;
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
}
catch (Exception ex)
{
throw;
}
return(rpta);
}
public bool AddNew(Preaches preach, string insertuser)
{
return(PDAL.AddNew(preach, insertuser));
}
