protected void btnSubmit_Click(object sender, EventArgs e) { string mat_req_id; VIEW_MATERIAL_REQUESTTableAdapter mrir = new VIEW_MATERIAL_REQUESTTableAdapter(); try { string uname = Session["USER_NAME"].ToString().ToUpper(); string user_id = WebTools.GetExpr("USER_ID", "USERS", " WHERE UPPER(USER_NAME)='" + uname + "'"); mrir.InsertQuery(decimal.Parse(Session["PROJECT_ID"].ToString()), txtRequestNo.Text, decimal.Parse(ddDiscipline.SelectedValue.ToString()), txtReqDate.SelectedDate, ddlReqFrom.SelectedText, decimal.Parse(ddlStoreList.SelectedValue), txtRemarks.Text, RadSubAreaDDL.SelectedText, RadAreaDDL.SelectedText, decimal.Parse(user_id)); mat_req_id = WebTools.GetExpr("MAT_REQ_ID", "MATERIAL_REQUEST", "PROJECT_ID=" + Session["PROJECT_ID"].ToString() + " AND MAT_REQ_NO='" + txtRequestNo.Text + "'"); Master.show_success("Material Request " + txtRequestNo.Text + " Added."); } catch (Exception ex) { Master.show_error(ex.Message); } finally { mrir.Dispose(); } }
protected void btnSubmit_Click(object sender, EventArgs e) { //string mat_req_id; VIEW_MATERIAL_REQUESTTableAdapter mrir = new VIEW_MATERIAL_REQUESTTableAdapter(); try { mrir.InsertQuery(decimal.Parse(Session["PROJECT_ID"].ToString()), txtRequestNo.Text, txtReqDate.SelectedDate, decimal.Parse(ddFrom.SelectedValue), decimal.Parse(ddTo.SelectedValue), txtRemarks.Text, txtReqBy.Text); Master.show_success(txtRequestNo.Text + " Created Successfully."); } catch (Exception ex) { Master.show_error(ex.Message); } finally { mrir.Dispose(); } }