using System; using System.Collections; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Data.SqlClient; public partial class Meeting_Add : System.Web.UI.Page { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString"].ToString()); protected void Page_Load(object sender, EventArgs e) { } protected void btnAdd2_Click(object sender, EventArgs e) { AddRecord(); } private void AddRecord() { string xadmin = Session["admin"].ToString(); if (xadmin == "True") { try { if (txtYear.Text == "") { txtYear.Text = "1435"; } SqlCommand cmdInsert = new SqlCommand("insert into tbl_Meeting(Le_Type,Le_WName,Le_No,Le_Where,Le_Note,"+ "Le_Day,Le_Month,Le_Year,Le_User,Le_CourseName)" + " Values(" + DrpLe_Type.SelectedValue + ",N'" + txtLe_WName.Text + "'," + " " + txtLe_No.Text + ",N'" + DrpLe_Where.SelectedValue + "',N'" + txtLe_Note.Text + "'," + " N'" + DrpDate.SelectedValue + "',N'" + DrpMonth.SelectedValue + "',N'" + txtYear.Text + "'," + " " + Session["User"].ToString() + " , N'" + txtCourse_Name.Text + "')", con); if (con.State == ConnectionState.Closed) con.Open(); cmdInsert.ExecuteNonQuery(); con.Close(); Cleartxt(); } catch (Exception ex) { lblerror2.Text = "حدث خطأ كالتالي " + ex.ToString(); return; } } else Response.Redirect("Home.aspx"); } private void Cleartxt() { lblerror2.Text = "تم إضافة دورات طلاب المنح"; txtLe_No.Text = ""; txtYear.Text = ""; txtLe_Note.Text = "-"; DrpMonth.ClearSelection(); DrpDate.ClearSelection(); DrpLe_Where.ClearSelection(); DrpLe_Type.ClearSelection(); txtLe_WName.Text = "-"; txtCourse_Name.Text = "-"; } protected void btnreturn_Click(object sender, EventArgs e) { Response.Redirect("Meeting.aspx"); } }