public HttpResponseMessage InsertAttendanceHistory(InsertAttendanceHistory obj)
        {
            HttpResponseMessage message;

            try
            {
                // ManpowerAttendanceDAL dal = new ManpowerAttendanceDAL();
                var dynObj = new { result = _obj.InsertAttendanceHistory(obj) };
                message = Request.CreateResponse(HttpStatusCode.OK, dynObj);
            }
            catch (Exception ex)
            {
                message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" });
                ErrorLog.CreateErrorMessage(ex, "Attendance History", "Insert Attendance History");
            }
            return(message);
        }
Exemple #2
0
        public bool InsertAttendanceHistory(InsertAttendanceHistory objAttendance)
        {
            bool       res    = false;
            SqlCommand SqlCmd = new SqlCommand("sp_insert_AttendanceHistory");

            SqlCmd.CommandType = CommandType.StoredProcedure;
            SqlCmd.Parameters.AddWithValue("@AttentanceId", objAttendance.AttendanceId);
            SqlCmd.Parameters.AddWithValue("@Status", objAttendance.Status);
            SqlCmd.Parameters.AddWithValue("@At_Year", objAttendance.At_Year);
            SqlCmd.Parameters.AddWithValue("@At_Month", objAttendance.At_Month);
            SqlCmd.Parameters.AddWithValue("@CreatedBy", objAttendance.ActionBy);
            int result = _unitOfWork.DbLayer.ExecuteNonQuery(SqlCmd);

            if (result != Int32.MaxValue)
            {
                res = true;
            }
            return(res);
        }