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."; } } }