Exemple #1
0
        public static List <Leaves> fetchleave(int userid)
        {
            List <Leaves>   leaves = new List <Leaves>();
            bus_eleave_ugc1 bus    = new bus_eleave_ugc1();

            bus.userid = userid;
            DataTable dt = bus.fetch_leaves();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Leaves _Leaves = new Leaves();
                _Leaves.LeaveType  = dt.Rows[i]["ltype"].ToString();
                _Leaves.LeaveCount = float.Parse(dt.Rows[i]["num"].ToString());
                _Leaves.LeavePerc  = float.Parse(dt.Rows[i]["perc"].ToString());
                _Leaves.LeaveTot   = float.Parse(dt.Rows[i]["tot"].ToString());
                leaves.Add(_Leaves);
            }
            return(leaves);
        }