protected void btnSubmit_Click(object sender, EventArgs e) { tbl_Review obj_User_review = new tbl_Review(); if (CheckBox2.Text.Trim() == "") { CheckBox2.Focus(); return; } if (ddlUserName.SelectedValue == "0") { ddlUserName.Focus(); return; } if (txtComment.Text.Trim() == "") { txtComment.Focus(); return; } obj_User_review.tbl_Review_Rating = Rating1.CurrentRating; // obj_User_review. =Convert.ToInt32(ddlUserName.SelectedValue); obj_User_review.tbl_Review_faviourate = CheckBox2.Text.Trim(); obj_User_review.tbl_Review_Comment = txtComment.Text.Trim(); if (new DataLayer().Insert_Review(obj_User_review)) { MessageBox.Show("Review Submitted!!"); } else { MessageBox.Show("Error!!"); } }
public bool Insert_Review(tbl_Review obj_User_review) { bool flag = false; DataSet dataSet = new DataSet(); string strQuer = "insert into tbl_Review([tbl_Review_Rating],[tbl_Review_Comment],[tbl_Review_faviourate]) values('" + obj_User_review.tbl_Review_Rating + "','" + obj_User_review.tbl_Review_Comment + "','" + obj_User_review.tbl_Review_faviourate + "'); "; int ret_type = 0; try { dataSet = ExecuteSelectQuery(strQuer); flag = true; } catch (Exception ee) { ret_type = 0; flag = false; } return(flag); }