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; using System.Text; public partial class Documenting_Add : System.Web.UI.Page { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CMSConnectionString"].ToString()); protected void Page_Load(object sender, EventArgs e) { string xadmin = "False"; if (Session["admin"] != null) xadmin = Session["admin"].ToString(); if (!IsPostBack) { if ((xadmin == "False") || (Session["admin"] == null)) Response.Redirect("Home.aspx"); } } protected void btnAdd_Click(object sender, EventArgs e) { string Doc_From = "", Doc_To = ""; try { if (Page.IsValid) { string xadmin = Session["admin"].ToString(); if (xadmin == "True") { if (CHKTo.Checked==true) Doc_To = DrpDayTo.SelectedValue + "/" + DrpMonthTo.SelectedValue; else Doc_To = "" ; if (CHKFrom.Checked==true) Doc_From = DrpDayFrom.SelectedValue + "/" + DrpMonthFrom.SelectedValue; else Doc_From = ""; if (txtDoc_Par_No.Text == "") txtDoc_Par_No.Text = "-"; if (txtDoc_Par_No.Text == "") txtDoc_Par_No.Text = "0"; if (txtDoc_Participate.Text == "") txtDoc_Participate.Text = "-"; if (FTBDoc_Note.Text == "") FTBDoc_Note.Text = "-"; if (FTBDoc_Par_Name.Text == "") FTBDoc_Par_Name.Text = "-"; StringBuilder Doc_Par_NameFTP = new StringBuilder(Server.HtmlEncode(FTBDoc_Par_Name.Text.Trim().Replace("'", "''"))); string Doc_Par_Name = Doc_Par_NameFTP.ToString(); StringBuilder Doc_NoteFTP = new StringBuilder(Server.HtmlEncode(FTBDoc_Note.Text.Trim().Replace("'", "''"))); string Doc_Note = Doc_NoteFTP.ToString(); string Doc_Date = DrpDate.SelectedValue + "/" + DrpMonth.SelectedValue + "/" + txtYear.Text; SqlCommand cmdInsert = new SqlCommand("insert into Documenting(Doc_Name,Doc_Participate,Doc_Date,Doc_Date_From,Doc_Date_To," + "Doc_Par_Name,Doc_Par_No,Doc_Note,Doc_Executer,Doc_User) " + " Values(N'" + txtDoc_Name.Text + "' , N'" + txtDoc_Participate.Text + "',N'" + Doc_Date.ToString() + "',N'" + Doc_From + "'," + " N'" + Doc_To + "',N'" + Doc_Par_Name + "',N'" + txtDoc_Par_No.Text + "' ,N'" + Doc_Note + "' ," + " N'" + DrpDoc_Executer.SelectedValue + "'," + Session["User"].ToString() + ")", con); if (con.State == ConnectionState.Closed) con.Open(); //Response.Write(cmdInsert.CommandText.ToString()); cmdInsert.ExecuteNonQuery(); con.Close(); lblerror2.Text = "تم إضافة بيانات البرنامج الجديد"; txtDoc_Name.Text = ""; txtDoc_Par_No.Text = ""; txtDoc_Participate.Text = ""; txtYear.Text = ""; DrpDoc_Executer.ClearSelection();//منفذ البرنامج DrpDate.ClearSelection(); DrpMonth.ClearSelection(); DrpMonthFrom.ClearSelection(); DrpMonthTo.ClearSelection(); DrpDayTo.ClearSelection(); DrpDayFrom.ClearSelection(); FTBDoc_Note.Text = ""; FTBDoc_Par_Name.Text = ""; } con.Close(); } } catch { lblerror2.Text = "حدث خطأ حاول مرة أخري"; return; } } protected void btnreturn_Click(object sender, EventArgs e) { Response.Redirect("Documenting.aspx"); } }