private void Load_Logo()
{
string connectionstring = "Server=tcp:evansvilledayschoolserver.database.windows.net,1433;Database=EvansvilleDaySchoolDatabase;User ID=Usiwallabies@evansvilledayschoolserver;Password=Quokka12;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
string selectstring = "SELECT ADMIN_LOGONAME FROM ADMINISTRATOR WHERE USER_ID = 0";
SqlDataSource database = new SqlDataSource(connectionstring, selectstring);
DataView dv = (DataView)database.Select(DataSourceSelectArguments.Empty);
string filename = (string)dv.Table.Rows[0][0];
if (System.IO.File.Exists(Server.MapPath("~/Content/") + filename) == true)
{
LogoImage.ImageUrl = "~/Content/" + filename;
}
else
{
LogoImage.ImageUrl = "~/Content/" + "evansville_day_school.jpg";
string connstring = "Server=tcp:evansvilledayschoolserver.database.windows.net,1433;Database=EvansvilleDaySchoolDatabase;User ID=Usiwallabies@evansvilledayschoolserver;Password=Quokka12;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
string selstring = "SELECT * FROM ADMINISTRATOR WHERE USER_ID = 0";
string updatestring = "UPDATE ADMINISTRATOR SET ADMIN_LOGONAME = 'evansville_day_school.jpg' WHERE USER_ID = 0";
SqlDataSource db = new SqlDataSource(connstring, selstring);
db.UpdateCommand = updatestring;
db.Update();
}
dv.Dispose();
}
}//public void GridViewURI_RowDeleting()
/// <summary>GridViewURI_RowUpdating</summary>
/// <details>
/// http://fredrik.nsquared2.com/viewpost.aspx?PostID=173&showfeedback=true Get a control or value from a GridView row.
/// http://www.chrisfrazier.net/blog/archive/category/1014.aspx
/// </details>
public void GridViewURI_RowUpdating
(
Object sender,
GridViewUpdateEventArgs gridViewUpdateEventArgs
)
{
int sequenceOrderId = -1;
DateTime dated;
string exceptionMessage = null;
string commentary = null;
string keyword = null;
string title = null;
string uri = null;
GridViewRow gridViewRow = null;
try
{
gridViewRow = GridViewURI.Rows[ gridViewUpdateEventArgs.RowIndex ];
if ( gridViewRow == null )
{
return;
}
Int32.TryParse( ( ( System.Web.UI.WebControls.Label ) gridViewRow.FindControl("LabelGridViewURIItemTemplateSequenceOrderId")).Text, out sequenceOrderId );
DateTime.TryParse( ( ( System.Web.UI.WebControls.TextBox ) gridViewRow.FindControl("TextBoxGridViewURIEditItemTemplateDated")).Text, out dated );
uri = ( ( System.Web.UI.WebControls.TextBox ) gridViewRow.FindControl("TextBoxGridViewURIEditItemTemplateURI")).Text;
title = ( ( System.Web.UI.WebControls.TextBox ) gridViewRow.FindControl("TextBoxGridViewURIEditItemTemplateTitle")).Text;
commentary = ( ( System.Web.UI.WebControls.TextBox ) gridViewRow.FindControl("TextBoxGridViewURIEditItemTemplateCommentary")).Text;
keyword = ( ( System.Web.UI.WebControls.TextBox ) gridViewRow.FindControl("TextBoxGridViewURIEditItemTemplateKeyword")).Text;
SqlDataSourceURIGridView.UpdateParameters["original_sequenceOrderId"].DefaultValue = sequenceOrderId.ToString();
if ( dated != DateTime.MinValue )
{
SqlDataSourceURIGridView.UpdateParameters["dated"].DefaultValue = dated.ToString();
}
SqlDataSourceURIGridView.UpdateParameters["uri"].DefaultValue = uri;
SqlDataSourceURIGridView.UpdateParameters["title"].DefaultValue = title;
SqlDataSourceURIGridView.UpdateParameters["commentary"].DefaultValue = commentary;
SqlDataSourceURIGridView.UpdateParameters["keyword"].DefaultValue = keyword;
SqlDataSourceURIGridView.Update();
}//try
catch ( Exception exception )
{
exceptionMessage = exception.Message;
}
if ( exceptionMessage != null )
{
Feedback = exceptionMessage;
return;
}
}//public void GridViewURI_RowUpdating()
protected void UploadNewLogoButton_Click(object sender, EventArgs e)
{
string filename = FileUpload1.FileName;
string extension = "";
if (FileUpload1.HasFile == true)
{
extension = filename.Substring(filename.Length - 4);
}
if (extension == ".jpg" || extension == ".png" || extension == ".gif" & FileUpload1.HasFile == true)
{
string connstring = "Server=tcp:evansvilledayschoolserver.database.windows.net,1433;Database=EvansvilleDaySchoolDatabase;User ID=Usiwallabies@evansvilledayschoolserver;Password=Quokka12;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
string selstring = "SELECT * FROM ADMINISTRATOR WHERE USER_ID = 0";
string updatestring = string.Format("UPDATE ADMINISTRATOR SET ADMIN_LOGONAME = '{0}' WHERE USER_ID = 0", filename);
SqlDataSource db = new SqlDataSource(connstring, selstring);
db.UpdateCommand = updatestring;
db.Update();
string rootpath = Server.MapPath("~/");
FileUpload1.PostedFile.SaveAs(rootpath + "/Content/" + filename);
LogoImage.ImageUrl = ("~/Content/" + filename);
Server.Transfer("OrganizationManagement.aspx");
}
else if (FileUpload1.HasFile == false)
{
Label1.Text = "No file chosen.";
Label1.ForeColor = System.Drawing.Color.Red;
}
else
{
Label1.Text = "ERROR: IMAGE MUST BE .JPG, .PNG, OR .GIF.";
Label1.ForeColor = System.Drawing.Color.Red;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string connstring = "Server=tcp:evansvilledayschoolserver.database.windows.net,1433;Database=EvansvilleDaySchoolDatabase;User ID=Usiwallabies@evansvilledayschoolserver;Password=Quokka12;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
string selstring = "SELECT * FROM SUBSCRIPTION JOIN USERS ON USERS.USER_ID = SUBSCRIPTION.USER_ID JOIN LIST ON SUBSCRIPTION.LIST_ID = LIST.LIST_ID";
string phone = Label1.Text + Label4.Text + Label5.Text;
string fname = Label2.Text;
string lname = Label3.Text;
string lists = Label6.Text;
SqlDataSource db = new SqlDataSource(connstring, selstring);
DataView dv = (DataView)db.Select(DataSourceSelectArguments.Empty);
string FirstName = (string)dv.Table.Rows[0][4];
string LastName = (string)dv.Table.Rows[0][5];
string Phone = (string)dv.Table.Rows[0][6];
int userid = (int)dv.Table.Rows[0][0];
string updatestring = String.Format("UPDATE USERS SET USER_FNAME={0}, USER_LNAME={1}, USER_PHONE={2} WHERE USER_ID={3};", fname, lname, phone, userid);
db.UpdateCommand = updatestring;
//db.InsertCommand = insertstring;
if (FirstName == Label2.Text && LastName == Label3.Text)
{
string firstUpdateString = String.Format("UPDATE USERS SET USER_FNAME={0}, USER_LNAME={1}, USER_PHONE={2} WHERE USER_ID={3};", fname, lname, phone, userid);
db.UpdateCommand = updatestring;
db.Update();
}
else
{
string insertstring = String.Format("INSERT INTO USERS VALUES {0},{1},{2}", fname, lname, phone);
db.Insert();
insertstring = String.Format("INSERT INTO SUBSCRIPTION VALUES {0}", lists);
db.InsertCommand = insertstring;
db.Insert();
}
Response.Redirect("TextAlertRegistration.aspx");
}
protected void SaveChangesButton_Click(object sender, EventArgs e)
{
string securitycode;
string connstring;
string selstring;
string updatestring;
SqlDataSource db;
if (RadioButtonList.SelectedValue == "Activated")
{
securitycode = TextBox1.Text;
connstring = "Server=tcp:evansvilledayschoolserver.database.windows.net,1433;Database=EvansvilleDaySchoolDatabase;User ID=Usiwallabies@evansvilledayschoolserver;Password=Quokka12;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
selstring = "SELECT * FROM ADMINISTRATOR WHERE USER_ID = 0";
updatestring = string.Format("UPDATE ADMINISTRATOR SET ADMIN_SECURITYCODE = '{0}' WHERE USER_ID = 0", securitycode);
db = new SqlDataSource(connstring, selstring);
db.UpdateCommand = updatestring;
db.Update();
}
else if (RadioButtonList.SelectedValue == "Deactivated")
{
securitycode = "No Code Set";
connstring = "Server=tcp:evansvilledayschoolserver.database.windows.net,1433;Database=EvansvilleDaySchoolDatabase;User ID=Usiwallabies@evansvilledayschoolserver;Password=Quokka12;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
selstring = "SELECT * FROM ADMINISTRATOR WHERE USER_ID = 0";
updatestring = string.Format("UPDATE ADMINISTRATOR SET ADMIN_SECURITYCODE = '{0}' WHERE USER_ID = 0", securitycode);
db = new SqlDataSource(connstring, selstring);
db.UpdateCommand = updatestring;
db.Update();
}
else
{
}
Server.Transfer("OrganizationManagement.aspx");
}
//Buying more Tokens
protected void Button1_Click(object sender, EventArgs e)
{
int temp1 = 0, temp2 = 0, FinalTokenCount = 0;
//Finds which checkboxes are chosen
foreach (ListItem item in CheckBoxList3.Items)
{
if (item.Selected)
{
if (item.Value == "100")
{
temp1 = 100;
}
else if (item.Value == "250")
{
temp1 = 250;
}
else if (item.Value == "500")
{
temp1 = 500;
}
else if (item.Value == "1,000")
{
temp1 = 1000;
}
else if (item.Value == "2,000")
{
temp1 = 2000;
}
else if (item.Value == "5,000")
{
temp1 = 5000;
}
else if (item.Value == "10,000")
{
temp1 = 10000;
}
else { }
//Adds all the checkboxes together
FinalTokenCount = temp1 + temp2;
temp2 = temp1 + temp2;
temp1 = 0;
string connstring = "Server=tcp:evansvilledayschoolserver.database.windows.net,1433;Database=EvansvilleDaySchoolDatabase;User ID=Usiwallabies@evansvilledayschoolserver;Password=Quokka12;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;";
string selstring = "SELECT * FROM ADMINISTRATOR";
SqlDataSource db = new SqlDataSource(connstring, selstring);
DataView dv = (DataView)db.Select(DataSourceSelectArguments.Empty);
int dbTokens = (int)dv.Table.Rows[0][1];
FinalTokenCount = FinalTokenCount + dbTokens;
string updatestring = String.Format("UPDATE ADMINISTRATOR SET ADMIN_TOKENS = {0}", FinalTokenCount);
string finalTokens = Convert.ToString(FinalTokenCount);
db.UpdateCommand = updatestring;
db.Update();
Response.Redirect("AddTokens.aspx");
//AddFinalTokenCount to database
//Change token count on label 1
}
}
}
