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();
}
}
