public void clear()
 {
     EmployeeIdTextBox.Text  = "";
     EmployeeTextBox.Text    = "";
     DepartmentTextBox.Text  = "";
     DesignationTextBox.Text = "";
     AfterTextBox.Text       = "";
     BeforeTextBox.Text      = "";
     SubjectTextBox.Text     = "";
     BenefitsTextBox.Text    = "";
     CategoryCheckBoxList.ClearSelection();
     ImageFileUpload1.Dispose();
     ImageFileUpload2.Dispose();
     ImageFileUpload3.Dispose();
 }
        public void Insert()
        {
            DataSet Ds = new DataSet();

            try
            {
                NSM.IdeaId   = SIdeaId.ToString().Trim();
                NSM.IDepID   = SIDepID.ToString();
                NSM.IDesID   = SIDesID.ToString();
                NSM.IEmpId   = EmployeeIdTextBox.Text.ToString().TrimStart().TrimEnd();
                NSM.Date     = System.DateTime.Now.ToString("yyyy-MM-dd").ToString().Trim();
                NSM.Subject  = SubjectTextBox.Text.ToString().TrimStart().TrimEnd();
                NSM.Benefits = BenefitsTextBox.Text.ToString().TrimStart().TrimEnd();

                for (int i = 0; i < CategoryCheckBoxList.Items.Count; i++)
                {
                    if (CategoryCheckBoxList.Items[i].Selected)
                    {
                        k = k + CategoryCheckBoxList.Items[i].Text + ", ";
                    }
                }
                NSM.Category = k.ToString().TrimStart().TrimEnd();

                NSM.Before = BeforeTextBox.Text.ToString().TrimStart().TrimEnd();
                NSM.After  = AfterTextBox.Text.ToString().TrimStart().TrimEnd();

                if (ImageFileUpload1.HasFile)
                {
                    extn = System.IO.Path.GetExtension(ImageFileUpload1.FileName);
                    //path = Server.MapPath("\\PIMS\\UI\\Image\\");
                    path      = Server.MapPath("..\\UI\\Image\\");
                    ImageName = ImageFileUpload1.FileName;
                    ImageFileUpload1.SaveAs(path + ImageName);
                    etn = ImageName;
                    //Label1.Text = path;
                }
                else
                {
                    etn = "No File";
                }
                NSM.FileUpload1 = etn.ToString();
                if (ImageFileUpload2.HasFile)
                {
                    extn = System.IO.Path.GetExtension(ImageFileUpload2.FileName);
                    // path = Server.MapPath("\\PIMS\\UI\\Image\\");
                    path      = Server.MapPath("..\\UI\\Image\\");
                    ImageName = ImageFileUpload2.FileName;
                    ImageFileUpload2.SaveAs(path + ImageName);
                    etn = ImageName;
                    //Label1.Text = path;
                }
                else
                {
                    etn = "No File";
                }
                NSM.FileUpload2 = etn.ToString();
                if (ImageFileUpload3.HasFile)
                {
                    extn = System.IO.Path.GetExtension(ImageFileUpload3.FileName);
                    // path = Server.MapPath("\\PIMS\\UI\\Image\\");
                    path      = Server.MapPath("..\\UI\\Image\\");
                    ImageName = ImageFileUpload3.FileName;
                    ImageFileUpload3.SaveAs(path + ImageName);
                    etn = ImageName;
                    //Label1.Text = path;
                }
                else
                {
                    etn = "No File";
                }
                NSM.FileUpload3 = etn.ToString();
                NSM.Status      = status.ToString().TrimStart().TrimEnd();
                NSM.Approved    = Approved.ToString().Trim();
                NSM.Remark2     = "UnRead";
                NSM.Remark2     = Remark2.ToString().Trim();
                NSM.Remark3     = Remark3.ToString().Trim();
                NSM.Remark4     = Remark4.ToString().Trim();

                NSM.SuggestionInsert(NSM);
                ClientScript.RegisterStartupScript(this.GetType(), "randomtext", "alertme('Your Suggestion Posted')", true);
                //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Your Suggestion Posted')", true);
                i = 1;
                Response.Redirect("Default.aspx?value=" + NSM.IEmpId, false);
            }
            catch (Exception)
            {
                //throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message);
            }
        }
        public void TeamEvaluvationInsert()
        {
            CEmpEmailContents EECS = new CEmpEmailContents();
            DataSet           Ds   = new DataSet();

            try
            {
                int    i      = 0;
                int    j      = 0;
                string array1 = MailIdIMPTextBox.Text.ToString();
                //string array = EmpDepTextBox.Text.ToString();
                string ds = EmpIDIMPTextBox.Text.ToString();

                string[] breakMysentence  = ds.Split(',');
                string[] breakMysentence1 = array1.Split(',');
                string[] ena1             = new string[breakMysentence.Length];
                string[] mail1            = new string[breakMysentence.Length];
                foreach (string data in breakMysentence)
                {
                    ena1[i] = data;

                    i = i + 1;
                }

                foreach (string data1 in breakMysentence1)
                {
                    mail1[j] = data1;
                    j        = j + 1;
                }
                DepIdAutoGeneretion();
                for (int x = 0; x < ena1.Length; x++)
                {
                    ComEvalInboxIDAutoGeneration();


                    DBM.SendId        = SendID.ToString();
                    DBM.IdeaId        = IMPIdeaIdTextBox.Text.ToString();
                    DBM.HEmployeeName = us1.ToString();
                    DBM.TempMail      = array1.ToString();
                    DBM.TempId        = ds.ToString();
                    DBM.Date          = System.DateTime.Now.ToString("yyyy-MM-dd").ToString().Trim();
                    DBM.HEmployeeID   = ena1[x].ToString().TrimStart().TrimEnd();
                    DBM.Email         = mail1[x].ToString().TrimStart().TrimEnd();
                    DBM.Subject       = SubjectIMPTextBox.Text.TrimStart().TrimEnd().ToString();
                    DBM.Discription   = ContectIMPTextBox.Text.TrimStart().TrimEnd().ToString();

                    if (ImageFileUpload3.HasFile)
                    {
                        extn = System.IO.Path.GetExtension(ImageFileUpload3.FileName);
                        // path = Server.MapPath("\\PIMS\\UI\\Image\\");
                        path      = Server.MapPath("..\\UI\\Image\\");
                        ImageName = ImageFileUpload3.FileName;
                        ImageFileUpload3.SaveAs(path + ImageName);
                        etn = ImageName;
                        //Label1.Text = path;
                    }
                    else
                    {
                        etn = "No File";
                    }
                    DBM.FileUpload3 = etn.ToString();

                    DBM.Remark1 = "i";
                    DBM.Remark2 = "HOS";
                    string idof = txtHODid.Text;//Request.Form["hodid2"];
                    DBM.HODID = idof;

                    DBM.ComInboxID = ComEvalInboxID.ToString();
                    DBM.DBMEmail   = Session["Email"].ToString();
                    DBM.HosInboxInsert(DBM);
                }
                DBM.ImplTeamEvaInsert(DBM);
                string myscript = "alert ('Mail Send HOS');";
                Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "MyScript", myscript, true);
                z = 1;

                //E.EmployeeInsert(E);
                //ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('New Employee Record Is Added')", true);
            }
            catch (Exception e1)
            {
                //throw new Exception("Error Initializing Data Class." + Environment.NewLine + ex.Message);
            }
        }