private void FillPage() { ArrayList chocList = DatabasePull.GetDetails(Id); StringBuilder table = new StringBuilder(); foreach (Choco choco in chocList) { table.Append(string.Format( @"<table class='chocTable'> <tr> <th rowspan='5' width = '25px'> ID </th> <th rowspan ='5' width = '25px'>{0}</th> <th rowspan='5' width = '250px'><img runat='server' src='{5}' height ='200px' width ='200px'/></th> <th width='50px' height='20px'>Name: </td> <td height='25px'>{2}</td> </tr> <tr> <th height='25px'>Brand:</th> <td height='25px'>{1}</td> </tr> <tr> <th height='25px'>Price:</th> <td height='25px'> RM{3}</td> </tr> <tr> <td colspan='3' width='500px'>{4}</td> </tr> </table>" , choco.Id, choco.brand, choco.name, choco.price, choco.desc, choco.img)); LabelOutput.Text = table.ToString(); } }
protected void Save_Click(object sender, EventArgs e) { string Id = Selection.Text; string brand = Brand.Text; string name = Name.Text; string type = Type.SelectedValue; SqlDecimal price = SqlDecimal.Parse(Price.Text); string desc = Desc.Text; string file = Path.GetFileName(Image.FileName); string img = "Images/" + file; if (img == ImageText.Text || file == "") { img = ImageText.Text; } else { Image.SaveAs(Server.MapPath("~/Images/") + file); } Choco choco = new Choco(brand, name, type, price, desc, img); DatabasePull.EditChoco(choco, Id); FillPage(); ClearTextView(); update.Text = "Updated Sucessfully"; }
protected void Save_Click(object sender, EventArgs e) { try { string file = Path.GetFileName(Upload.FileName); Upload.SaveAs(Server.MapPath("~/Images/") + file); string brand = Brand.Text; string name = Name.Text; string type = Type.SelectedValue; SqlDecimal price = SqlDecimal.Parse(Price.Text); string desc = Desc.Text; string image = "Images/" + file; Choco choco = new Choco(brand, name, type, price, desc, image); DatabasePull.AddChoco(choco); FillPage(); Result.Text = "Upload Success"; ClearTextField(); } catch (Exception) { Result.Text = "Upload Failed!"; } }
protected void Delete_Click(object sender, EventArgs e) { string id = Selection.Text; DeleteOutput.Text = DatabasePull.DeleteChoc(id); FillPage(); ClearTextView(); }
protected void Submit_Click1(object sender, EventArgs e) { string title = Title1.Text; string email = Email.Text; string feedback = Feedback.Text; Output.Text = DatabasePull.DoInsert(title, email, feedback); ClearTextView(); }
protected void Submit_Click(object sender, EventArgs e) { string username = Username.Text; string password = Password.Text; DatabasePull.GetCredentials(username, password); if (DatabasePull.GetCredentials(username, password) == true) { LabelOutput.Text = "Login successful"; Response.Redirect("Admin.aspx"); } else { LabelOutput.Text = "Wrong Username or Password , Try Again"; Username.Text = ""; Password.Text = ""; } }