public static string getdata(string companyid, string fromdate, string todate, string status, string schtype, string client, string project)
        {
            ClsTimeSheet   objts  = new ClsTimeSheet();
            DataSet        ds     = new DataSet();
            GeneralMethod  objgen = new GeneralMethod();
            ClsScheduleBAL objSch = new ClsScheduleBAL();

            objts.nid       = "";
            objts.action    = "selectgroup";
            objts.companyId = companyid;
            objts.from      = fromdate;
            objts.to        = todate;
            objts.clientid  = client;
            objts.projectid = project;
            objts.empid     = "";
            objts.Status    = status;
            objts.remark    = schtype;
            ds = objts.schedule();

            string result = "";

            DataTable dtbyItem = new DataTable();
            var       cWeek    = DateRange.getLastDates("Current Week");
            var       NWeek    = DateRange.getLastDates("Next Week");


            dtbyItem = objgen.filterTable("date>=#01/01/" + (DateTime.Now.Year - 1).ToString() + "# and date<=#12/31/" + (DateTime.Now.Year - 1).ToString() + "#", ds.Tables[0]);
            result   = objSch.scheduleHTML(dtbyItem, "Previous Year Schedules", "pys");

            dtbyItem = objgen.filterTable("date>=#01/01/" + DateTime.Now.Year.ToString() + "# and date<#" + cWeek.fromdate + "#", ds.Tables[0]);
            result   = result + objSch.scheduleHTML(dtbyItem, "Older Schedules", "os");


            dtbyItem = objgen.filterTable("date>=#" + cWeek.fromdate + "# and date<=#" + cWeek.todate + "#", ds.Tables[0]);
            result   = result + objSch.scheduleHTML(dtbyItem, "Current Week Schedules", "cv");

            dtbyItem = objgen.filterTable("date>=#" + NWeek.fromdate + "# and date<=#" + NWeek.todate + "#", ds.Tables[0]);
            result   = result + objSch.scheduleHTML(dtbyItem, "Next Week Schedules", "nv");

            dtbyItem = objgen.filterTable("date>#" + NWeek.todate + "#", ds.Tables[0]);
            result   = result + objSch.scheduleHTML(dtbyItem, "Upcoming Schedules", "uc");



            return(result);
        }
Example #2
0
        public string getToDoList(string empid)
        {
            DataAccess objda = new DataAccess();

            empTimeSheet.DataClasses.BAL.ClsToDoListBAL objtodo = new empTimeSheet.DataClasses.BAL.ClsToDoListBAL();
            GeneralMethod objgen = new GeneralMethod();

            string result = "";

            objda.empid  = empid;
            objda.id     = "";
            objda.action = "select";
            string tDay = "";

            try
            {
                ds   = objda.ToDoList();
                tDay = ds.Tables[1].Rows[0]["empdate"].ToString();

                DataTable dtbyItem = new DataTable();

                //Fill Today List
                if (ds.Tables[0].Rows.Count > 0)
                {
                    dtbyItem = objgen.filterTable("date1=#" + tDay + "#", ds.Tables[0]);
                    result   = objtodo.todayHTML(dtbyItem, "Today's Tasks", "t");

                    dtbyItem = objgen.filterTable("date1>#" + tDay + "#", ds.Tables[0]);
                    result   = result + objtodo.upComingHTML(dtbyItem, "Upcoming Tasks", "u");

                    dtbyItem = objgen.filterTable("date1<#" + tDay + "#", ds.Tables[0]);
                    result   = result + objtodo.upComingHTML(dtbyItem, "Previous Tasks", "p");
                }
                else
                {
                    result = "<div class='task-hding'>Today's Task</div> <div class='clear'></div><div class='notodaytask'>No task exists.</div>";
                }
            }
            catch (Exception ex)
            {
                result = ex.ToString();
            }
            return(result);
        }
        public static string getRoleHTML()
        {
            DataAccess    objda  = new DataAccess();
            DataSet       ds     = new DataSet();
            GeneralMethod objgen = new GeneralMethod();

            objda.id   = "";
            objda.name = "";

            objda.action = "getallroles";
            ds           = objda.ManageRoleGroup();

            StringBuilder sb     = new StringBuilder();
            string        result = "";
            int           num    = 0;

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                if (num == 0)
                {
                    result += "<tr>";
                }
                result += "<td> <div class='roleheader color'>" + ds.Tables[0].Rows[i]["rGroup"].ToString() + "</div><div class='roleBox'>";
                DataTable dtbyInt = new DataTable();
                dtbyInt = objgen.filterTable("rGroup='" + ds.Tables[0].Rows[i]["rGroup"].ToString() + "'", ds.Tables[1]);
                for (int j = 0; j < dtbyInt.Rows.Count; j++)
                {
                    result += "<div><input type='checkbox' name='chkrole' value='" + dtbyInt.Rows[j]["nid"].ToString() + "' /><span>" + dtbyInt.Rows[j]["roleName"].ToString() + "</span></div>";
                }
                result += "</div></td>";
                if (num == 2)
                {
                    result += "</tr>";
                    num     = 0;
                }
                else
                {
                    num = num + 1;
                }
            }



            return(result);
        }