public int AddNew(Sermons NewMS, string InserUser)
{
int rpta = 0;
try
{
DynamicParameters Parm = new DynamicParameters();
Parm.Add("@InsertUser", InserUser);
Parm.Add("@Title", NewMS.Title.Trim());
Parm.Add("@Description", NewMS.Description.Trim());
Parm.Add("@Banner", NewMS.BannerPath);
Parm.Add("@Tags", NewMS.Tags.Trim());
Parm.Add("@SermonDate", NewMS.SermonDate);
Parm.Add("@SermonURL", NewMS.SermonURL.Trim());
Parm.Add("@MinisterID", NewMS.MinisterID);
SqlCon.Open();
//SqlCon.Execute("[adm].[uspAddSermon]", Parm, commandType: CommandType.StoredProcedure);
rpta = Convert.ToInt32(SqlCon.ExecuteScalar <int>("[adm].[uspAddSermon]", Parm, commandType: CommandType.StoredProcedure));
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(rpta);
}
private void RibbonWindow_Loaded(object sender, RoutedEventArgs e)
{
config = new Config();
if (!config.sermon_folder_set) {
}
sermons = new Sermons();
}
public List <Sermons> List(bool ActiveFlag)
{
List <Sermons> List = new List <Sermons>();
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[config].[uspReadSermons]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
if (ActiveFlag == true)
{
SqlParameter pActiveFlag = new SqlParameter
{
ParameterName = "@ActiveFlag",
SqlDbType = SqlDbType.Bit,
Value = ActiveFlag
};
SqlCmd.Parameters.Add(pActiveFlag);
}
using (var dr = SqlCmd.ExecuteReader())
{
while (dr.Read())
{
var detail = new Sermons
{
SermonID = Convert.ToInt32(dr["SermonID"]),
Title = dr["Title"].ToString(),
Description = dr["Description"].ToString(),
Tags = dr["Tags"].ToString(),
MinisterID = Convert.ToInt32(dr["MinisterID"]),
MinisterName = dr["MinisterName"].ToString(),
SermonDate = Convert.ToDateTime(dr["SermonDate"]),
SermonURL = dr["SermonURL"].ToString(),
BannerPath = dr["ImagePath"].ToString(),
ActiveFlag = Convert.ToBoolean(dr["ActiveFlag"]),
};
List.Add(detail);
}
}
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(List);
}
public Sermons Details(int NewID)
{
Sermons details = new Sermons();
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[config].[uspReadSermons]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
SqlParameter pNewID = new SqlParameter
{
ParameterName = "@SermonID",
SqlDbType = SqlDbType.Int,
Value = NewID
};
SqlCmd.Parameters.Add(pNewID);
using (var dr = SqlCmd.ExecuteReader())
{
dr.Read();
if (dr.HasRows)
{
details.SermonID = Convert.ToInt32(dr["SermonID"]);
details.Title = dr["Title"].ToString();
details.Description = dr["Description"].ToString();
details.Tags = dr["Tags"].ToString();
details.BannerPath = dr["ImagePath"].ToString();
details.ActiveFlag = Convert.ToBoolean(dr["ActiveFlag"]);
details.SermonDate = Convert.ToDateTime(dr["SermonDate"]);
details.SermonURL = dr["SermonURL"].ToString();
details.MinisterID = Convert.ToInt32(dr["MinisterID"]);
details.MinisterName = dr["MinisterName"].ToString();
}
}
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(details);
}
public HttpResponseMessage Update([FromBody] Sermons model)
{
var authHeader = this.Request.Headers.GetValues("Authorization").FirstOrDefault();
var token = authHeader.Substring("Bearer ".Length);
var handler = new JwtSecurityTokenHandler();
var jsonToken = handler.ReadToken(token);
var tokenS = handler.ReadToken(token) as JwtSecurityToken;
var UserName = tokenS.Claims.First(claim => claim.Type == "UserName").Value;
var r = SBL.Update(model, UserName);
if (!r)
{
return(this.Request.CreateResponse(HttpStatusCode.InternalServerError));
}
else
{
return(this.Request.CreateResponse(HttpStatusCode.OK, r));
}
}
public bool Update(Sermons NewMS, string InsertUser)
{
bool rpta;
try
{
SqlCon.Open();
var SqlCmd = new SqlCommand("[adm].[uspUpdateSermon]", SqlCon)
{
CommandType = CommandType.StoredProcedure
};
//Insert Parameters
SqlParameter pSermonID = new SqlParameter
{
ParameterName = "@SermonID",
SqlDbType = SqlDbType.Int,
Value = NewMS.SermonID
};
SqlCmd.Parameters.Add(pSermonID);
SqlParameter pInsertUser = new SqlParameter
{
ParameterName = "@User",
SqlDbType = SqlDbType.VarChar,
Size = 100,
Value = InsertUser
};
SqlCmd.Parameters.Add(pInsertUser);
SqlParameter pSermonDate = new SqlParameter
{
ParameterName = "@SermonDate",
SqlDbType = SqlDbType.DateTime,
Value = NewMS.SermonDate
};
SqlCmd.Parameters.Add(pSermonDate);
if (!string.IsNullOrEmpty(NewMS.Title))
{
SqlParameter pTitle = new SqlParameter
{
ParameterName = "@Title",
SqlDbType = SqlDbType.VarChar,
Size = 100,
Value = NewMS.Title.Trim()
};
SqlCmd.Parameters.Add(pTitle);
SqlParameter pDescription = new SqlParameter
{
ParameterName = "@Description",
SqlDbType = SqlDbType.VarChar,
Value = NewMS.Description.Trim()
};
SqlCmd.Parameters.Add(pDescription);
SqlParameter Photo = new SqlParameter
{
ParameterName = "@Banner",
SqlDbType = SqlDbType.VarChar,
Size = 500,
Value = NewMS.BannerPath
};
SqlCmd.Parameters.Add(Photo);
SqlParameter pMinisterID = new SqlParameter
{
ParameterName = "@MinisterID",
SqlDbType = SqlDbType.Int,
Value = NewMS.MinisterID
};
SqlCmd.Parameters.Add(pMinisterID);
SqlParameter pTags = new SqlParameter
{
ParameterName = "@Tags",
SqlDbType = SqlDbType.VarChar,
Value = NewMS.Tags.Trim()
};
SqlCmd.Parameters.Add(pTags);
}
//EXEC Command
SqlCmd.ExecuteNonQuery();
rpta = true;
}
catch (Exception ex)
{
throw ex;
}
if (SqlCon.State == ConnectionState.Open)
{
SqlCon.Close();
}
return(rpta);
}
public HttpResponseMessage AddNew([FromBody] Sermons model)
{
var authHeader = this.Request.Headers.GetValues("Authorization").FirstOrDefault();
var token = authHeader.Substring("Bearer ".Length);
var handler = new JwtSecurityTokenHandler();
var jsonToken = handler.ReadToken(token);
var tokenS = handler.ReadToken(token) as JwtSecurityToken;
var UserName = tokenS.Claims.First(claim => claim.Type == "UserName").Value;
var r = SBL.AddNew(model, UserName);
if (r > 0)
{
#region Email
SermonEmail Res = SBL.DetailsForEmail(r);
MailAddressCollection emailtoBCC = new MailAddressCollection();
List <Users> Subscribers = USBL.Subscribers(0, true);
if (Subscribers.Count() > 0)
{
foreach (var item in Subscribers)
{
emailtoBCC.Add(item.Email);
}
}
string body = string.Empty;
using (StreamReader reader = new StreamReader(HttpContext.Current.Server.MapPath("~/Views/EmailTemplates/NewSermons.html")))
{
body = reader.ReadToEnd();
}
body = body.Replace("{Title}", Res.Title);
body = body.Replace("{MinisterName}", Res.MinisterName);
body = body.Replace("{Description}", Res.Description);
Emails Email = new Emails()
{
FromEmail = ConfigurationManager.AppSettings["AdminEmail"].ToString(),
ToEmail = ConfigurationManager.AppSettings["Subscribers"].ToString(),
SubjectEmail = "Oasis Alajuela ha subido una Prédica",
BodyEmail = body
};
MailMessage mm = new MailMessage(Email.FromEmail, Email.ToEmail)
{
Subject = Email.SubjectEmail,
Body = Email.BodyEmail,
IsBodyHtml = true,
BodyEncoding = Encoding.GetEncoding("utf-8")
};
if (Subscribers.Count() > 0)
{
mm.Bcc.Add(emailtoBCC.ToString());
}
SmtpClient smtp = new SmtpClient();
smtp.Send(mm);
#endregion
return(this.Request.CreateResponse(HttpStatusCode.OK, true));
}
else
{
return(this.Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
public bool Update(Sermons ms, string insertuser)
{
return(SDAL.Update(ms, insertuser));
}
public int AddNew(Sermons ms, string insertuser)
{
return(SDAL.AddNew(ms, insertuser));
}
