Exemplo n.º 1
0
        }    //end LoadMembersInListView

        public void Load_Searched_MembersInListView(ListView lv, String input)
        {
            Member    e  = new Member();
            DataTable dt = new DataTable();

            dt = e.SELECT_BY_NAME(input);

            lv.Items.Clear();

            if (dt != null)
            {
                int ctr = 1;
                foreach (DataRow r in dt.Rows)
                {
                    ListViewItem li = new ListViewItem();
                    li.Text = ctr.ToString();
                    li.SubItems.Add(r["memid"].ToString());
                    li.SubItems.Add(r["fullname"].ToString());
                    li.SubItems.Add(r["address"].ToString());
                    li.SubItems.Add(r["contactno"].ToString());
                    Member_Standing ms = new Member_Standing();
                    ms.memid = r["memid"].ToString();
                    li.SubItems.Add(ms.STANDING);

                    li.BackColor = (ms.STANDING == "MIGS") ? Color.GreenYellow : Color.Red;

                    lv.Items.Add(li);
                    ctr++;
                }
            }
        }    //end LoadMembersInListView
Exemplo n.º 2
0
        public Member_Standing SELECT_BY_ID()
        {
            MySqlCommand cmd = new MySqlCommand();

            db.SET_COMMAND_PARAMS(cmd, "MEMBER_STANDING_SELECT_BYID");
            cmd.Parameters.AddWithValue("_memid", memid);
            MySqlDataAdapter da = new MySqlDataAdapter(cmd);
            DataTable        dt = new DataTable();

            try
            {
                da.Fill(dt);
                if (dt.Rows.Count > 0)
                {
                    DataRow r = dt.Rows[0];

                    Member_Standing ms = new Member_Standing();
                    //declare 4 criteria (to become MIGS)

                    ms.PAYMENT_TENK_WITHIN_SIX_MONTHS   = Convert.ToBoolean(r["PAYMENT_TENK_WITHIN_SIX_MONTHS"].ToString());
                    ms.PAYMENT_FIFTYK_WITHIN_FIVE_YEARS = Convert.ToBoolean(r["PAYMENT_FIFTYK_WITHIN_FIVE_YEARS"].ToString());
                    ms.PATRONAGE_OF_MMG_SERVICES        = Convert.ToBoolean(r["PATRONAGE_OF_MMG_SERVICES"].ToString());
                    ms.ATTENDANCE = Convert.ToBoolean(r["ATTENDANCE"].ToString());

                    return(ms);
                }
                else
                {
                    return(null);
                }
            }
            catch (Exception e)
            {
                Logger.WriteErrorLog(e.Message);
                return(null);
            }
        }
Exemplo n.º 3
0
        public Member_Standing SELECT_BY_ID()
        {
            MySqlCommand cmd = new MySqlCommand();

            db.SET_COMMAND_PARAMS(cmd, "MEMBER_STANDING_SELECT_BYID");
            cmd.Parameters.AddWithValue("_memid", memid);
            MySqlDataAdapter da = new MySqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            try
            {
                da.Fill(dt);
                if (dt.Rows.Count > 0)
                {
                    DataRow r = dt.Rows[0];

                    Member_Standing ms = new Member_Standing();
                    //declare 4 criteria (to become MIGS)

                    ms.PAYMENT_TENK_WITHIN_SIX_MONTHS = Convert.ToBoolean(r["PAYMENT_TENK_WITHIN_SIX_MONTHS"].ToString());
                    ms.PAYMENT_FIFTYK_WITHIN_FIVE_YEARS =Convert.ToBoolean(r["PAYMENT_FIFTYK_WITHIN_FIVE_YEARS"].ToString());
                    ms.PATRONAGE_OF_MMG_SERVICES = Convert.ToBoolean(r["PATRONAGE_OF_MMG_SERVICES"].ToString());
                    ms.ATTENDANCE = Convert.ToBoolean(r["ATTENDANCE"].ToString());

                    return ms;

                }
                else
                {
                    return null;
                }
            }
            catch (Exception e)
            {
                Logger.WriteErrorLog(e.Message);
                return null;
            }
        }
Exemplo n.º 4
0
        public void Load_Searched_MembersInListView(ListView lv, String input)
        {
            Member e = new Member();
                DataTable dt = new DataTable();

                dt = e.SELECT_BY_NAME(input);

                lv.Items.Clear();

                if (dt != null)
                {
                    int ctr = 1;
                    foreach (DataRow r in dt.Rows)
                    {
                        ListViewItem li = new ListViewItem();
                        li.Text = ctr.ToString();
                        li.SubItems.Add(r["memid"].ToString());
                        li.SubItems.Add(r["fullname"].ToString());
                        li.SubItems.Add(r["address"].ToString());
                        li.SubItems.Add(r["contactno"].ToString());
                        Member_Standing ms = new Member_Standing();
                        ms.memid = r["memid"].ToString();
                        li.SubItems.Add(ms.STANDING);

                        li.BackColor = (ms.STANDING == "MIGS") ? Color.GreenYellow : Color.Red;

                        lv.Items.Add(li);
                        ctr++;

                    }
                }
        }