using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Threading;

public partial class _Default : System.Web.UI.Page
{
    public static int user_id;
    public static int dep;
    public static string dataNo = "";

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {

            user_id = int.Parse(Session["user_id"].ToString());
            Label11.Text = Session["User_Name"].ToString();
            dep = int.Parse(Session["dep"].ToString());
            //txtimprtNO.Text = 1 + "/";

            if (!Page.IsPostBack)
            {
                if (Session["User_Name"].ToString() == "Guest")
                {
                    Session["redirect"] = "Mail";
                    Response.Redirect("login.aspx");
                }

                else if (Session["User_Type"].ToString() == "Customer1")
                {
                    string connstring = ConfigurationManager.ConnectionStrings["import"].ToString();
                    SqlConnection conn = new SqlConnection(connstring);
                    MOHP.NICHP.fillComboBox(cmbDep, "select * from LTdepHosp where CodDep <> 7 and CodDep <> 8  and CodDep <> 0 ", conn, "-----");
                    MOHP.NICHP.fillComboBox(cmbDept, "select * from LTadmin", conn, "-----");
                    MOHP.NICHP.fillComboBox(cmbsent, "select * from LTsend where CodSend <> 3 ", conn, "------");
                }
                else if (Session["User_Type"].ToString() == "Customer3")
                {
                    string connstring = ConfigurationManager.ConnectionStrings["import"].ToString();
                    SqlConnection conn = new SqlConnection(connstring);
                    MOHP.NICHP.fillComboBox(cmbDep, "select * from LTdepHosp where CodDep <> 6 and CodDep <> 8  and CodDep <> 0", conn, "-----");
                    MOHP.NICHP.fillComboBox(cmbDept, "select * from LTadmin", conn, "-----");
                    fillsend();
                    //MOHP.NICHP.fillComboBox(cmbsent, "select * from LTsend where CodSend=3", conn, "----");
                }

            }
        }
    }
    void fillsend()
    {
        string connstring = ConfigurationManager.ConnectionStrings["import"].ToString();
        SqlConnection conn = new SqlConnection(connstring);
        SqlCommand cmdcmbDep = new SqlCommand();
        cmdcmbDep.CommandType = CommandType.StoredProcedure;
        cmdcmbDep.CommandText = "showsend";
        //cmdcmbDep.Parameters.AddWithValue("@codsend", 3);
        cmdcmbDep.Connection = conn;
        conn.Open();
        SqlDataAdapter da = new SqlDataAdapter(cmdcmbDep);
        DataSet ds = new DataSet();
        da.Fill(ds, "showsend");
        cmbsent.DataSource = ds;
        cmbsent.DataValueField = "CodSend";
        cmbsent.DataTextField = "NameSend";
        cmbsent.DataBind();
        conn.Close();
        conn.Dispose();
    }
    public string rep(string my_string)
    {
        my_string = my_string.Replace("أ", "ا");
        my_string = my_string.Replace("ة", "ه");
        my_string = my_string.Replace("ى", "ي");
        my_string = my_string.Replace("إ", "ا");

        return my_string;
    }

    protected void BTnCalnder_Click(object sender, EventArgs e)
    {

    }
    protected void cmbDep_SelectedIndexChanged(object sender, EventArgs e)
    {
        string connstring = ConfigurationManager.ConnectionStrings["import"].ToString();
        SqlConnection conn = new SqlConnection(connstring);
        MOHP.NICHP.fillComboBox(cmbHosp, "select codHosp,HospNam from LTHospt where codDep=" + cmbDep.SelectedValue, conn, "----");
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        checkimport();

    }
    public void insertimport()
    {
        lblchkImport.Visible = false;

        if (cmbDept.SelectedValue == "-1")
        {
            lblchkImport.Text = "لابد من  اختيار الجهة..................!";
            lblchkImport.Visible = true;

        }


        //else if (cmbHosp.SelectedValue == "-1")
        //{

        //    lblError.Visible = true;
        //    lblError.Text = "لابد من  اختيارالجهة الوارد منها";
        //}
        else if (cmbsent.SelectedValue == "-1")
        {

            lblError.Visible = true;
            lblError.Text = "لابد من  اختيار نوع المرسلة";
        }


        else if (txtAreaOut.Text.Trim() != "" && cmbDep.SelectedValue == "-1")
        {
            try
            {


                //dateNow = DateTime.Now.Year.ToString() + "/" + 1 + "/";
                //txtimprtNO.Text = dateNow.ToString() + txtimprtNO.Text.Trim();
                //txtimprtNO.Text = dateNow.ToString();
                string connstring = ConfigurationManager.ConnectionStrings["import"].ToString();
                SqlConnection conn = new SqlConnection(connstring);
                SqlCommand cmdinsert = new SqlCommand();
                cmdinsert.CommandType = CommandType.StoredProcedure;
                cmdinsert.CommandText = "insertimport";
                dataNo = DateTime.Now.Year.ToString() + "/" + txtAddNO.Text + "/" + txtimprtNO.Text.Trim();
                cmdinsert.Parameters.AddWithValue("@spcelNO", dataNo.ToString());
                cmdinsert.Parameters.AddWithValue("@DateImport", TxtDate.Text.ToString().Trim());
                cmdinsert.Parameters.AddWithValue("@codDep", "0");
                cmdinsert.Parameters.AddWithValue("@codHosp", "38");
                cmdinsert.Parameters.AddWithValue("@ExportNo", txtExpNO.Text.Trim());

                cmdinsert.Parameters.AddWithValue("@Subject",rep(txtSubjcet.Text.Trim()));
                cmdinsert.Parameters.AddWithValue("@coddept", int.Parse(cmbDept.SelectedValue));
                cmdinsert.Parameters.AddWithValue("@codsent", int.Parse(cmbsent.SelectedValue));
                cmdinsert.Parameters.AddWithValue("@Customer_id", Session["user_id"].ToString());
                cmdinsert.Parameters.AddWithValue("@AreaOut", txtAreaOut.Text.ToString());
                cmdinsert.Parameters.AddWithValue("@caseWork", false);
                cmdinsert.Parameters.AddWithValue("@CodDepIn", Session["dep"].ToString());
                cmdinsert.Parameters.AddWithValue("@Login_userName", Session["User_Name"].ToString());

                if (txtDateExport.Text.Length != 0)
                {
                    cmdinsert.Parameters.AddWithValue("@ExportDate", DateTime.Parse(txtDateExport.Text.Trim()));
                }
                else
                {
                    cmdinsert.Parameters.AddWithValue("@ExportDate", txtDateExport.Text.Trim());
                }
                if (txtDateEndWork.Text.Length != 0)
                {
                    cmdinsert.Parameters.AddWithValue("@DateEndWork", DateTime.Parse(txtDateEndWork.Text.Trim()));
                }
                else
                {
                    cmdinsert.Parameters.AddWithValue("@DateEndWork", txtDateEndWork.Text.Trim());
                }
                cmdinsert.Connection = conn;
                conn.Open();
                Thread.Sleep(50);

                cmdinsert.ExecuteNonQuery();
                //Response.Redirect("Default.aspx");
                conn.Close();
                lblchkImport.Text = "تم حفظ البيان بنجاح..................!";
                lblchkImport.Visible = true;
                //txtimprtNO.Text = 1 + "/";
            }

            catch (Exception ex)
            {

                lblError.Text = ex.Message;
            }

        }

        else if (cmbDep.SelectedValue != "-1" && txtAreaOut.Text.Trim() == "" && cmbHosp.SelectedValue != "-1")
        {
            try
            {

                string connstring = ConfigurationManager.ConnectionStrings["import"].ToString();
                SqlConnection conn = new SqlConnection(connstring);
                SqlCommand cmdinsert = new SqlCommand();
                cmdinsert.CommandType = CommandType.StoredProcedure;
                cmdinsert.CommandText = "insertimport";
                dataNo = DateTime.Now.Year.ToString() + "/" + txtAddNO.Text + "/" + txtimprtNO.Text.Trim();
                cmdinsert.Parameters.AddWithValue("@spcelNO", dataNo.ToString());
                cmdinsert.Parameters.AddWithValue("@DateImport", TxtDate.Text.ToString().Trim());
                cmdinsert.Parameters.AddWithValue("@codDep", int.Parse(cmbDep.SelectedValue));
                cmdinsert.Parameters.AddWithValue("@codHosp", int.Parse(cmbHosp.SelectedValue));
                cmdinsert.Parameters.AddWithValue("@ExportNo", txtExpNO.Text.Trim());

                cmdinsert.Parameters.AddWithValue("@Subject", rep(txtSubjcet.Text.Trim()));
                cmdinsert.Parameters.AddWithValue("@coddept", int.Parse(cmbDept.SelectedValue));
                cmdinsert.Parameters.AddWithValue("@codsent", int.Parse(cmbsent.SelectedValue));
                cmdinsert.Parameters.AddWithValue("@Customer_id", Session["user_id"].ToString());
                cmdinsert.Parameters.AddWithValue("@AreaOut", txtAreaOut.Text.ToString());
                cmdinsert.Parameters.AddWithValue("@caseWork", false);
                cmdinsert.Parameters.AddWithValue("@CodDepIn", Session["dep"].ToString());
                cmdinsert.Parameters.AddWithValue("@Login_userName", Session["User_Name"].ToString());
                if (txtDateExport.Text.Length != 0)
                {
                    cmdinsert.Parameters.AddWithValue("@ExportDate", DateTime.Parse(txtDateExport.Text.Trim()));
                }
                else
                {
                    cmdinsert.Parameters.AddWithValue("@ExportDate", txtDateExport.Text.Trim());
                }
                if (txtDateEndWork.Text.Length != 0)
                {
                    cmdinsert.Parameters.AddWithValue("@DateEndWork", DateTime.Parse(txtDateEndWork.Text.Trim()));
                }
                else
                {
                    cmdinsert.Parameters.AddWithValue("@DateEndWork", txtDateEndWork.Text.Trim());
                }
                cmdinsert.Connection = conn;
                conn.Open();
                cmdinsert.ExecuteNonQuery();
                //Response.Redirect("Default.aspx");
                conn.Close();
                lblchkImport.Text = "تم حفظ البيان بنجاح..................!";
                lblchkImport.Visible = true;
                //txtimprtNO.Text = 1 + "/";
                conn.Close();
                conn.Dispose();

            }

            catch (Exception ex)
            {

                lblError.Text = ex.Message;
            }
        }




    }


    protected void btnNewHosp_Click(object sender, EventArgs e)
    {
        //    if (cmbDep.SelectedValue=="6"||cmbDep.SelectedValue=="7"||cmbDep.SelectedValue=="8")
        //    {

        //            if (txtNewHosp.Text.Trim() != null && txtNewHosp.Text.Trim() != "")
        //            {
        //                string connstring = ConfigurationManager.ConnectionStrings["import"].ToString();
        //                SqlConnection conn = new SqlConnection(connstring);
        //                SqlCommand cmdinsert = new SqlCommand();
        //                cmdinsert.CommandType = CommandType.StoredProcedure;
        //                cmdinsert.CommandText = "newHosp";
        //                cmdinsert.Parameters.AddWithValue("@CodDep", int.Parse(cmbDep.SelectedValue.ToString()));
        //                cmdinsert.Parameters.AddWithValue("@HospNam", txtNewHosp.Text.Trim());
        //                cmdinsert.Connection = conn;
        //                conn.Open();
        //                cmdinsert.ExecuteNonQuery();
        //                Response.Redirect("Default.aspx");
        //                conn.Close();
        //                cmbDep_SelectedIndexChanged(sender, e);
        //                lblError.Text = "تم اضافة بيان";
        //            }
        //            else
        //            {

        //                lblError.Text = "لابد من ادخال بيان محدد اخرى";
        //            }


    }

    void checkimport()
    {
        string user_id1 = "";
        string chkimportNo = "";
        string chkmonth = "";
        string chkimportNo1 = "";
        //dateNow = DateTime.Now.Year.ToString() + "/" + "1" + "/";
        //txtimprtNO.Text =  txtimprtNO.Text.Trim()+dateNow.ToString();
        string connstring = ConfigurationManager.ConnectionStrings["import"].ToString();
        SqlConnection conn = new SqlConnection(connstring);
        SqlCommand cmdchk = new SqlCommand();
        cmdchk.CommandType = CommandType.StoredProcedure;
        cmdchk.CommandText = "checkimportNO";
        cmdchk.Parameters.AddWithValue("@user_id", int.Parse(user_id.ToString()));
        cmdchk.Parameters.AddWithValue("@spcelNO", txtimprtNO.Text.Trim());
        string userText = TxtDate.Text;
        lblchkImport.Text = userText.Substring(0, 2);
        cmdchk.Parameters.AddWithValue("@DateImport", lblchkImport.Text);
        cmdchk.Parameters.AddWithValue("@spcelNO1", DateTime.Now.Year.ToString());
        cmdchk.Connection = conn;
        conn.Open();
        SqlDataReader drchk = cmdchk.ExecuteReader();
        while (drchk.Read())
        {
            user_id1 = drchk.GetValue(2).ToString();
            chkimportNo = drchk.GetValue(0).ToString();
            chkmonth = drchk.GetValue(1).ToString();
            chkimportNo1 = drchk.GetValue(3).ToString();
        }
        lblchkImport.Text = chkmonth.ToString();
        if (chkimportNo != "" && chkmonth != "" && chkimportNo1 !="")
        {

            if (user_id1 == Session["user_id"].ToString())
            {
                lblchkImport.Text = "قد تم ادخل رقم المسلسل من قبل ولايمكن تسجلها مرة اخرى";

                lblchkImport.Visible = true;

            }
        }
         if (cmbDep.SelectedValue == "-1" && txtAreaOut.Text.Trim() == "")
        {

            lblchkImport.Text = "لابد من  اختيارالمراكز تابعة للامانة";
            lblchkImport.Visible = true;

        }
        else if (chkimportNo == "" && user_id1 !="0")
        {

            //dateNow = DateTime.Now.Year.ToString() + "/" + txtimprtNO.Text;
            //txtimprtNO.Text = dateNow.ToString();
            insertimport();
            lblchkImport.Text = "تم حفظ البيان بنجاح..................!";
            lblchkImport.Visible = true;
            //txtimprtNO.Text = 1 + "/";
        }
        conn.Close();
        conn.Dispose();
    }
}