public ActionResult Create([Bind(Include = "SectionName,SectionDescription,Visible,Created,Modified,CreatedBy,ModifiedBy,NewsLetterID")] Section section)
{
if (ModelState.IsValid)
{
section.Created = DateTime.Now;
section.CreatedBy = User.Identity.Name;
section.Modified = DateTime.Now;
section.ModifiedBy = User.Identity.Name;
db.Sections.Add(section);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.NewsLetterID = new SelectList(db.NewsLetters, "NewsLetterID", "Name", section.NewsLetterID);
return(View(section));
}
public ActionResult Create([Bind(Include = "NewsItemName,NewsItemDescription,ActualLink,Visible,Created,Modified,CreatedBy,ModifiedBy,SectionID")] NewsItem newsItem)
{
if (ModelState.IsValid)
{
newsItem.Created = DateTime.Now;
newsItem.CreatedBy = User.Identity.Name;
newsItem.Modified = DateTime.Now;
newsItem.ModifiedBy = User.Identity.Name;
db.NewsItems.Add(newsItem);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SectionID = new SelectList(db.Sections, "SectionID", "SectionName", newsItem.SectionID);
return(View(newsItem));
}
public ActionResult Create([Bind(Include = "NewsLetterID,Name,Description,Visible,Created,Modified,CreatedBy,ModifiedBy,TenantID")] NewsLetter newsLetter)
{
if (ModelState.IsValid)
{
newsLetter.CreatedBy = User.Identity.Name;
newsLetter.ModifiedBy = User.Identity.Name;
newsLetter.Created = DateTime.Now;
newsLetter.Modified = DateTime.Now;
db.NewsLetters.Add(newsLetter);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.TenantID = new SelectList(db.Tenants, "TenantID", "TenantName", newsLetter.TenantID);
return(View(newsLetter));
}
public ActionResult Unsubscribe(int Id)
{
using (NewsLetterEntities db = new NewsLetterEntities())
{
var signup = db.SignUps.Find(Id);
signup.Removed = DateTime.Now;
db.SaveChanges();
}
return RedirectToAction("Index");
}
// GET: Tenants/Create
public ActionResult Create()
{
DatabaseContext.Tenant tenant = new Tenant();
if (true)
{
Models.Tenant tenantModel = ClaimsIdentityExtensions.GetTenant();
tenant.TenantID = tenantModel.TenantID;
tenant.TenantName = tenantModel.TenantName;
tenant.ClientID = Startup.clientId;
tenant.ClientSecret = new Startup().appKey;
tenant.URL = tenantModel.TenantDomain;
tenant.Modified = DateTime.Now.Date;
tenant.Created = DateTime.Now.Date;
tenant.CreateBy = User.Identity.Name;
tenant.ModifiedBy = User.Identity.Name;
db.Tenants.Add(tenant);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult SignUp(string firstName, string lastName, string emailAddress)
{
if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) || string.IsNullOrEmpty(emailAddress))
{
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
using (NewsLetterEntities db = new NewsLetterEntities())
{
var signup = new SignUp();
signup.FirstName = firstName;
signup.LastName = lastName;
signup.EmailAddress = emailAddress;
db.SignUps.Add(signup);
db.SaveChanges();
}
//string queryString = @"INSERT INTO SignUps (FirstName, LastName, EmailAddress) VALUES
// (@FirstName, @LastName, @EmailAddress)";
//using (SqlConnection connection = new SqlConnection(connectionString))
//{
// SqlCommand command = new SqlCommand(queryString, connection);
// command.Parameters.Add("@FirstName", SqlDbType.VarChar);
// command.Parameters.Add("@LastName", SqlDbType.VarChar);
// command.Parameters.Add("@EmailAddress", SqlDbType.VarChar);
// command.Parameters["@FirstName"].Value = firstName;
// command.Parameters["@LastName"].Value = lastName;
// command.Parameters["@EmailAddress"].Value = emailAddress;
// connection.Open();
// command.ExecuteNonQuery();
// connection.Close();
//}
return(View("Success"));
}
}
public ActionResult SignUp(string firstName, string lastName, string emailAddress)
{
if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) || string.IsNullOrEmpty(emailAddress))
{
return(View("~/Views/Shared/Errors.cshtml"));
}
else
{
using (NewsLetterEntities db = new NewsLetterEntities())
{
var signup = new SignUp();
signup.FirstName = firstName;
signup.LastName = lastName;
signup.EmailAddress = emailAddress;
db.SignUps.Add(signup);
db.SaveChanges();
}
return(View("Success"));
}
}