public ActionResult suggest(int UserId)
{
var lb = new suggestion();
lb.UserId = UserId;
return(View(lb));
}
public ActionResult DeleteConfirmed(int id)
{
suggestion suggestion = db.suggestions.Find(id);
db.suggestions.Remove(suggestion);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult Reject(int id, suggestion bookk)
{
Library db = new Library();
db.Reject(bookk.SuggestionId);
return(RedirectToAction("viewsuggestion"));
}
public ActionResult Edit([Bind(Include = "sId,email,suggest")] suggestion suggestion)
{
if (ModelState.IsValid)
{
db.Entry(suggestion).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(suggestion));
}
public IActionResult suggest(suggestion su)
{
if (ModelState.IsValid)
{
Library libb = new Library();
libb.suggest(su);
}
return(View(su));
}
public int InsertNewSuggestion(string suggestion)
{
var user = GetCurrentUserContext();
var dbSuggestion = new suggestion();
dbSuggestion.description = suggestion;
dbSuggestion.details = user.Name;
dbSuggestion.user = user.EmailId;
var result = _userRepository.AddSuggestion(dbSuggestion);
return(result);
}
/// <summary>
/// suggestion
/// </summary>
/// <param name="query"></param>
/// <returns>only song names</returns>
public async override Task <SongSuggestionContent> GetSongSuggestionAsync(string query)
{
return(await this.GetResponse(new SongSuggestionContent(), SearchMethod.Suggestion(query), (o) =>
{
if (o.HasError)
{
return;
}
suggestion suggestion = (suggestion)JsonConvert.DeserializeObject(o.Value, typeof(suggestion));
o.Query = suggestion.query;
o.Items = suggestion.suggestion_list;
}));
}
public ActionResult Edit([Bind(Include = "ID_suggestion,createdby,createdon,ID_status,category,ID_section,ID_severity,title,priority,acceptedon,duedate,resolvedon,ticketno,steps, resolve")] suggestion suggestion)
{
if (ModelState.IsValid)
{
db.Entry(suggestion).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID_section = new SelectList(db.sections, "ID_section", "sectionname", suggestion.ID_section);
ViewBag.ID_severity = new SelectList(db.severities, "ID_severity", "name_severity", suggestion.ID_severity);
ViewBag.ID_status = new SelectList(db.status, "ID_status", "name", suggestion.ID_status);
return(View(suggestion));
}
// GET: suggestions/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
suggestion suggestion = db.suggestions.Find(id);
if (suggestion == null)
{
return(HttpNotFound());
}
return(View(suggestion));
}
public IActionResult Approve(int id, suggestion bookk)
{
Library db = new Library();
db.Approve(bookk.SuggestionId);
suggestion newbookk = new suggestion();
newbookk.BookAuthor = bookk.BookAuthor;
newbookk.BookName = bookk.BookName;
newbookk.BookPublishedYear = Convert.ToInt32(bookk.BookPublishedYear);
newbookk.BookCategory = bookk.BookCategory;
return(RedirectToAction("viewsuggestion"));
}
public ActionResult Approve(int id)
{
suggestion bookk = new suggestion();
var count = bookslist.Count();
for (int i = 0; i < count; i++)
{
if (bookslist[i].SuggestionId == id)
{
bookk = bookslist[i];
break;
}
}
return(View(bookk));
}
public ActionResult Create([Bind(Include = "sId,email,suggest")] suggestion suggestion)
{
if (ModelState.IsValid)
{
db.suggestions.Add(suggestion);
db.SaveChanges();
try
{
if (ModelState.IsValid)
{
var senderEmail = new MailAddress("*****@*****.**", "Tanuj DOshi");
var receiverEmail = new MailAddress(suggestion.email, "Receiver");
var password = "******";
var sub = "Thank You for your suggestion";
var body = "Thank you For Suggestion " + suggestion.suggest + "We are back with this very soon!!";
var smtp = new SmtpClient
{
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(senderEmail.Address, password)
};
using (var mess = new MailMessage(senderEmail, receiverEmail)
{
Subject = "Thank you",
Body = body
})
{
smtp.Send(mess);
}
Response.Write("<script>alert('Please Login Firs')</script>");
return(View());
}
}
catch (Exception)
{
ViewBag.Error = "Some Error";
}
return(RedirectToAction("Index"));
}
return(View(suggestion));
}
// GET: suggestions/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
suggestion suggestion = db.suggestions.Find(id);
if (suggestion == null)
{
return(HttpNotFound());
}
ViewBag.ID_section = new SelectList(db.sections, "ID_section", "sectionname", suggestion.ID_section);
ViewBag.ID_severity = new SelectList(db.severities, "ID_severity", "name_severity", suggestion.ID_severity);
ViewBag.ID_status = new SelectList(db.status, "ID_status", "name", suggestion.ID_status);
return(View(suggestion));
}
public ActionResult Contact(suggestion suggestion)
{
if (ModelState.IsValid)
{
if (suggestion.Name == null)
{
ModelState.AddModelError("Name", "Please Enter Your Name");
return(View());
}
}
try
{
mv.suggestions.Add(suggestion);
mv.SaveChanges();
ModelState.Clear();
return(View());
}
catch (Exception)
{
return(View());
}
}
public VenueSuggResult venueCreate(VenueSuggRequest venueSugg)
{
try
{
if (!verifyUser(venueSugg.connectionId))
return new VenueSuggResult() { code = 0 };
var userId = (from u in _entity.connections where u.connection_id == venueSugg.connectionId select u).FirstOrDefault();
suggestion s1 = new suggestion()
{
created = DateTime.Now,
event_id = venueSugg.eventId,
user_id = userId.user_id
};
_entity.suggestions.Add(s1);
_entity.SaveChanges();
var lastId = s1.id;
_entity.venue_suggestions.Add(new venue_suggestions()
{
address = venueSugg.address,
coordinates = venueSugg.coordinates,
description = venueSugg.description,
venue = venueSugg.venue,
suggestion_id = lastId
});
_entity.SaveChanges();
var context = GlobalHost.ConnectionManager.GetHubContext<TitanHub>();
var collabos = (from c in _entity.collaborators where c.event_id == venueSugg.eventId select c.user_id).ToList();
foreach (var id1 in _entity.connections)
{
if(collabos.Contains(id1.user_id))
{
context.Clients.Client(id1.connection_id).ReloadEventDetails(venueSugg.eventId);
TitanSync.NotifyClient(id1.connection_id, "New Venue Suggestion Added!", userId.user.name);
}
}
return new VenueSuggResult()
{
code = 1,
address = venueSugg.address,
coordinates = venueSugg.coordinates,
description = venueSugg.description,
suggestionId = lastId,
venue = venueSugg.venue
};
}
catch (Exception)
{
return new VenueSuggResult() { code = 0 };
}
}
public int AddSuggestion(suggestion suggestion)
{
var suggestions = Context.Set <suggestion>().Add(suggestion);
return(Context.SaveChanges());
}
