/////if the hr or particulaer person register.

        public void AddUseraccount(UserSignup US, string LoginName)
        {
            using (RecrutmentsysEntities db = new RecrutmentsysEntities())
            {
                COMPANY_REGISTER_REFRENCES CRF = db.COMPANY_REGISTER_REFRENCES.Where(o => o.CompanyEmailRef.Equals(LoginName)).FirstOrDefault();
                COMPANY_HR_REGISTER        CHR = new COMPANY_HR_REGISTER();
                CHR.CompanyId = CRF.CompanyId;
                CHR.HrName    = US.HrName;
                CHR.HrContact = US.HrContact;
                CHR.HrEmail   = US.HrEmail;

                db.COMPANY_HR_REGISTER.Add(CHR);
                db.SaveChanges();

                string password = RandomString(8);

                COMPANY_REGISTER_REFRENCES CRR = new COMPANY_REGISTER_REFRENCES();
                CRR.CompanyId       = CHR.CompanyId;
                CRR.CompanyEmailRef = US.HrEmail;
                CRR.CompanyPassword = password;
                CRR.CompanyType     = "Other";
                db.COMPANY_REGISTER_REFRENCES.Add(CRR);
                db.SaveChanges();

                using (MailMessage mm = new MailMessage())
                {
                    mm.To.Add(new MailAddress(US.HrEmail));
                    mm.From       = new MailAddress("*****@*****.**");
                    mm.Subject    = "Your Password Genrated for by Admin!";
                    mm.Body       = "This email create is company use of term and condition <br/> Your Email:- " + US.HrEmail + " <br/> you Password:-" + password + " ";
                    mm.IsBodyHtml = true;

                    using (SmtpClient smtp = new SmtpClient())
                    {
                        smtp.Host      = "smtp.gmail.com";
                        smtp.EnableSsl = true;
                        NetworkCredential networkcred = new NetworkCredential("*****@*****.**", "connectists@57confuse");
                        smtp.UseDefaultCredentials = true;
                        smtp.Credentials           = networkcred;
                        smtp.Port = 587;
                        smtp.Send(mm);
                    }
                }
            }
        }
        // far to the new job opening

        public void AddnewjobIsopen(NewJobView NJV, string Loginname)
        {
            using (RecrutmentsysEntities db = new RecrutmentsysEntities())
            {
                COMPANY_HR_REGISTER CHR = db.COMPANY_HR_REGISTER.Where(o => o.HrEmail.Equals(Loginname)).FirstOrDefault();
                COMPANY_JOB_OPENING CJO = new COMPANY_JOB_OPENING();
                CJO.CompanyId                = Convert.ToInt32(CHR.CompanyId);
                CJO.HrId                     = CHR.HrId;
                CJO.DepartmentName           = NJV.DepartmentName;
                CJO.RequestedBy              = NJV.RequestedBy;
                CJO.HrEmail                  = Loginname;
                CJO.Name_of_Vacancy          = NJV.Name_of_Vacancy;
                CJO.Number_of_Position       = NJV.Number_of_Position;
                CJO.Required_Technical_Skill = NJV.Required_Technical_Skill;
                CJO.Special_Technical_Skill  = NJV.Special_Technical_Skill;
                CJO.Min_Yearof_Experience    = NJV.Min_Yearof_Experience;
                CJO.Min_Qualification        = NJV.Min_Qualification;
                CJO.Deadline_Date            = NJV.Deadline_Date;
                CJO.Requested_Date           = DateTime.Now;
                CJO.Approval                 = false;

                db.COMPANY_JOB_OPENING.Add(CJO);
                db.SaveChanges();

                COMPANY_JOB_OPENING_REFRENCES CJOR = new COMPANY_JOB_OPENING_REFRENCES();
                CJOR.CompanyId          = CJO.CompanyId;
                CJOR.HrId               = CJO.HrId;
                CJOR.DepartmentCode     = Convert.ToString(CJO.DepartmentCode);
                CJOR.Number_of_Position = CJO.Number_of_Position;
                CJOR.RowcreatedDate     = DateTime.Now;
                CJOR.RowModifiddate     = DateTime.Now;

                db.COMPANY_JOB_OPENING_REFRENCES.Add(CJOR);
                db.SaveChanges();
            }
        }