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