예제 #1
0
        public JsonResult GetEmployeeID(string AttendanceID)
        {
            List <AbsencesAndTardiness> t = new List <AbsencesAndTardiness>();
            string conn = ConfigurationManager.ConnectionStrings["kalingaPPDO"].ConnectionString;

            using (SqlConnection cn = new SqlConnection(conn))
            {
                string     myQuery = "SELECT * FROM rep_AbsencesTardinessDetailsPerEmployee2 where empAttendanceMainID = @AttendanceID";
                SqlCommand cmd     = new SqlCommand()
                {
                    CommandText = myQuery,
                    CommandType = CommandType.Text
                };
                cmd.Parameters.AddWithValue("@AttendanceID", AttendanceID);
                cmd.Connection = cn;
                cn.Open();
                SqlDataReader dr = cmd.ExecuteReader();
                if (dr.HasRows)
                {
                    int counter = 0;
                    while (dr.Read())
                    {
                        AbsencesAndTardiness tsData = new AbsencesAndTardiness()
                        {
                            empID = dr["empID"].ToString()
                        };
                        t.Add(tsData);
                        counter++;
                    }
                }
            }
            return(Json(t, JsonRequestBehavior.AllowGet));
        }
        public JsonResult PerEmployee(int empID, int AttendanceID)
        {
            List <AbsencesAndTardiness> t = new List <AbsencesAndTardiness>();
            string conn = ConfigurationManager.ConnectionStrings["kalingaPPDO"].ConnectionString;

            using (SqlConnection cn = new SqlConnection(conn))
            {
                string     myQuery = "SELECT * FROM rep_AbsencesTardinessDetailsPerEmployee2 where empAttendanceMainID = @AttendanceID AND empID = @empID";
                SqlCommand cmd     = new SqlCommand()
                {
                    CommandText = myQuery,
                    CommandType = CommandType.Text
                };
                cmd.Parameters.AddWithValue("@AttendanceID", AttendanceID);
                cmd.Parameters.AddWithValue("@empID", empID);
                cmd.Connection = cn;
                cn.Open();
                SqlDataReader dr = cmd.ExecuteReader();
                if (dr.HasRows)
                {
                    int counter = 0;
                    while (dr.Read())
                    {
                        AbsencesAndTardiness tsData = new AbsencesAndTardiness()
                        {
                            empAttendanceMainID = dr["empAttendanceMainID"].ToString(),
                            NameDate            = dr["NameDate"].ToString(),
                            DTRDate             = dr["DTRDate"].ToString(),
                            empID             = dr["empID"].ToString(),
                            LOGIN             = dr["LOGIN"].ToString(),
                            LOGOUT            = dr["LOGOUT"].ToString(),
                            AbsHrs            = dr["AbsHrs"].ToString(),
                            AbsHrsDec         = dr["AbsHrsDec"].ToString(),
                            LateHrs           = dr["LateHrs"].ToString(),
                            LateHrsDec        = dr["LateHrsDec"].ToString(),
                            UnderTimeHours    = dr["UnderTimeHours"].ToString(),
                            UnderTimeHoursDec = dr["UnderTimeHoursDec"].ToString(),
                            LeaveTypeCode     = dr["LeaveTypeCode"].ToString(),
                            OTHrs             = dr["OTHrs"].ToString(),
                            OTHrsDec          = dr["OTHrsDec"].ToString(),
                        };
                        t.Add(tsData);
                        counter++;
                    }
                }
            }
            return(Json(t, JsonRequestBehavior.AllowGet));
        }