Ejemplo n.º 1
0
        public void _getData( string queryString )
        {
            radHeader1.Checked = true;

            dt = new DataTable();
            dtCache = new DataTable();
            datamethods2 dtmth = new datamethods2();

            if (useRIMSConnString == true) dt = dtmth._dataTable_NoParameter_RIMS(queryString); // use RIMS connstring
            else   dt = dtmth._dataTable_NoParameter(queryString); // use RnS connString

            if (dtmth.sqlUserError == string.Empty)
            {
                dv = new DataView();
                dv = dt.DefaultView;
                grdSearch.DataSource = dv;
                dtCache = dt;

            }

            if (strHeader1.Trim() == string.Empty)
            {
                radHeader1.Text = "ID";
            }
            else
            {
                radHeader1.Text = strHeader1;
            }

            if (strHeader2.Trim() == string.Empty)
            {
                radHeader2.Text = "Description";
                radHeader2.Visible = false;

            }
            else
            {
                radHeader2.Text = strHeader2;
            }

            if (strHeader3.Trim() == string.Empty)
            {
                radHeader3.Text = "Description 2";
                radHeader3.Visible = false;
            }
            else
            {
                radHeader3.Text = strHeader3;
            }

            if (strHeader4.Trim() == string.Empty)
            {
                radHeader4.Text = "Description 3";
                radHeader4.Visible = false;
            }
            else
            {
                radHeader4.Text = strHeader4;
            }
        }
Ejemplo n.º 2
0
        private void button1_Click(object sender, EventArgs e)
        {
            datamethods2 dmth = new datamethods2();
            if (radrecrnoonly.Checked == true && txtsearchvalue.Text.Trim() != string.Empty)
            {

                database2BindingSource.DataSource = database2TableAdapter.GetDataByRecrnoOnly(prv_recrno.Trim());
                this.reportViewer1.RefreshReport();

            }

            // for like
            if (radlikeonly.Checked == true && txtsearchvalue.Text.Trim() != string.Empty)
            {

                try
                {
                    string selValue = cmblikeselection.SelectedItem.ToString();

                    String sqlSelect = @"select distinct * from database2 "
                        + " where ltrim(rtrim(" + selValue.Trim() + "))  LIKE '"
                        +  txtsearchvalue.Text.Trim() + "%'";

                    DataTable dt = new DataTable();
                    dt = dmth._dataTable_NoParameter(sqlSelect, ConfigurationManager.ConnectionStrings["rnsConString"].ConnectionString);

                    if (dmth.sqlUserError.Trim() == string.Empty)
                    {

                        // bind the datasource to the selected query datatable
                        if (dt.Rows.Count > 0)
                        {
                            database2BindingSource.DataSource = dt;
                            this.reportViewer1.RefreshReport();
                        }
                        else MessageBox.Show("Records records not found!", "RnS Notification");

                    }
                    else
                    {
                        MessageBox.Show(dmth.sqlUserError.Trim());
                        MessageBox.Show("Error occured, pls, try again(1)!", "RnS Notification");
                        dt.Dispose();
                    }
                }
                catch
                {
                    dmth.sqlUserError.Trim();
                    MessageBox.Show("Error occured, pls, try again(2)!", "RnS Notification");
                }
            }

            if (radall.Checked == true )
            {
                database2BindingSource.DataSource = database2TableAdapter.GetData();
                this.reportViewer1.RefreshReport();
            }
        }
Ejemplo n.º 3
0
        private void populateScreen()
        {
            string strid = txtid.Text;
            txtusername.Text = "";
            txtpassword.Text = "";
            txtconfirm.Text = "";
            txtusername.Text = "";
            chkclientrequest.Checked = false;
            chkclients.Checked = false;
            chkdatabase1.Checked = false;
            chkdatabase2.Checked = false;
            chkdownload.Checked = false;
            chksetups.Checked = false;
            chksuspended.Checked = false;
            chkusers.Checked = false;

            string queryString = string.Empty;
            queryString= "select distinct * from useracct where userid = " + "'" +strid+ "'";
            datamethods2 dthm = new datamethods2();
            SqlDataReader drRecords = dthm._dataReader_NoParameter(queryString);
            drRecords.Read();
            if (drRecords.HasRows)
            {

                newRecords = false;

                txtusername.Text = drRecords["names"].ToString();
                txtpassword.Text = drRecords["pwd"].ToString();
                txtconfirm.Text = drRecords["pwd"].ToString();
                chkclientrequest.Checked = Convert.ToBoolean( drRecords["crequest"]);
                chkclients.Checked = Convert.ToBoolean(drRecords["clientsetup"]);
                chkdatabase1.Checked = Convert.ToBoolean(drRecords["database1"]);
                chkdatabase2.Checked = Convert.ToBoolean(drRecords["database2"]);
                chkdownload.Checked = Convert.ToBoolean(drRecords["download"]);
                chksetups.Checked = Convert.ToBoolean(drRecords["othersetup"]);
                chksuspended.Checked = Convert.ToBoolean(drRecords["suspend"]);
                chkusers.Checked = Convert.ToBoolean(drRecords["usersetup"]);
                chkreports.Checked = Convert.ToBoolean(drRecords["reports"]);

            }
            drRecords.Dispose();
            pictureBox6.Focus();
            txtid.Enabled = false;
        }
Ejemplo n.º 4
0
 private void audittray()
 {
     datamethods2 dthm = new datamethods2();
     dthm.audittray("Setup/Modify User " + txtusername.Text.Trim());
 }
Ejemplo n.º 5
0
        private void saveRecords()
        {
            if (txtid.Text.Trim() == string.Empty)
            {
                MessageBox.Show("ID can't be empty!","Missing ID");
                return;
            }
            if (txtusername.Text.Trim() == string.Empty)
            {
                MessageBox.Show("Username can't be empty!", "Missing Username");
                return;
            }
            if (txtpassword.Text.Trim() == string.Empty)
            {
                MessageBox.Show("Password can't be empty!", "Missing Password");
                return;
            }
               if (newRecords == true )
               {

                if (txtconfirm.Text.Trim() == string.Empty)
                {
                    MessageBox.Show("Confirm Password pls.", "Missing Password");
                    return;
                }
                if (txtpassword.Text.Trim() != txtconfirm.Text.Trim())
                {
                    MessageBox.Show("Password and Confirm Password are not the same!", "Missing Password");
                    return;
                }
               }

            string strid = "'" + txtid.Text.Trim() + "'";
            string strusername = "******" + txtusername.Text + "'";
            string strpassword = "******" + txtpassword.Text + "'";
            string boolSuspend = "'" + chksuspended.Checked + "'";
            string booldatabase1 = "'" + chkdatabase1.Checked + "'";
            string booldatabase2 = "'" + chkdatabase2.Checked + "'";
            string boolclientsetup = "'" + chkclients.Checked + "'";
            string booldownload = "'" + chkdownload.Checked + "'";
            string boolusersetup = "'" + chkusers.Checked + "'";
            string boolcrequest = "'" + chkclientrequest.Checked + "'";
            string boolothersetup = "'" + chksetups.Checked + "'";
            string boolreports = "'" + chkreports.Checked + "'";

            //

            // save new  records
               if (newRecords == true)
               {

               datamethods2 dthm = new datamethods2();
               string sqlInsert = string.Empty;
               sqlInsert = @" insert into useracct (userid,pwd,names,suspend,database1,database2,
                clientsetup,download,usersetup,crequest,othersetup,reports)
                values (" + strid + "," + strpassword + "," + strusername + "," + boolSuspend + ","
                + booldatabase1 + "," + booldatabase2 + "," + boolclientsetup + "," + booldownload + ","
                + boolusersetup + "," + boolcrequest + "," + boolothersetup + "," + boolreports + ")";

               int returnVal = dthm._update_Insert_NoParameter(sqlInsert);

               if (dthm.sqlUserError.Trim() != string.Empty) MessageBox.Show(dthm.sqlUserError);
               else
               {
                   MessageBox.Show("Records Saved.", "RnS Notification");
                   clearScreen();
               }

               }
               else

               {

               datamethods2 dthm = new datamethods2();
               string sqlInsert = string.Empty;
               sqlInsert = @" update useracct set  pwd = " + strpassword + "," + " names= "
                + strusername + "," + " suspend = "  + boolSuspend+ "," + " database1 = "
                + booldatabase1 + "," + " database2 = " + booldatabase2 + ","
                + " clientsetup = " + boolclientsetup + "," + " download= "+ booldownload + ","
                + " usersetup= " + boolusersetup + ","
                + " crequest= " + boolcrequest + "," + " othersetup= " + boolothersetup + ","
                + " reports= " + boolreports + "  where userid = " + strid ;

               int returnVal = dthm._update_Insert_NoParameter(sqlInsert);

               if (dthm.sqlUserError.Trim() != string.Empty) MessageBox.Show(dthm.sqlUserError);
               else
               {
                   MessageBox.Show("Update was successful Saved.", "RnS Notification");
                   clearScreen();
               }
               }
        }
Ejemplo n.º 6
0
        private void saveRecords()
        {
            if (txtid.Text.Trim() == string.Empty)
            {
                MessageBox.Show("ID can't be empty!", "Missing ID");
                return;
            }
            if (txtsurname.Text.Trim() == string.Empty)
            {
                MessageBox.Show("Username can't be empty!", "Missing Username");
                return;
            }
            if (txtfirstname.Text.Trim() == string.Empty)
            {
                MessageBox.Show("Username can't be empty!", "Missing Username");
                return;
            }

            string strid = "'" + txtid.Text.Trim() + "'";
            string strsurname = "'" + txtsurname.Text + "'";
            string strfirstname = "'" + txtfirstname.Text + "'";
            string strtxtmiddlename= "'" + txtmiddlename.Text + "'";
            string strinitials = "'" +  txtinitials.Text + "'";
            string strtitle = "'" + cmbtitle.SelectedItem.ToString().Trim() + "'";
            string straddress = "'" +  txtaddress.Text + "'";
            string strgender = "'" + cmbgender.SelectedItem.ToString().Trim() + "'";
            string strdob = "'" +  mskdob.Text + "'";
            string strage = "'" +  mskage.Text + "'";
            string stremail = "'" +  txtemail.Text + "'";
            string strphone = "'" +  mskphone.Text + "'";
            string strlocation = "'" + txtlocation.Text + "'";
            string strqualification = "'" + txtqualification.Text + "'";
            string strgrade = "'" + txtgrade.Text + "'";
            string strdocscreened = "'" + chkdocscreened.Checked + "'";
            string straptested = "'" + chkaptested.Checked + "'";
            string strtransfered = "'" + chktransfered.Checked + "'";
            string strTextResult = "'" + cmbtestresult.SelectedItem.ToString().Trim() + "'";

            //

            // save new  records
            if (newRecords == true)
            {

                datamethods2 dthm = new datamethods2();
                string sqlInsert = string.Empty;
                sqlInsert = @" insert into database1 (recrno,surname,firstname,middlename,initials,address,
                title,sex,birthdate,age,phone,email,lgadescr,qualdescr,gradedescr,screened,aptest,
                active,testresult,lgacode,qualcode,gradecode)
                values (" + strid + "," + strsurname + "," + strfirstname + "," + strtxtmiddlename + ","
                 + strinitials + "," + straddress + "," + strtitle + "," + strgender + ","
                 + strdob + "," + strage + "," + strphone + "," + stremail + "," + strlocation + "," + strqualification
                 + "," + strgrade + "," + strdocscreened + "," + straptested + ","
                 + strtransfered + ","
                 + strTextResult + ","
                 + "'" + prv_location + "'" + ","
                 + "'" + prv_qual + "'" + ","
                 + "'" + prv_grade + "'" + ","
                 + ")";

                int returnVal = dthm._update_Insert_NoParameter(sqlInsert);

                if (dthm.sqlUserError.Trim() != string.Empty) MessageBox.Show(dthm.sqlUserError);
                else
                {
                    MessageBox.Show("Records Saved.", "RnS Notification");
                    clearScreen();
                }

            }
            else
            {

                datamethods2 dthm = new datamethods2();
                string sqlInsert = string.Empty;
                sqlInsert = @" update database1 set  surname = " + strsurname + "," + " firstname= "
                 + strfirstname + "," + " middlename = " + strtxtmiddlename + "," + " initials = "
                 + strinitials + "," + " address = " + straddress + ","
                 + " title = " + strtitle + "," + " sex= " + strgender + ","
                 + " birthdate= " + strdob + ","
                 + " age= " + strage + "," + " phone= " + strphone + ","
                 + " email= " + stremail + "," + " lgadescr= " + strlocation + "," + " qualdescr= " + strqualification + ","
                 + " gradedescr= " + strgrade + "," + " screened= " + strdocscreened + "," + " aptest= " + straptested
                 + "," + " active= " + strtransfered
                 + "," + " testresult= " + strTextResult
                 + "," + " lgacode= " + "'" + prv_location + "'"
                 + "," + " qualcode= " + "'" + prv_qual + "'"
                 + "," + " gradecode= " + "'" + prv_grade + "'"
                 + "  where recrno = " + strid;

                int returnVal = dthm._update_Insert_NoParameter(sqlInsert);

                if (dthm.sqlUserError.Trim() != string.Empty) MessageBox.Show(dthm.sqlUserError);
                else
                {

                    MessageBox.Show("Update was successful Saved.", "RnS Notification");
                    clearScreen();
                }
            }
        }
Ejemplo n.º 7
0
        private void saveRecords_database1()
        {
            string strRecrno = String.Empty;

            string sqlInsertwhere = string.Empty;
            List<string> lstRecrno = new List<string>();

            int _totalSaved = 0;

            // get all the recrno
            for (int x = 0; x < grdCandidate.Rows.Count; x++)
            {
                if (grdCandidate.Rows[x].Cells[0].Value.ToString() != null && grdCandidate.Rows[x].Cells[0].Value.ToString().Trim() != string.Empty)
                {
                    if (Convert.ToBoolean(grdCandidate.Rows[x].Cells[4].Value) == true) lstRecrno.Add(grdCandidate.Rows[x].Cells[0].Value.ToString().Trim());
                }

            }

            if (lstRecrno.Count > 0)
            {
                sqlInsertwhere = " where recrno = '" + lstRecrno[0] + "'";
                if (lstRecrno.Count - 1 > 0)
                {
                    for (int x = 1; x < lstRecrno.Count; x++)
                    {
                        sqlInsertwhere += " or recrno = '" + lstRecrno[x] + "'";
                    }
                }
            }

            if (sqlInsertwhere.Trim() == string.Empty) // do insert
            {
                MessageBox.Show("Select not made", "RnS Notification");
                return;
            }

            // save the records
            datamethods2 dthm = new datamethods2();
            DataTable dt = new DataTable();
            string sqlQueury = "Select distinct * from database1 ";
            sqlQueury += sqlInsertwhere;

            MessageBox.Show(sqlQueury);

            dt = dthm._dataTable_NoParameter(sqlQueury);
            if (dthm.sqlUserError == string.Empty)
            {
                if (dt.Rows.Count > 0)
                {
                    _totalSaved = 0;

                    for (int x = 0; x < dt.Rows.Count; x++)
                    {

                        // insert into database 2
                        string sqlInsert = string.Empty;
                        sqlInsert = @" Insert into database2 "
                            + "(recrno,surname,firstname,middlename,initials,address, "
                            + " title,sex,age,phone,email,lgacode,lgadescr,birthdate,gradecode,gradedescr,screened,aptest,active,"
                            + " qualdescr,qualcode,manager,testsult,modifiedby,"
                            + " inview,documented,medical,interviewed,shl,induction)"
                            + " values ('" + dt.Rows[x]["recrno"].ToString() + "',"
                            + "'" + dt.Rows[x]["surname"].ToString() + "',"
                            + "'" + dt.Rows[x]["firstname"].ToString() + "',"
                            + "'" + dt.Rows[x]["middlename"].ToString() + "',"
                            + "'" + dt.Rows[x]["initials"].ToString() + "',"
                            + "'" + dt.Rows[x]["address"].ToString() + "',"
                            + "'" + dt.Rows[x]["title"].ToString() + "',"
                            + "'" + dt.Rows[x]["sex"].ToString() + "',"
                            + "'" + (DateTime.Now.Year - Convert.ToDateTime(dt.Rows[x]["birthdate"]).Year).ToString() + "',"
                            + "'" + dt.Rows[x]["phone"].ToString() + "',"
                            + "'" + dt.Rows[x]["email"].ToString() + "',"
                            + "'" + dt.Rows[x]["lgacode"].ToString() + "',"
                            + "'" + dt.Rows[x]["lgadescr"].ToString() + "',"
                            + "'" + dt.Rows[x]["birthdate"].ToString() + "',"
                            + "'" + " " + "',"
                            + "'" + " " + "',"
                            + "'" + false + "',"
                            + "'" + false + "',"
                            + "'" + false + "',"
                            + "'" + " " + "',"
                            + "'" + " " + "',"
                            + "'" + Program.pbUserName.Trim()+ "',"
                            + "'" + " " + "',"
                            + "'" + " " + "',"
                            + "'" + false + "',"
                            + "'" + false + "',"
                            + "'" + false + "',"
                            + "'" + false + "',"
                            + "'" + false + "',"
                            + "'" + false
                            + ")";

                        MessageBox.Show(sqlInsert);
                        dthm._update_Insert_NoParameter(sqlInsert);

                        if (dthm.sqlUserError.Trim() != string.Empty) MessageBox.Show(dthm.sqlUserError, "RnS Notification");
                        else
                        {

                            string strTime = DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + x.ToString();

                            // insert into candidtaerequest 2
                            sqlInsert = string.Empty;

                            //sqlInsert = @" Insert into candidatecallup "
                            //    + "(recrno,reqid,position,requestid,clientid,datesent, "
                            //    + " interview,ippased,employed,remarks)"
                            //    + " values ('" + dt.Rows[x]["recrno"].ToString() + "',"
                            //    + "'" + strTime + "',"
                            //    + "'" + lblposition.Text + "',"
                            //    + "'" + txtrequestid.Text + "',"
                            //    + "'" + txtclientid.Text + "',"
                            //    + "'" + "01/01/1900" + "',"
                            //    + "'" + false + "',"
                            //    + "'" + false + "',"
                            //    + "'" + false + "',"
                            //    + "'" + " " + "'"
                            //    + ")";

                            sqlInsert = @" Insert into candidatecallup "
                               + "(recrno,reqid,posdescr,requestid,clientid, position,,reqdescr)"
                               + " values ('" + dt.Rows[x]["recrno"].ToString() + "',"
                               + "'" + strTime + "',"
                               + "'" + lblposition.Text + "',"
                               + "'" + txtrequestid.Text + "',"
                               + "'" + txtclientid.Text + "',"
                               + "'" + prv_Poscode.Trim() + "'"
                               + "'" + lblrequestdescr.Text.Trim() + "'"
                               + ")";
                            dthm._update_Insert_NoParameter(sqlInsert);

                            // update into database1
                            sqlInsert = string.Empty;
                            sqlInsert = @" update database1 set active = 'true' where recrno = '" + dt.Rows[x]["recrno"].ToString() + "'";

                            dthm._update_Insert_NoParameter(sqlInsert);

                            _totalSaved += 1;

                            try
                            {
                                grdCandidate.Rows[x].Cells[8].Value = true;
                            }
                            catch
                            {
                            }

                        }
                    }
                }
                else MessageBox.Show("There are no records to processed", "RnS Notification");
            }

            else MessageBox.Show(dthm.sqlUserError, "RnS Notification");

            if (_totalSaved > 0) MessageBox.Show(_totalSaved.ToString() + " records was committed Successfully", "RnS Notification");
        }
Ejemplo n.º 8
0
        private void populateGrid()
        {
            string strid = "'" + txtid.Text + "'";


            String sqlSelect = @"select * from candidatecallup where recrno = " + strid;
           
            //DataTable dt = new DataTable();
            datamethods2 dtmth = new datamethods2();
            dt_callup.Rows.Clear();
            dt_callup = dtmth._dataTable_NoParameter(sqlSelect);

            if (dtmth.sqlUserError == string.Empty)
            {
                if (dt_callup.Rows.Count > 0)
                {

                    _addColumns(dt_callup);

                }
            }
            else
            {
                MessageBox.Show(dtmth.sqlUserError, "RnS Notification");
            }
         
        }
Ejemplo n.º 9
0
        private void populateScreen()
        {
            
            
            string strid = txtid.Text;
            clearScreen();
            txtid.Text = strid;
             

            string queryString = string.Empty;

            queryString = "select distinct * from database2 where recrno = " + "'" + strid + "'";
            datamethods2 dthm = new datamethods2();
            SqlDataReader drRecords = dthm._dataReader_NoParameter(queryString);
            drRecords.Read();
            if (drRecords.HasRows)
            {
                
                newRecords = false;


                txtsurname.Text = drRecords["surname"].ToString();
                txtfirstname.Text = drRecords["firstname"].ToString();
                txtmiddlename.Text = drRecords["middlename"].ToString();
         
                chkaptested.Checked = Convert.ToBoolean(drRecords["aptest"]);

                chkdocumented.Checked = Convert.ToBoolean(drRecords["documented"]);
                chkactive.Checked = Convert.ToBoolean(drRecords["active"]);
                chkmedical.Checked = Convert.ToBoolean(drRecords["medical"]);

                txtinitials.Text = drRecords["initials"].ToString();
                cmbtitle.Text = drRecords["title"].ToString();
                txtaddress.Text = drRecords["address"].ToString();
                cmbgender.Text = drRecords["sex"].ToString();
                dtpdob.Value = Convert.ToDateTime(drRecords["birthdate"]);
                
                // -- calacualte the age
                DateTime dtime = Convert.ToDateTime(drRecords["birthdate"]);
                Int32 int_year = dtime.Year;
                Int32 int_month = dtime.Month;
                Int32 int_Day = dtime.Day;
                Int32 int_yearDiff =  DateTime.Now.Date.Year-dtime.Year;

                
                if (int_yearDiff > 0)
                {
                    if (DateTime.Now.Date.Month >= int_month)
                    {
                       
                        if(DateTime.Now.Day >= int_Day )
                        {
                            
                            mskage.Text = (int_yearDiff).ToString();
                        }
                        else mskage.Text = (int_yearDiff-1).ToString();
                    }
                    else mskage.Text = (int_yearDiff - 1).ToString();
                }
                else mskage.Text ="0";

                
                // ------------------ 
                
                
               
                txtemail.Text = drRecords["email"].ToString();
                mskphone.Text = drRecords["phone"].ToString();

                txtlocation.Text = drRecords["lgadescr"].ToString();
                prv_location = drRecords["lgacode"].ToString();

                txtqualification.Text = drRecords["qualdescr"].ToString();
                prv_qual = drRecords["qualcode"].ToString();

                txtgrade.Text = drRecords["gradedescr"].ToString();
                prv_grade = drRecords["gradecode"].ToString();


                chkicslinterview.Checked = Convert.ToBoolean(drRecords["interviewed"]);
                cmdtinterviewresult.Text = drRecords["intersult"].ToString();
                cmbtestresult.Text = drRecords["testsult"].ToString();
                cmbmedicalresult.Text = drRecords["medsult"].ToString();
                txtmedissue.Text = drRecords["medissue"].ToString();
                chkessay.Checked = Convert.ToBoolean(drRecords["essay"]);
                cmbessayresult.Text = drRecords["essaysult"].ToString();
                chkshl.Checked = Convert.ToBoolean(drRecords["shl"]);
                chkinduction.Checked = Convert.ToBoolean(drRecords["induction"]);
                cmbinductionresult.Text = drRecords["inductsult"].ToString();
                txtmanager.Text = drRecords["manager"].ToString();
                mskrecordmanagerdate.Text = drRecords["entrydate"].ToString();
                mskmodifieddate.Text = drRecords["modifydate"].ToString();
                txtmodifiedby.Text = drRecords["modifiedby"].ToString();

                if (chkactive.Checked == true) chkactive.Enabled = false;
                drRecords.Dispose();
                //populateCandidateCallups();
               
            }
            else
            {
                drRecords.Close();
                drRecords.Dispose();


                queryString = "select distinct * from database1 where recrno = " + "'" + strid + "'";
                drRecords = dthm._dataReader_NoParameter(queryString);
                drRecords.Read();
                if (drRecords.HasRows)
                {
                    newRecords = true;
                    txtsurname.Text = drRecords["surname"].ToString();
                    txtfirstname.Text = drRecords["firstname"].ToString();
                    txtmiddlename.Text = drRecords["middlename"].ToString();
                    
                    chkaptested.Checked = Convert.ToBoolean(drRecords["aptest"]);

                    txtinitials.Text = drRecords["initials"].ToString();
                    cmbtitle.Text = drRecords["title"].ToString();
                    txtaddress.Text = drRecords["address"].ToString();
                    cmbgender.Text = drRecords["sex"].ToString();
                    dtpdob.Text = drRecords["birthdate"].ToString();
                    mskage.Text = drRecords["age"].ToString();
                    txtemail.Text = drRecords["email"].ToString();
                    mskphone.Text = drRecords["phone"].ToString();

                    cmbtestresult.Text = drRecords["testresult"].ToString();

                    txtlocation.Text = drRecords["lgadescr"].ToString();
                    prv_location = drRecords["lgacode"].ToString();

                    txtqualification.Text = drRecords["qualdescr"].ToString();
                    prv_qual = drRecords["qualcode"].ToString();

                    txtgrade.Text = drRecords["gradedescr"].ToString();
                    prv_grade = drRecords["gradecode"].ToString();

                }
                drRecords.Dispose();
            }

            
           
            txtid.Enabled = false;
            populateGrid();
        }
Ejemplo n.º 10
0
        private void login()
        {
            if (txtuserid.Text.Trim() == string.Empty)
            {
                MessageBox.Show("ID can't be empty!", "Missing ID");
                return;
            }

            if (txtpassword.Text.Trim() == string.Empty)
            {
                MessageBox.Show("Password can't be empty!", "Missing Password");
                return;
            }

            txtuserid.Enabled = false;
            txtpassword.Enabled = false;

            string strid = "'" + txtuserid.Text.Trim() + "'";
            string strpassword = "******" + txtpassword.Text + "'";

            string queryString = string.Empty;
            queryString = @"select distinct * from useracct where userid = " + strid
                + " and pwd = " +  strpassword ;

            datamethods2 dthm = new datamethods2();
            SqlDataReader drRecords;
            drRecords = dthm._dataReader_NoParameter(queryString);
            if (dthm.sqlUserError != String.Empty)
            {
                MessageBox.Show(dthm.sqlUserError);
                drRecords.Close();
                drRecords.Dispose();
                return;
            }

            drRecords.Read();
            if (drRecords.HasRows)
            {
                // get the access right vaiables
                if (Convert.ToBoolean(drRecords["suspend"]) == true)
                {
                    MessageBox.Show("Users Suspended!", "RnS Notification");
                    txtuserid.Enabled = true;
                    txtpassword.Enabled = true;
                    return;
                }

                Program.pbClientRequestAccess = Convert.ToBoolean(drRecords["crequest"]);
                Program.pbClientSetupAccess = Convert.ToBoolean(drRecords["clientsetup"]);
                Program.pbDatabase1Access = Convert.ToBoolean(drRecords["database1"]);
                Program.pbDatabase2Access = Convert.ToBoolean(drRecords["database2"]);
                Program.pbDownloadAcess = Convert.ToBoolean(drRecords["download"]);
                Program.pbSetupAccess = Convert.ToBoolean(drRecords["othersetup"]);
                Program.pbUserSetupAccess = Convert.ToBoolean(drRecords["usersetup"]);
                Program.pbReportAccess = Convert.ToBoolean(drRecords["reports"]);
                Program.pbUserName = drRecords["names"].ToString().Trim();
                Program.pbUserID = drRecords["userid"].ToString().Trim();

                MessageBox.Show("Welcome User: "******"RnS Notification");

                // open the main form
                Form1 frm_fm1 = new Form1();
                frm_fm1.FormClosed += new FormClosedEventHandler(frm2_FormClosed);
                frm_fm1.Show();
                this.Hide();

            }
            else
            {
                MessageBox.Show("Invalid Users...", "RnS Notification");
                txtuserid.Enabled = true;
                txtpassword.Enabled = true;
            }
            drRecords.Close();
            drRecords.Dispose();
        }
Ejemplo n.º 11
0
        private void _getOnlineRecords()
        {
            string strQuery = string.Empty;
            strQuery = "select recrno ,Surname, Othernames,Initials from recruittab where used = 'false'";
            datamethods2 dmth = new datamethods2();
            DataTable dt = new DataTable();
            dt = dmth._dataTable_NoParameter_webdb(strQuery);
            if (dmth.sqlUserError == String.Empty)
            {
                if (dt.Rows.Count > 0)
                {
                    dgvSource.Rows.Clear();
                    for (int x = 0; x < dt.Rows.Count; x++)
                    {

                        int n = dgvSource.Rows.Add();
                        dgvSource.Rows[n].Cells[0].Value = dt.Rows[x]["recrno"].ToString().Trim();
                        dgvSource.Rows[n].Cells[1].Value = dt.Rows[x]["surname"].ToString().Trim();
                        dgvSource.Rows[n].Cells[2].Value = dt.Rows[x]["othernames"].ToString().Trim();
                        dgvSource.Rows[n].Cells[3].Value = dt.Rows[x]["initials"].ToString().Trim();

                    }
                }
                else
                {
                    MessageBox.Show("Records not available! ","RnS Notification");
                }
            }
            else
            {
                MessageBox.Show(dmth.sqlUserError,"RnS Notification");
            }
        }
Ejemplo n.º 12
0
        private void _getDownloaded()
        {
            string strQuery = string.Empty;
            strQuery = "select recrno,Surname, firstname, middlename, Initials from database1";
            datamethods2 dmth = new datamethods2();
            DataTable dt = new DataTable();
            dt = dmth._dataTable_NoParameter(strQuery);
            if (dmth.sqlUserError == String.Empty)
            {
                if (dt.Rows.Count > 0)
                {
                    dgvDestination.Rows.Clear();
                    for (int x = 0; x < dt.Rows.Count; x++)
                    {

                        int n = dgvDestination.Rows.Add();
                        dgvDestination.Rows[n].Cells[0].Value = dt.Rows[x]["recrno"].ToString().Trim();
                        dgvDestination.Rows[n].Cells[1].Value = dt.Rows[x]["surname"].ToString();
                        dgvDestination.Rows[n].Cells[2].Value = dt.Rows[x]["firstname"].ToString().Trim() + " " + dt.Rows[x]["middlename"].ToString().Trim();
                        dgvDestination.Rows[n].Cells[3].Value = dt.Rows[x]["initials"].ToString().Trim();
                        dgvDestination.Rows[n].Cells[4].Value = true;
                    }
                }
                else
                {
                    MessageBox.Show("Records not available! ", "RnS Notification");
                }
            }
            else
            {
                MessageBox.Show(dmth.sqlUserError, "RnS Notification");
            }
        }
Ejemplo n.º 13
0
        private void saveRecords()
        {
            if (dgvDestination.Rows.Count == 0 )
            {
                MessageBox.Show("Move records into destination table", "RnS Notification");
                return;
            }

            lblprocessing.Text = "Processing pls wait...";

            string strRecrno = String.Empty;

            string sqlInsertwhere = string.Empty;
            List<string> lstRecrno = new List<string>();

            int _totalSaved = 0;

            // get all the recrno
            for (int x = 0; x < dgvDestination.Rows.Count; x++)
            {
                if (dgvDestination.Rows[x].Cells[0].Value.ToString() != null && dgvDestination.Rows[x].Cells[0].Value.ToString().Trim() != string.Empty)
                {
                  if (Convert.ToBoolean(dgvDestination.Rows[x].Cells[4].Value) == false) lstRecrno.Add(dgvDestination.Rows[x].Cells[0].Value.ToString().Trim());
                }

            }

            if (lstRecrno.Count > 0)
            {
                sqlInsertwhere = "where recrno = '" + lstRecrno[0] + "'";
                if (lstRecrno.Count - 1 > 0)
                {
                    for (int x = 1; x < lstRecrno.Count; x++)
                    {
                        sqlInsertwhere += " or recrno = '" + lstRecrno[x] + "'";
                    }
                }
            }

            if (sqlInsertwhere.Trim() == string.Empty) // do insert
            {
                MessageBox.Show("There are no new records to save", "RnS Notification");
                lblprocessing.Visible = false;
                return;
            }

            // save the records
            datamethods2 dthm = new datamethods2();
            DataTable dt = new DataTable();
            string sqlQueury = "Select * from recruittab ";
            sqlQueury += sqlInsertwhere;
            dt = dthm._dataTable_NoParameter_webdb(sqlQueury);
            if (dthm.sqlUserError == string.Empty)
            {
                if (dt.Rows.Count > 0)
                {
                    _totalSaved = 0;
                    string strLgaDescr = String.Empty;

                    for (int x = 0; x < dt.Rows.Count; x++)
                    {
                        lblprocessing.Visible = true;
                        lblprocessing.Text = "Processing Record " + (x + 1).ToString() + " of " + dt.Rows.Count.ToString();

                        string strSex = "Male";

                        if (dt.Rows[x]["sex"].ToString() == "2")
                        {
                            strSex = "Female";
                        }

                        strLgaDescr = "";

                        if (dt.Rows[x]["lga"].ToString().Trim() != string.Empty )
                        {
                            string sqlgetDescr = string.Empty;
                            sqlgetDescr = "select desc1 from codestab where option1='LGACODE' and code = '" + dt.Rows[x]["lga"].ToString() + "'";
                            SqlDataReader dr = dthm._dataReader_NoParameter(sqlgetDescr, ConfigurationManager.ConnectionStrings["rnsConString_rims"].ConnectionString);
                            if (dthm.sqlUserError == string.Empty)
                            {
                                dr.Read();
                                if (dr.HasRows)    strLgaDescr = dr["desc1"].ToString();
                            }
                            dr.Dispose();
                            dr.Close();
                        }

                        string sqlInsert = string.Empty;
                        sqlInsert = @" Insert into database1 "
                            + "(recrno,surname,firstname,middlename,initials,address, "
                            + " title,sex,age,phone,email,lgacode,lgadescr,birthdate,gradecode,gradedescr,qualcode,qualdescr,testresult,screened,aptest,active)"
                            + " values ('" + dt.Rows[x]["recrno"].ToString() + "',"
                            + "'" + dt.Rows[x]["surname"].ToString() + "',"
                            + "'" + dt.Rows[x]["othernames"].ToString() + "',"
                            + "'" + dt.Rows[x]["initials"].ToString() + "',"
                            + "'" + " " + "',"
                            + "'" + dt.Rows[x]["address"].ToString() + "',"
                            + "'" + dt.Rows[x]["title"].ToString() + "',"
                            + "'" + strSex + "',"
                            + "'" + (DateTime.Now.Year - Convert.ToDateTime(dt.Rows[x]["birthdate"]).Year).ToString() + "',"
                            + "'" + dt.Rows[x]["phone"].ToString() + "',"
                            + "'" + dt.Rows[x]["email"].ToString() + "',"
                            + "'" + dt.Rows[x]["lga"].ToString() + "',"
                            + "'" + strLgaDescr + "',"
                            + "'" + dt.Rows[x]["birthdate"].ToString() + "',"
                            + "'" + " " + "',"
                            + "'" + " " + "',"
                            + "'" + " " + "',"
                            + "'" + " " + "',"
                            + "'" + " " + "',"
                            + "'" + false + "',"
                            + "'" + false + "',"
                            + "'" + false + "')";

                        dthm._update_Insert_NoParameter(sqlInsert);

                        if (dthm.sqlUserError.Trim() != string.Empty) MessageBox.Show(dthm.sqlUserError, "RnS Notification");
                        else
                        {
                            _totalSaved += 1;

                            // update the webdb recruittaab
                            string sqlUpdate = string.Empty;
                            sqlUpdate = @" update recruittab set  used = 'true'"
                             + "  where recrno = '" + dt.Rows[x]["recrno"].ToString() + "'";
                            dthm._update_Insert_NoParameter(sqlUpdate, ConfigurationManager.ConnectionStrings["rnsConString_webdb"].ConnectionString);

                            try
                            {
                                dgvDestination.Rows[x].Cells[4].Value = true;
                            }
                            catch
                            {
                            }

                        }
                    }
                }
                else
                {

                    MessageBox.Show("There are no records to processed", "RnS Notification");
                    lblprocessing.Visible = false;
                }

            }

            else MessageBox.Show("dthm.sqlUserError","RnS Notification");

            if (_totalSaved > 0) MessageBox.Show(_totalSaved.ToString() + " records was committed Successfully", "RnS Notification");

            lblprocessing.Visible = false;
        }
Ejemplo n.º 14
0
        private void saveRecords_database2()
        {
            string strRecrno = String.Empty;

            string sqlInsertwhere = string.Empty;
            List<string> lstRecrno = new List<string>();

            int _totalSaved = 0;

            datamethods2 dthm = new datamethods2();

            // get all the recrno
            for (int x = 0; x < grdCandidate.Rows.Count; x++)
            {
                try
                {
                    if (Convert.ToBoolean(grdCandidate.Rows[x].Cells[7].Value)== true  && grdCandidate.Rows[x].Cells[0].Value.ToString().Trim() != string.Empty)
                    {
                        string strTime = DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + x.ToString();

                        MessageBox.Show(DateTime.Now.Date.ToString("yyyy/MM/dd"));

                        // insert into candidtaerequest 2
                        string sqlInsert = string.Empty;
                        sqlInsert = @" Insert into candidatecallup "
                            + "(recrno,reqid,posdescr,request,clientid,position,reqdescr,dcallup)"
                            + " values ('" + grdCandidate.Rows[x].Cells[0].Value.ToString() + "',"
                            + "'" + strTime + "',"
                            + "'" + lblposition.Text + "',"
                            + "'" + txtrequestid.Text + "',"
                            + "'" + txtclientid.Text + "',"
                            + "'" + prv_Poscode.Trim() + "',"
                            + "'" + lblrequestdescr.Text.Trim() + "',"
                            + "'" + DateTime.Now.Date.ToString("yyyy/MM/dd") + "'"
                            + ")";

                        dthm._update_Insert_NoParameter(sqlInsert);

                        if (dthm.sqlUserError.Trim() != string.Empty) MessageBox.Show(dthm.sqlUserError, "RnS Notification");
                        else
                        {

                            _totalSaved += 1;

                        }

                        // update the status of the grid
                        try
                        {
                            grdCandidate.Rows[x].Cells[8].Value = true;
                        }
                        catch
                        {
                        }

                    }
                }
                catch
                {
                }

            }
            if (_totalSaved > 0) MessageBox.Show(_totalSaved.ToString() + " records was committed Successfully", "RnS Notification");
        }
Ejemplo n.º 15
0
        private void Sample_report_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'rnsDataSet.clientrequest' table. You can move, or remove it, as needed.
            this.clientrequestTableAdapter.Fill(this.rnsDataSet.clientrequest);
            // TODO: This line of code loads data into the 'rnsDataSet.clientrequest' table. You can move, or remove it, as needed.

            //SqlConnection conn = new SqlConnection();
            //conn.ConnectionString = ConfigurationManager.ConnectionStrings["rnsConString"].ConnectionString;
            //if (conn.State == ConnectionState.Closed) conn.Open();

            //SqlCommand comm = new SqlCommand("select * from clientrequest where clientid = ''", conn);
            //rnsDataSet dr = new rnsDataSet();

            // TODO: This line of code loads data into the 'rnsDataSet.clientrequest' table. You can move, or remove it, as needed.

            // TODO: This line of code loads data into the 'sampledataset.clientrequest' table. You can move, or remove it, as needed.

            datamethods2 dmth = new datamethods2();

            //rnsDataSet dsrns = new rnsDataSet();
            //MessageBox.Show(dsrns.Tables.Count.ToString());
            //SqlDataAdapter da = new SqlDataAdapter();
            //da.Fill(dsrns);

            this.reportViewer1.RefreshReport();
            this.reportViewer1.RefreshReport();
        }
Ejemplo n.º 16
0
        private void populateGrid()
        {
            string strClientId = "'" + txtclientid.Text +"'";
            string strRequestId = "'" + Program._searchedValue.Trim() + "'";

            //if (!= string.Empty) txtrequestid.Text = Program._searchedValue;

            String sqlSelect = @"select * from clientrequest where clientid = " + strClientId +
            " and requestid = " + strRequestId;
            DataTable dt = new DataTable();
            datamethods2 dtmth = new datamethods2();
            dt = dtmth._dataTable_NoParameter(sqlSelect);
            if (dtmth.sqlUserError == string.Empty)
            {
                if (dt.Rows.Count > 0)
                {
                    txtrequestid.Text = Program._searchedValue.Trim();
                    dtpdeadline.Value = Convert.ToDateTime(dt.Rows[0]["drequest"]);
                    dtprequesteddate.Value = Convert.ToDateTime(dt.Rows[0]["reqdate"]);
                    txttitle.Text = Program._searchedValue2;

                    if (Convert.ToBoolean(dt.Rows[0]["status"]) == true)
                    {
                        chkactive.Checked = true;
                        chkactive.Enabled = false;
                        dtpdeadline.Enabled = false;
                    }

                     _addColumns(dt);

                }
                else
                {

                    // create a new request id
                    string strTime = DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString();
                    string strdate = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString();
                    string newRequestId = txtclientid.Text.Trim().ToUpper() + "/" + strdate + "/" + strTime;
                    txtrequestid.Text = newRequestId;
                    dtpdeadline.Text = DateTime.Now.Date.ToString();
                    txttitle.Text = "";

                }

                _formatCells();

            }
            else
            {
                MessageBox.Show(dtmth.sqlUserError,"RnS Notification");
            }
            txtrequestid.Enabled = false;
            //mskrequestdate.Focus();
        }
Ejemplo n.º 17
0
        private void saveRecords()
        {


            if (txtid.Text.Trim() == string.Empty)
            {
                MessageBox.Show("ID can't be empty!", "Missing ID");
                return;
            }
            if (txtsurname.Text.Trim() == string.Empty)
            {
                MessageBox.Show("Username can't be empty!", "Missing Username");
                return;
            }
            if (txtfirstname.Text.Trim() == string.Empty)
            {
                MessageBox.Show("Username can't be empty!", "Missing Username");
                return;
            }


            if (txtclient.Text.Trim() != string.Empty)
            {
                if (txtrequest.Text.Trim() == string.Empty)
                {
                    MessageBox.Show("Specify the client request!", "Missing request");
                    return;
                }

            }

           

            if (txtclient.Text.Trim() != string.Empty && txtrequest.Text.Trim() != string.Empty)
            {
                // if position is not selected
                if (txtposition.Text == String.Empty)
                {
                    MessageBox.Show("Specified Position", "RnS Notification");
                    return;
                }
                
                // checked employment infos
                if (chkclientinterview.Checked == true)
                {
                    // if emplyment type si not selected
                    if (cmbemploymenttype.SelectedIndex == 0)
                    {
                        MessageBox.Show("Specified Employment Type", "RnS Notification");
                        return;
                    }

                    // if position is not selected
                    if (txtposition.Text  == String.Empty)
                    {
                        MessageBox.Show("Specified Position", "RnS Notification");
                        return;
                    }

                    // if int location is not selected
                    if (interiewlocation.Text == String.Empty)
                    {
                        MessageBox.Show("Specified Interview Location", "RnS Notification");
                        return;
                    }

                    // if int location is not selected
                    if (cmbintassessment.SelectedIndex==0)
                    {
                        MessageBox.Show("Specified Interview Assessment", "RnS Notification");
                        return;
                    }

                   
                }
                
              
              
                   // if int location is not selected
                if (chkcinduction.Checked==true && cmbcindsult.SelectedIndex == 0 )
                {
                    
                        MessageBox.Show("Specified Induction Result", "RnS Notification");
                        return;
               

                }

            }




          

             string strentrydate = string.Empty;
             if (mskrecordmanagerdate.MaskFull == false) strentrydate = "'" + DateTime.Now.ToString("yyyy/MM/dd") + "'";
             else strentrydate = "'" + Convert.ToDateTime(mskrecordmanagerdate.Text).ToString("yyyy/MM/dd") + "'";


            string strid = "'" + txtid.Text.Trim() + "'";
            string strsurname = "'" + txtsurname.Text + "'";
            string strfirstname = "'" + txtfirstname.Text + "'";
            string strtxtmiddlename = "'" + txtmiddlename.Text + "'";
            string strinitials = "'" + txtinitials.Text + "'";
            string strtitle = "'" + cmbtitle.Text + "'";
            string straddress = "'" + txtaddress.Text + "'";
            string strgender = "'" + cmbgender.Text + "'";
            string strdob = "'" + dtpdob.Value.ToString("yyyy/MM/dd") + "'";
            string strage = "'" + mskage.Text + "'";
            string stremail = "'" + txtemail.Text + "'";
            string strphone = "'" + mskphone.Text + "'";
            string strlocation = "'" + txtlocation.Text + "'";
            string strqualification = "'" + txtqualification.Text + "'";
            string strgrade = "'" + txtgrade.Text + "'";
            string straptested = "'" + chkaptested.Checked + "'";

            string stremployed = "'" + chkcinduction.Checked + "'";
            string strdocumented = "'" + chkdocumented.Checked + "'";
            string stractive = "'" + chkactive.Checked + "'";
            string strmedical = "'" + chkmedical.Checked + "'";
            string stricslinterviewd = "'" + chkicslinterview.Checked + "'";


           

            string strdtpclientinterviewdate = dtpclientinterviewdate.Text;
            string strmskresumptiondate = dtpresumptiondate.Text;

            string strRequestdescr = "'" + txtrequest.Text + "'";
            string strModifiedBy = "'" + Program.pbUserName + "'";
            //


           
           

            // save new  records
            if (newRecords == true)
            {
                strModifiedBy = "'" + string.Empty + "'"; 

                datamethods2 dthm = new datamethods2();
                string sqlInsert = string.Empty;
                sqlInsert = @" insert into database2 (recrno,surname,firstname,middlename,initials,address, 
                title,sex,birthdate,age,phone,email,lgadescr,qualdescr,gradedescr,aptest,
                documented,active,interviewed, medical,
                intersult,
                medsult,
                medissue,
                essay,
                essaysult,
                induction,
                inductsult,
                shl,
                manager,
                lgacode,
                gradecode,
                qualcode,
                testsult,
                entrydate,
                modifydate,
                modifiedby
                )  values ("
                 + strid + "," + strsurname + "," + strfirstname + "," + strtxtmiddlename + ","
                 + strinitials + "," + straddress + "," + strtitle + "," + strgender + ","
                 + strdob + "," + strage + "," + strphone + "," + stremail + "," + strlocation + "," + strqualification
                 + "," + strgrade + "," + straptested + "," + strdocumented + "," + stractive + ","
                 + stricslinterviewd + "," + strmedical + ","
                 + "'" + cmdtinterviewresult.SelectedItem.ToString().Trim() + "'" + ","
                 + "'" + cmbmedicalresult.SelectedItem.ToString().Trim() + "'" + ","
                 + "'" + txtmedissue.Text.Trim() + "'" + ","
                 + "'" + chkessay.Checked + "'" + ","
                 + "'" + cmbessayresult.SelectedItem.ToString().Trim() + "'" + ","
                 + "'" + chkinduction.Checked + "'" + ","
                 + "'" + cmbinductionresult.SelectedItem.ToString().Trim() + "'" + ","
                 + "'" + chkshl.Checked + "'" + ","
                 + "'" + txtmanager.Text.Trim() + "'" + ","
                 + "'" + prv_location + "'" + ","
                 + "'" + prv_grade + "'" + ","
                 + "'" + prv_qual + "'" + ","
                 + "'" + cmbtestresult.SelectedItem.ToString().Trim() + "'" + ","
                 + strentrydate + ","
                 + "'" + "" + "'" + ","
                 + strModifiedBy 
                 + ")";



               int returnVal = dthm._update_Insert_NoParameter(sqlInsert);

                if (dthm.sqlUserError.Trim() != string.Empty) MessageBox.Show(dthm.sqlUserError);
                else
                {
                    saveToClientRequest();
                    MessageBox.Show("Records Saved.", "RnS Notification");
                    clearScreen();
                }

            }
            else // do update
            {
                

                datamethods2 dthm = new datamethods2();
                string sqlInsert = string.Empty;
                sqlInsert = @" update database2 set  surname = " + strsurname + "," + " firstname= "
                 + strfirstname + ",  middlename = " + strtxtmiddlename + ", initials = "
                 + strinitials + "," + " address = " + straddress + ","
                 + " title = " + strtitle + "," + " sex= " + strgender + ","
                 + " birthdate= " + strdob + ","
                 + " age= " + strage + "," + " phone= " + strphone + ","
                 + " email= " + stremail + "," + " lgadescr= " + strlocation + "," + " qualdescr= " + strqualification + ","
                 + " gradedescr= " + strgrade + "," + " aptest= " + straptested + ","
                 + " documented= " + strdocumented + "," + " active= " + stractive + "," + " medical= " + strmedical
                 + "," + " interviewed = " + stricslinterviewd 
                 + "," + "intersult= " + "'" + cmdtinterviewresult.SelectedItem.ToString().Trim() + "'" 
                 + "," + "medsult= " + "'" + cmbmedicalresult.SelectedItem.ToString().Trim() + "'" 
                 + "," + "medissue= " + "'" + txtmedissue.Text.Trim() + "'" 
                 + "," + "essay= " + "'" + chkessay.Checked + "'" 
                 + "," + "essaysult= " + "'" + cmbessayresult.SelectedItem.ToString().Trim() + "'" 
                 + "," + "induction= " + "'" + chkinduction.Checked + "'"  
                 + "," + "inductsult= " + "'" + cmbinductionresult.SelectedItem.ToString().Trim() + "'"  
                 + "," + "shl= " + "'" + chkshl.Checked + "'"  
                 + "," + "manager= " + "'" + txtmanager.Text.Trim() + "'"  
                 + "," + "lgacode= " +  "'" + prv_location.Trim() + "'"  
                 + "," + "gradecode= " + "'" + prv_grade.Trim() + "'" 
                 + "," + "qualcode= " + "'" + prv_qual.Trim() + "'" 
                 + "," + "testsult= " + "'" + cmbtestresult.SelectedItem.ToString().Trim() + "'" 
                 + "," + "entrydate= " + strentrydate 
                 + "," + "modifydate= " + "'" + DateTime.Now.ToString("yyyy/MM/dd") + "'"
                 + "," + "modifiedby= " + "'" + Program.pbUserName + "'" 
                 + "  where recrno = " + strid;

                int returnVal = dthm._update_Insert_NoParameter(sqlInsert);

                if (dthm.sqlUserError.Trim() != string.Empty) MessageBox.Show(dthm.sqlUserError);
                else
                {
                 
                    saveToClientRequest();
                 
                    updateDatabase1_active();
                    
                    MessageBox.Show("Done.", "RnS Notification");
                    clearScreen();
                }
            }
         
            

        }
Ejemplo n.º 18
0
        private void saveRecords()
        {
            if (chkactive.Enabled == false)
            {
                MessageBox.Show("This request is closed", "RnS Notification");
                return;
            }

            if (txtclientid.Text.Trim() == string.Empty)
            {
                MessageBox.Show("Client can't be empty!", "Missing Client ID");
                return;
            }
            if (txtrequestid.Text.Trim() == string.Empty)
            {
                MessageBox.Show("Request ID can't be empty!", "Missing Request ID");
                return;
            }
            //if (dtpdeadline.Text.Trim() == string.Empty)
            //{
            //    MessageBox.Show("Request Date can't be empty!", "Missing Request Date");
            //    return;
            //}

            if (txttitle.Text.Trim() == string.Empty)
            {
                MessageBox.Show("Request Title can't be empty!", "Missing Request Title");
                return;
            }

            string strClientID = txtclientid.Text.Trim() ;
            string strrequestid = txtrequestid.Text ;
            string strrequestdate = dtprequesteddate.Value.ToShortDateString();
            string strDeadeline = dtpdeadline.Value.ToShortDateString();
            string strTitle= txttitle.Text;
            if (strrequestdate == string.Empty) strrequestdate = DateTime.Now.ToString();
            string strActive = chkactive.Checked.ToString();

            int _totalSaved = 0;

            datamethods2 dthm = new datamethods2();

            for (int x = 0; x < grdClientRequest.Rows.Count; x++)
            {
                if (grdClientRequest.Rows[x].Cells[1].Value.ToString() != null && grdClientRequest.Rows[x].Cells[1].Value.ToString().Trim() != string.Empty)
                {

                    string reqid = grdClientRequest.Rows[x].Cells[0].Value.ToString();
                    string sPosition = grdClientRequest.Rows[x].Cells[1].Value.ToString();
                    string qual1 = grdClientRequest.Rows[x].Cells[2].Value.ToString();
                    string qual2 = grdClientRequest.Rows[x].Cells[3].Value.ToString();
                    string qual3 = grdClientRequest.Rows[x].Cells[4].Value.ToString();
                    string qual4 = grdClientRequest.Rows[x].Cells[5].Value.ToString();
                    string RequestNo = grdClientRequest.Rows[x].Cells[6].Value.ToString();
                    string Location = grdClientRequest.Rows[x].Cells[7].Value.ToString();
                    string SupplyNo = grdClientRequest.Rows[x].Cells[8].Value.ToString();
                    string InterviewNo = grdClientRequest.Rows[x].Cells[9].Value.ToString();
                    string EmployedNo = grdClientRequest.Rows[x].Cells[10].Value.ToString();
                    string Remarks = grdClientRequest.Rows[x].Cells[11].Value.ToString();
                    Boolean newkeyid = Convert.ToBoolean(grdClientRequest.Rows[x].Cells[12].Value);
                    string strposcode = grdClientRequest.Rows[x].Cells[13].Value.ToString();
                    string strlgacode = grdClientRequest.Rows[x].Cells[14].Value.ToString();

                    if (newkeyid == false) //existing: do Update
                    {

                        string sqlUpdate = string.Empty;
                        sqlUpdate = @" update clientrequest set  position = '" + sPosition + "',"
                            + " qual1= '" + qual1 + "',"
                            + " qual2 = '" + qual2 + "',"
                            + " qual3 = '" + qual3 + "',"
                            + " qual4 = '" + qual4 + "',"
                            + " RequestNo = '" + RequestNo + "',"
                            + " Location= '" + Location + "',"
                            + " EmployedNo= '" + EmployedNo + "',"
                            + " InterviewNo= '" + InterviewNo + "',"
                            + " SupplyNo= '" + SupplyNo + "',"
                            + " status= '" + strActive + "',"
                            + " drequest= '" + dtpdeadline.Value.ToString("yyyy/MM/dd") + "',"
                            + " reqdate= '" + dtprequesteddate.Value.ToString("yyyy/MM/dd") + "',"
                            + " title= '" + strTitle + "',"
                            + " poscode= '" + strposcode.Trim() + "',"
                            + " lgacode = '" + strlgacode + "',"
                            + " Remarks= '" + Remarks + "'"
                            + " where clientid = '" + strClientID + "'"
                            + " and requestid= '" + strrequestid + "'"
                            + " and reqid= '" + reqid + "'";

                        dthm._update_Insert_NoParameter(sqlUpdate);

                        if (dthm.sqlUserError.Trim() != string.Empty) MessageBox.Show(dthm.sqlUserError,"RnS Notification");
                        else
                        {
                            _totalSaved += 1;
                        }
                    }
                    else // new: do insert
                    {

                        string sqlInsert = string.Empty;
                        sqlInsert = @" Insert into clientrequest "
                            + "(position,qual1,qual2,qual3,qual4,RequestNo, "
                            + " poscode,lgacode,Location,EmployedNo,InterviewNo,SupplyNo,Remarks,status,drequest,reqdate,clientid,requestid,reqid,title)"
                            + " values ('" + sPosition + "',"
                            + "'" + qual1 + "',"
                            + "'" + qual2 + "',"
                            + "'" + qual3 + "',"
                            + "'" + qual4 + "',"
                            + "'" + RequestNo + "',"
                            + "'" + strposcode.Trim() + "',"
                            + "'" + strlgacode.Trim() + "',"
                            + "'" + Location + "',"
                            + "'" + EmployedNo + "',"
                            + "'" + InterviewNo + "',"
                            + "'" + SupplyNo + "',"
                            + "'" + Remarks + "',"
                            + "'" + strActive + "',"
                            + "'" + dtpdeadline.Value.ToString("yyyy/MM/dd") + "',"
                            + "'" + dtprequesteddate.Value.ToString("yyyy/MM/dd") + "',"
                            + "'" + strClientID + "',"
                            + "'" + strrequestid + "',"
                            + "'" + reqid + "',"
                            + "'" + strTitle + "'"
                            + ")";

                        dthm._update_Insert_NoParameter(sqlInsert);

                        if (dthm.sqlUserError.Trim() != string.Empty) MessageBox.Show(dthm.sqlUserError, "RnS Notification");
                        else
                        {
                            _totalSaved += 1;
                        }
                    }
                }

            }

            if (_totalSaved > 0)
            {
                MessageBox.Show(_totalSaved.ToString() + " records was committed Successfully", "RnS Notification");
                clearScreen();
            }
            else MessageBox.Show(_totalSaved.ToString() + " records was committed Successfully", "RnS Notification");
        }
Ejemplo n.º 19
0
        private void saveToClientRequest()
        {

            if (txtclient.Text.Trim() == string.Empty || txtrequest.Text.Trim() == string.Empty) 
            {
                return;
            }


          

            string strid = "'" + txtid.Text.Trim() + "'";

            string strdocumented = "'" + chkdocumented.Checked + "'";
            string stricslinterviewd = "'" + chkicslinterview.Checked + "'";
            string strdtpclientinterviewdate = "'" +  dtpclientinterviewdate.Value.ToString("yyyy/MM/dd") + "'";

                       
            string strmskresumptiondate = "'" + dtpresumptiondate.Value.ToString("yyyy/MM/dd") + "'";

            string strRequestdescr = "'" + txtrequest.Text + "'";
            

            string queryString = @"select distinct * from candidatecallup where recrno = " +  strid 
              +   " and clientid = '"+  txtclient.Text.Trim() + "'"
              + " and request = '" + prv_requestcode.Trim() + "'"
              + " and position = '" + prv_posit.Trim() +"'"
              + " and reqid = '" + strReqId.Trim() + "'";


            datamethods2 dthm = new datamethods2();
            SqlDataReader drRecords = dthm._dataReader_NoParameter(queryString);


            drRecords.Read();
            if (!drRecords.HasRows)
            {
                drRecords.Close();
                drRecords.Dispose();
                
                    

                string sqlInsert = string.Empty;
                sqlInsert = @" insert into candidatecallup (
                reqid,
                recrno, 
                emptype,
                intlocdesr,
                intloccode,
                clientid,
                position,
                posdescr,
                cinterview,
                cintersult,
                remarks,
                intervdate,
                rdate,
                request,
                reqdescr,
                cinduction,
                cindsult) "
                + " values ("
                 + "'" + strReqId + "'" + ","
                 + strid + ","
                 + "'" + cmbemploymenttype.Text.Trim() + "'" + ","
                 + "'" + interiewlocation.Text + "'" + ","
                 + "'" + prv_intlocation + "'" + ","
                 + "'" + txtclient.Text + "'" + ","
                 + "'" + prv_posit + "'" + ","
                 + "'" + txtposition.Text + "'" + ","
                 + "'" + chkclientinterview.Checked + "'" + ","
                 + "'" + cmbintassessment.Text.Trim() + "'" + ","
                 + "'" + txtremarks.Text + "'" + ","
                 + strdtpclientinterviewdate + ","
                 + strmskresumptiondate + ","
                 + "'" + prv_requestcode + "'" + ","
                 + strRequestdescr + ","
                 + "'" + chkcinduction.Checked + "'" + ","
                 + "'" + cmbcindsult.Text.Trim() + "'" + ")" ;


               
                int returnVal = dthm._update_Insert_NoParameter(sqlInsert);


                if (dthm.sqlUserError.Trim() != string.Empty) MessageBox.Show(dthm.sqlUserError);
                
            }
            else // do update
            {

  

                drRecords.Close();
                drRecords.Dispose();

                string sqlUpdate = string.Empty;
                sqlUpdate = @" update candidatecallup set "
                 + "emptype= " + "'" + cmbemploymenttype.Text.Trim() + "'"
                 + "," + "intlocdesr= " + "'" + interiewlocation.Text + "'"
                 + "," + "intloccode= " + "'" + prv_intlocation + "'"
                 + "," + "clientid= " + "'" + txtclient.Text + "'"
                 + "," + "position= " + "'" + prv_posit + "'"
                 + "," + "posdescr= " + "'" + txtposition.Text + "'"
                 + "," + "cinterview= " + "'" + chkclientinterview.Checked + "'"
                 + "," + "cintersult= " + "'" + cmbintassessment.Text.Trim() + "'"
                 + "," + "remarks= " + "'" + txtremarks.Text + "'"
                 + "," + "intervdate= " + strdtpclientinterviewdate
                 + "," + "request= " + "'" + prv_requestcode + "'"
                 + "," + "reqdescr = " + "'" + txtrequest.Text + "'"
                 + "," + "rdate= " + strmskresumptiondate
                 + "," + "cinduction= " + "'" + chkcinduction.Checked + "'"
                 + "," + "cindsult= " + "'" + cmbcindsult.Text.Trim() + "'"
                 + "  where recrno = " + strid
                 + " and reqid = '" + strReqId + "'" ;

                //MessageBox.Show(Convert.ToDateTime(strmskdatesentout).ToString("yyyy/MM/dd"));

                int returnVal = dthm._update_Insert_NoParameter(sqlUpdate);

                if (dthm.sqlUserError.Trim() != string.Empty) MessageBox.Show(dthm.sqlUserError);
               
            }
           

        }
Ejemplo n.º 20
0
        private void populateScreen()
        {
            string strid = txtid.Text;
            txtsurname.Text = "";
            txtfirstname.Text = "";
            txtmiddlename.Text = "";
            txtinitials.Text = "";
            chkdocscreened.Checked = false;
            chkaptested.Checked = false;
            cmbtitle.SelectedIndex = 0;
            txtaddress.Text = "";
            cmbgender.SelectedIndex = 0;
            mskdob.Text = "";
            mskage.Text = "";
            txtemail.Text = "";
            mskphone.Text = "";
            txtlocation.Text = "";
            txtqualification.Text = "";
            txtgrade.Text = "";
            txtid.Enabled = false;
            newRecords = true;
            chktransfered.Checked = false;

            string queryString = string.Empty;

            queryString = "select distinct * from database1 where recrno = " + "'" + strid + "'";
            datamethods2 dthm = new datamethods2();
            SqlDataReader drRecords = dthm._dataReader_NoParameter(queryString);
            drRecords.Read();
            if (drRecords.HasRows)
            {

                newRecords = false;

                txtsurname.Text = drRecords["surname"].ToString();
                txtfirstname.Text = drRecords["firstname"].ToString();
                txtmiddlename.Text = drRecords["middlename"].ToString();
                chkdocscreened.Checked = Convert.ToBoolean(drRecords["screened"]);
                chkaptested.Checked = Convert.ToBoolean(drRecords["aptest"]);
                txtinitials.Text = drRecords["initials"].ToString();
                cmbtitle.Text = drRecords["title"].ToString();
                txtaddress.Text = drRecords["address"].ToString();
                cmbgender.Text = drRecords["sex"].ToString();
                mskdob.Text = drRecords["birthdate"].ToString();
                mskage.Text = drRecords["age"].ToString();
                txtemail.Text = drRecords["email"].ToString();
                mskphone.Text = drRecords["phone"].ToString();
                txtlocation.Text = drRecords["lgadescr"].ToString();
                txtqualification.Text = drRecords["qualdescr"].ToString();
                txtgrade.Text = drRecords["gradedescr"].ToString();
                chktransfered.Checked = Convert.ToBoolean(drRecords["active"]);
                cmbtestresult.Text = drRecords["testresult"].ToString();
                prv_grade = drRecords["gradecode"].ToString();
                prv_location = drRecords["lgacode"].ToString();
                prv_qual = drRecords["qualcode"].ToString();

            }
            drRecords.Dispose();
            pictureBox6.Focus();
            txtid.Enabled = false;
        }
Ejemplo n.º 21
0
        private void updateDatabase1_active()
        {

            string strid = "'" + txtid.Text.Trim() + "'";

            datamethods2 dthm = new datamethods2();
            string sqlInsert = string.Empty;
            sqlInsert = @" update database1 set active = 'true' where recrno = " + strid;

            int returnVal = dthm._update_Insert_NoParameter(sqlInsert);

            if (dthm.sqlUserError.Trim() != string.Empty) MessageBox.Show(dthm.sqlUserError);
           
           


        }
Ejemplo n.º 22
0
        private void populateGrid()
        {
            if (txtclientid.Text == string.Empty || txtrequestid.Text == string.Empty)
            {
                MessageBox.Show("Both Client and Request must be specified","RnS Notification");
                return;
            }

            grdCandidate.Rows.Clear();
            dt_shortlisted.Rows.Clear();

            string strClientId = "'" + txtclientid.Text + "'";
            string strRequestId = "'" + Program._searchedValue.Trim() + "'";
            int _totalSaved = 0;
            _totalSaved = 0;

            List<string> lstRecrno = new List<string>();
            string strParam = string.Empty;
            string strWhereCaluse = string.Empty;

            if (cmbgender.SelectedItem.ToString().Trim() != string.Empty) strParam = strParam + " and a.sex = '" + cmbgender.SelectedItem.ToString().Trim() + "'";
            if (txtlocation.Text.Trim() != string.Empty) strParam = strParam + " and a.lgacode = '" + prv_location.Trim() + "'";
            if (txtqualification.Text.Trim() != string.Empty) strParam = strParam + " and a.qualcode = '" + prv_qual.Trim() + "'";
            if (txtgrade.Text.Trim() != string.Empty) strParam = strParam + " and a.gradecode = '" + prv_grade.Trim() + "'";

            if (chkaptested.Checked == true)
            {
                if (cmbtestresult.Text.Trim() == string.Empty)
                {
                    MessageBox.Show("Specify Test Result", "RnS Notification");
                    return;
                }

                if (cmbtestresult.Text.Trim() != string.Empty)
                {
                    strParam = strParam + " and a.aptest = 'true' and a.testsult = '" + cmbtestresult.Text.Trim() + "'";
                }

            }

            if (mskage.Text != string.Empty && mskage2.Text != string.Empty)
            {

                if ( Convert.ToInt32(mskage.Text) < Convert.ToInt32(mskage2.Text))
                {
                    strParam = strParam + " and a.age between " + mskage.Text + " and  " + mskage2.Text;

                }
                if (Convert.ToInt32(mskage.Text) > Convert.ToInt32(mskage2.Text))
                {

                    strParam = strParam + " and a.age between " + mskage2.Text + " and  " + mskage.Text;
                }

                if (Convert.ToInt32(mskage.Text) == Convert.ToInt32(mskage2.Text))
                {
                    strParam = strParam + " and a.age between " + mskage2.Text + " and  " + mskage.Text;
                }
            }

            //if (!= string.Empty) txtrequestid.Text = Program._searchedValue;

            // ----- selection from database 1
            if ( raddatabase1.Checked == true )
            {
                String sqlSelect = @"select distinct a.* from database1 a
                    where a.recrno not in (select recrno from database2)" + strParam;

            //                String sqlSelect = @"select distinct * from database1
            //                    where active = 'false' and recrno not in (select recrno from database2)" + strParam;

                DataTable dt = new DataTable();
                datamethods2 dtmth = new datamethods2();
                dt = dtmth._dataTable_NoParameter(sqlSelect);

                if (dtmth.sqlUserError == string.Empty)
                {
                    if (dt.Rows.Count > 0)
                    {
                        dt_shortlisted = dt;
                        _addColumns(dt);

                    }
                    else MessageBox.Show("Requested records not found!", "RnS Notification");

                }
                else
                {
                    MessageBox.Show(dtmth.sqlUserError, "RnS Notification");
                }
            }

            // ----- selection from database 2

            //interview
            if (chkicslinterview.Checked == true)
            {
                if (cmdtinterviewresult.Text.Trim() == string.Empty)
                {
                    MessageBox.Show("Specify ICSL Interview Result", "RnS Notification");
                    return;
                }

                if (cmdtinterviewresult.Text.Trim() != string.Empty)
                {
                    strParam = strParam + " and a.interviewed = 'true' and a.intersult = '" + cmdtinterviewresult.Text.Trim() + "'";
                }

            }

            //medical
            if (chkmedical.Checked == true)
            {
                if (cmbmedicalresult.Text.Trim() == string.Empty)
                {
                    MessageBox.Show("Specify Medical Result", "RnS Notification");
                    return;
                }

                if (cmbmedicalresult.Text.Trim() != string.Empty)
                {
                    strParam = strParam + " and a.medical = 'true' and a.medsult = '" + cmbmedicalresult.Text.Trim() + "'";
                }

            }

            //essay
            if (chkessay.Checked == true)
            {

                if (cmbessayresult.Text.Trim() == string.Empty)
                {
                    MessageBox.Show("Specify Essay Result", "RnS Notification");
                    return;
                }

                if (cmbessayresult.Text.Trim() != string.Empty)
                {
                    strParam = strParam + " and a.essay = 'true' and a.essaysult = '" + cmbessayresult.Text.Trim() + "'";
                }

            }

            //induction
            if (chkinduction.Checked == true)
            {
                if (cmbinductionresult.Text.Trim() == string.Empty)
                {
                    MessageBox.Show("Specify ICSL Induction assessment", "RnS Notification");
                    return;

                }

                if (cmbinductionresult.Text.Trim() != string.Empty)
                {
                    strParam = strParam + " and a.induction = 'true' and a.inductsult = '" + cmbinductionresult.Text.Trim() + "'";
                }

            }

            //documented
            if (chkdocumented.Checked == true) strParam = strParam + " and a.documented = 'true' ";

            //chkshl
            if (chkshl.Checked == true) strParam = strParam + " and a.shl = 'true' ";

            //client induction
            if (chkcinduction.Checked == true)
            {

                if (cmbcindsult.Text.Trim() == string.Empty)
                {
                    MessageBox.Show("Specify client Induction assessment", "RnS Notification");
                    return;
                }

                if (cmbcindsult.Text.Trim() != string.Empty)
                {
                    strParam = strParam + " and b.cinduction = 'true' and b.cindsult = '" + cmbcindsult.Text.Trim() + "'";
                }

            }

            //client interview
            if (chkcinterview.Checked == true)
            {

                if (chkcintsult.Text.Trim() == string.Empty)
                {
                    MessageBox.Show("Specify client interview assessment", "RnS Notification");
                    return;
                }

                strParam = strParam + " and b.cinterview = 'true' and b.cintersult = '" + chkcintsult.Text.Trim() + "'";

            }

            //emp type
            if (cmbemploymenttype.Text.Trim() != string.Empty)
            {
                strParam = strParam + " and b.emptype = '" + cmbemploymenttype.Text.Trim() + "'";
            }

            if (raddatabase2.Checked == true)
            {
                String sqlSelect = @"select distinct a.* from database2 a, candidatecallup b
                where a.recrno = b.recrno and  (a.active = 'false' or a.active = 'true' )" + strParam;

                //MessageBox.Show(sqlSelect);
                //return;
                DataTable dt = new DataTable();
                datamethods2 dtmth = new datamethods2();
                dt = dtmth._dataTable_NoParameter(sqlSelect);

                if (dtmth.sqlUserError == string.Empty)
                {
                    if (dt.Rows.Count > 0)
                    {
                        dt_shortlisted = dt;
                        _addColumns(dt);

                    }
                    else MessageBox.Show("Requested records not found!", "RnS Notification");

                }
                else
                {
                    MessageBox.Show(dtmth.sqlUserError, "RnS Notification");
                }
            }
            grdCandidate.Focus();
            raddatabase1.Enabled = false;
            raddatabase2.Enabled = false;
        }