public Task SaveAsync(IEnumerable <IEvent> events)
{
return(Task.Run(() =>
{
SavedEvents.AddRange(events);
}));
}
protected void Button1_Click(object sender, EventArgs e)
{
SavedEvents Seve = new SavedEvents();
Seve = new SavedEvents(Username, EventId, Eventlbl.Text, DescriptionLbl.Text, Convert.ToDateTime(EventDatelbl.Text), EventLocationlbl.Text, Maintypelbl.Text, Secondtypelbl.Text);
int result = Seve.FavouriteEvent();
}
public List <SavedEvents> selectfavorties(string username)
{
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
string sqlStmt = "Select * from SavedEvents where username = @parausername";
SqlDataAdapter da = new SqlDataAdapter(sqlStmt, myConn);
da.SelectCommand.Parameters.AddWithValue("@parausername", username);
DataSet ds = new DataSet();
da.Fill(ds);
List <SavedEvents> favouritelist = new List <SavedEvents>();
int rec_cnt = ds.Tables[0].Rows.Count;
for (int i = 0; i < rec_cnt; i++)
{
DataRow row = ds.Tables[0].Rows[i]; // Sql command returns only one record
string Username = row["username"].ToString();
string eventsid = row["eventsid"].ToString();
string eventname = row["eventname"].ToString();
string eventdescription = row["eventdescription"].ToString();
DateTime eventdate = Convert.ToDateTime(row["eventdate"]);
string maintype = row["maintype"].ToString();
string secondtype = row["secondtype"].ToString();
string location = row["location"].ToString();;
SavedEvents obj = new SavedEvents(username, eventsid, eventname, eventdescription, eventdate, location, maintype, secondtype);
favouritelist.Add(obj);
}
return(favouritelist);
}
public int FavEvent(SavedEvents Seve)
{
// Execute NonQuery return an integer value
int result = 0;
SqlCommand sqlCmd = new SqlCommand();
string DBConnect = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
SqlConnection myConn = new SqlConnection(DBConnect);
string sqlStmt = "INSERT INTO SavedEvents ( username, eventsid,eventname,eventdescription,eventdate,location,maintype,secondtype) " +
"VALUES (@parausername,@paraeventsid,@paraeventName,@paraeventDesc,@paraeventdate,@paraeventlocation,@paramaintype,@parasecondtype)";
sqlCmd = new SqlCommand(sqlStmt, myConn);
sqlCmd.Parameters.AddWithValue("@parausername", Seve.Username);
sqlCmd.Parameters.AddWithValue("@paraeventsid", Seve.EventsId);
sqlCmd.Parameters.AddWithValue("@paraeventName", Seve.eventName);
sqlCmd.Parameters.AddWithValue("@paraeventDesc", Seve.eventDescription);
sqlCmd.Parameters.AddWithValue("@paraeventdate", Seve.eventDate);
sqlCmd.Parameters.AddWithValue("@paraeventlocation", Seve.Location);
sqlCmd.Parameters.AddWithValue("@paramaintype", Seve.MainType);
sqlCmd.Parameters.AddWithValue("@parasecondtype", Seve.SecondType);
myConn.Open();
result = sqlCmd.ExecuteNonQuery();
myConn.Close();
return(result);
}
public Task SaveAsync()
{
SavedEvents.AddRange(unrecordedEvents);
unrecordedEvents.Clear();
return(Task.CompletedTask);
}
public void Reset()
{
QueryEvents.Clear();
SavedEvents.Clear();
ModifiedEvents.Clear();
DeletedEvents.Clear();
AddedEvents.Clear();
}
private void RefreshGridView()
{
if (Session["userName"].ToString() != null)
{
SavedEvents seve = new SavedEvents();
fList = seve.AllFavourites(Session["userName"].ToString());
FavouriteGV.Visible = true;
FavouriteGV.DataSource = fList;
FavouriteGV.DataBind();
}
else
{
ErrorLabel.Text = "Please log in to view your saved events.";
}
}
public virtual void Save(Type aggregateRootType, IEvent <ISingleSignOnToken> @event)
{
SavedEvents.Add(@event);
}
public Task Save(Guid aggregateId, int?expectedVersion, IEnumerable <IEvent> events)
{
SavedEvents.AddRange(events);
return(Task.CompletedTask);
}
public void Save(IEvent @event)
{
SavedEvents.Add(@event);
}
public Task Save(IEnumerable <IEvent> events, CancellationToken cancellationToken = default)
{
Token = cancellationToken;
SavedEvents.AddRange(events);
return(Task.CompletedTask);
}
public Task SaveAsync(IEvent @event)
{
SavedEvents.Add(@event);
return(Task.FromResult(0));
}
public void Save <T>(IEnumerable <IEvent> events)
{
SavedEvents.AddRange(events);
}
public Task Save <T>(IEnumerable <IEvent> events)
{
SavedEvents.AddRange(events);
return(Task.CompletedTask);
}
public void Save(Guid aggregateId, Event eventDescriptor)
{
SavedEvents.Add(eventDescriptor);
}
