コード例 #1
0
ファイル: Employee.cs プロジェクト: zerojec/MMG-PIAPS
        public String GET_CURRENT_POSITION(non_static_dbcon usethisconnection)
        {
            DataTable    dt  = new DataTable();
            MySqlCommand cmd = new MySqlCommand();

            usethisconnection.SET_COMMAND_PARAMS(cmd, "EMP_POSITION_SELECT_LATEST_BY_ID");
            cmd.Parameters.AddWithValue("_empid", empid);

            MySqlDataAdapter da = new MySqlDataAdapter(cmd);

            da.Fill(dt);

            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    String pos = "";
                    pos      = (dt.Rows[0].Field <String>("position_") != null) ? dt.Rows[0].Field <String>("position_") : "";
                    position = pos;
                    return(pos);
                }
                else
                {
                    return("");
                }
            }
            else
            {
                return("");
            }
        }
コード例 #2
0
ファイル: Employee.cs プロジェクト: zerojec/MMG-PIAPS
        public Byte[] GET_IMAGE_BY_ID(non_static_dbcon usethisconnection)
        {
            DataTable    dt  = new DataTable();
            MySqlCommand cmd = new MySqlCommand();

            usethisconnection.SET_COMMAND_PARAMS(cmd, "EMP_PIC_SELECT_BY_ID");
            cmd.Parameters.AddWithValue("_empid", empid);

            MySqlDataAdapter da = new MySqlDataAdapter(cmd);

            da.Fill(dt);

            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    Byte[] image = dt.Rows[0].Field <Byte[]>("imagebyte");
                    pic = image;
                    return(image);
                }
                else
                {
                    return(null);
                }
            }
            else
            {
                return(null);
            }
        }
コード例 #3
0
        }//end select bween dates

        public String SELECT_STR_BY_EMPID_BY_DATE(DateTime thisdate, non_static_dbcon usethisconnection)
        {
            DataTable    dt  = new DataTable();
            MySqlCommand cmd = new MySqlCommand();

            usethisconnection.SET_COMMAND_PARAMS(cmd, "ATTENDANCE_STR_BY_EMPID_BY_DATE");
            cmd.Parameters.AddWithValue("_empid", empid);
            cmd.Parameters.AddWithValue("_thisdate", thisdate);


            MySqlDataAdapter da = new MySqlDataAdapter(cmd);

            try
            {
                da.Fill(dt);
                if (dt != null)
                {
                    return(dt.Rows[0].Field <String>("attendance"));
                }
                else
                {
                    return("");
                }

                //return dt;
            }
            catch (Exception e)
            {
                Logger.WriteErrorLog("ATTENDANCE_STR_BY_EMPID_BW_DATES MODULE:" + e.Message);
                return("");
            }
        }//end str select bween dates
コード例 #4
0
ファイル: Employee.cs プロジェクト: zerojec/MMG-PIAPS
        public Employee SELECT_BY_ID(non_static_dbcon usethisconnection)
        {
            DataTable    dt  = new DataTable();
            MySqlCommand cmd = new MySqlCommand();

            usethisconnection.SET_COMMAND_PARAMS(cmd, "EMP_SELECT_BY_ID");
            cmd.Parameters.AddWithValue("_empid", empid);
            MySqlDataAdapter da = new MySqlDataAdapter(cmd);

            da.Fill(dt);

            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    Employee e = new Employee();
                    foreach (DataRow r in dt.Rows)
                    {
                        e.empid              = r["empid"].ToString();
                        e.fname              = r["fname"].ToString();
                        e.lname              = r["lname"].ToString();
                        e.mname              = r["mname"].ToString();
                        e.address            = r["address"].ToString();
                        e.birthdate          = Convert.ToDateTime(r["birthday"].ToString());
                        e.contactno          = r["contactno"].ToString();
                        e.gender             = r["gender"].ToString();
                        e.COOP_MEMBERSHIP_ID = r["COOP_MEMBERSHIP_ID"].ToString();
                        e.tinno              = r["tinno"].ToString();
                    }
                    return(e);
                }
                else
                {
                    return(null);
                }
            }
            else
            {
                return(null);
            }
        }
コード例 #5
0
        //for asychronous transaction

        public Emp_Sched SELECT_BY_EMPID(non_static_dbcon usethisconnection)
        {
            DataTable    dt  = new DataTable();
            MySqlCommand cmd = new MySqlCommand();

            usethisconnection.SET_COMMAND_PARAMS(cmd, "EMP_SCHED_SELECT_BY_EMPID");
            cmd.Parameters.AddWithValue("_empid", empid);
            MySqlDataAdapter da = new MySqlDataAdapter(cmd);

            da.Fill(dt);

            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    DataRow r = dt.Rows[0];

                    Emp_Sched es = new Emp_Sched();

                    es.empid = r["empid"].ToString();
                    es.mon   = r["mon"].ToString();
                    es.tue   = r["tue"].ToString();
                    es.wed   = r["wed"].ToString();
                    es.thu   = r["thu"].ToString();
                    es.fri   = r["fri"].ToString();
                    es.sat   = r["sat"].ToString();
                    es.sun   = r["sun"].ToString();

                    return(es);
                }
                else
                {
                    return(null);
                }
            }
            else
            {
                return(null);
            }
        }
コード例 #6
0
        }//end select bween dates

        public DataTable SELECT_BY_EMPID_BW_DATES(DateTime from, DateTime to, non_static_dbcon usethisconnection)
        {
            DataTable    dt  = new DataTable();
            MySqlCommand cmd = new MySqlCommand();

            usethisconnection.SET_COMMAND_PARAMS(cmd, "ATTENDANCE_BY_EMPID_BW_DATES");
            cmd.Parameters.AddWithValue("_empid", empid);
            cmd.Parameters.AddWithValue("_from", from);
            cmd.Parameters.AddWithValue("_to", to);

            MySqlDataAdapter da = new MySqlDataAdapter(cmd);

            try
            {
                da.Fill(dt);
                return(dt);
            }
            catch (Exception e)
            {
                Logger.WriteErrorLog("ATTENDANCE_BY_EMPID_BW_DATES MODULE:" + e.Message);
                return(null);
            }
        }//end select bween dates