protected void btn_gs_show_Click(object sender, EventArgs e) { _5101BFinalProject.Models.GiftShopT giftshop = new _5101BFinalProject.Models.GiftShopT(); //giftshop.Gift_Id = Convert.ToInt32(txt_gift_id.Text); //giftshop.Gift_Desc = txt_gift_desc2.Text; _5101BFinalProject.Models.CalvinDb db = new _5101BFinalProject.Models.CalvinDb(); try { GiftShopT gs = new GiftShopT(); if (txt_gift_id.Text != "") { gs.Gift_Id = Convert.ToInt32(txt_gift_id.Text); } if (txt_gift_desc2.Text != "") { gs.Gift_Desc = txt_gift_desc2.Text; } List <GiftShopT> gstable = db.Get(gs); table_gifts.InnerHtml = "<table border='1px solid #000'><tr><th>Gift ID</th><th>Sender's Full Name</th><th>Recipient's Full Name</th><th>Gift Type</th><th>Gift Description</th><th>Gift Price</th><th>Gift Sender ID</th><th>Gift Recipient ID</th></tr>"; foreach (GiftShopT item in gstable) { table_gifts.InnerHtml += "<tr><td>" + item.Gift_Id.ToString() + "</td><td>" + item.Sender_Full_Name + "</td><td>" + item.Recipient_Full_Name + "</td><td>" + item.Gift_Type + "</td><td>" + item.Gift_Desc + "</td><td> $ " + Math.Round(item.Gift_Price, 2).ToString() + "</td><td>" + item.Gift_Sender_Id.ToString() + "</td><td>" + item.Gift_Recipient_Id.ToString() + "</td></tr>"; } table_gifts.InnerHtml += "</table>"; } catch (OracleException except) { lbl_search_err.Text = except.Message + ". "; } finally { //lbl_msg.Text += Convert.ToString(db.Rows) + " rows deleted."; } }
protected void btn_gs_delete_Click(object sender, EventArgs e) { _5101BFinalProject.Models.GiftShopT giftshop = new _5101BFinalProject.Models.GiftShopT(); giftshop.Gift_Id = Convert.ToInt32(txt_gift_id3.Text); _5101BFinalProject.Models.CalvinDb db = new _5101BFinalProject.Models.CalvinDb(); try { db.Delete(giftshop); } catch (OracleException except) { if (except.Message.Contains("ORA-02290")) { gift_id3_err.Text = "Please provide Gift ID."; } else { gift_id3_err.Text = ""; } if (except.Message.Contains("ORA-01400")) { gift_id3_err.Text = "Please provide Gift ID."; } else { gift_id3_err.Text = ""; } if (except.Message.Contains("ORA-01722")) { gift_id3_err.Text = "Please input a valid number"; } else { gift_id3_err.Text = ""; } lbl_delete_err.Text = except.Message + ". "; } finally { lbl_delete_err.Text += Convert.ToString(db.Rows) + " rows deleted."; } }
protected void btn_submit_Click(object sender, EventArgs e) { _5101BFinalProject.Models.ClientGiftshop clientgiftshop = new _5101BFinalProject.Models.ClientGiftshop(); clientgiftshop.Gift_Sender_First_Name = txt_sender_f_name.Text; clientgiftshop.Gift_Sender_Last_Name = txt_sender_l_name.Text; clientgiftshop.Gift_Recipient_First_Name = txt_recipient_f_name.Text; clientgiftshop.Gift_Recipient_Last_Name = txt_recipient_l_name.Text; clientgiftshop.Gift_Type = ddl_gift_type.SelectedItem.Value; clientgiftshop.Gift_Desc = txt_gift_desc.Text; _5101BFinalProject.Models.CalvinDb db = new _5101BFinalProject.Models.CalvinDb(); try { db.Add(clientgiftshop); } catch (OracleException except) { if (txt_sender_f_name.Text == "") { if (except.Message.Contains("ORA-01400")) { gift_send_f_name_err.Text = "Please provide Sender's first name."; } } else { gift_send_f_name_err.Text = ""; } if (txt_sender_l_name.Text == "") { if (except.Message.Contains("ORA-01400")) { gift_send_l_name_err.Text = "Please provide Sender's last name."; } } else { gift_send_l_name_err.Text = ""; } if (txt_recipient_f_name.Text == "") { if (except.Message.Contains("ORA-01400")) { gift_rec_f_name_err.Text = "Please provide Recipient's first name."; } } else { gift_rec_f_name_err.Text = ""; } if (txt_recipient_l_name.Text == "") { if (except.Message.Contains("ORA-01400")) { gift_rec_l_name_err.Text = "Please provide Recipient's last name."; } } else { gift_rec_l_name_err.Text = ""; } // Gift Type if (except.Message.Contains("ORA-02290")) { gift_type_err.Text = "Please select proper gift type."; } else { gift_type_err.Text = ""; } //Gift Description if (txt_gift_desc.Text == "") { if (except.Message.Contains("ORA-01400")) { gift_desc_err.Text = "Please provide gift description."; } } else { gift_desc_err.Text = ""; } } finally { thank_you_msg.Text = "Thank you, your order has been received."; } }
protected void btn_gs_create_Click(object sender, EventArgs e) { _5101BFinalProject.Models.GiftShopT giftshop = new _5101BFinalProject.Models.GiftShopT(); //giftshop.Gift_Id = Convert.ToInt32(txt_gift_id2.Text); // how to put into validation giftshop.Gift_Sender_First_Name = txt_sender_f_name.Text; giftshop.Gift_Sender_Last_Name = txt_sender_l_name.Text; giftshop.Gift_Recipient_First_Name = txt_recipient_f_name.Text; giftshop.Gift_Recipient_Last_Name = txt_recipient_l_name.Text; giftshop.Gift_Type = ddl_gift_type.SelectedItem.Value; giftshop.Gift_Desc = txt_gift_desc.Text; _5101BFinalProject.Models.CalvinDb db = new _5101BFinalProject.Models.CalvinDb(); //if (Convert.ToInt32(txt_gift_id2.Text) == 0) if (txt_gift_id2.Text == "") { gift_id2_err.Text = "Please enter a valid number"; } else if (txt_gift_price.Text == "") { gift_price_err.Text = "Please enter a valid number"; } else if (txt_gift_sender_id.Text == "") { gift_sender_id_err.Text = "Please enter a valid number"; } else if (txt_gift_recipient_id.Text == "") { gift_recipient_id_err.Text = "Please enter a valid number"; } else { giftshop.Gift_Id = Convert.ToInt32(txt_gift_id2.Text); double giftprice = Convert.ToDouble(txt_gift_price.Text); giftshop.Gift_Price = Math.Round(giftprice, 2); giftshop.Gift_Sender_Id = Convert.ToInt32(txt_gift_sender_id.Text); giftshop.Gift_Recipient_Id = Convert.ToInt32(txt_gift_recipient_id.Text); gift_id2_err.Text = ""; gift_price_err.Text = ""; gift_sender_id_err.Text = ""; gift_recipient_id_err.Text = ""; try { db.Add(giftshop); } catch (OracleException except) { if (txt_sender_f_name.Text == "") { if (except.Message.Contains("ORA-01400")) { gift_send_f_name_err.Text = "Please provide Sender's first name."; } } else { gift_send_f_name_err.Text = ""; } if (txt_sender_l_name.Text == "") { if (except.Message.Contains("ORA-01400")) { gift_send_l_name_err.Text = "Please provide Sender's last name."; } } else { gift_send_l_name_err.Text = ""; } if (txt_recipient_f_name.Text == "") { if (except.Message.Contains("ORA-01400")) { gift_rec_f_name_err.Text = "Please provide Recipient's first name."; } } else { gift_rec_f_name_err.Text = ""; } if (txt_recipient_l_name.Text == "") { if (except.Message.Contains("ORA-01400")) { gift_rec_l_name_err.Text = "Please provide Recipient's last name."; } } else { gift_rec_l_name_err.Text = ""; } // Recipient ID if (except.Message.Contains("ORA-01400")) { gift_recipient_id_err.Text = "Please provide Recipient ID."; } else { gift_recipient_id_err.Text = ""; } if (except.Message.Contains("ORA-01722")) { gift_recipient_id_err.Text = "Please input a valid number"; } else { gift_recipient_id_err.Text = ""; } if (except.Message.Contains("ORA-02291")) { gift_recipient_id_err.Text = "Recipient ID doesn't exist"; } else { gift_recipient_id_err.Text = ""; } // Sender ID if (except.Message.Contains("ORA-01400")) { gift_sender_id_err.Text = "Please provide Sender ID."; } else { gift_sender_id_err.Text = ""; } if (except.Message.Contains("ORA-01722")) { gift_sender_id_err.Text = "Please input a valid number"; } else { gift_sender_id_err.Text = ""; } if (except.Message.Contains("ORA-02291")) { gift_sender_id_err.Text = "Sender ID doesn't exist"; } else { gift_sender_id_err.Text = ""; } // Gift Price if (except.Message.Contains("ORA-01400")) { gift_price_err.Text = "Please put price for the item."; } else { gift_price_err.Text = ""; } if (except.Message.Contains("ORA-01722")) { gift_price_err.Text = "Please input a valid number"; } else { gift_price_err.Text = ""; } // Gift type if (except.Message.Contains("ORA-02290")) { gift_type_err.Text = "Please select proper gift type."; } else { gift_type_err.Text = ""; } // Gift Description if (txt_gift_desc.Text == "") { if (except.Message.Contains("ORA-01400")) { gift_desc_err.Text = "Please provide gift description."; } } else { gift_desc_err.Text = ""; } if (except.Message.Contains("ORA-01400")) { gift_id2_err.Text = "Please provide Gift ID."; } else { gift_id2_err.Text = ""; } if (except.Message.Contains("ORA-00001")) { gift_id2_err.Text = "Gift ID already in use."; } else { gift_id2_err.Text = ""; } if (except.Message.Contains("ORA-01722")) { gift_id2_err.Text = "Please input a valid number"; } else { gift_id2_err.Text = ""; } lbl_insert_err.Text = except.Message + ". "; } finally { lbl_insert_err.Text += Convert.ToString(db.Rows) + " rows inserted."; } } }