protected void ServerRejectChange(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
try
{
HtmlButton thebutton = (HtmlButton)sender;
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
string theRow = "";
bool isVenue = false;
if (thebutton.Attributes["commArg"].ToString().ToLower() == "venue")
isVenue = true;
string rowID = "";
if (isVenue)
{
if (thebutton.Attributes["commandargument"].Contains("category"))
{
//THIS PART NOW TAKEN CARE OF BY REJECTCATEGORY METHOD
//rowID = thebutton.Attributes["commandargument"].Replace("category", "");
//theRow = rowID;
//string venueName = dat.GetData("SELECT * FROM Venues V, VenueCategoryRevisions VCR WHERE V.ID=VCR.VenueID AND VCR.ID=" + rowID).Tables[0].Rows[0]["Name"].ToString();
//string categoryName = dat.GetData("SELECT * FROM VenueCategoryRevisions VCR, VenueCategories VC " +
// "WHERE VC.CategoryID=VCR.CategoryID AND VCR.ID=" + rowID).Tables[0].Rows[0]["CategoryName"].ToString();
//dat.Execute("UPDATE VenueCategoryRevisions SET Approved='False' WHERE ID=" + rowID);
//DataSet dsRevision = dat.GetData("SELECT * FROM VenueCategoryRevisions VCR, Users U WHERE U.User_ID=VCR.modifierID AND VCR.ID=" + rowID);
//DataSet dsUser = dat.GetData("SELECT * FROM Users U WHERE User_ID=" + dsRevision.Tables[0].Rows[0]["modifierID"].ToString());
//string emailBody = "The category suggestion '" + categoryName + "' has been rejected for the venue '" + venueName +
// "' by the venue's author. <br/><br/> " +
// "To view the venue, please visit <a href=\"http://HippoHappenings.com/Venue.aspx?ID=" +
// dsRevision.Tables[0].Rows[0]["VenueID"].ToString() + "\">" + venueName + "</a>";
//dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
//System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
//dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "One of your changes has been rejected for venue: '" +
//venueName + "'");
//Literal lab = new Literal();
//lab.Text = "<div class=\"AddGreenLink\" style=\"float: right;margin-top: 20px; padding-bottom: 4px;height: 30px;\">You have rejected this change.</div>";
////Remove the 'Accept' button first
//thebutton.Page.Controls.RemoveAt(thebutton.Parent.Controls.IndexOf(thebutton) - 1);
////Put the label in place of the 'Reject' button
//thebutton.Parent.Controls.AddAt(thebutton.Parent.Controls.IndexOf(thebutton), lab);
////Then remove the 'Reject' button
//thebutton.Parent.Controls.Remove(thebutton);
}
else
{
string[] delim = { "reject" };
string[] tokens = thebutton.Attributes["commandargument"].Split(delim, StringSplitOptions.None);
rowID = tokens[0];
int columnNumber = int.Parse(tokens[1]);
dat.ApproveRejectChange("VenueRevisions", rowID, columnNumber-3, false);
theRow = rowID;
DataSet dsEventID = dat.GetData("SELECT * FROM VenueRevisions WHERE ID=" + rowID);
string eventID = dsEventID.Tables[0].Rows[0]["VenueID"].ToString();
string columnName = dsEventID.Tables[0].Columns[columnNumber].ColumnName;
string temp = dsEventID.Tables[0].Rows[0][columnName].ToString();
Literal lab = new Literal();
lab.Text = "<div class=\"Green12LinkNF\" style=\"float: right;margin-top: 20px; padding-bottom: 4px;height: 30px;\">You have rejected this change.</div>";
string venueName = dat.GetData("SELECT * FROM Venues V, VenueRevisions VCR WHERE V.ID=VCR.VenueID AND VCR.ID=" +
rowID).Tables[0].Rows[0]["Name"].ToString();
//string categoryName = dat.GetData("SELECT * FROM VenueRevisions VCR, VenueCategories VC " +
// "WHERE VC.CategoryID=VCR.CategoryID AND VCR.ID=" + rowID).Tables[0].Rows[0]["CategoryName"].ToString();
DataSet dsRevision = dat.GetData("SELECT * FROM VenueRevisions VCR, Users U WHERE U.User_ID=VCR.modifierID AND VCR.ID=" +
rowID);
DataSet dsUser = dat.GetData("SELECT * FROM Users U WHERE User_ID=" + dsRevision.Tables[0].Rows[0]["modifierID"].ToString());
string emailBody = "The submitted change for " + columnName + " has been rejected by the author of the venue. <br/><br/> " +
"To view these changes, please visit <a href=\"http://HippoHappenings.com/"+dat.MakeNiceName(venueName)+"_" + dsRevision.Tables[0].Rows[0]["VenueID"].ToString() + "_Venue\">" + venueName + "</a>";
if (!Request.IsLocal)
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "One of your changes has been rejected for venue: '" +
venueName + "'");
}
Label lab2 = new Label();
HtmlButton but2 = new HtmlButton();
but2 = (HtmlButton)thebutton.Parent.Controls[thebutton.Parent.Controls.IndexOf(thebutton) - 1];
but2.Parent.Controls.AddAt(but2.Parent.Controls.IndexOf(but2), lab2);
but2.Parent.Controls.Remove(but2);
//Put the label in place of the button
thebutton.Parent.Controls.AddAt(thebutton.Parent.Controls.IndexOf(thebutton), lab);
//Then remove the button
thebutton.Parent.Controls.Remove(thebutton);
}
}
else
{
if (thebutton.Attributes["commandargument"].Contains("occurance"))
{
rowID = thebutton.Attributes["commandargument"].Replace("occurance", "");
theRow = rowID;
dat.Execute("UPDATE EventRevisions_Occurance SET Approved='False' WHERE RevisionID=" + rowID);
DataSet dsRevision = dat.GetData("SELECT E.Header AS H1, E.ID AS TID, * FROM EventRevisions ER, Events E WHERE E.ID=ER.EventID AND ER.ID=" + rowID);
DataSet dsUser = dat.GetData("SELECT * FROM Users U WHERE User_ID=" + dsRevision.Tables[0].Rows[0]["modifierID"].ToString());
string emailBody = "The revised event re-occurance dates have been rejected by the author of the event. <br/><br/> " +
"We appologize for any inconvenience. <br/><br/>To view the event, please visit <a href=\"http://HippoHappenings.com/"+dat.MakeNiceName(dsRevision.Tables[0].Rows[0]["H1"].ToString())+"_" +
dsRevision.Tables[0].Rows[0]["TID"].ToString() + "_Event\">" + dsRevision.Tables[0].Rows[0]["H1"].ToString() + "</a>";
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "One of your changes has been rejected for event: '" +
dsRevision.Tables[0].Rows[0]["H1"].ToString() + "'");
Literal lab = new Literal();
lab.Text = "<div class=\"Green12LinkNF\" style=\"float: right;margin-top: 20px; padding-bottom: 4px;height: 30px;\">You have rejected this change.</div>";
Label lab2 = new Label();
HtmlButton but2 = new HtmlButton();
but2 = (HtmlButton)thebutton.Parent.Controls[thebutton.Parent.Controls.IndexOf(thebutton) + 1];
but2.Parent.Controls.AddAt(but2.Parent.Controls.IndexOf(but2), lab2);
but2.Parent.Controls.Remove(but2);
//Put the label in place of the button
thebutton.Parent.Controls.AddAt(thebutton.Parent.Controls.IndexOf(thebutton), lab);
//Then remove the button
thebutton.Parent.Controls.Remove(thebutton);
}
else
{
string[] delim = { "reject" };
string[] tokens = thebutton.Attributes["commandargument"].Split(delim, StringSplitOptions.None);
rowID = tokens[0];
int columnNumber = int.Parse(tokens[1]);
theRow = rowID;
DataSet dsEventID = dat.GetData("SELECT * FROM EventRevisions WHERE ID=" + rowID);
dat.ApproveRejectChange("EventRevisions", rowID, columnNumber-3, false);
string eventID = dsEventID.Tables[0].Rows[0]["EventID"].ToString();
string columnName = dsEventID.Tables[0].Columns[columnNumber].ColumnName;
string temp = dsEventID.Tables[0].Rows[0][columnName].ToString();
if (columnName.ToLower() == "venue")
{
dat.ApproveRejectChange("EventRevisions", rowID, 3, false);
dat.ApproveRejectChange("EventRevisions", rowID, 4, false);
dat.ApproveRejectChange("EventRevisions", rowID, 5, false);
dat.ApproveRejectChange("EventRevisions", rowID, 6, false);
dat.ApproveRejectChange("EventRevisions", rowID, 10, false);
}
DataSet dsRevision = dat.GetData("SELECT E.Header AS H1, E.ID AS TID, * FROM EventRevisions ER, Events E WHERE E.ID=ER.EventID AND ER.ID=" + rowID);
DataSet dsUser = dat.GetData("SELECT * FROM Users U WHERE User_ID=" + dsRevision.Tables[0].Rows[0]["modifierID"].ToString());
string emailBody = "The revised event " + columnName + " has been rejected by the author of the event. <br/><br/> " +
"We appologize for any inconvenience. To view the event, please visit <a href=\"http://HippoHappenings.com/" +dat.MakeNiceName(dsRevision.Tables[0].Rows[0]["H1"].ToString())+"_"+
dsRevision.Tables[0].Rows[0]["TID"].ToString() + "_Event\">" + dsRevision.Tables[0].Rows[0]["H1"].ToString() + "</a>";
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "One of your changes has been rejected for event: '" +
dsRevision.Tables[0].Rows[0]["H1"].ToString() + "'");
Literal lab = new Literal();
lab.Text = "<div class=\"Green12LinkNF\" style=\"float: right;margin-top: 20px; padding-bottom: 4px;height: 30px;\">You have rejected this change.</div>";
Label lab2 = new Label();
HtmlButton but2 = new HtmlButton();
but2 = (HtmlButton)thebutton.Parent.Controls[thebutton.Parent.Controls.IndexOf(thebutton) - 1];
but2.Parent.Controls.AddAt(but2.Parent.Controls.IndexOf(but2), lab2);
but2.Parent.Controls.Remove(but2);
//Put the label in place of the button
thebutton.Parent.Controls.AddAt(thebutton.Parent.Controls.IndexOf(thebutton), lab);
//Then remove the button
thebutton.Parent.Controls.Remove(thebutton);
}
}
}
catch (Exception ex)
{
MessagesLabel.Text = ex.ToString();
}
}
protected void ServerAcceptChange(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["BrowserDate"];
try
{
LinkButton thebutton = (LinkButton)sender;
Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
string theRow = "";
bool isVenue = false;
if (thebutton.Attributes["commArg"].ToString().ToLower() == "venue")
isVenue = true;
if (isVenue)
{
if (thebutton.Attributes["commandargument"].Contains("category"))
{
}
else
{
string[] delim = { "accept" };
string[] tokens = thebutton.Attributes["commandargument"].Split(delim, StringSplitOptions.None);
string rowID = tokens[0];
string columnNumber = tokens[1];
theRow = rowID;
DataSet dsEventID = dat.GetData("SELECT * FROM VenueRevisions WHERE ID=" + rowID);
string eventID = dsEventID.Tables[0].Rows[0]["VenueID"].ToString();
string columnName = dsEventID.Tables[0].Columns[int.Parse(columnNumber)].ColumnName;
string temp = dsEventID.Tables[0].Rows[0][columnName].ToString();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("UPDATE Venues SET " + columnName + "=@p1 WHERE ID=@eventID", conn);
cmd.Parameters.Add("@p1", SqlDbType.NVarChar).Value = dsEventID.Tables[0].Rows[0][columnName].ToString();
cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = eventID;
cmd.ExecuteNonQuery();
conn.Close();
dat.ApproveRejectChange("VenueRevisions", rowID, int.Parse(columnNumber)-3, true);
string venueName = dat.GetData("SELECT * FROM Venues V, VenueRevisions VCR WHERE V.ID=VCR.VenueID AND VCR.ID=" + rowID).Tables[0].Rows[0]["Name"].ToString();
//string categoryName = dat.GetData("SELECT * FROM VenueRevisions VCR, VenueCategories VC " +
// "WHERE VC.CategoryID=VCR.CategoryID AND VCR.ID=" + rowID).Tables[0].Rows[0]["CategoryName"].ToString();
DataSet dsRevision = dat.GetData("SELECT * FROM VenueRevisions VCR, Users U WHERE U.User_ID=VCR.modifierID AND VCR.ID=" + rowID);
DataSet dsUser = dat.GetData("SELECT * FROM Users U WHERE User_ID=" + dsRevision.Tables[0].Rows[0]["modifierID"].ToString());
string emailBody = "The revised venue " + columnName + " has been apporved by the author of the venue. <br/><br/> " +
"To view these changes, please visit <a href=\"http://HippoHappenings.com/"+dat.MakeNiceName(venueName) +"_"+ dsRevision.Tables[0].Rows[0]["VenueID"].ToString() + "_Venue\">" + venueName + "</a>";
if (!Request.IsLocal)
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "One of your changes has been approved for venue: '" +
venueName + "'");
}
Literal lab = new Literal();
lab.Text = "<div class=\"Green12LinkNF\" style=\"float: right;margin-top: 20px; padding-bottom: 4px;height: 30px;\">You have accepted this change.</div>";
Label lab2 = new Label();
HtmlButton but2 = new HtmlButton();
but2 = (HtmlButton)thebutton.Parent.Controls[thebutton.Parent.Controls.IndexOf(thebutton) + 1];
but2.Parent.Controls.AddAt(but2.Parent.Controls.IndexOf(but2), lab2);
but2.Parent.Controls.Remove(but2);
//Put the label in place of the button
thebutton.Parent.Controls.AddAt(thebutton.Parent.Controls.IndexOf(thebutton), lab);
//Then remove the button
thebutton.Parent.Controls.Remove(thebutton);
}
}
else
{
if (thebutton.Attributes["commandargument"].Contains("occurance"))
{
//MessagesLabel.Text = "got here ";
string rowID = thebutton.Attributes["commandargument"].Replace("occurance", "");
theRow = rowID;
//MessagesLabel.Text = rowID;
dat.Execute("INSERT INTO Event_Occurance (EventID, DateTimeStart, DateTimeEnd) " +
"SELECT EventID, DateTimeStart, DateTimeEnd FROM EventRevisions_Occurance WHERE RevisionID=" + rowID);
//MessagesLabel.Text = "flew here";
dat.Execute("UPDATE EventRevisions_Occurance SET Approved='True' WHERE RevisionID=" + rowID);
DataSet dsRevision = dat.GetData("SELECT E.Header AS H1, E.ID AS TID, * FROM EventRevisions ER, Events E WHERE E.ID=ER.EventID AND ER.ID=" + rowID);
DataSet dsUser = dat.GetData("SELECT * FROM Users U WHERE User_ID=" + dsRevision.Tables[0].Rows[0]["modifierID"].ToString());
string emailBody = "The revised event re-occurance dates have been apporved by the author of the event. <br/><br/> " +
"To view these changes, please visit <a href=\"http://HippoHappenings.com/"+dat.MakeNiceName(dsRevision.Tables[0].Rows[0]["H1"].ToString())+"_" + dsRevision.Tables[0].Rows[0]["TID"].ToString() + "_Event\">" + dsRevision.Tables[0].Rows[0]["H1"].ToString() + "</a>";
if (!Request.IsLocal)
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "One of your changes has been approved for event: '" +
dsRevision.Tables[0].Rows[0]["H1"].ToString() + "'");
//Send email to all users who have this event in their calendar and have their email preference set for event updates
emailBody = "<br/><br/>Changes have been made to an event in your calendar: Event '\"" + dsRevision.Tables[0].Rows[0]["H1"].ToString() +
"\"'. <br/><br/> To view these changes, please go to this event's <a class=\"NavyLink12\" href=\"http://hippohappenings.com/" + dat.MakeNiceName(dsRevision.Tables[0].Rows[0]["H1"].ToString()) + "_" + dsRevision.Tables[0].Rows[0]["TID"].ToString() + "_Event\">page</a>. " +
"<br/><br/><br/>Have a Hippo Happening Day!<br/><br/> <a class=\"NavyLink12\" href=\"http://HippoHappenings.com\">Happening Hippo</a>";
DataSet dsAllUsers = dat.GetData("SELECT * FROM User_Calendar UC, Users U, UserPreferences UP WHERE U.User_ID=UP.UserID AND UP.EmailPrefs LIKE '%C%' AND U.User_ID=UC.UserID AND UC.EventID=" + dsRevision.Tables[0].Rows[0]["TID"].ToString());
DataView dv = new DataView(dsAllUsers.Tables[0], "", "", DataViewRowState.CurrentRows);
if (dv.Count > 0)
{
for (int i = 0; i < dv.Count; i++)
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dv[i]["Email"].ToString(), emailBody,
"Event '" +
dsRevision.Tables[0].Rows[0]["H1"].ToString() + "' has been modified");
dat.Execute("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, " +
"To_UserID, Date, [Read], Mode, Live, SentLive) VALUES('" + emailBody.Replace("'", "''") + "', '" + "Event ''" +
dsRevision.Tables[0].Rows[0]["H1"].ToString().Replace("'", "''") + "'' has been modified', "+dat.HIPPOHAPP_USERID.ToString()+", " + dv[i]["UserID"].ToString() + ", GETDATE(), 0, 1, 1, 0)");
}
}
}
Literal lab = new Literal();
lab.Text = "<div class=\"Green12LinkNF\" style=\"float: right;margin-top: 20px; padding-bottom: 4px;height: 30px;\">You have accepted this change.</div>";
Label lab2 = new Label();
HtmlButton but2 = new HtmlButton();
but2 = (HtmlButton)thebutton.Parent.Controls[thebutton.Parent.Controls.IndexOf(thebutton) + 1];
but2.Parent.Controls.AddAt(but2.Parent.Controls.IndexOf(but2), lab2);
but2.Parent.Controls.Remove(but2);
//Put the label in place of the button
thebutton.Parent.Controls.AddAt(thebutton.Parent.Controls.IndexOf(thebutton), lab);
//Then remove the button
thebutton.Parent.Controls.Remove(thebutton);
}
else
{
string[] delim = { "accept" };
string[] tokens = thebutton.Attributes["commandargument"].Split(delim, StringSplitOptions.None);
string rowID = tokens[0];
string columnNumber = tokens[1];
theRow = rowID;
DataSet dsEventID = dat.GetData("SELECT * FROM EventRevisions WHERE ID=" + rowID);
string eventID = dsEventID.Tables[0].Rows[0]["EventID"].ToString();
string columnName = dsEventID.Tables[0].Columns[int.Parse(columnNumber)].ColumnName;
string temp = dsEventID.Tables[0].Rows[0][columnName].ToString();
dat.ApproveRejectChange("EventRevisions", rowID, int.Parse(columnNumber)-3, true);
//if user is accepting a venue change, also accept zip, city, state and country
if (columnName.ToLower() == "venue")
{
dat.ApproveRejectChange("EventRevisions", rowID, 3, true);
dat.ApproveRejectChange("EventRevisions", rowID, 4, true);
dat.ApproveRejectChange("EventRevisions", rowID, 5, true);
dat.ApproveRejectChange("EventRevisions", rowID, 6, true);
dat.ApproveRejectChange("EventRevisions", rowID, 10, true);
}
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Connection"].ToString());
conn.Open();
SqlCommand cmd = new SqlCommand("UPDATE Events SET " + columnName + "=@p1 WHERE ID=@eventID", conn);
cmd.Parameters.Add("@p1", SqlDbType.NVarChar).Value = dsEventID.Tables[0].Rows[0][columnName].ToString();
cmd.Parameters.Add("@eventID", SqlDbType.Int).Value = eventID;
cmd.ExecuteNonQuery();
conn.Close();
DataSet dsRevision = dat.GetData("SELECT E.Header AS H1, E.ID AS TID, * FROM EventRevisions ER, Events E WHERE E.ID=ER.EventID AND ER.ID=" + rowID);
DataSet dsUser = dat.GetData("SELECT * FROM Users U WHERE User_ID=" + dsRevision.Tables[0].Rows[0]["modifierID"].ToString());
string emailBody = "The revised event " + columnName + " has been apporved by the author of the event. <br/><br/> " +
"To view these changes, please visit <a href=\"http://HippoHappenings.com/" + dat.MakeNiceName(dsRevision.Tables[0].Rows[0]["H1"].ToString()) + "_" + dsRevision.Tables[0].Rows[0]["TID"].ToString() + "_Event\">" + dsRevision.Tables[0].Rows[0]["H1"].ToString() + "</a>";
if (!Request.IsLocal)
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dsUser.Tables[0].Rows[0]["Email"].ToString(), emailBody, "One of your changes has been approved for event: '" +
dsRevision.Tables[0].Rows[0]["H1"].ToString() + "'");
//Send email to all users who have this event in their calendar and have their email preference set for event updates
emailBody = "<br/><br/>Changes have been made to an event in your calendar: Event '\"" + dsRevision.Tables[0].Rows[0]["H1"].ToString() +
"\"'. <br/><br/> To view these changes, please go to this event's <a class=\"NavyLink12\" href=\"http://hippohappenings.com/" + dat.MakeNiceName(dsRevision.Tables[0].Rows[0]["H1"].ToString()) + "_" + dsRevision.Tables[0].Rows[0]["TID"].ToString() + "_Event\">page</a>. " +
"<br/><br/><br/>Have a Hippo Happening Day!<br/><br/> <a class=\"NavyLink12\" href=\"http://HippoHappenings.com\">HippoHappenings</a>";
DataSet dsAllUsers = dat.GetData("SELECT * FROM User_Calendar UC, Users U, UserPreferences UP " +
"WHERE U.User_ID=UP.UserID AND U.User_ID=UC.UserID AND UC.EventID=" +
dsRevision.Tables[0].Rows[0]["TID"].ToString());
DataView dv = new DataView(dsAllUsers.Tables[0], "", "", DataViewRowState.CurrentRows);
if (dv.Count > 0)
{
for (int i = 0; i < dv.Count; i++)
{
if (dv[i]["EmailPrefs"].ToString().Contains("C"))
{
dat.SendEmail(System.Configuration.ConfigurationManager.AppSettings["emailemail"].ToString(),
System.Configuration.ConfigurationManager.AppSettings["emailName"].ToString(),
dv[i]["Email"].ToString(), emailBody,
"Event '" +
dsRevision.Tables[0].Rows[0]["H1"].ToString() + "' has been modified");
}
dat.Execute("INSERT INTO UserMessages (MessageContent, MessageSubject, From_UserID, " +
"To_UserID, Date, [Read], Mode, Live, SentLive) VALUES('" + emailBody.Replace("'", "''") + "', '" + "Event ''" +
dsRevision.Tables[0].Rows[0]["H1"].ToString().Replace("'", "''") + "'' has been modified', " + dat.HIPPOHAPP_USERID +
", " + dv[i]["UserID"].ToString() + ", GETDATE(), 0, 1, 1, 0)");
}
}
}
Literal lab = new Literal();
lab.Text = "<div class=\"Green12LinkNF\" style=\"float: right;margin-top: 20px; padding-bottom: 4px;height: 30px;\">You have accepted this change.</div>";
Label lab2 = new Label();
HtmlButton but2 = new HtmlButton();
but2 = (HtmlButton)thebutton.Parent.Controls[thebutton.Parent.Controls.IndexOf(thebutton) + 1];
but2.Parent.Controls.AddAt(but2.Parent.Controls.IndexOf(but2), lab2);
but2.Parent.Controls.Remove(but2);
//Put the label in place of the button
thebutton.Parent.Controls.AddAt(thebutton.Parent.Controls.IndexOf(thebutton), lab);
//Then remove the button
thebutton.Parent.Controls.Remove(thebutton);
}
}
}
catch (Exception ex)
{
MessagesLabel.Text = ex.ToString();
}
}
